schema-related information (like schema version, DB syntax, etc.) moved from "config...
[public/netxms.git] / sql / setup.in
1 /*
2 ** Default configuration parameters
3 **
4 ** ex: syntax=sql
5 */
6
7 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
8 VALUES ('DBLockStatus','UNLOCKED',0,1);
9 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
10 VALUES ('DBLockInfo','#00',0,0);
11 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
12 VALUES ('DBLockPID','0',0,0);
13 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
14 VALUES ('ServerID','#00',0,1);
15 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
16 VALUES ('EnableZoning','0',1,1);
17 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
18 VALUES ('SyncInterval','60',1,1);
19 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
20 VALUES ('DiscoveryPollingInterval','900',1,1);
21 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
22 VALUES ('StatusPollingInterval','60',1,1);
23 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
24 VALUES ('ConfigurationPollingInterval','3600',1,1);
25 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
26 VALUES ('RoutingTableUpdateInterval','300',1,1);
27 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
28 VALUES ('ConditionPollingInterval','60',1,1);
29 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
30 VALUES ('ResolveNodeNames','1',1,0);
31 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
32 VALUES ('NumberOfEventProcessors','1',1,1);
33 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
34 VALUES ('ClientListenerPort','4701',1,1);
35 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
36 VALUES ('NumberOfDataCollectors','25',1,1);
37 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
38 VALUES ('NumberOfStatusPollers','10',1,1);
39 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
40 VALUES ('NumberOfConfigurationPollers','5',1,1);
41 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
42 VALUES ('NumberOfDiscoveryPollers','1',1,1);
43 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
44 VALUES ('NumberOfRoutingTablePollers','5',1,1);
45 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
46 VALUES ('NumberOfConditionPollers','10',1,1);
47 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
48 VALUES ('RunNetworkDiscovery','0',1,1);
49 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
50 VALUES ('ActiveNetworkDiscovery','0',1,1);
51 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
52 VALUES ('ActiveDiscoveryInterval','7200',1,1);
53 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
54 VALUES ('DiscoveryFilterFlags','0',1,0);
55 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56 VALUES ('DiscoveryFilter','none',1,0);
57 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
58 VALUES ('EnableAdminInterface','1',1,1);
59 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
60 VALUES ('EventLogRetentionTime','90',1,0); // Default retention time is 90 days == 5184000 seconds
61 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
62 VALUES ('HouseKeepingInterval','3600',1,1);
63 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
64 VALUES ('DeleteEmptySubnets','0',1,1);
65 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
66 VALUES ('EnableSNMPTraps','1',1,1);
67 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
68 VALUES ('SMSDriver','<none>',1,1);
69 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
70 VALUES ('SMSDrvConfig','#00',1,1);
71 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
72 VALUES ('SMTPServer','localhost',1,0);
73 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
74 VALUES ('SMTPFromAddr','netxms@localhost',1,0);
75 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
76 VALUES ('AgentUpgradeWaitTime','600',1,0);
77 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
78 VALUES ('NumberOfUpgradeThreads','10',1,0);
79 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
80 VALUES ('KeepAliveInterval','60',1,1);
81 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
82 VALUES ('DefaultEncryptionPolicy','1',1,1);
83 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
84 VALUES ('AllowedCiphers','15',1,1);
85 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
86 VALUES ('EnableMultipleDBConnections','1',1,1);
87 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
88 VALUES ('NumberOfDatabaseWriters','1',1,1);
89 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
90 VALUES ('IcmpPingSize','46',1,1);
91 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
92 VALUES ('EnableSyslogDaemon','0',1,1);
93 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
94 VALUES ('SyslogListenPort','514',1,1);
95 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
96 VALUES ('SyslogRetentionTime','90',1,0);
97 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
98 VALUES ('StatusCalculationAlgorithm','1',1,1);
99 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
100 VALUES ('StatusPropagationAlgorithm','1',1,1);
101 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
102 VALUES ('FixedStatusValue','0',1,1);
103 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
104 VALUES ('StatusShift','0',1,1);
105 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
106 VALUES ('StatusTranslation','01020304',1,1);
107 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
108 VALUES ('StatusSingleThreshold','75',1,1);
109 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
110 VALUES ('StatusThresholds','503C2814',1,1);
111 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
112 VALUES ('CapabilityExpirationTime','604800',1,0); // In seconds
113 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
114 VALUES ('DefaultCommunityString','public',1,0);
115 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
116 VALUES ('LogAllSNMPTraps','0',1,1);
117 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
118 VALUES ('DisableVacuum','0',1,0);
119 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
120 VALUES ('LockTimeout','60000',1,1);
121 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
122 VALUES ('RADIUSServer','localhost',1,0);
123 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
124 VALUES ('RADIUSSecret','netxms',1,0);
125 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
126 VALUES ('RADIUSPort','1645',1,0);
127 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
128 VALUES ('RADIUSNumRetries','5',1,0);
129 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
130 VALUES ('RADIUSTimeout','3',1,0);
131 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
132 VALUES ('MailEncoding','iso-8859-1',1,0);
133 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
134 VALUES ('WindowsConsoleUpgradeURL','http://www.netxms.org/download/netxms-%version%.exe',1,0);
135 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
136 VALUES ('InternalCA','0',1,1);
137 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
138 VALUES ('SNMPRequestTimeout','2000',1,1);
139 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
140 VALUES ('AgentCommandTimeout','2000',1,1);
141 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
142 VALUES ('TopologyExpirationTime','900',1,0);
143 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
144 VALUES ('TopologyDiscoveryRadius','3',1,0);
145 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
146 VALUES ('AuditLogRetentionTime','90',1,0);
147 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
148 VALUES ('EnableAuditLog','1',1,1);
149 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
150 VALUES ('ThresholdRepeatInterval','0',1,1);
151 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
152 VALUES ('PollCountForStatusChange','1',1,1);
153 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
154 VALUES ('AllowDirectSMS','0',1,0);
155 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
156 VALUES ('EnableEventStormDetection','0',1,1);
157 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
158 VALUES ('EventStormEventsPerSecond','100',1,1);
159 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
160 VALUES ('EventStormDuration','15',1,1);
161 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
162 VALUES ('UseInterfaceAliases','0',1,0);
163 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
164 VALUES ('SyncNodeNamesWithDNS','0',1,0);
165 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
166 VALUES ('BeaconHosts','#00',1,1);
167 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
168 VALUES ('BeaconTimeout','1000',1,1);
169 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
170 VALUES ('BeaconPollingInterval','1000',1,1);
171 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
172 VALUES ('CheckTrustedNodes','1',1,1);
173 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
174 VALUES ('EnableAgentRegistration','1',1,0);
175 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
176 VALUES ('AnonymousFileAccess','0',1,0);
177 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
178 VALUES ('EnableISCListener','0',1,1);
179 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
180 VALUES ('ReceiveForwardedEvents','0',1,0);
181 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
182 VALUES ('UseIfXTable','1',1,0);
183 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
184 VALUES ('SMTPRetryCount','1',1,0);
185
186
187 /*
188 ** Default admin user
189 */
190
191 INSERT INTO users (id,name,password,system_access,flags,full_name,
192 description,grace_logins,auth_method,guid,
193 cert_mapping_method,cert_mapping_data)
194 VALUES (0,'admin',
195 '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
196 65535,8,'#00','Built-in system administrator account',5,0,
197 '00000000-0000-0000-0000-000000000000',0,'#00'
198 );
199
200
201 /*
202 ** Special "Everyone" user group
203 */
204
205 INSERT INTO user_groups (id,name,system_access,flags,description,guid)
206 VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group',
207 '00000000-0000-0000-0000-000000000000'
208 );
209
210
211 /*
212 ** Default "Admins" group
213 */
214
215 INSERT INTO user_groups (id,name,system_access,flags,description,guid)
216 VALUES (-2147483647, 'Admins', 65535, 0, 'Default administrative group',
217 '00000000-0000-0000-0000-000000000000'
218 );
219
220 INSERT INTO acl (object_id,user_id,access_rights) VALUES (1,-2147483647,2047);
221 INSERT INTO acl (object_id,user_id,access_rights) VALUES (2,-2147483647,2047);
222 INSERT INTO acl (object_id,user_id,access_rights) VALUES (3,-2147483647,2047);
223
224
225 /*
226 ** Default event groups
227 */
228
229 #define ID_GROUP_1 -2147483647
230 #define ID_GROUP_2 -2147483646
231
232 INSERT INTO event_groups (id,name,description,range_start,range_end)
233 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change',0,0);
234 INSERT INTO event_groups (id,name,description,range_start,range_end)
235 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation',0,0);
236
237 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
238 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
239 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
240 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
241 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
242 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
243 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
244
245 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
246 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
247 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
248
249
250 /*
251 ** Default container categories
252 */
253
254 INSERT INTO container_categories (category,name,image_id,description)
255 VALUES (1,'Group',0,'Generic object group');
256 INSERT INTO container_categories (category,name,image_id,description)
257 VALUES (2,'Location',0,'Geografic location');
258 INSERT INTO container_categories (category,name,image_id,description)
259 VALUES (3,'Service',0,'Logical service');
260
261
262 /*
263 ** SNMP OID to node type mappings
264 */
265
266 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
267 VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0);
268 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
269 VALUES (1,'.1.3.6.1.4.1.3224.1.*',NODE_TYPE_NETSCREEN,0);
270 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
271 VALUES (2,'.1.3.6.1.4.1.45.3.26.*',NODE_TYPE_NORTEL_BAYSTACK,0);
272 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
273 VALUES (3,'.1.3.6.1.4.1.45.3.30.*',NODE_TYPE_NORTEL_BAYSTACK,0);
274 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
275 VALUES (4,'.1.3.6.1.4.1.45.3.31.*',NODE_TYPE_NORTEL_BAYSTACK,0);
276 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
277 VALUES (5,'.1.3.6.1.4.1.45.3.32.*',NODE_TYPE_NORTEL_BAYSTACK,0);
278 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
279 VALUES (6,'.1.3.6.1.4.1.45.3.33.*',NODE_TYPE_NORTEL_BAYSTACK,0);
280 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
281 VALUES (7,'.1.3.6.1.4.1.45.3.34.*',NODE_TYPE_NORTEL_BAYSTACK,0);
282 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
283 VALUES (8,'.1.3.6.1.4.1.45.3.35.*',NODE_TYPE_NORTEL_BAYSTACK,0);
284 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
285 VALUES (9,'.1.3.6.1.4.1.45.3.36.*',NODE_TYPE_NORTEL_BAYSTACK,0);
286 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
287 VALUES (10,'.1.3.6.1.4.1.45.3.40.*',NODE_TYPE_NORTEL_BAYSTACK,0);
288 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
289 VALUES (11,'.1.3.6.1.4.1.45.3.46.*',NODE_TYPE_NORTEL_BAYSTACK,0);
290 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
291 VALUES (12,'.1.3.6.1.4.1.45.3.52.*',NODE_TYPE_NORTEL_BAYSTACK,0);
292 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
293 VALUES (13,'.1.3.6.1.4.1.45.3.61.*',NODE_TYPE_NORTEL_BAYSTACK,0);
294 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
295 VALUES (14,'.1.3.6.1.4.1.45.3.48.*',NODE_TYPE_NORTEL_OPTERA,0);
296 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
297 VALUES (15,'.1.3.6.1.4.1.45.3.29.*',NODE_TYPE_NORTEL_BAYSTACK,0);
298 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
299 VALUES (16,'.1.3.6.1.4.1.45.3.41.*',NODE_TYPE_NORTEL_BAYSTACK,0);
300 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
301 VALUES (17,'.1.3.6.1.4.1.45.3.45.*',NODE_TYPE_NORTEL_BAYSTACK,0);
302 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
303 VALUES (18,'.1.3.6.1.4.1.45.3.43.*',NODE_TYPE_NORTEL_BAYSTACK,0);
304 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
305 VALUES (19,'.1.3.6.1.4.1.45.3.57.*',NODE_TYPE_NORTEL_BAYSTACK,0);
306 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
307 VALUES (20,'.1.3.6.1.4.1.45.3.49.*',NODE_TYPE_NORTEL_BAYSTACK,0);
308 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
309 VALUES (21,'.1.3.6.1.4.1.45.3.54.*',NODE_TYPE_NORTEL_BAYSTACK,0);
310 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
311 VALUES (22,'.1.3.6.1.4.1.45.3.63.*',NODE_TYPE_NORTEL_BAYSTACK,0);
312 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
313 VALUES (23,'.1.3.6.1.4.1.45.3.64.*',NODE_TYPE_NORTEL_BAYSTACK,0);
314 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
315 VALUES (24,'.1.3.6.1.4.1.45.3.53.*',NODE_TYPE_NORTEL_BAYSTACK,0);
316 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
317 VALUES (25,'.1.3.6.1.4.1.45.3.59.*',NODE_TYPE_NORTEL_BAYSTACK,0);
318 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
319 VALUES (26,'.1.3.6.1.4.1.45.3.39.*',NODE_TYPE_NORTEL_BAYSTACK,0);
320 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
321 VALUES (27,'.1.3.6.1.4.1.45.3.65.*',NODE_TYPE_NORTEL_BAYSTACK,0);
322 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
323 VALUES (28,'.1.3.6.1.4.1.45.3.66.*',NODE_TYPE_NORTEL_BAYSTACK,0);
324 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
325 VALUES (29,'.1.3.6.1.4.1.45.3.44.*',NODE_TYPE_NORTEL_OPTERA,0);
326 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
327 VALUES (30,'.1.3.6.1.4.1.45.3.47.*',NODE_TYPE_NORTEL_OPTERA,0);
328 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
329 VALUES (31,'.1.3.6.1.4.1.45.3.48.*',NODE_TYPE_NORTEL_OPTERA,0);