Commit | Line | Data |
---|---|---|
6c9e7d36 VK |
1 | /* |
2 | ** Default configuration parameters | |
b51c8c91 AK |
3 | ** |
4 | ** ex: syntax=sql | |
6c9e7d36 | 5 | */ |
c1142e46 | 6 | |
549f48b3 VK |
7 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ActiveDiscoveryInterval','7200',1,1); |
8 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ActiveNetworkDiscovery','0',1,1); | |
9 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AgentCommandTimeout','4000',1,1); | |
af21affe | 10 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AgentDefaultSharedSecret','netxms',1,0); |
549f48b3 VK |
11 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AgentUpgradeWaitTime','600',1,0); |
12 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AlarmHistoryRetentionTime','180',1,0); | |
b66098ac | 13 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AlarmListDisplayLimit','4096',1,0); |
ed0a30ba VK |
14 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmSummaryEmailRecipients','',1,0,'S','A semicolon separated list of alarm summary e-mail recipient addresses'); |
15 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmSummaryEmailSchedule','0 0 * * *',1,0,'S','Schedule for sending alarm summary e-mails in cron format'); | |
549f48b3 | 16 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AllowDirectSMS','0',1,0); |
ae8e3292 | 17 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AllowedCiphers','63',1,1); |
549f48b3 VK |
18 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AllowTrapVarbindsConversion','1',1,1); |
19 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AnonymousFileAccess','0',1,0); | |
483d35ad | 20 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ApplyDCIFromTemplateToDisabledDCI','1',1,1); |
549f48b3 VK |
21 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('AuditLogRetentionTime','90',1,0); |
22 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BeaconHosts','',1,1); | |
23 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BeaconPollingInterval','1000',1,1); | |
24 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BeaconTimeout','1000',1,1); | |
25 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('BlockInactiveUserAccounts','0',1,0); | |
af21affe | 26 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('CapabilityExpirationTime','604800',1,0); /* in seconds */ |
8a1519ce | 27 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('CaseInsensitiveLoginNames','0',1,1,'B','Enable/disable case insensitive login names'); |
f3f2ddd9 | 28 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('CheckTrustedNodes','0',1,1,'B','Enable/disable trusted nodes check'); |
549f48b3 | 29 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ClientListenerPort','4701',1,1); |
221826d9 VK |
30 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ClusterContainerAutoBind','0',1,0,'B','Enable/disable container auto binding for clusters'); |
31 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ClusterTemplateAutoApply','0',1,0,'B','Enable/disable template auto apply for clusters'); | |
549f48b3 VK |
32 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ConditionPollingInterval','60',1,1); |
33 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ConfigurationPollingInterval','3600',1,1); | |
1422840a | 34 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,is_public,description) VALUES ('DashboardDataExportEnableInterpolation','1',1,1,'B','Y','Enable/disable data interpolation in dashboard data export'); |
9c236c87 VK |
35 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolBaseSize','10',1,1); |
36 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolCooldownTime','300',1,1); | |
37 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolMaxLifetime','14400',1,1); | |
38 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBConnectionPoolMaxSize','30',1,1); | |
549f48b3 VK |
39 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBLockInfo','',0,0); |
40 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBLockPID','0',0,0); | |
41 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DBLockStatus','UNLOCKED',0,1); | |
c1f07289 | 42 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultAgentCacheMode','2',1,1); |
549f48b3 | 43 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultConsoleDateFormat','dd.MM.yyyy',1,0); |
bc969eaf | 44 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultConsoleShortTimeFormat','HH:mm',1,0); |
549f48b3 VK |
45 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultConsoleTimeFormat','HH:mm:ss',1,0); |
46 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultDCIPollingInterval','60',1,0); | |
47 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultDCIRetentionTime','30',1,0); | |
48 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultEncryptionPolicy','1',1,1); | |
ad62667a | 49 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultInterfaceExpectedState','1',1,0,'C','Default expected state for new interface objects'); |
549f48b3 | 50 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DefaultMapBackgroundColor','0xffffff',1,0); |
9d7771b8 VK |
51 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultSubnetMaskIPv4','24',1,0,'I','Default mask for synthetic IPv4 subnets'); |
52 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultSubnetMaskIPv6','64',1,0,'I','Default mask for synthetic IPv6 subnets'); | |
549f48b3 VK |
53 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteAlarmsOfDeletedObject','1',1,0); |
54 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteEmptySubnets','0',1,1); | |
55 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteEventsOfDeletedObject','1',1,0); | |
56 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DeleteUnreachableNodesPeriod','0',1,1); | |
549f48b3 VK |
57 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DiscoveryFilter','none',1,0); |
58 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DiscoveryFilterFlags','0',1,0); | |
59 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('DiscoveryPollingInterval','900',1,1); | |
60 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableAdminInterface','1',1,1); | |
61 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableAgentRegistration','1',1,0); | |
62 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableAuditLog','1',1,1); | |
9a1f7c45 | 63 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableCheckPointSNMP','0',1,0); |
d38a36c6 | 64 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableReportingServer','0',1,1); |
549f48b3 VK |
65 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableEventStormDetection','0',1,1); |
66 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableISCListener','0',1,1); | |
549f48b3 VK |
67 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableNXSLContainerFunctions','1',1,1); |
68 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableObjectTransactions','0',1,1); | |
69 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableSNMPTraps','1',1,1); | |
ed0a30ba | 70 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAlarmSummaryEmails','0',1,0,'I','Enable alarm summary e-mails'); |
685508a7 | 71 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableSyslogReceiver','0',1,1); |
d1730ccf | 72 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableTimedAlarmAck','1',1,1); |
244c65ef | 73 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableXMPPConnector','0',1,1); |
549f48b3 | 74 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EnableZoning','0',1,1); |
815638fe | 75 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EscapeLocalCommands','0',1,0); |
549f48b3 VK |
76 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EventLogRetentionTime','90',1,0); |
77 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EventStormDuration','15',1,1); | |
78 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('EventStormEventsPerSecond','100',1,1); | |
d1730ccf | 79 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExtendedLogQueryAccessControl','0',1,0); |
549f48b3 VK |
80 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditFacility','13',1,1); |
81 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditPort','514',1,1); | |
82 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditServer','none',1,1); | |
83 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditSeverity','5',1,1); | |
84 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ExternalAuditTag','netxmsd-audit',1,1); | |
85 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('FirstFreeObjectId','100',0,1); | |
86 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('FixedStatusValue','0',1,1); | |
34a320ad | 87 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('HelpDeskLink','none',1,1); |
b06ae508 | 88 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('HousekeeperStartTime','02:00',1,1); |
549f48b3 | 89 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IcmpPingSize','46',1,1); |
c59466d2 | 90 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IcmpPingTimeout','1500',1,1); |
03b96461 | 91 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ImportConfigurationOnStartup','1',1,1,'B','Import configuration from local files on server startup'); |
43ef30b2 | 92 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('InstancePollingInterval','600',1,1); |
549f48b3 VK |
93 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('InternalCA','0',1,1); |
94 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IntruderLockoutThreshold','0',1,0); | |
95 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('IntruderLockoutTime','30',1,0); | |
c299358f EJ |
96 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraIssueType','Task',1,0); |
97 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraLogin','netxms',1,1); | |
98 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraPassword','',1,1); | |
99 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraProjectCode','NETXMS',1,0); | |
100 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraProjectComponent','',1,0); | |
101 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JiraServerURL','http://localhost',1,1); | |
549f48b3 | 102 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('JobHistoryRetentionTime','90',1,0); |
355aa002 | 103 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JobRetryCount','5',1,0,'I','Maximum mumber of job execution retrys'); |
549f48b3 | 104 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('KeepAliveInterval','60',1,1); |
d9177dd1 | 105 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapGroupClass','',1,0); |
bad2c02e | 106 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapGroupUniqueId','',1,0); |
6c352bb5 | 107 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapConnectionString','ldap://localhost:389',1,0); |
2575f149 | 108 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapMappingDescription','',1,0); |
d9177dd1 | 109 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapMappingFullName','displayName',1,0); |
f70a8b3c | 110 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapMappingName','',1,0); |
b00236dd | 111 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapPageSize','1000',1,0); |
d9177dd1 | 112 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSearchBase','',1,0); |
113 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSearchFilter','',1,0); | |
114 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSyncInterval','0',1,0); | |
115 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSyncUser','',1,0); | |
116 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapSyncUserPassword','',1,0); | |
4f754e74 | 117 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapUserClass','',1,0); |
b00236dd | 118 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapUserDeleteAction','1',1,0); |
bad2c02e | 119 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LdapUserUniqueId','',1,0); |
549f48b3 VK |
120 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LockTimeout','60000',1,1); |
121 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('LogAllSNMPTraps','0',1,1); | |
b9bcd02c | 122 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MailEncoding','utf8',1,0); |
8b75662b | 123 | INSERT INTO config (var_name,var_value,is_visible,data_type,need_server_restart,description) VALUES ('MessageOfTheDay','',1,'S',0,'Message to be shown when a user logs into the console'); |
549f48b3 | 124 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MinPasswordLength','0',1,0); |
8deadd79 | 125 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MinViewRefreshInterval','1000',1,0); |
549f48b3 | 126 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('MobileDeviceListenerPort','4747',1,1); |
549f48b3 | 127 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('NumberOfDataCollectors','25',1,1); |
549f48b3 | 128 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('NumberOfUpgradeThreads','10',1,0); |
c8e3cd04 | 129 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('OfflineDataRelevanceTime','86400',1,1,'I','Time period in seconds within which received offline data still relevant for threshold validation'); |
549f48b3 VK |
130 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PasswordComplexity','0',1,0); |
131 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PasswordExpiration','0',1,0); | |
132 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PasswordHistoryLength','0',1,0); | |
133 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PollCountForStatusChange','1',1,1); | |
e1d2050f VK |
134 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PollerThreadPoolBaseSize','10',1,1); |
135 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('PollerThreadPoolMaxSize','250',1,1); | |
b2ecde3b | 136 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSAuthMethod','PAP',1,0,'S','RADIUS authentication method to be used (PAP, CHAP, MS-CHAPv1, MS-CHAPv2)'); |
549f48b3 VK |
137 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSNumRetries','5',1,0); |
138 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSPort','1645',1,0); | |
139 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecondaryPort','1645',1,0); | |
140 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecondarySecret','netxms',1,0); | |
141 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecondaryServer','none',1,0); | |
142 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSSecret','netxms',1,0); | |
143 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSServer','none',1,0); | |
144 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RADIUSTimeout','3',1,0); | |
145 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ReceiveForwardedEvents','0',1,0); | |
d38a36c6 EJ |
146 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ReportingServerHostname','localhost',1,1); |
147 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ReportingServerPort','4710',1,1); | |
4553d424 | 148 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ResolveDNSToIPOnStatusPoll','0',1,1); |
549f48b3 VK |
149 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ResolveNodeNames','1',1,0); |
150 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RoutingTableUpdateInterval','300',1,1); | |
151 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('RunNetworkDiscovery','0',1,1); | |
88072662 | 152 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerColor','',1,0,'S','Identification color for this server'); |
48905317 | 153 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ServerCommandOutputTimeout','60',1,0); |
88072662 | 154 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerName','',1,0,'S','Name of this server'); |
549f48b3 VK |
155 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMSDriver','<none>',1,1); |
156 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMSDrvConfig','',1,1); | |
157 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPFromAddr','netxms@localhost',1,0); | |
158 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPFromName','NetXMS Server',1,0); | |
159 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPRetryCount','1',1,0); | |
4e7ebbb4 | 160 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPPorts','161',1,0); |
549f48b3 | 161 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SMTPServer','localhost',1,0); |
014fbefc | 162 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPRequestTimeout','1500',1,1); |
549f48b3 | 163 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPTrapLogRetentionTime','90',1,0); |
eb4822b6 | 164 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SNMPTrapPort','162',1,1); |
549f48b3 VK |
165 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusCalculationAlgorithm','1',1,1); |
166 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusPollingInterval','60',1,1); | |
167 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusPropagationAlgorithm','1',1,1); | |
168 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusShift','0',1,1); | |
169 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusSingleThreshold','75',1,1); | |
170 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusThresholds','503C2814',1,1); | |
171 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StatusTranslation','01020304',1,1); | |
95e2329a | 172 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('StrictAlarmStatusFlow','0',1,0); |
549f48b3 VK |
173 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyncInterval','60',1,1); |
174 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyncNodeNamesWithDNS','0',1,0); | |
b8c8a8a7 | 175 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogIgnoreMessageTimestamp','0',1,0,'B','Ignore timestamp received in syslog messages and always use server time'); |
549f48b3 | 176 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyslogListenPort','514',1,1); |
d368074d | 177 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyslogNodeMatchingPolicy','0',1,1); |
549f48b3 VK |
178 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('SyslogRetentionTime','90',1,0); |
179 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('ThresholdRepeatInterval','0',1,1); | |
180 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('TileServerURL','http://tile.openstreetmap.org/',1,0); | |
181 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('TopologyDiscoveryRadius','3',1,0); | |
182 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('TopologyExpirationTime','900',1,0); | |
cf38357f | 183 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('TrapSourcesInAllZones','0',1,1,'B','Search all zones to match trap/syslog source address to node'); |
549f48b3 VK |
184 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseDNSNameForDiscoveredNodes','0',1,0); |
185 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseFQDNForNodeNames','1',1,1); | |
186 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseIfXTable','1',1,0); | |
187 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseInterfaceAliases','0',1,0); | |
e02953a4 | 188 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('UseSNMPTrapsForDiscovery','0',1,1); |
244c65ef VK |
189 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPLogin','netxms@localhost',1,1); |
190 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPPassword','netxms',1,1); | |
191 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPPort','5222',1,1); | |
192 | INSERT INTO config (var_name,var_value,is_visible,need_server_restart) VALUES ('XMPPServer','localhost',1,1); | |
9b057805 | 193 | |
6c9e7d36 | 194 | /* |
be737a59 | 195 | ** System user |
6c9e7d36 | 196 | */ |
383b42a1 | 197 | INSERT INTO users (id,name,password,system_access,flags,full_name, |
0e0da2f1 | 198 | description,grace_logins,auth_method,guid, |
0f1ddb74 VK |
199 | cert_mapping_method,cert_mapping_data, |
200 | auth_failures,last_passwd_change,min_passwd_length, | |
201 | disabled_until,last_login) | |
be737a59 VK |
202 | VALUES (0,'system', |
203 | '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */ | |
204 | 274877906943,12,'','Built-in system account',5,0, /* Flags: change password + disabled */ | |
490e43fd | 205 | '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0 |
057f9dfb VK |
206 | ); |
207 | ||
be737a59 VK |
208 | /* |
209 | ** Default admin user | |
210 | */ | |
211 | INSERT INTO users (id,name,password,system_access,flags,full_name, | |
212 | description,grace_logins,auth_method,guid, | |
213 | cert_mapping_method,cert_mapping_data, | |
214 | auth_failures,last_passwd_change,min_passwd_length, | |
215 | disabled_until,last_login) | |
216 | VALUES (1,'admin', | |
217 | '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */ | |
218 | 0,8,'','Default administrator account',5,0, | |
219 | '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0 | |
220 | ); | |
057f9dfb VK |
221 | |
222 | /* | |
a852b4fb | 223 | ** Special "Everyone" user group |
057f9dfb | 224 | */ |
95b6a1b6 | 225 | INSERT INTO user_groups (id,name,system_access,flags,description,guid) |
b27be523 | 226 | VALUES (-2147483648, 'Everyone', 274877906960, 0, 'Built-in everyone group', |
383b42a1 VK |
227 | '00000000-0000-0000-0000-000000000000' |
228 | ); | |
a852b4fb | 229 | |
a852b4fb VK |
230 | /* |
231 | ** Default "Admins" group | |
232 | */ | |
768935e8 | 233 | INSERT INTO user_groups (id,name,system_access,flags,description,guid) |
be737a59 | 234 | VALUES (-2147483647, 'Admins', 274877906943, 0, 'Default administrative group', |
768935e8 VK |
235 | '00000000-0000-0000-0000-000000000000' |
236 | ); | |
237 | ||
be737a59 | 238 | INSERT INTO user_group_members (group_id,user_id) VALUES (-2147483647,1); |
b6a77d6d | 239 | |
be737a59 VK |
240 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (1,-2147483647,32767); |
241 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (2,-2147483647,32767); | |
242 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (3,-2147483647,32767); | |
243 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (4,-2147483647,32767); | |
244 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (5,-2147483647,32767); | |
245 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (6,-2147483647,32767); | |
246 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (7,-2147483647,32767); | |
247 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (8,-2147483647,32767); | |
248 | INSERT INTO acl (object_id,user_id,access_rights) VALUES (9,-2147483647,32767); | |
b6a77d6d | 249 | |
3c468b80 VK |
250 | /* |
251 | ** Default event groups | |
252 | */ | |
253 | ||
c6576857 VK |
254 | #define ID_GROUP_1 -2147483647 |
255 | #define ID_GROUP_2 -2147483646 | |
3c468b80 | 256 | |
d8ee1efc | 257 | INSERT INTO event_groups (id,name,description,range_start,range_end) |
9f2ad16c VK |
258 | VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change',0,0); |
259 | INSERT INTO event_groups (id,name,description,range_start,range_end) | |
260 | VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation',0,0); | |
3c468b80 | 261 | |
c19b2871 VK |
262 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL); |
263 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR); | |
264 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING); | |
265 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR); | |
266 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL); | |
267 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN); | |
268 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED); | |
269 | ||
270 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED); | |
271 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED); | |
272 | INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED); | |
15bbaeb3 | 273 | |
274 | /* | |
275 | ** Default community string | |
276 | */ | |
277 | INSERT INTO snmp_communities (id,community) VALUES(1,'public'); |