Commit | Line | Data |
---|---|---|
6c9e7d36 VK |
1 | /* |
2 | ** Default configuration parameters | |
b51c8c91 AK |
3 | ** |
4 | ** ex: syntax=sql | |
6c9e7d36 | 5 | */ |
c1142e46 | 6 | |
31115ff9 VK |
7 | INSERT INTO config (var_name,var_value) VALUES ('DBFormatVersion',DB_FORMAT_VERSION); |
8 | INSERT INTO config (var_name,var_value) VALUES ('SyncInterval','60'); | |
9 | INSERT INTO config (var_name,var_value) VALUES ('NewNodePollingInterval','60'); | |
10 | INSERT INTO config (var_name,var_value) VALUES ('DiscoveryPollingInterval','900'); | |
11 | INSERT INTO config (var_name,var_value) VALUES ('StatusPollingInterval','30'); | |
12 | INSERT INTO config (var_name,var_value) VALUES ('ConfigurationPollingInterval','3600'); | |
13 | INSERT INTO config (var_name,var_value) VALUES ('ResolveNodeNames','0'); | |
14 | INSERT INTO config (var_name,var_value) VALUES ('NumberOfEventProcessors','1'); | |
15 | INSERT INTO config (var_name,var_value) VALUES ('ClientListenerPort','4701'); | |
16 | INSERT INTO config (var_name,var_value) VALUES ('NumberOfDataCollectors','10'); | |
17 | INSERT INTO config (var_name,var_value) VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer,idata_value varchar(255))'); | |
18 | INSERT INTO config (var_name,var_value) VALUES ('RunNetworkDiscovery','1'); | |
19 | INSERT INTO config (var_name,var_value) VALUES ('EnableAdminInterface','1'); | |
20 | INSERT INTO config (var_name,var_value) VALUES ('EnableAccessControl','1'); | |
21 | INSERT INTO config (var_name,var_value) VALUES ('EnableEventsAccessControl','0'); | |
22 | INSERT INTO config (var_name,var_value) VALUES ('EventLogRetentionTime','5184000'); // Default retention time is 60 days == 5184000 seconds | |
23 | INSERT INTO config (var_name,var_value) VALUES ('HouseKeepingInterval','3600'); | |
24 | INSERT INTO config (var_name,var_value) VALUES ('DeleteEmptySubnets','1'); | |
25 | INSERT INTO config (var_name,var_value) VALUES ('EnableSNMPTraps','1'); | |
9b057805 VK |
26 | |
27 | ||
6c9e7d36 VK |
28 | /* |
29 | ** Default users | |
30 | */ | |
9b057805 | 31 | |
00c79c7b | 32 | INSERT INTO users (id,name,password,access,flags,full_name,description) |
057f9dfb VK |
33 | VALUES (0,'admin', |
34 | '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms | |
00c79c7b | 35 | 65535,8,'','Built-in system administrator account' |
057f9dfb | 36 | ); |
00c79c7b | 37 | INSERT INTO users (id,name,password,access,flags,full_name,description) |
057f9dfb | 38 | VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty |
00c79c7b | 39 | 0,0,'','Default guest user' |
057f9dfb VK |
40 | ); |
41 | ||
42 | ||
43 | /* | |
44 | ** Special "Everyone" user group | |
45 | */ | |
46 | ||
00c79c7b VK |
47 | INSERT INTO user_groups (id,name,access,flags,description) |
48 | VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group'); | |
b6a77d6d VK |
49 | |
50 | ||
51 | /* | |
52 | ** Component lock table | |
53 | */ | |
54 | ||
55 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) | |
3c468b80 | 56 | VALUES (CID_NETXMS_INSTANCE,'NetXMS Server Instance',-1,''); |
b6a77d6d | 57 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) |
3c468b80 | 58 | VALUES (CID_EPP,'Event Processing Policy',-1,''); |
b6a77d6d | 59 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) |
1b3e2cfe | 60 | VALUES (CID_USER_DB,'User Database',-1,''); |
3c468b80 | 61 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) |
9fd5ec9e | 62 | VALUES (CID_EVENT_DB,'Event Configuration Database',-1,''); |
c9363772 VK |
63 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) |
64 | VALUES (CID_ACTION_DB,'Action Configuration Database',-1,''); | |
3c468b80 VK |
65 | |
66 | ||
67 | /* | |
68 | ** Default event groups | |
69 | */ | |
70 | ||
c6576857 VK |
71 | #define ID_GROUP_1 -2147483647 |
72 | #define ID_GROUP_2 -2147483646 | |
3c468b80 | 73 | |
feea53fd | 74 | INSERT INTO event_groups (id,name,description) |
3c468b80 | 75 | VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change'); |
feea53fd | 76 | INSERT INTO event_groups (id,name,description) |
3c468b80 VK |
77 | VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation'); |
78 | ||
feea53fd VK |
79 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL); |
80 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MINOR); | |
81 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_WARNING); | |
82 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR); | |
83 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL); | |
84 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN); | |
85 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED); | |
3c468b80 | 86 | |
feea53fd VK |
87 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_NODE_ADDED); |
88 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED); | |
89 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED); | |
ef44d5ea VK |
90 | |
91 | ||
92 | /* | |
93 | ** Default container categories | |
94 | */ | |
95 | ||
96 | INSERT INTO container_categories (category,name,image_id,description) | |
97 | VALUES (1,'Group',0,'Generic object group'); | |
98 | INSERT INTO container_categories (category,name,image_id,description) | |
99 | VALUES (2,'Location',0,'Geografic location'); | |
100 | INSERT INTO container_categories (category,name,image_id,description) | |
101 | VALUES (3,'Service',0,'Logical service'); |