Commit | Line | Data |
---|---|---|
6c9e7d36 VK |
1 | /* |
2 | ** Default configuration parameters | |
3 | */ | |
c1142e46 | 4 | |
809847f3 | 5 | INSERT INTO config (name,value) VALUES ('SyncInterval','60'); |
a713e82e | 6 | INSERT INTO config (name,value) VALUES ('NewNodePollingInterval','60'); |
24045761 | 7 | INSERT INTO config (name,value) VALUES ('DiscoveryPollingInterval','900'); |
8bf20f8c | 8 | INSERT INTO config (name,value) VALUES ('StatusPollingInterval','30'); |
ba1ececc | 9 | INSERT INTO config (name,value) VALUES ('ConfigurationPollingInterval','3600'); |
24045761 | 10 | INSERT INTO config (name,value) VALUES ('ResolveNodeNames','0'); |
c1142e46 | 11 | INSERT INTO config (name,value) VALUES ('NumberOfEventProcessors','1'); |
b04752b5 | 12 | INSERT INTO config (name,value) VALUES ('ClientListenerPort','4701'); |
69630c40 VK |
13 | INSERT INTO config (name,value) VALUES ('NumberOfDataCollectors','10'); |
14 | INSERT INTO config (name,value) VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,timestamp integer,value varchar(255))'); | |
f806ed94 VK |
15 | INSERT INTO config (name,value) VALUES ('RunNetworkDiscovery','1'); |
16 | INSERT INTO config (name,value) VALUES ('EnableAdminInterface','1'); | |
17 | INSERT INTO config (name,value) VALUES ('EnableAccessControl','1'); | |
18 | INSERT INTO config (name,value) VALUES ('EnableEventsAccessControl','0'); | |
96c368de VK |
19 | INSERT INTO config (name,value) VALUES ('EventLogRetentionTime','5184000'); // Default retention time is 60 days == 5184000 seconds |
20 | INSERT INTO config (name,value) VALUES ('HouseKeepingInterval','3600'); | |
2fa71464 | 21 | INSERT INTO config (name,value) VALUES ('DeleteEmptySubnets','1'); |
8e52088c | 22 | INSERT INTO config (name,value) VALUES ('EnableSNMPTraps','1'); |
9b057805 VK |
23 | |
24 | ||
6c9e7d36 VK |
25 | /* |
26 | ** Default users | |
27 | */ | |
9b057805 | 28 | |
b6a77d6d VK |
29 | INSERT INTO users (id,name,password) |
30 | VALUES (0,'admin','3A445C0072CD69D9030CC6644020E5C4576051B1'); // Default password: netxms | |
31 | INSERT INTO users (id,name,password) | |
32 | VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709'); // Default password is empty | |
33 | ||
34 | ||
35 | /* | |
36 | ** Component lock table | |
37 | */ | |
38 | ||
39 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) | |
3c468b80 | 40 | VALUES (CID_NETXMS_INSTANCE,'NetXMS Server Instance',-1,''); |
b6a77d6d | 41 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) |
3c468b80 | 42 | VALUES (CID_EPP,'Event Processing Policy',-1,''); |
b6a77d6d | 43 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) |
3c468b80 VK |
44 | VALUES (CID_USER_MGMT,'User Management',-1,''); |
45 | INSERT INTO locks (component_id,component_name,lock_status,owner_info) | |
9fd5ec9e | 46 | VALUES (CID_EVENT_DB,'Event Configuration Database',-1,''); |
3c468b80 VK |
47 | |
48 | ||
49 | /* | |
50 | ** Default event groups | |
51 | */ | |
52 | ||
c6576857 VK |
53 | #define ID_GROUP_1 -2147483647 |
54 | #define ID_GROUP_2 -2147483646 | |
3c468b80 | 55 | |
feea53fd | 56 | INSERT INTO event_groups (id,name,description) |
3c468b80 | 57 | VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change'); |
feea53fd | 58 | INSERT INTO event_groups (id,name,description) |
3c468b80 VK |
59 | VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation'); |
60 | ||
feea53fd VK |
61 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL); |
62 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MINOR); | |
63 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_WARNING); | |
64 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR); | |
65 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL); | |
66 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN); | |
67 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED); | |
3c468b80 | 68 | |
feea53fd VK |
69 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_NODE_ADDED); |
70 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED); | |
71 | INSERT INTO event_group_members (group_id,event_id) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED); |