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