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