Added default values for NumberOfConfigurationPollers and NumberOfStatusPollers
[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 ('SyncInterval','60',1,1);
17 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
18 VALUES ('NewNodePollingInterval','60',1,1);
19 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
20 VALUES ('DiscoveryPollingInterval','900',1,1);
21 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
22 VALUES ('StatusPollingInterval','30',1,1);
23 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
24 VALUES ('ConfigurationPollingInterval','3600',1,1);
25 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
26 VALUES ('ResolveNodeNames','0',1,0);
27 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
28 VALUES ('NumberOfEventProcessors','1',1,1);
29 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
30 VALUES ('ClientListenerPort','4701',1,1);
31 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
32 VALUES ('NumberOfDataCollectors','10',1,1);
33 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
34 VALUES ('NumberOfStatusPollers','10',1,1);
35 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
36 VALUES ('NumberOfConfigurationPollers','4',1,1);
37 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
38 #ifdef DB_MYSQL
39 VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer,idata_value varchar(255)) TYPE=InnoDB',0,1);
40 #else
41 VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer,idata_value varchar(255))',0,1);
42 #endif
43 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
44 VALUES ('RunNetworkDiscovery','0',1,1);
45 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
46 VALUES ('EnableAdminInterface','1',1,1);
47 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
48 VALUES ('EnableAccessControl','1',1,0);
49 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
50 VALUES ('EnableEventsAccessControl','0',1,0);
51 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
52 VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds
53 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
54 VALUES ('HouseKeepingInterval','3600',1,1);
55 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56 VALUES ('DeleteEmptySubnets','1',1,1);
57 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
58 VALUES ('EnableSNMPTraps','1',1,1);
59 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
60 VALUES ('SMSDriver','<none>',1,1);
61 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
62 VALUES ('SMTPServer','localhost',1,0);
63 INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
64 VALUES ('SMTPFromAddr','netxms@localhost',1,0);
65
66
67 /*
68 ** Default users
69 */
70
71 INSERT INTO users (id,name,password,access,flags,full_name,description)
72 VALUES (0,'admin',
73 '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
74 65535,8,'','Built-in system administrator account'
75 );
76 INSERT INTO users (id,name,password,access,flags,full_name,description)
77 VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty
78 0,0,'','Default guest user'
79 );
80
81
82 /*
83 ** Special "Everyone" user group
84 */
85
86 INSERT INTO user_groups (id,name,access,flags,description)
87 VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group');
88
89
90 /*
91 ** Default event groups
92 */
93
94 #define ID_GROUP_1 -2147483647
95 #define ID_GROUP_2 -2147483646
96
97 INSERT INTO event_groups (id,name,description)
98 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
99 INSERT INTO event_groups (id,name,description)
100 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
101
102 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
103 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
104 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
105 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
106 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
107 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
108 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
109
110 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
111 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
112 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
113
114
115 /*
116 ** Default container categories
117 */
118
119 INSERT INTO container_categories (category,name,image_id,description)
120 VALUES (1,'Group',0,'Generic object group');
121 INSERT INTO container_categories (category,name,image_id,description)
122 VALUES (2,'Location',0,'Geografic location');
123 INSERT INTO container_categories (category,name,image_id,description)
124 VALUES (3,'Service',0,'Logical service');
125
126
127 /*
128 ** SNMP OID to node type mappings
129 */
130
131 INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
132 VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0);