- do not fail in initialization on unsuccessful connect
[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
b4895bbe
VK
7INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
8 VALUES ('DBLockStatus','UNLOCKED',0,1);
9INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
bf4a58d4 10 VALUES ('DBLockInfo','#00',0,0);
48ad2f8d
VK
11INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
12 VALUES ('DBLockPID','0',0,0);
b1c6ea4a 13INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
bf4a58d4 14 VALUES ('ServerID','#00',0,1);
9587eba3
VK
15INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
16 VALUES ('EnableZoning','0',1,1);
333ece94
VK
17INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
18 VALUES ('SyncInterval','60',1,1);
333ece94
VK
19INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
20 VALUES ('DiscoveryPollingInterval','900',1,1);
21INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56d41577 22 VALUES ('StatusPollingInterval','60',1,1);
333ece94
VK
23INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
24 VALUES ('ConfigurationPollingInterval','3600',1,1);
66485623
VK
25INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
26 VALUES ('RoutingTableUpdateInterval','300',1,1);
a717e56a
VK
27INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
28 VALUES ('ConditionPollingInterval','60',1,1);
333ece94 29INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
9587eba3 30 VALUES ('ResolveNodeNames','1',1,0);
333ece94
VK
31INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
32 VALUES ('NumberOfEventProcessors','1',1,1);
33INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
34 VALUES ('ClientListenerPort','4701',1,1);
35INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
625ad507 36 VALUES ('NumberOfDataCollectors','25',1,1);
d39ca961 37INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
040c45fa 38 VALUES ('NumberOfStatusPollers','25',1,1);
d39ca961 39INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
040c45fa 40 VALUES ('NumberOfConfigurationPollers','10',1,1);
bb0a5754
VK
41INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
42 VALUES ('NumberOfDiscoveryPollers','1',1,1);
66485623 43INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
040c45fa
VK
44 VALUES ('NumberOfRoutingTablePollers','10',1,1);
45INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
46 VALUES ('NumberOfTopologyTablePollers','10',1,1);
a717e56a
VK
47INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
48 VALUES ('NumberOfConditionPollers','10',1,1);
333ece94
VK
49INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
50 VALUES ('RunNetworkDiscovery','0',1,1);
51INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
e2ce7f94 52 VALUES ('ActiveNetworkDiscovery','0',1,1);
dd5b3364
VK
53INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
54 VALUES ('ActiveDiscoveryInterval','7200',1,1);
e2ce7f94
VK
55INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56 VALUES ('DiscoveryFilterFlags','0',1,0);
333ece94 57INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
e2ce7f94 58 VALUES ('DiscoveryFilter','none',1,0);
333ece94 59INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
e2ce7f94 60 VALUES ('EnableAdminInterface','1',1,1);
333ece94 61INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
878b4261 62 VALUES ('EventLogRetentionTime','90',1,0);
333ece94
VK
63INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
64 VALUES ('HouseKeepingInterval','3600',1,1);
65INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
dfd24edd 66 VALUES ('DeleteEmptySubnets','0',1,1);
333ece94
VK
67INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
68 VALUES ('EnableSNMPTraps','1',1,1);
7cbe553e
VK
69INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
70 VALUES ('SMSDriver','<none>',1,1);
aa975b7e 71INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
bf4a58d4 72 VALUES ('SMSDrvConfig','#00',1,1);
083abe62
VK
73INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
74 VALUES ('SMTPServer','localhost',1,0);
75INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
76 VALUES ('SMTPFromAddr','netxms@localhost',1,0);
0a84462b
VK
77INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
78 VALUES ('SMTPFromName','NetXMS Server',1,0);
751f4600
VK
79INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
80 VALUES ('AgentUpgradeWaitTime','600',1,0);
a9052846
VK
81INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
82 VALUES ('NumberOfUpgradeThreads','10',1,0);
dfd24edd
VK
83INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
84 VALUES ('KeepAliveInterval','60',1,1);
305800bf
VK
85INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
86 VALUES ('DefaultEncryptionPolicy','1',1,1);
87INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
88 VALUES ('AllowedCiphers','15',1,1);
dc17b82b
VK
89INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
90 VALUES ('EnableMultipleDBConnections','1',1,1);
91INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
92 VALUES ('NumberOfDatabaseWriters','1',1,1);
7e7357e8
VK
93INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
94 VALUES ('IcmpPingSize','46',1,1);
77edf0b5 95INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
de6e949b 96 VALUES ('EnableSyslogDaemon','0',1,1);
77edf0b5
VK
97INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
98 VALUES ('SyslogListenPort','514',1,1);
cb53cb15 99INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
0b4ebe8b 100 VALUES ('SyslogRetentionTime','90',1,0);
b6ce3970
VK
101INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
102 VALUES ('StatusCalculationAlgorithm','1',1,1);
103INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
104 VALUES ('StatusPropagationAlgorithm','1',1,1);
105INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
106 VALUES ('FixedStatusValue','0',1,1);
107INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
108 VALUES ('StatusShift','0',1,1);
109INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
110 VALUES ('StatusTranslation','01020304',1,1);
111INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
112 VALUES ('StatusSingleThreshold','75',1,1);
113INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
114 VALUES ('StatusThresholds','503C2814',1,1);
8d8cd3f8
VK
115INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
116 VALUES ('CapabilityExpirationTime','604800',1,0); // In seconds
269e3aca
VK
117INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
118 VALUES ('DefaultCommunityString','public',1,0);
56b32598
VK
119INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
120 VALUES ('LogAllSNMPTraps','0',1,1);
5d8a7f11
VK
121INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
122 VALUES ('DisableVacuum','0',1,0);
7db87985
VK
123INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
124 VALUES ('LockTimeout','60000',1,1);
f3d12ff6 125INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
9bfc9a6b 126 VALUES ('RADIUSServer','none',1,0);
f3d12ff6
VK
127INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
128 VALUES ('RADIUSSecret','netxms',1,0);
129INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
130 VALUES ('RADIUSPort','1645',1,0);
9bfc9a6b
VK
131INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
132 VALUES ('RADIUSSecondaryServer','none',1,0);
133INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
134 VALUES ('RADIUSSecondarySecret','netxms',1,0);
135INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
136 VALUES ('RADIUSSecondaryPort','1645',1,0);
f3d12ff6
VK
137INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
138 VALUES ('RADIUSNumRetries','5',1,0);
139INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
140 VALUES ('RADIUSTimeout','3',1,0);
36178cb9
AK
141INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
142 VALUES ('MailEncoding','iso-8859-1',1,0);
a0856b0d
VK
143INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
144 VALUES ('WindowsConsoleUpgradeURL','http://www.netxms.org/download/netxms-%version%.exe',1,0);
1f4cd940
VK
145INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
146 VALUES ('InternalCA','0',1,1);
e181d889
VK
147INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
148 VALUES ('SNMPRequestTimeout','2000',1,1);
5a8fcfbb
VK
149INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
150 VALUES ('AgentCommandTimeout','2000',1,1);
7ef13f79
VK
151INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
152 VALUES ('TopologyExpirationTime','900',1,0);
153INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
36da5e09 154 VALUES ('TopologyDiscoveryRadius','3',1,0);
82e16cf5
VK
155INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
156 VALUES ('AuditLogRetentionTime','90',1,0);
157INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
788c26e5 158 VALUES ('EnableAuditLog','1',1,1);
fe41ef92
VK
159INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
160 VALUES ('ThresholdRepeatInterval','0',1,1);
7c2ea1c1
VK
161INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
162 VALUES ('PollCountForStatusChange','1',1,1);
c4ead45c 163INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
5d175d89 164 VALUES ('AllowDirectSMS','0',1,0);
c4ead45c 165INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
5b9c2b5a
VK
166 VALUES ('EnableEventStormDetection','0',1,1);
167INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
168 VALUES ('EventStormEventsPerSecond','100',1,1);
169INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
170 VALUES ('EventStormDuration','15',1,1);
2cf42996
VK
171INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
172 VALUES ('UseInterfaceAliases','0',1,0);
17dd5fb3
VK
173INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
174 VALUES ('SyncNodeNamesWithDNS','0',1,0);
40b7416c 175INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
9c69cc80
VK
176 VALUES ('BeaconHosts','#00',1,1);
177INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
178 VALUES ('BeaconTimeout','1000',1,1);
179INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
180 VALUES ('BeaconPollingInterval','1000',1,1);
d51ccc0d
VK
181INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
182 VALUES ('CheckTrustedNodes','1',1,1);
522f6f07
VK
183INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
184 VALUES ('EnableAgentRegistration','1',1,0);
185INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
186 VALUES ('AnonymousFileAccess','0',1,0);
86cffad8
VK
187INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
188 VALUES ('EnableISCListener','0',1,1);
189INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
190 VALUES ('ReceiveForwardedEvents','0',1,0);
4d0d4896
VK
191INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
192 VALUES ('UseIfXTable','1',1,0);
088b9b54
VK
193INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
194 VALUES ('SMTPRetryCount','1',1,0);
e2babedf
VK
195INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
196 VALUES ('ConnectionPoolBaseSize','5',1,1);
197INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
198 VALUES ('ConnectionPoolMaxSize','20',1,1);
199INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
200 VALUES ('ConnectionPoolCooldownTime','300',1,1);
a0e73ff4
VK
201INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
202 VALUES ('ExternalAuditServer','none',1,1);
203INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
204 VALUES ('ExternalAuditPort','514',1,1);
205INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
206 VALUES ('ExternalAuditFacility','13',1,1);
207INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
208 VALUES ('ExternalAuditSeverity','5',1,1);
209INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
210 VALUES ('ExternalAuditTag','netxmsd-audit',1,1);
ab185583
VK
211INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
212 VALUES ('PasswordHistoryLength','0',1,0);
213INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
214 VALUES ('IntruderLockoutThreshold','0',1,0);
215INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
216 VALUES ('IntruderLockoutTime','30',1,0);
217INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
218 VALUES ('MinPasswordLength','0',1,0);
219INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
220 VALUES ('PasswordComplexity','0',1,0);
221INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
222 VALUES ('PasswordExpiration','0',1,0);
223INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
224 VALUES ('BlockInactiveUserAccounts','0',1,0);
d749debc
VK
225INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
226 VALUES ('AllowTrapVarbindsConversion','1',1,1);
fceea457
VK
227INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
228 VALUES ('TileServerURL','http://tile.openstreetmap.org/',1,0);
878b4261
VK
229INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
230 VALUES ('JobHistoryRetentionTime','90',1,0);
9b057805
VK
231
232
6c9e7d36 233/*
383b42a1 234** Default admin user
6c9e7d36 235*/
9b057805 236
383b42a1 237INSERT INTO users (id,name,password,system_access,flags,full_name,
0e0da2f1 238 description,grace_logins,auth_method,guid,
0f1ddb74
VK
239 cert_mapping_method,cert_mapping_data,
240 auth_failures,last_passwd_change,min_passwd_length,
241 disabled_until,last_login)
057f9dfb
VK
242 VALUES (0,'admin',
243 '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
bf4a58d4 244 65535,8,'#00','Built-in system administrator account',5,0,
0f1ddb74 245 '00000000-0000-0000-0000-000000000000',0,'#00',0,0,0,0,0
057f9dfb
VK
246 );
247
248
249/*
a852b4fb 250** Special "Everyone" user group
057f9dfb
VK
251*/
252
95b6a1b6 253INSERT INTO user_groups (id,name,system_access,flags,description,guid)
383b42a1
VK
254 VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group',
255 '00000000-0000-0000-0000-000000000000'
256 );
a852b4fb
VK
257
258
259/*
260** Default "Admins" group
261*/
262
768935e8
VK
263INSERT INTO user_groups (id,name,system_access,flags,description,guid)
264 VALUES (-2147483647, 'Admins', 65535, 0, 'Default administrative group',
265 '00000000-0000-0000-0000-000000000000'
266 );
267
a852b4fb
VK
268INSERT INTO acl (object_id,user_id,access_rights) VALUES (1,-2147483647,2047);
269INSERT INTO acl (object_id,user_id,access_rights) VALUES (2,-2147483647,2047);
270INSERT INTO acl (object_id,user_id,access_rights) VALUES (3,-2147483647,2047);
b6a77d6d
VK
271
272
3c468b80
VK
273/*
274** Default event groups
275*/
276
c6576857
VK
277#define ID_GROUP_1 -2147483647
278#define ID_GROUP_2 -2147483646
3c468b80 279
9f2ad16c
VK
280INSERT INTO event_groups (id,name,description,range_start,range_end)
281 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change',0,0);
282INSERT INTO event_groups (id,name,description,range_start,range_end)
283 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation',0,0);
3c468b80 284
c19b2871
VK
285INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
286INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
287INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
288INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
289INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
290INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
291INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
292
293INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
294INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
295INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
ef44d5ea
VK
296
297
298/*
299** Default container categories
300*/
301
302INSERT INTO container_categories (category,name,image_id,description)
303 VALUES (1,'Group',0,'Generic object group');
304INSERT INTO container_categories (category,name,image_id,description)
305 VALUES (2,'Location',0,'Geografic location');
306INSERT INTO container_categories (category,name,image_id,description)
307 VALUES (3,'Service',0,'Logical service');