Commit | Line | Data |
---|---|---|
6c9e7d36 VK |
1 | /* |
2 | ** Default configuration parameters | |
b51c8c91 AK |
3 | ** |
4 | ** ex: syntax=sql | |
6c9e7d36 | 5 | */ |
c1142e46 | 6 | |
333ece94 VK |
7 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
8 | VALUES ('DBFormatVersion',DB_FORMAT_VERSION,0,1); | |
70573ffe VK |
9 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
10 | VALUES ('DBSyntax',DB_SYNTAX,0,1); | |
b4895bbe VK |
11 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
12 | VALUES ('DBLockStatus','UNLOCKED',0,1); | |
13 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
14 | VALUES ('DBLockInfo','',0,0); | |
b1c6ea4a VK |
15 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
16 | VALUES ('ServerID','',0,1); | |
9587eba3 VK |
17 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
18 | VALUES ('EnableZoning','0',1,1); | |
333ece94 VK |
19 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
20 | VALUES ('SyncInterval','60',1,1); | |
333ece94 VK |
21 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
22 | VALUES ('DiscoveryPollingInterval','900',1,1); | |
23 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
56d41577 | 24 | VALUES ('StatusPollingInterval','60',1,1); |
333ece94 VK |
25 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
26 | VALUES ('ConfigurationPollingInterval','3600',1,1); | |
66485623 VK |
27 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
28 | VALUES ('RoutingTableUpdateInterval','300',1,1); | |
333ece94 | 29 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
9587eba3 | 30 | VALUES ('ResolveNodeNames','1',1,0); |
333ece94 VK |
31 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
32 | VALUES ('NumberOfEventProcessors','1',1,1); | |
33 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
34 | VALUES ('ClientListenerPort','4701',1,1); | |
35 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
36 | VALUES ('NumberOfDataCollectors','10',1,1); | |
d39ca961 IK |
37 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
38 | VALUES ('NumberOfStatusPollers','10',1,1); | |
39 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
40 | VALUES ('NumberOfConfigurationPollers','4',1,1); | |
bb0a5754 VK |
41 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
42 | VALUES ('NumberOfDiscoveryPollers','1',1,1); | |
66485623 VK |
43 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
44 | VALUES ('NumberOfRoutingTablePollers','5',1,1); | |
333ece94 | 45 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
cb7ec554 | 46 | #ifdef DB_MYSQL |
0212dc5a | 47 | VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null) TYPE=InnoDB',0,1); |
cb7ec554 | 48 | #else |
0212dc5a | 49 | VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null)',0,1); |
cb7ec554 | 50 | #endif |
f2692e04 | 51 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
0212dc5a | 52 | VALUES ('IDataIndexCreationCommand_0','CREATE INDEX idx_idata_%d_item_id ON idata_%d(item_id)',0,1); |
dfd24edd | 53 | #ifndef DB_MYSQL |
52fe5aa2 | 54 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
0212dc5a | 55 | VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%d_timestamp ON idata_%d(idata_timestamp)',0,1); |
dfd24edd | 56 | #endif |
333ece94 VK |
57 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
58 | VALUES ('RunNetworkDiscovery','0',1,1); | |
59 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
60 | VALUES ('EnableAdminInterface','1',1,1); | |
61 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
62 | VALUES ('EnableAccessControl','1',1,0); | |
63 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
64 | VALUES ('EnableEventsAccessControl','0',1,0); | |
65 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
b7be6692 | 66 | VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds |
333ece94 VK |
67 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
68 | VALUES ('HouseKeepingInterval','3600',1,1); | |
69 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
dfd24edd | 70 | VALUES ('DeleteEmptySubnets','0',1,1); |
333ece94 VK |
71 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
72 | VALUES ('EnableSNMPTraps','1',1,1); | |
7cbe553e VK |
73 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
74 | VALUES ('SMSDriver','<none>',1,1); | |
aa975b7e VK |
75 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
76 | VALUES ('SMSDrvConfig','',1,1); | |
083abe62 VK |
77 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
78 | VALUES ('SMTPServer','localhost',1,0); | |
79 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
80 | VALUES ('SMTPFromAddr','netxms@localhost',1,0); | |
751f4600 VK |
81 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
82 | VALUES ('AgentUpgradeWaitTime','600',1,0); | |
a9052846 VK |
83 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
84 | VALUES ('NumberOfUpgradeThreads','10',1,0); | |
dfd24edd VK |
85 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
86 | VALUES ('KeepAliveInterval','60',1,1); | |
305800bf VK |
87 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
88 | VALUES ('DefaultEncryptionPolicy','1',1,1); | |
89 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
90 | VALUES ('AllowedCiphers','15',1,1); | |
dc17b82b VK |
91 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
92 | VALUES ('EnableMultipleDBConnections','1',1,1); | |
93 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
94 | VALUES ('NumberOfDatabaseWriters','1',1,1); | |
7e7357e8 VK |
95 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
96 | VALUES ('IcmpPingSize','46',1,1); | |
77edf0b5 | 97 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
de6e949b | 98 | VALUES ('EnableSyslogDaemon','0',1,1); |
77edf0b5 VK |
99 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
100 | VALUES ('SyslogListenPort','514',1,1); | |
cb53cb15 VK |
101 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
102 | VALUES ('SyslogRetentionTime','5184000',1,0); | |
b6ce3970 VK |
103 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
104 | VALUES ('StatusCalculationAlgorithm','1',1,1); | |
105 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
106 | VALUES ('StatusPropagationAlgorithm','1',1,1); | |
107 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
108 | VALUES ('FixedStatusValue','0',1,1); | |
109 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
110 | VALUES ('StatusShift','0',1,1); | |
111 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
112 | VALUES ('StatusTranslation','01020304',1,1); | |
113 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
114 | VALUES ('StatusSingleThreshold','75',1,1); | |
115 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
116 | VALUES ('StatusThresholds','503C2814',1,1); | |
8d8cd3f8 VK |
117 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
118 | VALUES ('CapabilityExpirationTime','604800',1,0); // In seconds | |
269e3aca VK |
119 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
120 | VALUES ('DefaultCommunityString','public',1,0); | |
121 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
122 | VALUES ('DiscoveryFilter','none',1,0); | |
56b32598 VK |
123 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
124 | VALUES ('LogAllSNMPTraps','0',1,1); | |
5d8a7f11 VK |
125 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
126 | VALUES ('DisableVacuum','0',1,0); | |
7db87985 VK |
127 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
128 | VALUES ('LockTimeout','60000',1,1); | |
f3d12ff6 VK |
129 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
130 | VALUES ('RADIUSServer','localhost',1,0); | |
131 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
132 | VALUES ('RADIUSSecret','netxms',1,0); | |
133 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
134 | VALUES ('RADIUSPort','1645',1,0); | |
135 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
136 | VALUES ('RADIUSNumRetries','5',1,0); | |
137 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
138 | VALUES ('RADIUSTimeout','3',1,0); | |
9b057805 VK |
139 | |
140 | ||
6c9e7d36 VK |
141 | /* |
142 | ** Default users | |
143 | */ | |
9b057805 | 144 | |
95b6a1b6 | 145 | /* |
d46f2345 | 146 | INSERT INTO users (id,name,password,system_access,flags,full_name,description,grace_logins) |
057f9dfb VK |
147 | VALUES (0,'admin', |
148 | '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms | |
d46f2345 | 149 | 65535,8,'','Built-in system administrator account',5 |
057f9dfb | 150 | ); |
d46f2345 | 151 | INSERT INTO users (id,name,password,system_access,flags,full_name,description,grace_logins) |
057f9dfb | 152 | VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty |
d46f2345 | 153 | 0,0,'','Default guest user',5 |
057f9dfb | 154 | ); |
95b6a1b6 | 155 | */ |
057f9dfb VK |
156 | |
157 | ||
158 | /* | |
159 | ** Special "Everyone" user group | |
160 | */ | |
161 | ||
95b6a1b6 VK |
162 | INSERT INTO user_groups (id,name,system_access,flags,description,guid) |
163 | VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group','00000000-0000-0000-0000-000000000000'); | |
b6a77d6d VK |
164 | |
165 | ||
3c468b80 VK |
166 | /* |
167 | ** Default event groups | |
168 | */ | |
169 | ||
c6576857 VK |
170 | #define ID_GROUP_1 -2147483647 |
171 | #define ID_GROUP_2 -2147483646 | |
3c468b80 | 172 | |
feea53fd | 173 | INSERT INTO event_groups (id,name,description) |
3c468b80 | 174 | VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change'); |
feea53fd | 175 | INSERT INTO event_groups (id,name,description) |
3c468b80 VK |
176 | VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation'); |
177 | ||
c19b2871 VK |
178 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL); |
179 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR); | |
180 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING); | |
181 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR); | |
182 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL); | |
183 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN); | |
184 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED); | |
185 | ||
186 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED); | |
187 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED); | |
188 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED); | |
ef44d5ea VK |
189 | |
190 | ||
191 | /* | |
192 | ** Default container categories | |
193 | */ | |
194 | ||
195 | INSERT INTO container_categories (category,name,image_id,description) | |
196 | VALUES (1,'Group',0,'Generic object group'); | |
197 | INSERT INTO container_categories (category,name,image_id,description) | |
198 | VALUES (2,'Location',0,'Geografic location'); | |
199 | INSERT INTO container_categories (category,name,image_id,description) | |
200 | VALUES (3,'Service',0,'Logical service'); | |
5e918a37 VK |
201 | |
202 | ||
203 | /* | |
204 | ** SNMP OID to node type mappings | |
205 | */ | |
206 | ||
207 | INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags) | |
208 | VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0); |