git.netxms.org / public / netxms.git / blame
| Commit | Line | Data |
|---|---|---|
| 6c9e7d36 VK |
1 | /* |
| 2 | ** Default configuration parameters | |
| b51c8c91 AK |
3 | ** |
| 4 | ** ex: syntax=sql | |
| 6c9e7d36 | 5 | */ |
| c1142e46 | 6 | |
| 333ece94 VK |
7 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 8 | VALUES ('DBFormatVersion',DB_FORMAT_VERSION,0,1); | |
| 70573ffe VK |
9 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 10 | VALUES ('DBSyntax',DB_SYNTAX,0,1); | |
| b4895bbe VK |
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); | |
| b1c6ea4a VK |
15 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 16 | VALUES ('ServerID','',0,1); | |
| 9587eba3 VK |
17 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 18 | VALUES ('EnableZoning','0',1,1); | |
| 333ece94 VK |
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 ('NewNodePollingInterval','60',1,1); | |
| 23 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 24 | VALUES ('DiscoveryPollingInterval','900',1,1); | |
| 25 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 56d41577 | 26 | VALUES ('StatusPollingInterval','60',1,1); |
| 333ece94 VK |
27 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 28 | VALUES ('ConfigurationPollingInterval','3600',1,1); | |
| 66485623 VK |
29 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 30 | VALUES ('RoutingTableUpdateInterval','300',1,1); | |
| 333ece94 | 31 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 9587eba3 | 32 | VALUES ('ResolveNodeNames','1',1,0); |
| 333ece94 VK |
33 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 34 | VALUES ('NumberOfEventProcessors','1',1,1); | |
| 35 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 36 | VALUES ('ClientListenerPort','4701',1,1); | |
| 37 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 38 | VALUES ('NumberOfDataCollectors','10',1,1); | |
| d39ca961 IK |
39 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 40 | VALUES ('NumberOfStatusPollers','10',1,1); | |
| 41 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 42 | VALUES ('NumberOfConfigurationPollers','4',1,1); | |
| bb0a5754 VK |
43 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 44 | VALUES ('NumberOfDiscoveryPollers','1',1,1); | |
| 66485623 VK |
45 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 46 | VALUES ('NumberOfRoutingTablePollers','5',1,1); | |
| 333ece94 | 47 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| cb7ec554 | 48 | #ifdef DB_MYSQL |
| 0212dc5a | 49 | 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); |
| cb7ec554 | 50 | #else |
| 0212dc5a | 51 | VALUES ('IDataTableCreationCommand','CREATE TABLE idata_%d (item_id integer not null,idata_timestamp integer not null,idata_value varchar(255) not null)',0,1); |
| cb7ec554 | 52 | #endif |
| f2692e04 | 53 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 0212dc5a | 54 | VALUES ('IDataIndexCreationCommand_0','CREATE INDEX idx_idata_%d_item_id ON idata_%d(item_id)',0,1); |
| dfd24edd | 55 | #ifndef DB_MYSQL |
| 52fe5aa2 | 56 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 0212dc5a | 57 | VALUES ('IDataIndexCreationCommand_1','CREATE INDEX idx_idata_%d_timestamp ON idata_%d(idata_timestamp)',0,1); |
| dfd24edd | 58 | #endif |
| 333ece94 VK |
59 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 60 | VALUES ('RunNetworkDiscovery','0',1,1); | |
| 61 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 62 | VALUES ('EnableAdminInterface','1',1,1); | |
| 63 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 64 | VALUES ('EnableAccessControl','1',1,0); | |
| 65 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 66 | VALUES ('EnableEventsAccessControl','0',1,0); | |
| 67 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| b7be6692 | 68 | VALUES ('EventLogRetentionTime','5184000',1,0); // Default retention time is 60 days == 5184000 seconds |
| 333ece94 VK |
69 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 70 | VALUES ('HouseKeepingInterval','3600',1,1); | |
| 71 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| dfd24edd | 72 | VALUES ('DeleteEmptySubnets','0',1,1); |
| 333ece94 VK |
73 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 74 | VALUES ('EnableSNMPTraps','1',1,1); | |
| 7cbe553e VK |
75 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 76 | VALUES ('SMSDriver','<none>',1,1); | |
| aa975b7e VK |
77 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 78 | VALUES ('SMSDrvConfig','',1,1); | |
| 083abe62 VK |
79 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 80 | VALUES ('SMTPServer','localhost',1,0); | |
| 81 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 82 | VALUES ('SMTPFromAddr','netxms@localhost',1,0); | |
| 751f4600 VK |
83 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 84 | VALUES ('AgentUpgradeWaitTime','600',1,0); | |
| a9052846 VK |
85 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 86 | VALUES ('NumberOfUpgradeThreads','10',1,0); | |
| dfd24edd VK |
87 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 88 | VALUES ('KeepAliveInterval','60',1,1); | |
| 305800bf VK |
89 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 90 | VALUES ('DefaultEncryptionPolicy','1',1,1); | |
| 91 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 92 | VALUES ('AllowedCiphers','15',1,1); | |
| dc17b82b VK |
93 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 94 | VALUES ('EnableMultipleDBConnections','1',1,1); | |
| 95 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 96 | VALUES ('NumberOfDatabaseWriters','1',1,1); | |
| 7e7357e8 VK |
97 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 98 | VALUES ('IcmpPingSize','46',1,1); | |
| 77edf0b5 | 99 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| de6e949b | 100 | VALUES ('EnableSyslogDaemon','0',1,1); |
| 77edf0b5 VK |
101 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 102 | VALUES ('SyslogListenPort','514',1,1); | |
| cb53cb15 VK |
103 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 104 | VALUES ('SyslogRetentionTime','5184000',1,0); | |
| b6ce3970 VK |
105 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) |
| 106 | VALUES ('StatusCalculationAlgorithm','1',1,1); | |
| 107 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 108 | VALUES ('StatusPropagationAlgorithm','1',1,1); | |
| 109 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 110 | VALUES ('FixedStatusValue','0',1,1); | |
| 111 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 112 | VALUES ('StatusShift','0',1,1); | |
| 113 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 114 | VALUES ('StatusTranslation','01020304',1,1); | |
| 115 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 116 | VALUES ('StatusSingleThreshold','75',1,1); | |
| 117 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) | |
| 118 | VALUES ('StatusThresholds','503C2814',1,1); | |
| 9b057805 VK |
119 | |
| 120 | ||
| 6c9e7d36 VK |
121 | /* |
| 122 | ** Default users | |
| 123 | */ | |
| 9b057805 | 124 | |
| fa3f5211 | 125 | INSERT INTO users (id,name,password,system_access,flags,full_name,description) |
| 057f9dfb VK |
126 | VALUES (0,'admin', |
| 127 | '3A445C0072CD69D9030CC6644020E5C4576051B1', // Default password: netxms | |
| 00c79c7b | 128 | 65535,8,'','Built-in system administrator account' |
| 057f9dfb | 129 | ); |
| fa3f5211 | 130 | INSERT INTO users (id,name,password,system_access,flags,full_name,description) |
| 057f9dfb | 131 | VALUES (1,'guest','DA39A3EE5E6B4B0D3255BFEF95601890AFD80709', // Default password is empty |
| 00c79c7b | 132 | 0,0,'','Default guest user' |
| 057f9dfb VK |
133 | ); |
| 134 | ||
| 135 | ||
| 136 | /* | |
| 137 | ** Special "Everyone" user group | |
| 138 | */ | |
| 139 | ||
| fa3f5211 | 140 | INSERT INTO user_groups (id,name,system_access,flags,description) |
| 00c79c7b | 141 | VALUES (-2147483648, 'Everyone', 16, 0, 'Built-in everyone group'); |
| b6a77d6d VK |
142 | |
| 143 | ||
| 3c468b80 VK |
144 | /* |
| 145 | ** Default event groups | |
| 146 | */ | |
| 147 | ||
| c6576857 VK |
148 | #define ID_GROUP_1 -2147483647 |
| 149 | #define ID_GROUP_2 -2147483646 | |
| 3c468b80 | 150 | |
| feea53fd | 151 | INSERT INTO event_groups (id,name,description) |
| 3c468b80 | 152 | VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change'); |
| feea53fd | 153 | INSERT INTO event_groups (id,name,description) |
| 3c468b80 VK |
154 | VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation'); |
| 155 | ||
| c19b2871 VK |
156 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL); |
| 157 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR); | |
| 158 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING); | |
| 159 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR); | |
| 160 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL); | |
| 161 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN); | |
| 162 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED); | |
| 163 | ||
| 164 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED); | |
| 165 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED); | |
| 166 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED); | |
| ef44d5ea VK |
167 | |
| 168 | ||
| 169 | /* | |
| 170 | ** Default container categories | |
| 171 | */ | |
| 172 | ||
| 173 | INSERT INTO container_categories (category,name,image_id,description) | |
| 174 | VALUES (1,'Group',0,'Generic object group'); | |
| 175 | INSERT INTO container_categories (category,name,image_id,description) | |
| 176 | VALUES (2,'Location',0,'Geografic location'); | |
| 177 | INSERT INTO container_categories (category,name,image_id,description) | |
| 178 | VALUES (3,'Service',0,'Logical service'); | |
| 5e918a37 VK |
179 | |
| 180 | ||
| 181 | /* | |
| 182 | ** SNMP OID to node type mappings | |
| 183 | */ | |
| 184 | ||
| 185 | INSERT INTO oid_to_type (pair_id,snmp_oid,node_type,node_flags) | |
| 186 | VALUES (0,'.1.3.6.1.4.1.2272.*',NODE_TYPE_NORTEL_ACCELAR,0); |