Wait hint value for service startup increased
[public/netxms.git] / doc / db_format_change.txt
1 *************
2 * 35 ==> 36 *
3 *************
4
5 - Added new column proxy_node to "nodes" table:
6 ALTER TABLE nodes ADD proxy_node integer not null
7 - Added new column matching_oid to "object_tools" table:
8 ALTER TABLE object_tools ADD matching_oid varchar(255) not null
9
10
11 *************
12 * 34 ==> 35 *
13 *************
14
15 - Table object_properties modified:
16 Column status_alg deleted
17 New columns added:
18 status_calc_alg integer not null,
19 status_prop_alg integer not null,
20 status_prop_alg integer not null,
21 status_fixed_val integer not null,
22 status_shift integer not null,
23 status_translation varchar(8) not null,
24 status_single_threshold integer not null,
25 status_thresholds varchar(8) not null
26 - Configuration parameter should be re-created:
27 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
28 VALUES ('StatusCalculationAlgorithm','1',1,1);
29 - New configuration parameters added:
30 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
31 VALUES ('StatusPropagationAlgorithm','1',1,1);
32 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
33 VALUES ('FixedStatusValue','0',1,1);
34 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
35 VALUES ('StatusShift','0',1,1);
36 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
37 VALUES ('StatusTranslation','01020304',1,1);
38 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
39 VALUES ('StatusSingleThreshold','75',1,1);
40 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
41 VALUES ('StatusThresholds','503C2814',1,1);
42
43
44 *************
45 * 33 ==> 34 *
46 *************
47
48 - Added configuration variable IcmpPingSize
49 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
50 VALUES ('IcmpPingSize','46',1,1);
51 - Added configuration variable SMSDrvConfig
52 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
53 VALUES ('SMSDrvConfig','',1,1);
54 - Added table for storing syslog messages
55 CREATE TABLE syslog
56 (
57 msg_id SQL_BIGINT not null,
58 msg_timestamp integer not null,
59 facility integer not null,
60 severity integer not null,
61 source_object_id integer not null,
62 hostname varchar(127) not null,
63 msg_tag varchar(32) not null,
64 msg_text SQL_TEXT not null,
65 PRIMARY KEY(msg_id)
66 ) TABLE_TYPE;
67 - New syslog-related parameters added:
68 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
69 VALUES ('EnableSyslogDaemon','0',1,1);
70 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
71 VALUES ('SyslogListenPort','514',1,1);
72 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
73 VALUES ('SyslogRetentionTime','5184000',1,0);
74 - New field adv_schedule of type integer added to table items. Existing items
75 should have this field set to 0.
76 - New table for advanced DCI schedules
77 CREATE TABLE dci_schedules
78 (
79 item_id integer not null,
80 schedule varchar(255) not null
81 ) TABLE_TYPE;
82
83
84 *************
85 * 32 ==> 33 *
86 *************
87
88 - Added table object_tools_table_columns
89 CREATE TABLE object_tools_table_columns
90 (
91 tool_id integer not null,
92 col_number integer not null,
93 col_name varchar(255),
94 col_oid varchar(255),
95 col_format integer,
96 col_substr integer,
97 PRIMARY KEY(tool_id,col_number)
98 ) TABLE_TYPE;
99 - Predefined tools added:
100 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
101 VALUES (5,'&Info->&Switch forwarding database (FDB)',TOOL_TYPE_TABLE_SNMP,'Forwarding database',0,'Show switch forwarding database');
102 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
103 VALUES (5,0,'MAC Address','.1.3.6.1.2.1.17.4.3.1.1',CFMT_MAC_ADDR,0);
104 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
105 VALUES (5,1,'Port','.1.3.6.1.2.1.17.4.3.1.2',CFMT_INTEGER,0);
106
107 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
108 VALUES (6,'&Connect->Open &web browser',TOOL_TYPE_URL,'http://%OBJECT_IP_ADDR%',0,'Open embedded web browser to node');
109 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
110 VALUES (7,'&Connect->Open &web browser (HTTPS)',TOOL_TYPE_URL,'https://%OBJECT_IP_ADDR%',0,'Open embedded web browser to node using HTTPS');
111
112 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
113 VALUES (8,'&Info->&Agent->&Subagent list',TOOL_TYPE_TABLE_AGENT,'Subagent List#7FAgent.SubAgentList#7F^(.*) (.*) (.*) (.*)',0,'Show list of loaded subagents');
114 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
115 VALUES (8,0,'Name','',CFMT_STRING,1);
116 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
117 VALUES (8,1,'Version','',CFMT_STRING,2);
118 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
119 VALUES (8,2,'File','',CFMT_STRING,4);
120 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
121 VALUES (8,3,'Module handle','',CFMT_STRING,3);
122
123 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
124 VALUES (9,'&Info->&Agent->Supported &parameters',TOOL_TYPE_TABLE_AGENT,'Supported parameters#7FAgent.SupportedParameters#7F^(.*)',0,'Show list of parameters supported by agent');
125 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
126 VALUES (9,0,'Parameter','',CFMT_STRING,1);
127
128 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
129 VALUES (10,'&Info->&Agent->Supported &enums',TOOL_TYPE_TABLE_AGENT,'Supported enums#7FAgent.SupportedEnums#7F^(.*)',0,'Show list of enums supported by agent');
130 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
131 VALUES (10,0,'Parameter','',CFMT_STRING,1);
132
133 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
134 VALUES (11,'&Info->&Agent->Supported &actions',TOOL_TYPE_TABLE_AGENT,'Supported actions#7FAgent.ActionList#7F^(.*) (.*) "(.*)".*',0,'Show list of actions supported by agent');
135 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
136 VALUES (11,0,'Name','',CFMT_STRING,1);
137 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
138 VALUES (11,1,'Type','',CFMT_STRING,2);
139 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
140 VALUES (11,2,'Data','',CFMT_STRING,3);
141
142 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
143 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');
144 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
145 VALUES (12,0,'IP Address','',CFMT_STRING,1);
146 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
147 VALUES (12,1,'Name','',CFMT_STRING,4);
148 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
149 VALUES (12,2,'Last RTT','',CFMT_STRING,2);
150 INSERT INTO object_tools_table_columns (tool_id,col_number,col_name,col_oid,col_format,col_substr)
151 VALUES (12,4,'Average RTT','',CFMT_STRING,3);
152
153 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (5,-2147483648);
154 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (6,-2147483648);
155 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (7,-2147483648);
156 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (8,-2147483648);
157 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (9,-2147483648);
158 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (10,-2147483648);
159 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (11,-2147483648);
160 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (12,-2147483648);
161
162
163 *************
164 * 31 ==> 32 *
165 *************
166
167 - Added table object_tools:
168 CREATE TABLE object_tools
169 (
170 tool_id integer not null,
171 tool_name varchar(255) not null,
172 tool_type integer not null,
173 tool_data SQL_TEXT,
174 description varchar(255),
175 flags integer not null,
176 PRIMARY KEY(tool_id)
177 ) TABLE_TYPE;
178 - Added table object_tools_acl:
179 CREATE TABLE object_tools_acl
180 (
181 tool_id integer not null,
182 user_id integer not null,
183 PRIMARY KEY(tool_id,user_id)
184 ) TABLE_TYPE;
185 - Predefined tools added:
186 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
187 VALUES (1,'&Shutdown system',TOOL_TYPE_ACTION,'System.Shutdown',0,'Shutdown target node via NetXMS agent');
188 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
189 VALUES (2,'&Restart system',TOOL_TYPE_ACTION,'System.Restart',0,'Restart target node via NetXMS agent');
190 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
191 VALUES (3,'&Wakeup node',TOOL_TYPE_INTERNAL,'wakeup',0,'Wakeup node using Wake-On-LAN magic packet');
192 INSERT INTO object_tools (tool_id,tool_name,tool_type,tool_data,flags,description)
193 VALUES (4,'Restart &agent',TOOL_TYPE_ACTION,'Agent.Restart',0,'Restart NetXMS agent on target node');
194 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (1,-2147483648);
195 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (2,-2147483648);
196 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (3,-2147483648);
197 INSERT INTO object_tools_acl (tool_id,user_id) VALUES (4,-2147483648);
198
199
200 *************
201 * 30 ==> 31 *
202 *************
203
204 - Added configuration parameter NumberOfRoutingTablePollers
205 - Added configuration parameter RoutingTableUpdateInterval
206 - Added table vpn_connectors:
207 CREATE TABLE vpn_connectors
208 (
209 id integer not null,
210 node_id integer not null,
211 peer_gateway integer not null,
212 PRIMARY KEY(id)
213 ) TABLE_TYPE;
214 - Added table vpn_connector_networks:
215 CREATE TABLE vpn_connector_networks
216 (
217 vpn_id integer not null,
218 network_type integer not null, // 0 == local, 1 == remote
219 ip_addr varchar(15),
220 ip_netmask varchar(15),
221 PRIMARY KEY(vpn_id,ip_addr)
222 ) TABLE_TYPE;
223 - New images added:
224 INSERT INTO default_images (object_class,image_id)
225 VALUES (12, IMG_VPN_CONNECTOR);
226 INSERT INTO images (image_id,name,file_name_png,file_hash_png,file_name_ico,file_hash_ico)
227 VALUES (IMG_VPN_CONNECTOR,'Obj.VPNConnector','vpnc.png','<invalid_hash>',
228 'vpnc.ico','<invalid_hash>');