schema-related information (like schema version, DB syntax, etc.) moved from "config...
[public/netxms.git] / doc / internal / db_format_change.txt
1 *************
2 * 86 ==> 87 *
3 *************
4
5 - New table "metadata" added for storing data like schema version,
6 database syntax, etc.
7 CREATE TABLE metadata
8 (
9 var_name varchar(63) not null,
10 var_value varchar(255) not null,
11 PRIMARY KEY(var_name)
12 ) TABLE_TYPE;
13 - Configuration parameters DBFormatVersion, DBSyntax,
14 IDataTableCreationCommand, IDataIndexCreationCommand_* moved to
15 "metadata" table
16
17
18 *************
19 * 85 ==> 86 *
20 *************
21
22 - Unused tables removed: alarm_grops, alarm_group_map, alarm_change_log,
23 lpp, lpp_associations, lpp_rulesets,
24 lpp_rules, lpp_groups
25
26
27 *************
28 * 84 ==> 85 *
29 *************
30
31 - New columns added to table "nodes":
32 ALTER TABLE nodes ADD use_ifxtable integer not null
33 - New configuration parameters: UseIfXTable, SMTPRetryCount
34
35
36 *************
37 * 83 ==> 84 *
38 *************
39
40 - New configuration parameters: EnableAgentRegistration, AnonymousFileAccess,
41 EnableISCListener, ReceiveForwardedEvents
42
43
44 *************
45 * 82 ==> 83 *
46 *************
47
48 - Fix incorrect alarm timeouts:
49 UPDATE alarms SET timeout=0,timeout_event=43
50
51
52 *************
53 * 81 ==> 82 *
54 *************
55
56 - New table added:
57 CREATE TABLE config_clob
58 (
59 var_name varchar(63) not null,
60 var_value SQL_TEXT not null,
61 PRIMARY KEY(var_name)
62 ) TABLE_TYPE;
63
64
65 *************
66 * 80 ==> 81 *
67 *************
68
69 - New column added to table "dci_schedules":
70 ALTER TABLE dci_schedules ADD schedule_id integer not null
71 - Set primary key constraints:
72 dci_schedules ---> item_id,schedule_id
73 address_lists ---> list_type,community_id,addr_type,addr1,addr2
74 lpp_associations ---> lpp_id,node_id,log_file
75 - New tables added:
76 CREATE TABLE object_custom_attributes
77 (
78 object_id integer not null,
79 attr_name varchar(127) not null,
80 attr_value SQL_TEXT not null,
81 PRIMARY KEY(object_id,attr_name)
82 ) TABLE_TYPE;
83 CREATE TABLE web_maps
84 (
85 id integer not null,
86 title varchar(63) not null,
87 properties SQL_TEXT not null,
88 data SQL_TEXT not null,
89 PRIMARY KEY(id)
90 ) TABLE_TYPE;
91
92
93 *************
94 * 79 ==> 80 *
95 *************
96
97 - New columns added to table "nodes":
98 ALTER TABLE nodes ADD uname varchar(255) not null
99
100
101 *************
102 * 78 ==> 79 *
103 *************
104
105 - Table "modules" deleted
106 - MySQL only: column type blob changed to text in schema
107 - Configuration parameter RetainCustomInterfaceNames deleted
108
109
110 *************
111 * 77 ==> 78 *
112 *************
113
114 - New table added:
115 CREATE TABLE trusted_nodes
116 (
117 source_object_id integer not null,
118 target_node_id integer not null,
119 PRIMARY KEY(source_object_id,target_node_id)
120 ) TABLE_TYPE;
121 - New configuration parameter added: CheckTrustedNodes
122
123
124 *************
125 * 76 ==> 77 *
126 *************
127
128 - Table "cond_dci_map" altered:
129 - Added new column sequence_number (type "integer not null")
130 - Primary key changed to "condition_id,sequence_number"
131
132
133 *************
134 * 75 ==> 76 *
135 *************
136
137 - New events added:
138 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
139 (
140 EVENT_NETWORK_CONNECTION_LOST, 'SYS_NETWORK_CONN_LOST',
141 EVENT_SEVERITY_CRITICAL, 1,
142 'NetXMS server network connectivity lost',
143 'Generated when system detects loss of network connectivity based on beacon probing.#0D#0A' CONCAT
144 'Parameters:#0D#0A' CONCAT
145 ' 1) Number of beacons'
146 );
147 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
148 (
149 EVENT_NETWORK_CONNECTION_RESTORED, 'SYS_NETWORK_CONN_RESTORED',
150 EVENT_SEVERITY_NORMAL, 1,
151 'NetXMS server network connectivity restored',
152 'Generated when system detects restoration of network connectivity based on beacon probing.#0D#0A' CONCAT
153 'Parameters:#0D#0A' CONCAT
154 ' 1) Number of beacons'
155 );
156 - New configuration parameters added: AgentCommandTimeout, BeaconHosts,
157 BeaconTimeout, BeaconPollingInterval
158
159
160 *************
161 * 74 ==> 75 *
162 *************
163
164 - New table added:
165 CREATE TABLE snmp_communities
166 (
167 id integer not null,
168 community varchar(255) not null,
169 PRIMARY KEY(id)
170 ) TABLE_TYPE;
171 - New columns added to table "address_lists":
172 ALTER TABLE address_lists ADD community_id integer not null
173 - New configuration parameters added: UseInterfaceAliases, SyncNodeNamesWithDNS
174
175
176 *************
177 * 73 ==> 74 *
178 *************
179
180 - New configuration parameters added: EnableEventStormDetection,
181 EventStormEventsPerSecond, EventStormDuration
182 - Removed configuration parameters NumberOfEventProcessors, EventStormThreshold
183 - New events added:
184 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
185 (
186 EVENT_EVENT_STORM_DETECTED, 'SYS_EVENT_STORM_DETECTED',
187 EVENT_SEVERITY_MAJOR, 1,
188 'Event storm detected (Events per second: %1)',
189 'Generated when system detects an event storm.#0D#0A' CONCAT
190 'Parameters:#0D#0A' CONCAT
191 ' 1) Events per second#0D#0A' CONCAT
192 ' 2) Duration#0D#0A' CONCAT
193 ' 3) Threshold'
194 );
195 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
196 (
197 EVENT_EVENT_STORM_ENDED, 'SYS_EVENT_STORM_ENDED',
198 EVENT_SEVERITY_NORMAL, 1,
199 'Event storm ended',
200 'Generated when system clears event storm condition.#0D#0A' CONCAT
201 'Parameters:#0D#0A' CONCAT
202 ' 1) Events per second#0D#0A' CONCAT
203 ' 2) Duration#0D#0A' CONCAT
204 ' 3) Threshold'
205 );
206
207
208 *************
209 * 72 ==> 73 *
210 *************
211
212 - New columns added to table "event_policy":
213 ALTER TABLE event_policy ADD situation_id integer not null
214 ALTER TABLE event_policy ADD situation_instance varchar(255) not null
215 - New table added:
216 CREATE TABLE policy_situation_attr_list
217 (
218 rule_id integer not null,
219 situation_id integer not null,
220 attr_name varchar(255) not null,
221 attr_value varchar(255) not null,
222 PRIMARY KEY(rule_id,situation_id,attr_name)
223 ) TABLE_TYPE;
224 - New table added:
225 CREATE TABLE situations
226 (
227 id integer not null,
228 name varchar(127) not null,
229 comments SQL_TEXT not null,
230 PRIMARY KEY(id)
231 ) TABLE_TYPE;
232 - New configuration parameters added: RetainCustomInterfaceNames,
233 AllowDirectSMS, EventStormThreshold
234
235
236 *************
237 * 71 ==> 72 *
238 *************
239
240 - New column added to table "items":
241 ALTER TABLE items ADD proxy_node integer not null
242
243
244 *************
245 * 70 ==> 71 *
246 *************
247
248 - New column added to table "nodes":
249 ALTER TABLE nodes ADD required_polls integer not null
250 - New column added to table "interfaces":
251 ALTER TABLE interfaces ADD required_polls integer not null
252 - New column added to table "network_services":
253 ALTER TABLE network_services ADD required_polls integer not null
254 - New configuration parameter added: PollCountForStatusChange
255
256
257 *************
258 * 69 ==> 70 *
259 *************
260
261 - New column added to table "snmp_trap_cfg":
262 ALTER TABLE snmp_trap_cfg ADD user_tag varchar(63) not null
263 - New column added to table "event_log":
264 ALTER TABLE event_log ADD user_tag varchar(63) not null
265
266
267 *************
268 * 68 ==> 69 *
269 *************
270
271 - New table "audit_log" added:
272 CREATE TABLE audit_log
273 (
274 record_id integer not null,
275 timestamp integer not null,
276 subsystem varchar(32) not null,
277 success integer not null,
278 user_id integer not null,
279 workstation varchar(63) not null,
280 object_id integer not null,
281 message SQL_TEXT not null,
282 PRIMARY KEY(record_id)
283 );
284
285
286 *************
287 * 67 ==> 68 *
288 *************
289
290 - New configuration parameter added: ThresholdRepeatInterval
291 - New column added to table "thresholds":
292 ALTER TABLE thresholds ADD repeat_interval integer not null
293
294
295 *************
296 * 66 ==> 67 *
297 *************
298
299 - New column added to table "subnets":
300 ALTER TABLE subnets ADD synthetic_mask integer not null
301 - New column added to table "interfaces":
302 ALTER TABLE interfaces ADD synthetic_mask integer not null
303
304
305 *************
306 * 65 ==> 66 *
307 *************
308
309 - New columns added to table "submap_links":
310 ALTER TABLE submap_links ADD port1 varchar(255) not null
311 ALTER TABLE submap_links ADD port2 varchar(255) not null
312
313
314 *************
315 * 64 ==> 65 *
316 *************
317
318 - Field "community" in table "nodes" changed to varchar(127)
319
320
321 *************
322 * 63 ==> 64 *
323 *************
324
325 - New OID to type mappings:
326 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
327 VALUES (15,'.1.3.6.1.4.1.45.3.29.*',NODE_TYPE_NORTEL_BAYSTACK,0);
328 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
329 VALUES (16,'.1.3.6.1.4.1.45.3.41.*',NODE_TYPE_NORTEL_BAYSTACK,0);
330 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
331 VALUES (17,'.1.3.6.1.4.1.45.3.45.*',NODE_TYPE_NORTEL_BAYSTACK,0);
332 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
333 VALUES (18,'.1.3.6.1.4.1.45.3.43.*',NODE_TYPE_NORTEL_BAYSTACK,0);
334 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
335 VALUES (19,'.1.3.6.1.4.1.45.3.57.*',NODE_TYPE_NORTEL_BAYSTACK,0);
336 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
337 VALUES (20,'.1.3.6.1.4.1.45.3.49.*',NODE_TYPE_NORTEL_BAYSTACK,0);
338 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
339 VALUES (21,'.1.3.6.1.4.1.45.3.54.*',NODE_TYPE_NORTEL_BAYSTACK,0);
340 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
341 VALUES (22,'.1.3.6.1.4.1.45.3.63.*',NODE_TYPE_NORTEL_BAYSTACK,0);
342 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
343 VALUES (23,'.1.3.6.1.4.1.45.3.64.*',NODE_TYPE_NORTEL_BAYSTACK,0);
344 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
345 VALUES (24,'.1.3.6.1.4.1.45.3.53.*',NODE_TYPE_NORTEL_BAYSTACK,0);
346 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
347 VALUES (25,'.1.3.6.1.4.1.45.3.59.*',NODE_TYPE_NORTEL_BAYSTACK,0);
348 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
349 VALUES (26,'.1.3.6.1.4.1.45.3.39.*',NODE_TYPE_NORTEL_BAYSTACK,0);
350 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
351 VALUES (27,'.1.3.6.1.4.1.45.3.65.*',NODE_TYPE_NORTEL_BAYSTACK,0);
352 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
353 VALUES (28,'.1.3.6.1.4.1.45.3.66.*',NODE_TYPE_NORTEL_BAYSTACK,0);
354 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
355 VALUES (29,'.1.3.6.1.4.1.45.3.44.*',NODE_TYPE_OPTERA_METRO,0);
356 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
357 VALUES (30,'.1.3.6.1.4.1.45.3.47.*',NODE_TYPE_OPTERA_METRO,0);
358 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
359 VALUES (31,'.1.3.6.1.4.1.45.3.48.*',NODE_TYPE_OPTERA_METRO,0);
360
361
362 *************
363 * 62 ==> 63 *
364 *************
365
366 - New events added:
367 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
368 (
369 EVENT_INTERFACE_UNKNOWN, 'SYS_IF_UNKNOWN',
370 EVENT_SEVERITY_WARNING, 1,
371 'Interface "%2" changed state to UNKNOWN (IP Addr: %3/%4, IfIndex: %5)',
372 'Generated when interface goes to unknown state.#0D#0A' CONCAT
373 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
374 'Parameters:#0D#0A' CONCAT
375 ' 1) Interface object ID#0D#0A' CONCAT
376 ' 2) Interface name#0D#0A' CONCAT
377 ' 3) Interface IP address#0D#0A' CONCAT
378 ' 4) Interface netmask#0D#0A' CONCAT
379 ' 5) Interface index'
380 );
381 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
382 (
383 EVENT_INTERFACE_DISABLED, 'SYS_IF_DISABLED',
384 EVENT_SEVERITY_NORMAL, 1,
385 'Interface "%2" disabled (IP Addr: %3/%4, IfIndex: %5)',
386 'Generated when interface administratively disabled.#0D#0A' CONCAT
387 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
388 'Parameters:#0D#0A' CONCAT
389 ' 1) Interface object ID#0D#0A' CONCAT
390 ' 2) Interface name#0D#0A' CONCAT
391 ' 3) Interface IP address#0D#0A' CONCAT
392 ' 4) Interface netmask#0D#0A' CONCAT
393 ' 5) Interface index'
394 );
395 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
396 (
397 EVENT_INTERFACE_TESTING, 'SYS_IF_TESTING',
398 EVENT_SEVERITY_NORMAL, 1,
399 'Interface "%2" is testing (IP Addr: %3/%4, IfIndex: %5)',
400 'Generated when interface goes to testing state.#0D#0A' CONCAT
401 'Please note that source of event is node, not an interface itself.#0D#0A' CONCAT
402 'Parameters:#0D#0A' CONCAT
403 ' 1) Interface object ID#0D#0A' CONCAT
404 ' 2) Interface name#0D#0A' CONCAT
405 ' 3) Interface IP address#0D#0A' CONCAT
406 ' 4) Interface netmask#0D#0A' CONCAT
407 ' 5) Interface index'
408 );
409
410
411 *************
412 * 61 ==> 62 *
413 *************
414
415 - Column "alarm_ack_key" removed from table "event_policy"
416 - New columns added to table "event_policy":
417 ALTER TABLE event_policy ADD alarm_timeout integer not null
418 ALTER TABLE event_policy ADD alarm_timeout_event integer not null
419 - New events added:
420 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
421 (
422 EVENT_ALARM_TIMEOUT, 'SYS_ALARM_TIMEOUT',
423 EVENT_SEVERITY_WARNING, 1,
424 'Alarm timeout',
425 'Generated when alarm timeout expires.#0D#0A' CONCAT
426 'Parameters:#0D#0A' CONCAT
427 ' 1) Alarm ID#0D#0A' CONCAT
428 ' 2) Alarm message#0D#0A' CONCAT
429 ' 3) Alarm key#0D#0A' CONCAT
430 ' 4) Original event code'
431 );
432 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
433 (
434 EVENT_LOG_RECORD_MATCHED, 'SYS_LOG_RECORD_MATCHED',
435 EVENT_SEVERITY_WARNING, 1,
436 'Log record matched (Policy: %1; File: %2; Record: %4)',
437 'Default event for log record match.#0D#0A' CONCAT
438 'Parameters:#0D#0A' CONCAT
439 ' 1) Policy name#0D#0A' CONCAT
440 ' 2) Log file name#0D#0A' CONCAT
441 ' 3) Matching regular expression#0D#0A' CONCAT
442 ' 4) Matched record#0D#0A' CONCAT
443 ' 5 .. 9) Reserved#0D#0A' CONCAT
444 ' 10 .. 99) Substrings extracted by regular expression'
445 );
446 - New tables added:
447 CREATE TABLE lpp_groups
448 (
449 lpp_group_id integer not null,
450 lpp_group_name varchar(63) not null,
451 parent_group integer not null, // 0 for root
452 PRIMARY KEY(lpp_group_id)
453 ) TABLE_TYPE;
454
455 CREATE TABLE lpp
456 (
457 lpp_id integer not null,
458 lpp_group_id integer not null, // 0 for root
459 lpp_name varchar(63) not null,
460 lpp_version integer not null,
461 lpp_flags integer not null,
462 PRIMARY KEY(lpp_id)
463 ) TABLE_TYPE;
464
465 CREATE TABLE lpp_associations
466 (
467 lpp_id integer not null,
468 node_id integer not null,
469 log_file varchar(255) not null
470 ) TABLE_TYPE;
471
472 CREATE TABLE lpp_rulesets
473 (
474 ruleset_id integer not null,
475 ruleset_name varchar(63),
476 PRIMARY KEY(ruleset_id)
477 ) TABLE_TYPE;
478
479 CREATE TABLE lpp_rules
480 (
481 lpp_id integer not null,
482 rule_number integer not null,
483 ruleset_id integer not null, // 0 - matching rule, >0 - ruleset id
484 msg_id_start integer not null,
485 msg_id_end integer not null,
486 severity integer not null,
487 source_name varchar(255) not null,
488 msg_text_regexp varchar(255) not null,
489 event_code integer not null,
490 PRIMARY KEY(lpp_id,rule_number)
491 ) TABLE_TYPE;
492 - New fields added to table "alarms":
493 ALTER TABLE alarms ADD timeout integer;
494 ALTER TABLE alarms ADD timeout_event integer;
495
496
497 *************
498 * 60 ==> 61 *
499 *************
500
501 - New configuration parameters: TopologyExpirationTime, TopologyDiscoveryRadius
502 - Object tool "Nortel topology" changed:
503 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description,confirmation_text)
504 VALUES (14,'&Info->Topology table (Nortel)',TOOL_TYPE_TABLE_SNMP,'Topology table',1,' ','Show topology table (Nortel protocol)','#00');
505 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
506 VALUES (14,0,'Peer IP','.1.3.6.1.4.1.45.1.6.13.2.1.1.3',CFMT_IP_ADDR,0);
507 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
508 VALUES (14,1,'Peer MAC','.1.3.6.1.4.1.45.1.6.13.2.1.1.5',CFMT_MAC_ADDR,0);
509 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
510 VALUES (14,2,'Slot','.1.3.6.1.4.1.45.1.6.13.2.1.1.1',CFMT_INTEGER,0);
511 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
512 VALUES (14,3,'Port','.1.3.6.1.4.1.45.1.6.13.2.1.1.2',CFMT_INTEGER,0);
513 - New object tools added:
514 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description,confirmation_text)
515 VALUES (17,'&Info->AR&P cache (SNMP)',TOOL_TYPE_TABLE_SNMP,'ARP Cache',1,' ','Show ARP cache','#00');
516 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
517 VALUES (17,0,'IP Address','.1.3.6.1.2.1.4.22.1.3',CFMT_IP_ADDR,0);
518 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
519 VALUES (17,1,'MAC Address','.1.3.6.1.2.1.4.22.1.2',CFMT_MAC_ADDR,0);
520 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
521 VALUES (17,2,'Interface','.1.3.6.1.2.1.4.22.1.1',CFMT_IFINDEX,0);
522
523 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description,confirmation_text)
524 VALUES (18,'&Info->AR&P cache (Agent)',TOOL_TYPE_TABLE_AGENT,
525 'ARP Cache#7FNet.ArpCache#7F(.*) (.*) (.*)',2,' ','Show ARP cache','#00');
526 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
527 VALUES (18,0,'IP Address','.1.3.6.1.2.1.4.22.1.3',CFMT_STRING,2);
528 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
529 VALUES (18,1,'MAC Address','.1.3.6.1.2.1.4.22.1.2',CFMT_STRING,1);
530 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
531 VALUES (18,2,'Interface','.1.3.6.1.2.1.4.22.1.1',CFMT_IFINDEX,3);
532
533 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description,confirmation_text)
534 VALUES (19,'&Info->&Routing table (SNMP)',TOOL_TYPE_TABLE_SNMP,'Routing Table',1,' ','Show IP routing table','#00');
535 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
536 VALUES (19,0,'Destination','.1.3.6.1.2.1.4.21.1.1',CFMT_IP_ADDR,0);
537 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
538 VALUES (19,1,'Mask','.1.3.6.1.2.1.4.21.1.11',CFMT_IP_ADDR,0);
539 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
540 VALUES (19,2,'Next hop','.1.3.6.1.2.1.4.21.1.7',CFMT_IP_ADDR,0);
541 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
542 VALUES (19,3,'Metric','.1.3.6.1.2.1.4.21.1.3',CFMT_INTEGER,0);
543 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
544 VALUES (19,4,'Interface','.1.3.6.1.2.1.4.21.1.2',CFMT_IFINDEX,0);
545
546 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (17,-2147483648);
547 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (18,-2147483648);
548 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (19,-2147483648);
549
550
551 *************
552 * 59 ==> 60 *
553 *************
554
555 - New table added:
556 CREATE TABLE certificates
557 (
558 cert_id integer not null,
559 cert_type integer not null,
560 cert_data SQL_TEXT not null,
561 subject SQL_TEXT not null,
562 comments SQL_TEXT not null,
563 PRIMARY KEY(cert_id)
564 ) TABLE_TYPE;
565 - New configuration parameters: SNMPRequestTimeout
566
567
568 *************
569 * 58 ==> 59 *
570 *************
571
572 - Added columns "cert_mapping_method" and "cert_mapping_data" to table "users":
573 ALTER TABLE users ADD cert_mapping_method integer;
574 ALTER TABLE users ADD cert_mapping_data SQL_TEXT;
575 UPDATE users SET cert_mapping_method=0;
576 UPDATE users SET cert_mapping_data='#00';
577 - New configuration parameters: InternalCA
578
579
580 *************
581 * 57 ==> 58 *
582 *************
583
584 - Added column "is_system" to table "object_properties":
585 ALTER TABLE object_properties ADD is_system integer;
586 UPDATE object_properties SET is_system=0;
587 - New tables added:
588 CREATE TABLE graphs
589 (
590 graph_id integer not null,
591 owner_id integer not null,
592 name varchar(255) not null,
593 config SQL_TEXT not null,
594 PRIMARY KEY(graph_id)
595 ) TABLE_TYPE;
596 CREATE TABLE graph_acl
597 (
598 graph_id integer not null,
599 user_id integer not null,
600 user_rights integer not null,
601 PRIMARY KEY(graph_id,user_id)
602 ) TABLE_TYPE;
603
604
605 *************
606 * 56 ==> 57 *
607 *************
608
609 - Added column "resource_id" to table "items":
610 ALTER TABLE items ADD resource_id integer;
611 UPDATE items SET resource_id=0;
612 - Added column "snmp_poxy" to table "nodes":
613 ALTER TABLE nodes ADD snmp_proxy integer;
614 UPDATE nodes SET snmp_proxy=0;
615
616
617 *************
618 * 55 ==> 56 *
619 *************
620
621 - New table added:
622 CREATE TABLE cluster_resources
623 (
624 cluster_id integer not null,
625 resource_id integer not null,
626 resource_name varchar(255) not null,
627 ip_addr varchar(15) not null,
628 PRIMARY KEY(cluster_id,resource_id)
629 ) TABLE_TYPE;
630 - New events added:
631 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
632 (
633 EVENT_CLUSTER_RESOURCE_MOVED, 'SYS_CLUSTER_RESOURCE_MOVED',
634 EVENT_SEVERITY_WARNING, 1,
635 'Cluster resource "%2" moved from node %4 to node %6',
636 'Generated when cluster resource moved between nodes.#0D#0A' CONCAT
637 'Parameters:#0D#0A' CONCAT
638 ' 1) Resource ID#0D#0A' CONCAT
639 ' 2) Resource name#0D#0A' CONCAT
640 ' 3) Previous owner node ID#0D#0A' CONCAT
641 ' 4) Previous owner node name#0D#0A' CONCAT
642 ' 5) New owner node ID#0D#0A' CONCAT
643 ' 6) New owner node name'
644 );
645 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
646 (
647 EVENT_CLUSTER_RESOURCE_DOWN, 'SYS_CLUSTER_RESOURCE_DOWN',
648 EVENT_SEVERITY_MAJOR, 1,
649 'Cluster resource "%2" is down (last owner was %4)',
650 'Generated when cluster resource goes down.#0D#0A' CONCAT
651 'Parameters:#0D#0A' CONCAT
652 ' 1) Resource ID#0D#0A' CONCAT
653 ' 2) Resource name#0D#0A' CONCAT
654 ' 3) Last owner node ID#0D#0A' CONCAT
655 ' 4) Last owner node name'
656 );
657 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
658 (
659 EVENT_CLUSTER_RESOURCE_UP, 'SYS_CLUSTER_RESOURCE_UP',
660 EVENT_SEVERITY_NORMAL, 1,
661 'Cluster resource "%2" is up (new owner is %4)',
662 'Generated when cluster resource goes up.#0D#0A' CONCAT
663 'Parameters:#0D#0A' CONCAT
664 ' 1) Resource ID#0D#0A' CONCAT
665 ' 2) Resource name#0D#0A' CONCAT
666 ' 3) New owner node ID#0D#0A' CONCAT
667 ' 4) New owner node name'
668 );
669 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
670 (
671 EVENT_CLUSTER_DOWN, 'SYS_CLUSTER_DOWN',
672 EVENT_SEVERITY_CRITICAL, 1,
673 'Cluster is down',
674 'Generated when cluster goes down.#0D#0A' CONCAT
675 'Parameters:#0D#0A' CONCAT
676 ' No message-specific parameters'
677 );
678 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
679 (
680 EVENT_CLUSTER_UP, 'SYS_CLUSTER_UP',
681 EVENT_SEVERITY_NORMAL, 1,
682 'Cluster is up',
683 'Generated when cluster goes up.#0D#0A' CONCAT
684 'Parameters:#0D#0A' CONCAT
685 ' No message-specific parameters'
686 );
687
688
689 *************
690 * 54 ==> 55 *
691 *************
692
693 - New tables added:
694 CREATE TABLE clusters
695 (
696 id integer not null,
697 cluster_type integer not null,
698 PRIMARY KEY(id)
699 ) TABLE_TYPE;
700 CREATE TABLE cluster_members
701 (
702 cluster_id integer not null,
703 node_id integer not null,
704 PRIMARY KEY(cluster_id,node_id)
705 ) TABLE_TYPE;
706 CREATE TABLE cluster_sync_subnets
707 (
708 cluster_id integer not null,
709 subnet_addr varchar(15) not null,
710 subnet_mask varchar(15) not null,
711 PRIMARY KEY(cluster_id,subnet_addr)
712 ) TABLE_TYPE;
713 - Column "description" removed from table "nodes"
714 - Column "description" removed from table "containers"
715 - Column "description" removed from table "zones"
716 - Column "description" removed from table "templates"
717 - New object image:
718 INSERT INTO images (image_id,name,file_name_png,file_hash_png,file_name_ico,file_hash_ico)
719 VALUES (16,'Obj.Cluster','cluster.png','<invalid_hash>',
720 'cluster.ico','<invalid_hash>');
721 INSERT INTO default_images (object_class,image_id)
722 VALUES (14,16);
723 - New OID to type mappings:
724 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
725 VALUES (12,'.1.3.6.1.4.1.45.3.46.*',3,0);
726 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
727 VALUES (13,'.1.3.6.1.4.1.45.3.52.*',3,0);
728 - New configuration parameters: WindowsConsoleUpgradeURL
729
730
731 *************
732 * 53 ==> 54 *
733 *************
734
735 - New table added:
736 CREATE TABLE address_lists
737 (
738 list_type integer not null, // discovery filter, etc.
739 addr_type integer not null, // 0 - addr/mask, 1 - address range
740 addr1 varchar(15) not null,
741 addr2 varchar(15) not null
742 ) TABLE_TYPE;
743 CREATE INDEX idx_address_lists_list_type ON address_lists(list_type);
744 - New configuration parameters: ActiveNetworkDiscovery, DiscoveryFilterFlags,
745 ActiveDiscoveryInterval
746 - Delete configuration parameters: EnableAccessControl,
747 EnableEventsAccessControl
748
749
750 *************
751 * 52 ==> 53 *
752 *************
753
754 - Indexes for idata tables changed
755
756
757 *************
758 * 51 ==> 52 *
759 *************
760
761 - New configuration parameter: MailEncoding
762 - Object tool "Configured ICMP targets" updated (new column "packet size" added)
763 UPDATE object_tools SET tool_data='Configured ICMP targets#7FICMP.TargetList#7F^(.*) (.*) (.*) (.*) (.*)' WHERE tool_id=12;
764 UPDATE object_tools_table_columns SET col_number=4 WHERE col_number=3 AND tool_id=12;
765 UPDATE object_tools_table_columns SET col_number=3 WHERE col_number=2 AND tool_id=12;
766 UPDATE object_tools_table_columns SET col_substr=5 WHERE col_number=1 AND tool_id=12;
767 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
768 VALUES (12,2,'Packet size','',0,4);
769 - New object tool added:
770 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description,confirmation_text)
771 VALUES (16,'&Info->Active &user sessions',TOOL_TYPE_TABLE_AGENT,
772 'Active User Sessions#7FSystem.ActiveUserSessions#7F^"(.*)" "(.*)" "(.*)"',2,'','Show list of active user sessions','#00');
773 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
774 VALUES (16,0,'User','',0,1);
775 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
776 VALUES (16,1,'Terminal','',0,2);
777 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
778 VALUES (16,2,'From','',0,3);
779
780
781 *************
782 * 50 ==> 51 *
783 *************
784
785 - Columns "range_start" and "range_end" added to table "event_groups"
786
787
788 *************
789 * 49 ==> 50 *
790 *************
791
792 - Column "confirmation_text" added to table "object_tools"
793 - Default confirmation texts set for agent restart, system restart, and system
794 shutdown tools
795
796
797 *************
798 * 48 ==> 49 *
799 *************
800
801 - Column "rearm_event_code" added to table "thresholds"
802 - Column "all_thresholds" added to table "items"
803
804
805 *************
806 * 47 ==> 48 *
807 *************
808
809 - Added table "policy_time_range_list":
810 CREATE TABLE policy_time_range_list
811 (
812 rule_id integer not null,
813 time_range_id integer not null,
814 PRIMARY KEY(rule_id,time_range_id)
815 ) TABLE_TYPE;
816 - Added table "time_ranges":
817 CREATE TABLE time_ranges
818 (
819 time_range_id integer not null,
820 wday_mask integer not null, // Bits 0 .. 6 for each day of week
821 mday_mask integer not null, // Bits 0 .. 30 for each day of month
822 month_mask integer not null, // Bits 0 .. 11 for each month
823 time_range varchar(255) not null, // In format HHMMHHMM[,HHMMHHMM[,...]]
824 PRIMARY KEY(time_range_id)
825 ) TABLE_TYPE;
826 - Column "script" added to table "event_policy"
827
828
829 *************
830 * 46 ==> 47 *
831 *************
832
833 - Column "current_state" added to table "thresholds"
834 - Column "comments" added to table "object_properties"
835 - Column "discovery_flags" removed from table "nodes"
836 - Table "alarm_notes" redesigned:
837 CREATE TABLE alarm_notes
838 (
839 note_id integer not null,
840 alarm_id integer not null,
841 change_time integer not null,
842 user_id integer not null, // Last edited by
843 note_text SQL_TEXT not null,
844 PRIMARY KEY(note_id)
845 ) TABLE_TYPE;
846 CREATE INDEX idx_alarm_notes_alarm_id ON alarm_notes(alarm_id);
847 - Table "alarms" redesigned:
848 CREATE TABLE alarms
849 (
850 alarm_id integer not null, // Unique alarm identifier
851 alarm_state integer not null,
852 hd_state integer not null, // Help desk system state
853 hd_ref varchar(63) not null, // Help desk reference
854 creation_time integer not null,
855 last_change_time integer not null,
856 source_object_id integer not null,
857 source_event_code integer not null,
858 source_event_id SQL_INT64 not null,
859 message varchar(255) not null,
860 original_severity integer not null,
861 current_severity integer not null,
862 repeat_count integer not null,
863 alarm_key varchar(255) not null, // Alarm key (used for auto acknowlegment)
864 ack_by integer not null, // ID of user who acknowleges alarm
865 term_by integer not null, // ID of user who was terminated alarm
866 PRIMARY KEY(alarm_id)
867 ) TABLE_TYPE;
868 - Table "alarm_change_log" added:
869 CREATE TABLE alarm_change_log
870 (
871 change_id SQL_INT64 not null,
872 change_time integer not null,
873 alarm_id integer not null,
874 opcode integer not null, // Operation code
875 user_id integer not null,
876 info_text SQL_TEXT not null, // Additional information
877 PRIMARY KEY(change_id)
878 ) TABLE_TYPE;
879 CREATE INDEX idx_alarm_change_log_alarm_id ON alarm_change_log(alarm_id);
880 - Table "alarm_groups" added:
881 CREATE TABLE alarm_grops
882 (
883 alarm_group_id integer not null,
884 group_name varchar(255) not null,
885 PRIMARY KEY(alarm_group_id)
886 ) TABLE_TYPE;
887 - Table "alarm_group_map" added:
888 CREATE TABLE alarm_group_map
889 (
890 alarm_group_id integer not null,
891 alarm_id integer not null,
892 PRIMARY KEY(alarm_group_id,alarm_id)
893 ) TABLE_TYPE;
894
895
896 *************
897 * 45 ==> 46 *
898 *************
899
900 - Object tool "Switch FDB" updated:
901 UPDATE object_tools_table_columns SET col_format=5 WHERE tool_id=5 AND col_number=1
902 - New OID to type translations added:
903 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
904 VALUES (2,'.1.3.6.1.4.1.45.3.26.*',3,0)
905 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
906 VALUES (3,'.1.3.6.1.4.1.45.3.30.*',3,0)
907 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
908 VALUES (4,'.1.3.6.1.4.1.45.3.31.*',3,0)
909 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
910 VALUES (5,'.1.3.6.1.4.1.45.3.32.*',3,0)
911 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
912 VALUES (6,'.1.3.6.1.4.1.45.3.33.*',3,0)
913 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
914 VALUES (7,'.1.3.6.1.4.1.45.3.34.*',3,0)
915 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
916 VALUES (8,'.1.3.6.1.4.1.45.3.35.*',3,0)
917 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
918 VALUES (9,'.1.3.6.1.4.1.45.3.36.*',3,0)
919 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
920 VALUES (10,'.1.3.6.1.4.1.45.3.40.*',3,0)
921 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
922 VALUES (11,'.1.3.6.1.4.1.45.3.61.*',3,0)
923 - New object tools added:
924 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description)
925 VALUES (14,'&Info->Topology table (Nortel)',2 ,'Topology table',1,'','Show topology table (Nortel protocol)');
926 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
927 VALUES (14,0,'Peer IP','.1.3.6.1.4.1.45.1.6.13.2.1.1.3',3 ,0);
928 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
929 VALUES (14,1,'Peer MAC','.1.3.6.1.4.1.45.1.6.13.2.1.1.5',4 ,0);
930 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
931 VALUES (14,2,'Port','.1.3.6.1.4.1.45.1.6.13.2.1.1.2',5 ,0);
932 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (14,-2147483648);
933 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description)
934 VALUES (15,'&Info->Topology table (CDP)',2 ,'Topology table',1,'','Show topology table (CDP)');
935 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
936 VALUES (15,0,'Device ID','.1.3.6.1.4.1.9.9.23.1.2.1.1.6',0 ,0);
937 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
938 VALUES (15,1,'IP Address','.1.3.6.1.4.1.9.9.23.1.2.1.1.4',3 ,0);
939 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
940 VALUES (15,2,'Platform','.1.3.6.1.4.1.9.9.23.1.2.1.1.8',0 ,0);
941 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
942 VALUES (15,3,'Version','.1.3.6.1.4.1.9.9.23.1.2.1.1.5',0 ,0);
943 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
944 VALUES (15,4,'Port','.1.3.6.1.4.1.9.9.23.1.2.1.1.7',0 ,0);
945 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (15,-2147483648);
946
947
948 *************
949 * 44 ==> 45 *
950 *************
951
952 - New events added:
953 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
954 (
955 36, 'SYS_DB_CONN_LOST', 4, 1,
956 'Lost connection with backend database engine',
957 'Generated if connection with backend database engine is lost.#0D#0A' CONCAT
958 'Parameters:#0D#0A' CONCAT
959 ' No message-specific parameters'
960 );
961 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
962 (
963 37, 'SYS_DB_CONN_RESTORED', 0, 1,
964 'Connection with backend database engine restored',
965 'Generated when connection with backend database engine restored.#0D#0A' CONCAT
966 'Parameters:#0D#0A' CONCAT
967 ' No message-specific parameters'
968 );
969
970
971 *************
972 * 43 ==> 44 *
973 *************
974
975 - Added table "agent_configs":
976 CREATE TABLE agent_configs
977 (
978 config_id integer not null,
979 config_name varchar(255) not null,
980 config_file SQL_TEXT not null,
981 config_filter SQL_TEXT not null,
982 sequence_number integer not null,
983 PRIMARY KEY(config_id)
984 ) TABLE_TYPE;
985 - New object tools added:
986 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,matching_oid,description)
987 VALUES (13,'&Info->&Process list',3,
988 'Process List#7FSystem.ProcessList#7F^([0-9]+) (.*)',2,'','Show list of currently running processes');
989 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
990 VALUES (13,0,'PID','',0,1);
991 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
992 VALUES (13,1,'Name','',0,2);
993 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (13,-2147483648);
994 - New configuration parameter: DBLockPID (hidden)
995
996
997 *************
998 * 42 ==> 43 *
999 *************
1000
1001 - New configuration parameter: RADIUSPort
1002
1003
1004 *************
1005 * 41 ==> 42 *
1006 *************
1007
1008 - Added table "conditions":
1009 CREATE TABLE conditions
1010 (
1011 id integer not null,
1012 activation_event integer not null,
1013 deactivation_event integer not null,
1014 source_object integer not null,
1015 active_status integer not null,
1016 inactive_status integer not null,
1017 script SQL_TEXT not null,
1018 PRIMARY KEY(id)
1019 ) TABLE_TYPE;
1020 - Added table "cond_dci_map":
1021 CREATE TABLE cond_dci_map
1022 (
1023 condition_id integer not null,
1024 dci_id integer not null,
1025 node_id integer not null,
1026 dci_func integer not null,
1027 num_polls integer not null,
1028 PRIMARY KEY(condition_id,dci_id)
1029 ) TABLE_TYPE;
1030 - New configuration parameters: NumberOfConditionPollers, ConditionPollingInterval
1031 - New image records:
1032 INSERT INTO images (image_id,name,file_name_png,file_hash_png,file_name_ico,file_hash_ico)
1033 VALUES (15,'Obj.Condition','condition.png','<invalid_hash>',
1034 'condition.ico','<invalid_hash>');
1035 INSERT INTO default_images (object_class,image_id)
1036 VALUES (13, 15);
1037 - New events added:
1038 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
1039 (
1040 34, 'SYS_CONDITION_ACTIVATED', 2, 1,
1041 'Condition "%2" activated',
1042 'Default event for condition activation.#0D#0A' CONCAT
1043 'Parameters:#0D#0A' CONCAT
1044 ' 1) Condition object ID#0D#0A' CONCAT
1045 ' 2) Condition object name#0D#0A' CONCAT
1046 ' 3) Previous condition status#0D#0A' CONCAT
1047 ' 4) Current condition status'
1048 );
1049 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
1050 (
1051 35, 'SYS_CONDITION_DEACTIVATED', 0, 1,
1052 'Condition "%2" deactivated',
1053 'Default event for condition deactivation.#0D#0A' CONCAT
1054 'Parameters:#0D#0A' CONCAT
1055 ' 1) Condition object ID#0D#0A' CONCAT
1056 ' 2) Condition object name#0D#0A' CONCAT
1057 ' 3) Previous condition status#0D#0A' CONCAT
1058 ' 4) Current condition status'
1059 );
1060 - Added new node type:
1061 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
1062 VALUES (1,'.1.3.6.1.4.1.3224.1.*',2,0);
1063
1064
1065 *************
1066 * 40 ==> 41 *
1067 *************
1068
1069 - New configuration parameters: RADIUSServer, RADIUSSecret, RADIUSNumRetries,
1070 RADIUSTimeout
1071 - Added column "guid" to table "users":
1072 ALTER TABLE users ADD guid varchar(36) not null;
1073 - Added column "auth_method" to table "users":
1074 ALTER TABLE users ADD auth_method integer not null;
1075 - Added column "guid" to table "user_groups":
1076 ALTER TABLE user_groups ADD guid varchar(36) not null;
1077
1078
1079 *************
1080 * 39 ==> 40 *
1081 *************
1082
1083 - Added column "grace_logins" to table "users":
1084 ALTER TABLE users ADD grace_logins integer;
1085 UPDATE users SET grace_logins=5;
1086
1087
1088 *************
1089 * 38 ==> 39 *
1090 *************
1091
1092 - Added configuration parameter "DisableVacuum"
1093 - Added configuration parameter "LockTimeout"
1094 - Added table "maps":
1095 CREATE TABLE maps
1096 (
1097 map_id integer not null,
1098 map_name varchar(255) not null,
1099 description SQL_TEXT not null,
1100 root_object_id integer not null,
1101 PRIMARY KEY(map_id)
1102 ) TABLE_TYPE;
1103 - Added table "map_access_lists":
1104 CREATE TABLE map_access_lists
1105 (
1106 map_id integer not null,
1107 user_id integer not null,
1108 access_rights integer not null,
1109 PRIMARY KEY(map_id,user_id)
1110 ) TABLE_TYPE;
1111 - Added table "submaps":
1112 CREATE TABLE submaps
1113 (
1114 map_id integer not null,
1115 submap_id integer not null,
1116 attributes integer not null,
1117 PRIMARY KEY(map_id,submap_id)
1118 ) TABLE_TYPE;
1119 - Added table "submap_object_positions":
1120 CREATE TABLE submap_object_positions
1121 (
1122 map_id integer not null,
1123 submap_id integer not null,
1124 object_id integer not null,
1125 x integer not null,
1126 y integer not null,
1127 PRIMARY KEY(map_id,submap_id,object_id)
1128 ) TABLE_TYPE;
1129 - Added table "submap_links":
1130 CREATE TABLE submap_links
1131 (
1132 map_id integer not null,
1133 submap_id integer not null,
1134 object_id1 integer not null,
1135 object_id2 integer not null,
1136 link_type integer not null,
1137 PRIMARY KEY(map_id,submap_id,object_id1,object_id2)
1138 ) TABLE_TYPE;
1139 - Added default map configuration:
1140 INSERT INTO maps (map_id,map_name,description,root_object_id)
1141 VALUES (1,'Default','Default network map',1);
1142 INSERT INTO map_access_lists (map_id,user_id,access_rights) VALUES (1,-2147483648,1);
1143 - Added event SYS_SCRIPT_ERROR:
1144 INSERT INTO event_cfg (event_code,event_name,severity,flags,message,description) VALUES
1145 (
1146 33, 'SYS_SCRIPT_ERROR', 2, 1,
1147 'Script (%1) execution error: %2',
1148 'Generated when server encounters NXSL script execution error.#0D#0A' CONCAT
1149 'Parameters:#0D#0A' CONCAT
1150 ' 1) Script name#0D#0A' CONCAT
1151 ' 2) Error text#0D#0A' CONCAT
1152 ' 3) DCI ID if script is DCI transformation script, or 0 otherwise'
1153 );
1154
1155
1156 *************
1157 * 37 ==> 38 *
1158 *************
1159
1160 - Added table "snmp_trap_log":
1161 CREATE TABLE snmp_trap_log
1162 (
1163 trap_id SQL_INT64 not null,
1164 trap_timestamp integer not null,
1165 ip_addr varchar(15) not null,
1166 object_id integer not null,
1167 trap_oid varchar(255) not null,
1168 trap_varlist SQL_TEXT not null,
1169 PRIMARY KEY(trap_id)
1170 ) TABLE_TYPE;
1171 CREATE INDEX idx_snmp_trap_log_trap_timestamp ON snmp_trap_log(trap_timestamp);
1172 - Indexes added to existing log tables:
1173 CREATE INDEX idx_event_log_event_timestamp ON event_log(event_timestamp);
1174 CREATE INDEX idx_syslog_msg_timestamp ON syslog(msg_timestamp);
1175 - Added configuration parameter "LogAllSNMPTraps"
1176
1177
1178 *************
1179 * 36 ==> 37 *
1180 *************
1181
1182 - Added table "script_library":
1183 CREATE TABLE script_library
1184 (
1185 script_id integer not null,
1186 script_name varchar(63) not null,
1187 script_code SQL_TEXT not null,
1188 PRIMARY KEY(script_id)
1189 ) TABLE_TYPE;
1190 - Added configuration parameter "DefaultCommunityString"
1191 - Added configuration parameter "DiscoveryFilter"
1192 - Removed table "new_nodes"
1193 - Removed configuration parameter "NewNodePollingInterval"
1194
1195
1196 *************
1197 * 35 ==> 36 *
1198 *************
1199
1200 - Added new column proxy_node to "nodes" table:
1201 ALTER TABLE nodes ADD proxy_node integer not null;
1202 UPDATE nodes SET proxy_node=0;
1203 - Added new column matching_oid to "object_tools" table:
1204 ALTER TABLE object_tools ADD matching_oid varchar(255) not null;
1205 UPDATE object_tools SET matching_oid='#00';
1206 - New configuration parameters added:
1207 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1208 VALUES ('CapabilityExpirationTime','604800',1,0);
1209
1210
1211 *************
1212 * 34 ==> 35 *
1213 *************
1214
1215 - Table object_properties modified:
1216 Column status_alg deleted
1217 New columns added:
1218 status_calc_alg integer not null,
1219 status_prop_alg integer not null,
1220 status_prop_alg integer not null,
1221 status_fixed_val integer not null,
1222 status_shift integer not null,
1223 status_translation varchar(8) not null,
1224 status_single_threshold integer not null,
1225 status_thresholds varchar(8) not null
1226 - Configuration parameter should be re-created:
1227 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1228 VALUES ('StatusCalculationAlgorithm','1',1,1);
1229 - New configuration parameters added:
1230 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1231 VALUES ('StatusPropagationAlgorithm','1',1,1);
1232 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1233 VALUES ('FixedStatusValue','0',1,1);
1234 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1235 VALUES ('StatusShift','0',1,1);
1236 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1237 VALUES ('StatusTranslation','01020304',1,1);
1238 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1239 VALUES ('StatusSingleThreshold','75',1,1);
1240 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1241 VALUES ('StatusThresholds','503C2814',1,1);
1242
1243
1244 *************
1245 * 33 ==> 34 *
1246 *************
1247
1248 - Added configuration variable IcmpPingSize
1249 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1250 VALUES ('IcmpPingSize','46',1,1);
1251 - Added configuration variable SMSDrvConfig
1252 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1253 VALUES ('SMSDrvConfig','',1,1);
1254 - Added table for storing syslog messages
1255 CREATE TABLE syslog
1256 (
1257 msg_id SQL_BIGINT not null,
1258 msg_timestamp integer not null,
1259 facility integer not null,
1260 severity integer not null,
1261 source_object_id integer not null,
1262 hostname varchar(127) not null,
1263 msg_tag varchar(32) not null,
1264 msg_text SQL_TEXT not null,
1265 PRIMARY KEY(msg_id)
1266 ) TABLE_TYPE;
1267 - New syslog-related parameters added:
1268 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1269 VALUES ('EnableSyslogDaemon','0',1,1);
1270 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1271 VALUES ('SyslogListenPort','514',1,1);
1272 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
1273 VALUES ('SyslogRetentionTime','5184000',1,0);
1274 - New field adv_schedule of type integer added to table items. Existing items
1275 should have this field set to 0.
1276 - New table for advanced DCI schedules
1277 CREATE TABLE dci_schedules
1278 (
1279 item_id integer not null,
1280 schedule varchar(255) not null
1281 ) TABLE_TYPE;
1282
1283
1284 *************
1285 * 32 ==> 33 *
1286 *************
1287
1288 - Added table object_tools_table_columns
1289 CREATE TABLE object_tools_table_columns
1290 (
1291 tool_id integer not null,
1292 col_number integer not null,
1293 col_name varchar(255),
1294 col_oid varchar(255),
1295 col_format integer,
1296 col_substr integer,
1297 PRIMARY KEY(tool_id,col_number)
1298 ) TABLE_TYPE;
1299 - Predefined tools added:
1300 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1301 VALUES (5,'&Info->&Switch forwarding database (FDB)',TOOL_TYPE_TABLE_SNMP,'Forwarding database',0,'Show switch forwarding database');
1302 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1303 VALUES (5,0,'MAC Address','.1.3.6.1.2.1.17.4.3.1.1',CFMT_MAC_ADDR,0);
1304 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1305 VALUES (5,1,'Port','.1.3.6.1.2.1.17.4.3.1.2',CFMT_INTEGER,0);
1306
1307 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1308 VALUES (6,'&Connect->Open &web browser',TOOL_TYPE_URL,'http://%OBJECT_IP_ADDR%',0,'Open embedded web browser to node');
1309 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1310 VALUES (7,'&Connect->Open &web browser (HTTPS)',TOOL_TYPE_URL,'https://%OBJECT_IP_ADDR%',0,'Open embedded web browser to node using HTTPS');
1311
1312 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1313 VALUES (8,'&Info->&Agent->&Subagent list',TOOL_TYPE_TABLE_AGENT,'Subagent List#7FAgent.SubAgentList#7F^(.*) (.*) (.*) (.*)',0,'Show list of loaded subagents');
1314 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1315 VALUES (8,0,'Name','',CFMT_STRING,1);
1316 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1317 VALUES (8,1,'Version','',CFMT_STRING,2);
1318 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1319 VALUES (8,2,'File','',CFMT_STRING,4);
1320 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1321 VALUES (8,3,'Module handle','',CFMT_STRING,3);
1322
1323 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1324 VALUES (9,'&Info->&Agent->Supported &parameters',TOOL_TYPE_TABLE_AGENT,'Supported parameters#7FAgent.SupportedParameters#7F^(.*)',0,'Show list of parameters supported by agent');
1325 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1326 VALUES (9,0,'Parameter','',CFMT_STRING,1);
1327
1328 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1329 VALUES (10,'&Info->&Agent->Supported &enums',TOOL_TYPE_TABLE_AGENT,'Supported enums#7FAgent.SupportedEnums#7F^(.*)',0,'Show list of enums supported by agent');
1330 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1331 VALUES (10,0,'Parameter','',CFMT_STRING,1);
1332
1333 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1334 VALUES (11,'&Info->&Agent->Supported &actions',TOOL_TYPE_TABLE_AGENT,'Supported actions#7FAgent.ActionList#7F^(.*) (.*) "(.*)".*',0,'Show list of actions supported by agent');
1335 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1336 VALUES (11,0,'Name','',CFMT_STRING,1);
1337 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1338 VALUES (11,1,'Type','',CFMT_STRING,2);
1339 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1340 VALUES (11,2,'Data','',CFMT_STRING,3);
1341
1342 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1343 VALUES (12,'&Info->&Agent->Configured &ICMP targets',TOOL_TYPE_TABLE_AGENT,'Configured ICMP targets#7FICMP.TargetList#7F^(.*) (.*) (.*) (.*)',0,'Show list of actions supported by agent');
1344 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1345 VALUES (12,0,'IP Address','',CFMT_STRING,1);
1346 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1347 VALUES (12,1,'Name','',CFMT_STRING,4);
1348 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1349 VALUES (12,2,'Last RTT','',CFMT_STRING,2);
1350 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
1351 VALUES (12,4,'Average RTT','',CFMT_STRING,3);
1352
1353 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (5,-2147483648);
1354 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (6,-2147483648);
1355 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (7,-2147483648);
1356 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (8,-2147483648);
1357 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (9,-2147483648);
1358 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (10,-2147483648);
1359 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (11,-2147483648);
1360 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (12,-2147483648);
1361
1362
1363 *************
1364 * 31 ==> 32 *
1365 *************
1366
1367 - Added table object_tools:
1368 CREATE TABLE object_tools
1369 (
1370 tool_id integer not null,
1371 tool_name varchar(255) not null,
1372 tool_type integer not null,
1373 tool_data SQL_TEXT,
1374 description varchar(255),
1375 flags integer not null,
1376 PRIMARY KEY(tool_id)
1377 ) TABLE_TYPE;
1378 - Added table object_tools_acl:
1379 CREATE TABLE object_tools_acl
1380 (
1381 tool_id integer not null,
1382 user_id integer not null,
1383 PRIMARY KEY(tool_id,user_id)
1384 ) TABLE_TYPE;
1385 - Predefined tools added:
1386 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1387 VALUES (1,'&Shutdown system',TOOL_TYPE_ACTION,'System.Shutdown',0,'Shutdown target node via NetXMS agent');
1388 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1389 VALUES (2,'&Restart system',TOOL_TYPE_ACTION,'System.Restart',0,'Restart target node via NetXMS agent');
1390 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1391 VALUES (3,'&Wakeup node',TOOL_TYPE_INTERNAL,'wakeup',0,'Wakeup node using Wake-On-LAN magic packet');
1392 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
1393 VALUES (4,'Restart &agent',TOOL_TYPE_ACTION,'Agent.Restart',0,'Restart NetXMS agent on target node');
1394 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (1,-2147483648);
1395 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (2,-2147483648);
1396 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (3,-2147483648);
1397 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (4,-2147483648);
1398
1399
1400 *************
1401 * 30 ==> 31 *
1402 *************
1403
1404 - Added configuration parameter NumberOfRoutingTablePollers
1405 - Added configuration parameter RoutingTableUpdateInterval
1406 - Added table vpn_connectors:
1407 CREATE TABLE vpn_connectors
1408 (
1409 id integer not null,
1410 node_id integer not null,
1411 peer_gateway integer not null,
1412 PRIMARY KEY(id)
1413 ) TABLE_TYPE;
1414 - Added table vpn_connector_networks:
1415 CREATE TABLE vpn_connector_networks
1416 (
1417 vpn_id integer not null,
1418 network_type integer not null, // 0 == local, 1 == remote
1419 ip_addr varchar(15),
1420 ip_netmask varchar(15),
1421 PRIMARY KEY(vpn_id,ip_addr)
1422 ) TABLE_TYPE;
1423 - New images added:
1424 INSERT INTO default_images (object_class,image_id)
1425 VALUES (12, IMG_VPN_CONNECTOR);
1426 INSERT INTO images (image_id,name,file_name_png,file_hash_png,file_name_ico,file_hash_ico)
1427 VALUES (IMG_VPN_CONNECTOR,'Obj.VPNConnector','vpnc.png','<invalid_hash>',
1428 'vpnc.ico','<invalid_hash>');