agent upgrade on Windows run with option to force close applications keeping agent...
[public/netxms.git] / sql / setup.in
CommitLineData
6c9e7d36
VK
1/*
2** Default configuration parameters
b51c8c91
AK
3**
4** ex: syntax=sql
6c9e7d36 5*/
c1142e46 6
549f48b3
VK
7INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ActiveDiscoveryInterval','7200',1,1);
8INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ActiveNetworkDiscovery','0',1,1);
9INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AgentCommandTimeout','4000',1,1);
af21affe 10INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AgentDefaultSharedSecret','netxms',1,0);
549f48b3
VK
11INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AgentUpgradeWaitTime','600',1,0);
12INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AlarmHistoryRetentionTime','180',1,0);
b66098ac 13INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AlarmListDisplayLimit','4096',1,0);
ed0a30ba
VK
14INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmSummaryEmailRecipients','',1,0,'S','A semicolon separated list of alarm summary e-mail recipient addresses');
15INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmSummaryEmailSchedule','0 0 * * *',1,0,'S','Schedule for sending alarm summary e-mails in cron format');
549f48b3 16INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AllowDirectSMS','0',1,0);
ae8e3292 17INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AllowedCiphers','63',1,1);
549f48b3
VK
18INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AllowTrapVarbindsConversion','1',1,1);
19INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AnonymousFileAccess','0',1,0);
483d35ad 20INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ApplyDCIFromTemplateToDisabledDCI','1',1,1);
549f48b3
VK
21INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AuditLogRetentionTime','90',1,0);
22INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BeaconHosts','',1,1);
23INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BeaconPollingInterval','1000',1,1);
24INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BeaconTimeout','1000',1,1);
25INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BlockInactiveUserAccounts','0',1,0);
af21affe 26INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('CapabilityExpirationTime','604800',1,0); /* in seconds */
8a1519ce 27INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('CaseInsensitiveLoginNames','0',1,1,'B','Enable/disable case insensitive login names');
f3f2ddd9 28INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('CheckTrustedNodes','0',1,1,'B','Enable/disable trusted nodes check');
549f48b3 29INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ClientListenerPort','4701',1,1);
221826d9
VK
30INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ClusterContainerAutoBind','0',1,0,'B','Enable/disable container auto binding for clusters');
31INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ClusterTemplateAutoApply','0',1,0,'B','Enable/disable template auto apply for clusters');
549f48b3
VK
32INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ConditionPollingInterval','60',1,1);
33INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ConfigurationPollingInterval','3600',1,1);
1422840a 34INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,is_public,description) VALUES ('DashboardDataExportEnableInterpolation','1',1,1,'B','Y','Enable/disable data interpolation in dashboard data export');
9c236c87
VK
35INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolBaseSize','10',1,1);
36INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolCooldownTime','300',1,1);
37INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolMaxLifetime','14400',1,1);
38INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolMaxSize','30',1,1);
549f48b3
VK
39INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBLockInfo','',0,0);
40INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBLockPID','0',0,0);
41INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBLockStatus','UNLOCKED',0,1);
c1f07289 42INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultAgentCacheMode','2',1,1);
549f48b3 43INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultConsoleDateFormat','dd.MM.yyyy',1,0);
bc969eaf 44INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultConsoleShortTimeFormat','HH:mm',1,0);
549f48b3
VK
45INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultConsoleTimeFormat','HH:mm:ss',1,0);
46INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultDCIPollingInterval','60',1,0);
47INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultDCIRetentionTime','30',1,0);
48INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultEncryptionPolicy','1',1,1);
ad62667a 49INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultInterfaceExpectedState','1',1,0,'C','Default expected state for new interface objects');
549f48b3 50INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultMapBackgroundColor','0xffffff',1,0);
9d7771b8
VK
51INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultSubnetMaskIPv4','24',1,0,'I','Default mask for synthetic IPv4 subnets');
52INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultSubnetMaskIPv6','64',1,0,'I','Default mask for synthetic IPv6 subnets');
549f48b3
VK
53INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteAlarmsOfDeletedObject','1',1,0);
54INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteEmptySubnets','0',1,1);
55INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteEventsOfDeletedObject','1',1,0);
56INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteUnreachableNodesPeriod','0',1,1);
549f48b3
VK
57INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DiscoveryFilter','none',1,0);
58INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DiscoveryFilterFlags','0',1,0);
59INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DiscoveryPollingInterval','900',1,1);
60INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableAdminInterface','1',1,1);
61INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableAgentRegistration','1',1,0);
62INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableAuditLog','1',1,1);
9a1f7c45 63INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableCheckPointSNMP','0',1,0);
d38a36c6 64INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableReportingServer','0',1,1);
549f48b3
VK
65INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableEventStormDetection','0',1,1);
66INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableISCListener','0',1,1);
549f48b3
VK
67INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableNXSLContainerFunctions','1',1,1);
68INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableObjectTransactions','0',1,1);
69INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableSNMPTraps','1',1,1);
ed0a30ba 70INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAlarmSummaryEmails','0',1,0,'I','Enable alarm summary e-mails');
685508a7 71INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableSyslogReceiver','0',1,1);
d1730ccf 72INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableTimedAlarmAck','1',1,1);
244c65ef 73INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableXMPPConnector','0',1,1);
549f48b3 74INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableZoning','0',1,1);
815638fe 75INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EscapeLocalCommands','0',1,0);
549f48b3
VK
76INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EventLogRetentionTime','90',1,0);
77INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EventStormDuration','15',1,1);
78INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EventStormEventsPerSecond','100',1,1);
d1730ccf 79INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExtendedLogQueryAccessControl','0',1,0);
549f48b3
VK
80INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditFacility','13',1,1);
81INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditPort','514',1,1);
82INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditServer','none',1,1);
83INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditSeverity','5',1,1);
84INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditTag','netxmsd-audit',1,1);
85INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('FirstFreeObjectId','100',0,1);
86INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('FixedStatusValue','0',1,1);
34a320ad 87INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('HelpDeskLink','none',1,1);
b06ae508 88INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('HousekeeperStartTime','02:00',1,1);
549f48b3 89INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IcmpPingSize','46',1,1);
c59466d2 90INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IcmpPingTimeout','1500',1,1);
03b96461 91INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ImportConfigurationOnStartup','1',1,1,'B','Import configuration from local files on server startup');
43ef30b2 92INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('InstancePollingInterval','600',1,1);
549f48b3
VK
93INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('InternalCA','0',1,1);
94INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IntruderLockoutThreshold','0',1,0);
95INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IntruderLockoutTime','30',1,0);
c299358f
EJ
96INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraIssueType','Task',1,0);
97INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraLogin','netxms',1,1);
98INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraPassword','',1,1);
99INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraProjectCode','NETXMS',1,0);
100INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraProjectComponent','',1,0);
101INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraServerURL','http://localhost',1,1);
549f48b3 102INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JobHistoryRetentionTime','90',1,0);
355aa002 103INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JobRetryCount','5',1,0,'I','Maximum mumber of job execution retrys');
549f48b3 104INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('KeepAliveInterval','60',1,1);
d9177dd1 105INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapGroupClass','',1,0);
bad2c02e 106INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapGroupUniqueId','',1,0);
6c352bb5 107INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapConnectionString','ldap://localhost:389',1,0);
2575f149 108INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapMappingDescription','',1,0);
d9177dd1 109INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapMappingFullName','displayName',1,0);
f70a8b3c 110INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapMappingName','',1,0);
b00236dd 111INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapPageSize','1000',1,0);
d9177dd1 112INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSearchBase','',1,0);
113INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSearchFilter','',1,0);
114INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSyncInterval','0',1,0);
115INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSyncUser','',1,0);
116INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSyncUserPassword','',1,0);
4f754e74 117INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapUserClass','',1,0);
b00236dd 118INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapUserDeleteAction','1',1,0);
bad2c02e 119INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapUserUniqueId','',1,0);
549f48b3
VK
120INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LockTimeout','60000',1,1);
121INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LogAllSNMPTraps','0',1,1);
b9bcd02c 122INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MailEncoding','utf8',1,0);
8b75662b 123INSERT INTO config (var_name,var_value,is_visible,data_type,need_server_restart,description) VALUES ('MessageOfTheDay','',1,'S',0,'Message to be shown when a user logs into the console');
549f48b3 124INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MinPasswordLength','0',1,0);
8deadd79 125INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MinViewRefreshInterval','1000',1,0);
549f48b3 126INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MobileDeviceListenerPort','4747',1,1);
549f48b3 127INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('NumberOfDataCollectors','25',1,1);
549f48b3 128INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('NumberOfUpgradeThreads','10',1,0);
c8e3cd04 129INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('OfflineDataRelevanceTime','86400',1,1,'I','Time period in seconds within which received offline data still relevant for threshold validation');
549f48b3
VK
130INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PasswordComplexity','0',1,0);
131INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PasswordExpiration','0',1,0);
132INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PasswordHistoryLength','0',1,0);
133INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PollCountForStatusChange','1',1,1);
e1d2050f
VK
134INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PollerThreadPoolBaseSize','10',1,1);
135INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PollerThreadPoolMaxSize','250',1,1);
b2ecde3b 136INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSAuthMethod','PAP',1,0,'S','RADIUS authentication method to be used (PAP, CHAP, MS-CHAPv1, MS-CHAPv2)');
549f48b3
VK
137INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSNumRetries','5',1,0);
138INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSPort','1645',1,0);
139INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecondaryPort','1645',1,0);
140INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecondarySecret','netxms',1,0);
141INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecondaryServer','none',1,0);
142INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecret','netxms',1,0);
143INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSServer','none',1,0);
144INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSTimeout','3',1,0);
145INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ReceiveForwardedEvents','0',1,0);
d38a36c6
EJ
146INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ReportingServerHostname','localhost',1,1);
147INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ReportingServerPort','4710',1,1);
4553d424 148INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ResolveDNSToIPOnStatusPoll','0',1,1);
549f48b3
VK
149INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ResolveNodeNames','1',1,0);
150INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RoutingTableUpdateInterval','300',1,1);
151INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RunNetworkDiscovery','0',1,1);
88072662 152INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerColor','',1,0,'S','Identification color for this server');
48905317 153INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ServerCommandOutputTimeout','60',1,0);
88072662 154INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerName','',1,0,'S','Name of this server');
549f48b3
VK
155INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMSDriver','<none>',1,1);
156INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMSDrvConfig','',1,1);
157INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPFromAddr','netxms@localhost',1,0);
158INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPFromName','NetXMS Server',1,0);
159INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPRetryCount','1',1,0);
4e7ebbb4 160INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPPorts','161',1,0);
549f48b3 161INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPServer','localhost',1,0);
014fbefc 162INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPRequestTimeout','1500',1,1);
549f48b3 163INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPTrapLogRetentionTime','90',1,0);
eb4822b6 164INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPTrapPort','162',1,1);
549f48b3
VK
165INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusCalculationAlgorithm','1',1,1);
166INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusPollingInterval','60',1,1);
167INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusPropagationAlgorithm','1',1,1);
168INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusShift','0',1,1);
169INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusSingleThreshold','75',1,1);
170INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusThresholds','503C2814',1,1);
171INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusTranslation','01020304',1,1);
95e2329a 172INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StrictAlarmStatusFlow','0',1,0);
549f48b3
VK
173INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyncInterval','60',1,1);
174INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyncNodeNamesWithDNS','0',1,0);
b8c8a8a7 175INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogIgnoreMessageTimestamp','0',1,0,'B','Ignore timestamp received in syslog messages and always use server time');
549f48b3 176INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyslogListenPort','514',1,1);
d368074d 177INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyslogNodeMatchingPolicy','0',1,1);
549f48b3
VK
178INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyslogRetentionTime','90',1,0);
179INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ThresholdRepeatInterval','0',1,1);
180INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('TileServerURL','http://tile.openstreetmap.org/',1,0);
181INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('TopologyDiscoveryRadius','3',1,0);
182INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('TopologyExpirationTime','900',1,0);
cf38357f 183INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('TrapSourcesInAllZones','0',1,1,'B','Search all zones to match trap/syslog source address to node');
549f48b3
VK
184INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseDNSNameForDiscoveredNodes','0',1,0);
185INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseFQDNForNodeNames','1',1,1);
186INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseIfXTable','1',1,0);
187INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseInterfaceAliases','0',1,0);
e02953a4 188INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseSNMPTrapsForDiscovery','0',1,1);
244c65ef
VK
189INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPLogin','netxms@localhost',1,1);
190INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPPassword','netxms',1,1);
191INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPPort','5222',1,1);
192INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPServer','localhost',1,1);
9b057805 193
6c9e7d36 194/*
be737a59 195** System user
6c9e7d36 196*/
383b42a1 197INSERT INTO users (id,name,password,system_access,flags,full_name,
0e0da2f1 198 description,grace_logins,auth_method,guid,
0f1ddb74
VK
199 cert_mapping_method,cert_mapping_data,
200 auth_failures,last_passwd_change,min_passwd_length,
201 disabled_until,last_login)
be737a59
VK
202 VALUES (0,'system',
203 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
204 274877906943,12,'','Built-in system account',5,0, /* Flags: change password + disabled */
490e43fd 205 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0
057f9dfb
VK
206 );
207
be737a59
VK
208/*
209** Default admin user
210*/
211INSERT INTO users (id,name,password,system_access,flags,full_name,
212 description,grace_logins,auth_method,guid,
213 cert_mapping_method,cert_mapping_data,
214 auth_failures,last_passwd_change,min_passwd_length,
215 disabled_until,last_login)
216 VALUES (1,'admin',
217 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
218 0,8,'','Default administrator account',5,0,
219 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0
220 );
057f9dfb
VK
221
222/*
a852b4fb 223** Special "Everyone" user group
057f9dfb 224*/
95b6a1b6 225INSERT INTO user_groups (id,name,system_access,flags,description,guid)
b27be523 226 VALUES (-2147483648, 'Everyone', 274877906960, 0, 'Built-in everyone group',
383b42a1
VK
227 '00000000-0000-0000-0000-000000000000'
228 );
a852b4fb 229
a852b4fb
VK
230/*
231** Default "Admins" group
232*/
768935e8 233INSERT INTO user_groups (id,name,system_access,flags,description,guid)
be737a59 234 VALUES (-2147483647, 'Admins', 274877906943, 0, 'Default administrative group',
768935e8
VK
235 '00000000-0000-0000-0000-000000000000'
236 );
237
be737a59 238INSERT INTO user_group_members (group_id,user_id) VALUES (-2147483647,1);
b6a77d6d 239
be737a59
VK
240INSERT INTO acl (object_id,user_id,access_rights) VALUES (1,-2147483647,32767);
241INSERT INTO acl (object_id,user_id,access_rights) VALUES (2,-2147483647,32767);
242INSERT INTO acl (object_id,user_id,access_rights) VALUES (3,-2147483647,32767);
243INSERT INTO acl (object_id,user_id,access_rights) VALUES (4,-2147483647,32767);
244INSERT INTO acl (object_id,user_id,access_rights) VALUES (5,-2147483647,32767);
245INSERT INTO acl (object_id,user_id,access_rights) VALUES (6,-2147483647,32767);
246INSERT INTO acl (object_id,user_id,access_rights) VALUES (7,-2147483647,32767);
247INSERT INTO acl (object_id,user_id,access_rights) VALUES (8,-2147483647,32767);
248INSERT INTO acl (object_id,user_id,access_rights) VALUES (9,-2147483647,32767);
b6a77d6d 249
3c468b80
VK
250/*
251** Default event groups
252*/
253
c6576857
VK
254#define ID_GROUP_1 -2147483647
255#define ID_GROUP_2 -2147483646
3c468b80 256
d8ee1efc 257INSERT INTO event_groups (id,name,description,range_start,range_end)
9f2ad16c
VK
258 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change',0,0);
259INSERT INTO event_groups (id,name,description,range_start,range_end)
260 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation',0,0);
3c468b80 261
c19b2871
VK
262INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
263INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
264INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
265INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
266INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
267INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
268INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
269
270INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
271INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
272INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
15bbaeb3 273
274/*
275** Default community string
276*/
277INSERT INTO snmp_communities (id,community) VALUES(1,'public');