be8e7b4fe6a343c1f3a3e7c863743d118fdbc5a5
[public/netxms.git] / sql / setup.in
1 /*
2 ** Default configuration parameters
3 **
4 ** ex: syntax=sql
5 */
6
7 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
8 VALUES ('DBFormatVersion',DB_FORMAT_VERSION,0,1);
9 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
10 VALUES ('DBSyntax',DB_SYNTAX,0,1);
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);
15 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
16 VALUES ('ServerID','',0,1);
17 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
18 VALUES ('EnableZoning','0',1,1);
19 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
20 VALUES ('SyncInterval','60',1,1);
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)
24 VALUES ('StatusPollingInterval','60',1,1);
25 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
26 VALUES ('ConfigurationPollingInterval','3600',1,1);
27 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
28 VALUES ('RoutingTableUpdateInterval','300',1,1);
29 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
30 VALUES ('ResolveNodeNames','1',1,0);
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);
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);
41 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
42 VALUES ('NumberOfDiscoveryPollers','1',1,1);
43 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
44 VALUES ('NumberOfRoutingTablePollers','5',1,1);
45 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
46 #ifdef DB_MYSQL
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);
48 #else
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);
50 #endif
51 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
52 VALUES ('IDataIndexCreationCommand_0','CREATE INDEX idx_idata_%d_item_id ON idata_%d(item_id)',0,1);
53 #ifndef DB_MYSQL
54 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
55 VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%d_timestamp ON idata_%d(idata_timestamp)',0,1);
56 #endif
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)
66 VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds
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)
70 VALUES ('DeleteEmptySubnets','0',1,1);
71 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
72 VALUES ('EnableSNMPTraps','1',1,1);
73 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
74 VALUES ('SMSDriver','<none>',1,1);
75 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
76 VALUES ('SMSDrvConfig','',1,1);
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);
81 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
82 VALUES ('AgentUpgradeWaitTime','600',1,0);
83 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
84 VALUES ('NumberOfUpgradeThreads','10',1,0);
85 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
86 VALUES ('KeepAliveInterval','60',1,1);
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);
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);
95 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
96 VALUES ('IcmpPingSize','46',1,1);
97 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
98 VALUES ('EnableSyslogDaemon','0',1,1);
99 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
100 VALUES ('SyslogListenPort','514',1,1);
101 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
102 VALUES ('SyslogRetentionTime','5184000',1,0);
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);
117 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
118 VALUES ('CapabilityExpirationTime','604800',1,0); // In seconds
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);
123 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
124 VALUES ('LogAllSNMPTraps','0',1,1);
125 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
126 VALUES ('DisableVacuum','0',1,0);
127 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
128 VALUES ('LockTimeout','60000',1,1);
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);
139
140
141 /*
142 ** Default users
143 */
144
145 INSERT INTO users (id,name,password,system_access,flags,full_name,description,grace_logins)
146 VALUES (0,'admin',
147 '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
148 65535,8,'','Built-in system administrator account',5
149 );
150 INSERT INTO users (id,name,password,system_access,flags,full_name,description,grace_logins)
151 VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty
152 0,0,'','Default guest user',5
153 );
154
155
156 /*
157 ** Special "Everyone" user group
158 */
159
160 INSERT INTO user_groups (id,name,system_access,flags,description)
161 VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group');
162
163
164 /*
165 ** Default event groups
166 */
167
168 #define ID_GROUP_1 -2147483647
169 #define ID_GROUP_2 -2147483646
170
171 INSERT INTO event_groups (id,name,description)
172 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
173 INSERT INTO event_groups (id,name,description)
174 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
175
176 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
177 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
178 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
179 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
180 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
181 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
182 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
183
184 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
185 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
186 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
187
188
189 /*
190 ** Default container categories
191 */
192
193 INSERT INTO container_categories (category,name,image_id,description)
194 VALUES (1,'Group',0,'Generic object group');
195 INSERT INTO container_categories (category,name,image_id,description)
196 VALUES (2,'Location',0,'Geografic location');
197 INSERT INTO container_categories (category,name,image_id,description)
198 VALUES (3,'Service',0,'Logical service');
199
200
201 /*
202 ** SNMP OID to node type mappings
203 */
204
205 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
206 VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0);