Upgrade wait time changed
[public/netxms.git] / sql / setup.in
CommitLineData
6c9e7d36
VK
1/*
2** Default configuration parameters
b51c8c91
AK
3**
4** ex: syntax=sql
6c9e7d36 5*/
c1142e46 6
333ece94
VK
7INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
8 VALUES ('DBFormatVersion',DB_FORMAT_VERSION,0,1);
70573ffe
VK
9INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
10 VALUES ('DBSyntax',DB_SYNTAX,0,1);
b4895bbe
VK
11INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
12 VALUES ('DBLockStatus','UNLOCKED',0,1);
13INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
14 VALUES ('DBLockInfo','',0,0);
333ece94
VK
15INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
16 VALUES ('SyncInterval','60',1,1);
17INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
18 VALUES ('NewNodePollingInterval','60',1,1);
19INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
20 VALUES ('DiscoveryPollingInterval','900',1,1);
21INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
22 VALUES ('StatusPollingInterval','30',1,1);
23INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
24 VALUES ('ConfigurationPollingInterval','3600',1,1);
25INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
26 VALUES ('ResolveNodeNames','0',1,0);
27INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
28 VALUES ('NumberOfEventProcessors','1',1,1);
29INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
30 VALUES ('ClientListenerPort','4701',1,1);
31INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
32 VALUES ('NumberOfDataCollectors','10',1,1);
d39ca961
IK
33INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
34 VALUES ('NumberOfStatusPollers','10',1,1);
35INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
36 VALUES ('NumberOfConfigurationPollers','4',1,1);
333ece94 37INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
cb7ec554 38#ifdef DB_MYSQL
f2692e04 39 VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%ld (item_id integer not null,idata_timestamp integer,idata_value varchar(255)) TYPE=InnoDB',0,1);
cb7ec554 40#else
f2692e04 41 VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%ld (item_id integer not null,idata_timestamp integer,idata_value varchar(255))',0,1);
cb7ec554 42#endif
f2692e04
VK
43INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
44 VALUES ('IDataIndexCreationCommand','CREATE INDEX idx_item_id ON idata_%ld(item_id)',0,1);
333ece94
VK
45INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
46 VALUES ('RunNetworkDiscovery','0',1,1);
47INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
48 VALUES ('EnableAdminInterface','1',1,1);
49INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
50 VALUES ('EnableAccessControl','1',1,0);
51INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
52 VALUES ('EnableEventsAccessControl','0',1,0);
53INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
54 VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds
55INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
56 VALUES ('HouseKeepingInterval','3600',1,1);
57INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
58 VALUES ('DeleteEmptySubnets','1',1,1);
59INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
60 VALUES ('EnableSNMPTraps','1',1,1);
7cbe553e
VK
61INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
62 VALUES ('SMSDriver','<none>',1,1);
083abe62
VK
63INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
64 VALUES ('SMTPServer','localhost',1,0);
65INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
66 VALUES ('SMTPFromAddr','netxms@localhost',1,0);
751f4600
VK
67INSERT INTO config (var_name,var_value,is_visible,need_server_restart)
68 VALUES ('AgentUpgradeWaitTime','600',1,0);
9b057805
VK
69
70
6c9e7d36
VK
71/*
72** Default users
73*/
9b057805 74
00c79c7b 75INSERT INTO users (id,name,password,access,flags,full_name,description)
057f9dfb
VK
76 VALUES (0,'admin',
77 '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms
00c79c7b 78 65535,8,'','Built-in system administrator account'
057f9dfb 79 );
00c79c7b 80INSERT INTO users (id,name,password,access,flags,full_name,description)
057f9dfb 81 VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty
00c79c7b 82 0,0,'','Default guest user'
057f9dfb
VK
83 );
84
85
86/*
87** Special "Everyone" user group
88*/
89
00c79c7b
VK
90INSERT INTO user_groups (id,name,access,flags,description)
91 VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group');
b6a77d6d
VK
92
93
3c468b80
VK
94/*
95** Default event groups
96*/
97
c6576857
VK
98#define ID_GROUP_1 -2147483647
99#define ID_GROUP_2 -2147483646
3c468b80 100
feea53fd 101INSERT INTO event_groups (id,name,description)
3c468b80 102 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change');
feea53fd 103INSERT INTO event_groups (id,name,description)
3c468b80
VK
104 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
105
c19b2871
VK
106INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
107INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
108INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
109INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
110INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
111INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
112INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
113
114INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
115INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
116INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
ef44d5ea
VK
117
118
119/*
120** Default container categories
121*/
122
123INSERT INTO container_categories (category,name,image_id,description)
124 VALUES (1,'Group',0,'Generic object group');
125INSERT INTO container_categories (category,name,image_id,description)
126 VALUES (2,'Location',0,'Geografic location');
127INSERT INTO container_categories (category,name,image_id,description)
128 VALUES (3,'Service',0,'Logical service');
5e918a37
VK
129
130
131/*
132** SNMP OID to node type mappings
133*/
134
135INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags)
136 VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0);