fixes in AnySMS driver
[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
e11eade2
EJ
7INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ActiveDiscoveryInterval','7200',1,1,'I','Interval in seconds between active network discovery polls.');
8INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ActiveNetworkDiscovery','0',1,1,'B','Enable/disable active network discovery. This setting is change by Network Discovery GUI');
9INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AgentCommandTimeout','4000',1,1,'I','Timeout in milliseconds for commands sent to agent. If agent did not respond to command within given number of seconds, \ncommand considered as failed.');
10INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AgentDefaultSharedSecret','netxms',1,0,'S','String that will be used as a shared secret in case if agent will required authentication.');
11INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AgentUpgradeWaitTime','600',1,0,'I','Maximum wait time in seconds for agent restart after upgrade. If agent cannot be contacted after this time period, \nupgrade process is considered as failed.');
12INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmHistoryRetentionTime','180',1,0,'I','A number of days the server keeps an alarm history in the database.');
13INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmListDisplayLimit','4096',1,0,'I','Maximum alarm count that will be displayed on Alarm Browser page. Alarms that exceed this count will not be shown.');
ed0a30ba
VK
14INSERT 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');
15INSERT 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');
e11eade2
EJ
16INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AllowDirectSMS','0',1,0,'B','Allow/disallow sending of SMS via NetXMS server using nxsms utility.');
17INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AllowedCiphers','63',1,1,'I','A bitmask for encryption algorithms allowed in the server(sum the values to allow multiple algorithms at once): \n\t*1 - AES256 \n\t*2 - Blowfish-256 \n\t*4 - IDEA \n\t*8 - 3DES\n\t*16 - AES128\n\t*32 - Blowfish-128');
18INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AllowTrapVarbindsConversion','1',1,1,'B','');
19INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AnonymousFileAccess','0',1,0,'B','');
20INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ApplyDCIFromTemplateToDisabledDCI','1',1,1,'B','Enable applying all DCIs from a template to the node, including disabled ones.');
21INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('AuditLogRetentionTime','90',1,0,'I','Retention time in days for the records in audit log. All records older than specified will be deleted by housekeeping process.');
22INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('BeaconHosts','',1,1,'S','Comma-separated list of hosts to be used as beacons for checking NetXMS server network connectivity. Either DNS names \nor IP addresses can be used. This list is pinged by NetXMS server and if none of the hosts have responded, server considers that connection \nwith network is lost and generates specific event.');
23INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('BeaconPollingInterval','1000',1,1,'I','Interval in milliseconds between beacon hosts polls.');
24INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('BeaconTimeout','1000',1,1,'I','Timeout in milliseconds to consider beacon host unreachable.');
25INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('BlockInactiveUserAccounts','0',1,0,'B','');
26INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('CapabilityExpirationTime','604800',1,0,'I',''); /* in seconds */
8a1519ce 27INSERT 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 28INSERT 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');
e11eade2
EJ
29INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ClientListenerPort','4701',1,1,'I','The server port for incoming client connections (such as management console).');
30INSERT 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.');
31INSERT 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.');
32INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ConditionPollingInterval','60',1,1,'I','Interval in seconds between polling (re-evaluating) of condition objects.');
33INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ConfigurationPollingInterval','3600',1,1,'I','Interval in seconds between configuration polls.');
34INSERT 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.');
35INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolBaseSize','10',1,1,'I','A number of connections to the database created on the server startup.');
36INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolCooldownTime','300',1,1,'I','');
37INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolMaxLifetime','14400',1,1,'I','');
38INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolMaxSize','30',1,1,'I','A maximum number of connections in the connection pool.');
39INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockInfo','',0,0,'S','');
40INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockPID','0',0,0,'I','');
41INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockStatus','UNLOCKED',0,1,'S','');
42INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultAgentCacheMode','2',1,1,'I','');
43INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultConsoleDateFormat','dd.MM.yyyy',1,0,'S','Default format to display date in console GUI.');
44INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultConsoleShortTimeFormat','HH:mm',1,0,'S','Default format to display time in a short way in console GUI.');
45INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultConsoleTimeFormat','HH:mm:ss',1,0,'S','Default format to display time in a long way in console GUI.');
46INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultDCIPollingInterval','60',1,0,'I','Default polling interval for newly created DCI (in seconds).');
47INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultDCIRetentionTime','30',1,0,'I','Default retention time for newly created DCI (in days).');
48INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultEncryptionPolicy','1',1,1,'C','Set the default encryption policy for communications with agents.');
49INSERT 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.');
50INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultMapBackgroundColor','0xffffff',1,0,'H','Default background color for new network map objects.');
51INSERT 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.');
52INSERT 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.');
53INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteAlarmsOfDeletedObject','1',1,0,'B','Enable/disable automatic alarm removal of an object when it is deleted.');
54INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteEmptySubnets','0',1,1,'B','Enable/disable automatic deletion of subnet objects without any nodes within. When enabled, empty subnets will be deleted \nby housekeeping process.');
55INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteEventsOfDeletedObject','1',1,0,'B','Enable/disable automatic event removal of an object when it is deleted.');
56INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteUnreachableNodesPeriod','0',1,1,'B','Delete nodes which were unreachable for a number of days specified by this parameter.');
57INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryFilter','none',1,0,'S','');
58INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryFilterFlags','0',1,0,'I','');
59INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryPollingInterval','900',1,1,'I','Interval in seconds between passive network discovery polls.');
60INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAdminInterface','1',1,1,'B','');
61INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAgentRegistration','1',1,0,'B','Enable/disable agent self-registration');
62INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAuditLog','1',1,1,'B','Enable/disable audit log.');
63INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableCheckPointSNMP','0',1,0,'B','');
64INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableReportingServer','0',1,1,'B','');
65INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableEventStormDetection','0',1,1,'B','');
66INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableISCListener','0',1,1,'B','Enable/disable Inter-Server Communications Listener.');
67INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableNXSLContainerFunctions','1',1,1,'B','Enable/disable server-side NXSL functions for container management (such as CreateContainer, RemoveContainer, BindObject, \nUnbindObject).');
68INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableObjectTransactions','0',1,1,'B','');
69INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableSNMPTraps','1',1,1,'B','Enable/disable SNMP trap processing.');
70INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAlarmSummaryEmails','0',1,0,'B','Enable/disable alarm summary e-mails.');
71INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableSyslogReceiver','0',1,1,'B','Enable/disable receiving of syslog messages.');
72INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableTimedAlarmAck','1',1,1,'B','');
73INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableXMPPConnector','0',1,1,'B','Enable/disable XMPP connector (required to enable XMPP message sending).');
74INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableZoning','0',1,1,'B','Enable/disable zoning support');
75INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EscapeLocalCommands','0',1,0,'B','');
76INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EventLogRetentionTime','90',1,0,'I','');
77INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EventStormDuration','15',1,1,'I','');
78INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('EventStormEventsPerSecond','100',1,1,'I','Event storm events per second');
79INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ExtendedLogQueryAccessControl','0',1,0,'B','Enable/disable extended access control in log queries.');
80INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditFacility','13',1,1,'I','Syslog facility to be used in audit log records sent to external server.');
81INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditPort','514',1,1,'I','UDP port of external syslog server to send audit records to.');
3fc1a730 82INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditServer','none',1,1,'S','External syslog server to send audit records to. If set to "none", external audit logging is disabled.');
e11eade2
EJ
83INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditSeverity','5',1,1,'I','Syslog severity to be used in audit log records sent to external server.');
84INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditTag','netxmsd-audit',1,1,'S','Syslog tag to be used in audit log records sent to external server.');
85INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('FirstFreeObjectId','100',0,1,'I','');
86INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('FixedStatusValue','0',1,1,'I','');
87INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('HelpDeskLink','none',1,1,'S','');
88INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('HousekeeperStartTime','02:00',1,1,'S','Time when housekeeper starts. Housekeeper deletes old log lines, old DCI data, cleans removed objects and does VACUUM for \nPostgreSQL.');
89INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('IcmpPingSize','46',1,1,'I','Size of ICMP packets (in bytes, excluding IP header size) used for status polls.');
90INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('IcmpPingTimeout','1500',1,1,'I','Timeout for ICMP ping used for status polls (in milliseconds).');
91INSERT 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.');
92INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('InstancePollingInterval','600',1,1,'I','Instance polling interval (in milliseconds).');
93INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('InternalCA','0',1,1,'B','Enable/disable internal certificate authority.');
94INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('IntruderLockoutThreshold','0',1,0,'I','');
95INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('IntruderLockoutTime','30',1,0,'I','');
96INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraIssueType','Task',1,0,'S','');
97INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraLogin','netxms',1,1,'S','Jira login name.');
98INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraPassword','',1,1,'S','Jira password');
99INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraProjectCode','NETXMS',1,0,'S','Jira project code');
100INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraProjectComponent','',1,0,'S','');
101INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraServerURL','http://localhost',1,1,'S','The URL of the Jira server');
102INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('JobHistoryRetentionTime','90',1,0,'I','');
3fc1a730 103INSERT 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 retries.');
e11eade2
EJ
104INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('KeepAliveInterval','60',1,1,'I','Interval in seconds between sending keep alive packets to connected clients.');
105INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapGroupClass','',1,0,'S','Specifies which object class represents group objects. If the found entry is not of user or group class, it will be ignored.');
106INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapGroupUniqueId','',1,0,'I','');
107INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapConnectionString','ldap://localhost:389',1,0,'S','The LdapConnectionString configuration parameter may be a comma- or whitespace-separated list of URIs containing only the \nschema, the host, and the port fields. Format: schema://host:port.');
3fc1a730
EJ
108INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapMappingDescription','',1,0,'S','The name of an attribute whose value will be used as a user''s description.');
109INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapMappingFullName','displayName',1,0,'S','The name of an attribute whose value will be used as a user''s full name.');
110INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapMappingName','',1,0,'S','The name of an attribute whose value will be used as a user''s login name.');
e11eade2
EJ
111INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapPageSize','1000',1,0,'I','The maximum amount of records that can be returned in one search page.');
112INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSearchBase','',1,0,'S','The DN of the entry at which to start the search.');
113INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSearchFilter','',1,0,'S','A string representation of the filter to apply in the search.');
114INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSyncInterval','0',1,0,'I','The synchronization interval (in minutes) between the NetXMS server and the LDAP server. If the parameter is set to 0, no \nsynchronization will take place.');
115INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSyncUser','',1,0,'S','User login for LDAP synchronization.');
116INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSyncUserPassword','',1,0,'S', 'User password for LDAP synchronization.');
117INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapUserClass','',1,0,'S','The object class which represents user objects. If the found entry is not of user or group class, it will be ignored.');
118INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapUserDeleteAction','1',1,0,'C','This parameter specifies what should be done while synchronizing with a deleted user/group from LDAP.');
119INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapUserUniqueId','',1,0,'I','');
120INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LockTimeout','60000',1,1,'I','');
121INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('LogAllSNMPTraps','0',1,1,'B','Log all SNMP traps.');
122INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('MailEncoding','utf8',1,0,'S','Encoding for e-mails generated by NetXMS server.');
123INSERT 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.');
124INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('MinPasswordLength','0',1,0,'I','Default minimum password length for a NetXMS user. The default applied only if per-user setting is not defined.');
125INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('MinViewRefreshInterval','1000',1,0,'I','');
126INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('MobileDeviceListenerPort','4747',1,1,'I','');
127INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('NumberOfDataCollectors','25',1,1,'I','The number of threads used for data collection.');
128INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('NumberOfUpgradeThreads','10',1,0,'I','The number of threads used to perform agent upgrades (i.e. maximum number of parallel upgrades).');
129INSERT 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.');
130INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('PasswordComplexity','0',1,0,'I','Set of flags to enforce password complexity.');
131INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('PasswordExpiration','0',1,0,'I','Password expiration time in days. If set to 0, password expiration is disabled.');
132INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('PasswordHistoryLength','0',1,0,'I','Number of previous passwords to keep. Users are not allowed to set password if it matches one from previous passwords list.');
133INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('PollCountForStatusChange','1',1,1,'I','The number of consecutive unsuccessful polls required to declare interface as down.');
134INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('PollerThreadPoolBaseSize','10',1,1,'I','The base thread pool size.');
135INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('PollerThreadPoolMaxSize','250',1,1,'I','Maximum thread pool size.');
136INSERT 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).');
137INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSNumRetries','5',1,0,'I','The number of retries for RADIUS authentication.');
138INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSPort','1645',1,0,'I','Port number used for connection to primary RADIUS server.');
139INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecondaryPort','1645',1,0,'I','Port number used for connection to secondary RADIUS server.');
140INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecondarySecret','netxms',1,0,'S','Shared secret used for communication with secondary RADIUS server.');
141INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecondaryServer','none',1,0,'S','Host name or IP address of secondary RADIUS server.');
142INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecret','netxms',1,0,'S','Shared secret used for communication with primary RADIUS server.');
143INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSServer','none',1,0,'S','Host name or IP address of primary RADIUS server.');
144INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSTimeout','3',1,0,'I','Timeout in seconds for requests to RADIUS server.');
145INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ReceiveForwardedEvents','0',1,0,'B','Enable/disable reception of events forwarded by another NetXMS server. Please note that for external event reception ISC listener \nshould be enabled as well.');
146INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ReportingServerHostname','localhost',1,1,'S','The hostname of the reporting server.');
147INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ReportingServerPort','4710',1,1,'I','The port of the reporting server.');
148INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ResolveDNSToIPOnStatusPoll','0',1,1,'B','Resolve DNS to IP on status poll.');
149INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ResolveNodeNames','1',1,0,'B','');
150INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RoutingTableUpdateInterval','300',1,1,'I','Interval in seconds between reading routing table from node.');
151INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('RunNetworkDiscovery','0',1,1,'B','Enable/disable automatic network discovery process. *This setting is change by Network Discovery GUI*.');
152INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerColor','',1,0,'H','Identification color for this server');
153INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerCommandOutputTimeout','60',1,0,'I','');
88072662 154INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerName','',1,0,'S','Name of this server');
e11eade2 155INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SMSDriver','<none>',1,1,'S','Mobile phone driver to be used for sending SMS.');
3fc1a730 156INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SMSDrvConfig','',1,1,'S','SMS driver parameters. For "generic" driver, it should be the name of COM port device.');
3c76ed34
VK
157INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPPorts','161',1,0,'S','Comma separated list of UDP ports used by SNMP capable devices.');
158INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPRequestTimeout','1500',1,1,'I','Timeout in milliseconds for SNMP requests sent by NetXMS server.');
159INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPTrapLogRetentionTime','90',1,0,'I','The time how long SNMP trap logs are retained.');
160INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPTrapPort','162',1,1,'I','Port used for SNMP traps.');
e11eade2
EJ
161INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPFromAddr','netxms@localhost',1,0,'S','The address used for sending mail from.');
162INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPFromName','NetXMS Server',1,0,'S','The name used as the sender.');
163INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPRetryCount','1',1,0,'I','Number of retries for sending mail.');
e11eade2 164INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPServer','localhost',1,0,'S','An SMTP server used for sending mail.');
e11eade2
EJ
165INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusCalculationAlgorithm','1',1,1,'I','');
166INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusPollingInterval','60',1,1,'I','Interval in seconds between status polls.');
3fc1a730 167INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusPropagationAlgorithm','1',1,1,'C','Algorithm for status propagation (how object''s status affects its child object statuses).');
e11eade2
EJ
168INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusShift','0',1,1,'I','');
169INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusSingleThreshold','75',1,1,'I','');
170INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusThresholds','503C2814',1,1,'S','');
171INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusTranslation','01020304',1,1,'S','');
172INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('StrictAlarmStatusFlow','0',1,0,'B','Enable/disable strict alarm status flow (alarm can be terminated only after it has been resolved).');
173INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SyncInterval','60',1,1,'I','Interval in seconds between writing object changes to the database.');
174INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SyncNodeNamesWithDNS','0',1,0,'B','Enable/disable synchronization of node names with DNS on each configuration poll.');
175INSERT 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.');
176INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogListenPort','514',1,1,'I','UDP port used by built-in syslog server.');
177INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogNodeMatchingPolicy','0',1,1,'C','Node matching policy for built-in syslog daemon.');
178INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogRetentionTime','90',1,0,'I','Retention time in days for records in syslog. All records older than specified will be deleted by housekeeping process.');
179INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('ThresholdRepeatInterval','0',1,1,'I','System-wide interval in seconds for resending threshold violation events. Value of 0 disables event resending.');
180INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('TileServerURL','http://tile.openstreetmap.org/',1,0,'S','The URL for the Tile server.');
181INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('TopologyDiscoveryRadius','3',1,0,'I','');
182INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('TopologyExpirationTime','900',1,0,'I','');
183INSERT 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.');
184INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('UseDNSNameForDiscoveredNodes','0',1,0,'B','Enable/disable the use of DNS name instead of IP address as primary name for newly discovered nodes.');
185INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('UseFQDNForNodeNames','1',1,1,'B','Enable/disable the use of fully qualified domain names as primary names for newly discovered nodes.');
186INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('UseIfXTable','1',1,0,'B','Enable/disable the use of SNMP ifXTable instead of ifTable for interface configuration polling.');
187INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('UseInterfaceAliases','0',1,0,'C','Control usage of interface aliases (or descriptions).');
188INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('UseSNMPTrapsForDiscovery','0',1,1,'B','This parameter defines if trap information should be used for new node discovery.');
189INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPLogin','netxms@localhost',1,1,'S','Login name that will be used to authentication on XMPP server.');
190INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPPassword','netxms',1,1,'S','Password that will be used to authentication on XMPP server.');
191INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPPort','5222',1,1,'I','XMPP connection port.');
192INSERT INTO config (var_name,var_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPServer','localhost',1,1,'S','XMPP connection server.');
193
194/*
195** Config possible values
196*/
197INSERT INTO config_values (var_name,var_value) VALUES ('ClientListenerPort','65535');
198INSERT INTO config_values (var_name,var_value) VALUES ('ExternalAuditPort','65535');
199INSERT INTO config_values (var_name,var_value) VALUES ('MobileDeviceListenerPort','65535');
200INSERT INTO config_values (var_name,var_value) VALUES ('RADIUSPort','65535');
201INSERT INTO config_values (var_name,var_value) VALUES ('RADIUSSecondaryPort','65535');
202INSERT INTO config_values (var_name,var_value) VALUES ('ReportingServerPort','65535');
203INSERT INTO config_values (var_name,var_value) VALUES ('SNMPPorts','65535');
204INSERT INTO config_values (var_name,var_value) VALUES ('SNMPTrapPort','65535');
205INSERT INTO config_values (var_name,var_value) VALUES ('SyslogListenPort','65535');
206INSERT INTO config_values (var_name,var_value) VALUES ('XMPPPort','65535');
e11eade2 207INSERT INTO config_values (var_name,var_value) VALUES ('AllowedCiphers','63');
3fc1a730
EJ
208INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','0','UP');
209INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','1','DOWN');
210INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','2','IGNORE');
211INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','0','Disabled');
212INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','1','Allowed');
213INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','2','Preferred');
214INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','3','Required');
215INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','0','Default');
216INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','1','Unchanged');
217INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','2','Fixed');
218INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','3','Relative');
219INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','4','Translated');
220INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','0','Don''t use aliases');
221INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','1','Use aliases when possible');
222INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','2','Concatenate alias and name');
223INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','3','Concatenate name and alias');
224INSERT INTO config_values (var_name,var_value,var_description) VALUES ('SyslogNodeMatchingPolicy','0','IP,, then hostname');
225INSERT INTO config_values (var_name,var_value,var_description) VALUES ('SyslogNodeMatchingPolicy','1','Hostname, then IP');
226INSERT INTO config_values (var_name,var_value,var_description) VALUES ('LdapUserDeleteAction','0','Delete user');
227INSERT INTO config_values (var_name,var_value,var_description) VALUES ('LdapUserDeleteAction','1','Disable user');
9b057805 228
6c9e7d36 229/*
be737a59 230** System user
6c9e7d36 231*/
383b42a1 232INSERT INTO users (id,name,password,system_access,flags,full_name,
0e0da2f1 233 description,grace_logins,auth_method,guid,
0f1ddb74
VK
234 cert_mapping_method,cert_mapping_data,
235 auth_failures,last_passwd_change,min_passwd_length,
236 disabled_until,last_login)
be737a59
VK
237 VALUES (0,'system',
238 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
239 274877906943,12,'','Built-in system account',5,0, /* Flags: change password + disabled */
490e43fd 240 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0
057f9dfb
VK
241 );
242
be737a59
VK
243/*
244** Default admin user
245*/
246INSERT INTO users (id,name,password,system_access,flags,full_name,
247 description,grace_logins,auth_method,guid,
248 cert_mapping_method,cert_mapping_data,
249 auth_failures,last_passwd_change,min_passwd_length,
250 disabled_until,last_login)
251 VALUES (1,'admin',
252 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
253 0,8,'','Default administrator account',5,0,
254 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0
255 );
057f9dfb
VK
256
257/*
a852b4fb 258** Special "Everyone" user group
057f9dfb 259*/
95b6a1b6 260INSERT INTO user_groups (id,name,system_access,flags,description,guid)
b27be523 261 VALUES (-2147483648, 'Everyone', 274877906960, 0, 'Built-in everyone group',
383b42a1
VK
262 '00000000-0000-0000-0000-000000000000'
263 );
a852b4fb 264
a852b4fb
VK
265/*
266** Default "Admins" group
267*/
768935e8 268INSERT INTO user_groups (id,name,system_access,flags,description,guid)
be737a59 269 VALUES (-2147483647, 'Admins', 274877906943, 0, 'Default administrative group',
768935e8
VK
270 '00000000-0000-0000-0000-000000000000'
271 );
272
be737a59 273INSERT INTO user_group_members (group_id,user_id) VALUES (-2147483647,1);
b6a77d6d 274
be737a59
VK
275INSERT INTO acl (object_id,user_id,access_rights) VALUES (1,-2147483647,32767);
276INSERT INTO acl (object_id,user_id,access_rights) VALUES (2,-2147483647,32767);
277INSERT INTO acl (object_id,user_id,access_rights) VALUES (3,-2147483647,32767);
278INSERT INTO acl (object_id,user_id,access_rights) VALUES (4,-2147483647,32767);
279INSERT INTO acl (object_id,user_id,access_rights) VALUES (5,-2147483647,32767);
280INSERT INTO acl (object_id,user_id,access_rights) VALUES (6,-2147483647,32767);
281INSERT INTO acl (object_id,user_id,access_rights) VALUES (7,-2147483647,32767);
282INSERT INTO acl (object_id,user_id,access_rights) VALUES (8,-2147483647,32767);
283INSERT INTO acl (object_id,user_id,access_rights) VALUES (9,-2147483647,32767);
b6a77d6d 284
3c468b80
VK
285/*
286** Default event groups
287*/
288
c6576857
VK
289#define ID_GROUP_1 -2147483647
290#define ID_GROUP_2 -2147483646
3c468b80 291
d8ee1efc 292INSERT INTO event_groups (id,name,description,range_start,range_end)
9f2ad16c
VK
293 VALUES (ID_GROUP_1,'NodeStatus','All events reporting about node status change',0,0);
294INSERT INTO event_groups (id,name,description,range_start,range_end)
295 VALUES (ID_GROUP_2,'NewObjects','All events reporting about new objects creation',0,0);
3c468b80 296
c19b2871
VK
297INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
298INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
299INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
300INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
301INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
302INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
303INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
304
305INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
306INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
307INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
15bbaeb3 308
309/*
310** Default community string
311*/
312INSERT INTO snmp_communities (id,community) VALUES(1,'public');