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