configuration parameter DBWriter.MaxRecordsPerTransaction added to database
[public/netxms.git] / sql / setup.in
1 /*
2 ** Default configuration parameters
3 **
4 ** ex: syntax=sql
5 */
6
7 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ActiveDiscoveryInterval','7200','7200',1,1,'I','Interval in seconds between active network discovery polls.');
8 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ActiveNetworkDiscovery','0','0',1,1,'B','Enable/disable active network discovery. This setting is change by Network Discovery GUI');
9 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AgentCommandTimeout','4000','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.');
10 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AgentDefaultSharedSecret','netxms','netxms',1,0,'S','String that will be used as a shared secret in case if agent will required authentication.');
11 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AgentUpgradeWaitTime','600','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.');
12 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmHistoryRetentionTime','180','180',1,0,'I','A number of days the server keeps an alarm history in the database.');
13 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmListDisplayLimit','4096','4096',1,0,'I','Maximum alarm count that will be displayed on Alarm Browser page. Alarms that exceed this count will not be shown.');
14 INSERT INTO config (var_name,var_value,default_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,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AlarmSummaryEmailSchedule','0 0 * * *','0 0 * * *',1,0,'S','Schedule for sending alarm summary e-mails in cron format');
16 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AllowDirectSMS','0','0',1,0,'B','Allow/disallow sending of SMS via NetXMS server using nxsms utility.');
17 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AllowedCiphers','63','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');
18 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AllowTrapVarbindsConversion','1','1',1,1,'B','');
19 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AnonymousFileAccess','0','0',1,0,'B','');
20 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ApplyDCIFromTemplateToDisabledDCI','1','1',1,1,'B','Enable applying all DCIs from a template to the node, including disabled ones.');
21 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('AuditLogRetentionTime','90','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.');
22 INSERT INTO config (var_name,var_value,default_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.');
23 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('BeaconPollingInterval','1000','1000',1,1,'I','Interval in milliseconds between beacon hosts polls.');
24 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('BeaconTimeout','1000','1000',1,1,'I','Timeout in milliseconds to consider beacon host unreachable.');
25 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('BlockInactiveUserAccounts','0','0',1,0,'B','');
26 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('CapabilityExpirationTime','604800','604800',1,0,'I',''); /* in seconds */
27 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('CaseInsensitiveLoginNames','0','0',1,1,'B','Enable/disable case insensitive login names');
28 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('CheckTrustedNodes','0','0',1,1,'B','Enable/disable trusted nodes check');
29 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ClientListenerPort','4701','4701',1,1,'I','The server port for incoming client connections (such as management console).');
30 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ClusterContainerAutoBind','0','0',1,0,'B','Enable/disable container auto binding for clusters.');
31 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ClusterTemplateAutoApply','0','0',1,0,'B','Enable/disable template auto apply for clusters.');
32 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ConditionPollingInterval','60','60',1,1,'I','Interval in seconds between polling (re-evaluating) of condition objects.');
33 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ConfigurationPollingInterval','3600','3600',1,1,'I','Interval in seconds between configuration polls.');
34 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,is_public,description) VALUES ('DashboardDataExportEnableInterpolation','1','1',1,1,'B','Y','Enable/disable data interpolation in dashboard data export.');
35 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DataCollector.ThreadPool.BaseSize','10','10',1,1,'I','Base size for data collector thread pool.');
36 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DataCollector.ThreadPool.MaxSize','250','250',1,1,'I','Maximum size for data collector thread pool.');
37 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolBaseSize','10','10',1,1,'I','A number of connections to the database created on the server startup.');
38 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolCooldownTime','300','300',1,1,'I','');
39 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolMaxLifetime','14400','14400',1,1,'I','');
40 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolMaxSize','30','30',1,1,'I','A maximum number of connections in the connection pool.');
41 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockInfo','','',0,0,'S','');
42 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockPID','0','0',0,0,'I','');
43 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockStatus','UNLOCKED','UNLOCKED',0,1,'S','');
44 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBWriter.MaxRecordsPerTransaction','1000','1000',1,1,'I','Maximum number of records per one transaction for delayed database writes');
45 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultAgentCacheMode','2','2',1,1,'C','Default agent cache mode');
46 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultAgentProtocolCompressionMode','1','1',1,0,'C','Default agent protocol compression mode');
47 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultConsoleDateFormat','dd.MM.yyyy','dd.MM.yyyy',1,0,'S','Default date display format for GUI.');
48 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultConsoleShortTimeFormat','HH:mm','HH:mm',1,0,'S','Default short time display format for GUI.');
49 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultConsoleTimeFormat','HH:mm:ss','HH:mm:ss',1,0,'S','Default long time display format for GUI.');
50 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultDCIPollingInterval','60','60',1,0,'I','Default polling interval for newly created DCI (in seconds).');
51 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultDCIRetentionTime','30','30',1,0,'I','Default retention time for newly created DCI (in days).');
52 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultEncryptionPolicy','1','1',1,1,'C','Set the default encryption policy for communications with agents.');
53 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultInterfaceExpectedState','1','1',1,0,'C','Default expected state for new interface objects.');
54 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultMapBackgroundColor','0xffffff','0xffffff',1,0,'H','Default background color for new network map objects.');
55 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultSubnetMaskIPv4','24','24',1,0,'I','Default mask for synthetic IPv4 subnets.');
56 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DefaultSubnetMaskIPv6','64','64',1,0,'I','Default mask for synthetic IPv6 subnets.');
57 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteAlarmsOfDeletedObject','1','1',1,0,'B','Enable/disable automatic alarm removal of an object when it is deleted.');
58 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteEmptySubnets','0','0',1,1,'B','Enable/disable automatic deletion of subnet objects without any nodes within.');
59 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteEventsOfDeletedObject','1','1',1,0,'B','Enable/disable automatic event removal of an object when it is deleted.');
60 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DeleteUnreachableNodesPeriod','0','0',1,0,'I','Delete nodes which were unreachable for a number of days specified by this parameter.');
61 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryFilter','none','none',1,0,'S','');
62 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryFilterFlags','0','0',1,0,'I','');
63 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryPollingInterval','900','900',1,1,'I','Interval in seconds between passive network discovery polls.');
64 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAgentRegistration','1','1',1,0,'B','Enable/disable agent self-registration');
65 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAuditLog','1','1',1,1,'B','Enable/disable audit log.');
66 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableCheckPointSNMP','0','0',1,0,'B','');
67 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableReportingServer','0','0',1,1,'B','');
68 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableEventStormDetection','0','0',1,1,'B','');
69 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableISCListener','0','0',1,1,'B','Enable/disable Inter-Server Communications Listener.');
70 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableNXSLContainerFunctions','1','1',1,1,'B','Enable/disable server-side NXSL functions for container management (such as CreateContainer, RemoveContainer, BindObject, \nUnbindObject).');
71 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableObjectTransactions','0','0',1,1,'B','');
72 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableSNMPTraps','1','1',1,1,'B','Enable/disable SNMP trap processing.');
73 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableAlarmSummaryEmails','0','0',1,0,'B','Enable/disable alarm summary e-mails.');
74 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableSyslogReceiver','0','0',1,1,'B','Enable/disable receiving of syslog messages.');
75 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableTimedAlarmAck','1','1',1,1,'B','');
76 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableXMPPConnector','0','0',1,1,'B','Enable/disable XMPP connector (required to enable XMPP message sending).');
77 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableZoning','0','0',1,1,'B','Enable/disable zoning support');
78 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EscapeLocalCommands','0','0',1,0,'B','');
79 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EventLogRetentionTime','90','90',1,0,'I','');
80 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EventStormDuration','15','15',1,1,'I','');
81 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EventStormEventsPerSecond','100','100',1,1,'I','Event storm events per second');
82 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ExtendedLogQueryAccessControl','0','0',1,0,'B','Enable/disable extended access control in log queries.');
83 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditFacility','13','13',1,1,'I','Syslog facility to be used in audit log records sent to external server.');
84 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditPort','514','514',1,1,'I','UDP port of external syslog server to send audit records to.');
85 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditServer','none','none',1,1,'S','External syslog server to send audit records to. If set to "none", external audit logging is disabled.');
86 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditSeverity','5','5',1,1,'I','Syslog severity to be used in audit log records sent to external server.');
87 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ExternalAuditTag','netxmsd-audit','netxmsd-audit',1,1,'S','Syslog tag to be used in audit log records sent to external server.');
88 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('FirstFreeObjectId','100','100',0,1,'I','');
89 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('FixedStatusValue','0','0',1,1,'I','');
90 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('GraceLoginCount','5','5',1,0,'I','User grace login count');
91 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('HelpDeskLink','none','none',1,1,'S','');
92 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('HousekeeperStartTime','02:00','02:00',1,1,'S','Timer when housekeeper starts. Housekeeper deletes old log lines, old DCI data, cleans removed objects and does VACUUM for \nPostgreSQL.');
93 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('IcmpPingSize','46','46',1,1,'I','Size of ICMP packets (in bytes, excluding IP header size) used for status polls.');
94 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('IcmpPingTimeout','1500','1500',1,1,'I','Timeout for ICMP ping used for status polls (in milliseconds).');
95 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ImportConfigurationOnStartup','1','1',1,1,'B','Import configuration from local files on server startup.');
96 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('InstancePollingInterval','600','600',1,1,'I','Instance polling interval (in seconds).');
97 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('InternalCA','0','0',1,1,'B','Enable/disable internal certificate authority.');
98 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('IntruderLockoutThreshold','0','0',1,0,'I','');
99 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('IntruderLockoutTime','30','30',1,0,'I','');
100 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraIssueType','Task','Task',1,0,'S','');
101 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraLogin','netxms','netxms',1,1,'S','Jira login name.');
102 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraPassword','','',1,1,'S','Jira password');
103 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraProjectCode','NETXMS','NETXMS',1,0,'S','Jira project code');
104 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraProjectComponent','','',1,0,'S','');
105 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraServerURL','http://localhost','http://localhost',1,1,'S','The URL of the Jira server');
106 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JobHistoryRetentionTime','90','90',1,0,'I','');
107 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JobRetryCount','5','5',1,0,'I','Maximum mumber of job execution retries.');
108 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('KeepAliveInterval','60','60',1,1,'I','Interval in seconds between sending keep alive packets to connected clients.');
109 INSERT INTO config (var_name,var_value,default_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.');
110 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapGroupUniqueId','','',1,0,'S','');
111 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapConnectionString','ldap://localhost:389','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.');
112 INSERT INTO config (var_name,var_value,default_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.');
113 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapMappingFullName','displayName','displayName',1,0,'S','The name of an attribute whose value will be used as a user''s full name.');
114 INSERT INTO config (var_name,var_value,default_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.');
115 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapPageSize','1000','1000',1,0,'I','The maximum amount of records that can be returned in one search page.');
116 INSERT INTO config (var_name,var_value,default_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.');
117 INSERT INTO config (var_name,var_value,default_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.');
118 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSyncInterval','0','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.');
119 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSyncUser','','',1,0,'S','User login for LDAP synchronization.');
120 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapSyncUserPassword','','',1,0,'S', 'User password for LDAP synchronization.');
121 INSERT INTO config (var_name,var_value,default_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.');
122 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapUserDeleteAction','1','1',1,0,'C','This parameter specifies what should be done while synchronizing with a deleted user/group from LDAP.');
123 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapUserUniqueId','','',1,0,'S','');
124 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LockTimeout','60000','60000',1,1,'I','');
125 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LogAllSNMPTraps','0','0',1,1,'B','Log all SNMP traps.');
126 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LongRunningQueryThreshold','0','0',1,1,'I','Threshold in milliseconds to report long running SQL queries (0 to disable)');
127 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('MailEncoding','utf8','utf8',1,0,'S','Encoding for e-mails generated by NetXMS server.');
128 INSERT INTO config (var_name,var_value,default_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.');
129 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('MinPasswordLength','0','0',1,0,'I','Default minimum password length for a NetXMS user. The default applied only if per-user setting is not defined.');
130 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('MinViewRefreshInterval','1000','1000',1,0,'I','');
131 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('MobileDeviceListenerPort','4747','4747',1,1,'I','');
132 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('NumberOfUpgradeThreads','10','10',1,0,'I','The number of threads used to perform agent upgrades (i.e. maximum number of parallel upgrades).');
133 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('OfflineDataRelevanceTime','86400','86400',1,1,'I','Time period in seconds within which received offline data still relevant for threshold validation.');
134 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('PasswordComplexity','0','0',1,0,'I','Set of flags to enforce password complexity.');
135 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('PasswordExpiration','0','0',1,0,'I','Password expiration time in days. If set to 0, password expiration is disabled.');
136 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('PasswordHistoryLength','0','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.');
137 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('PollCountForStatusChange','1','1',1,1,'I','The number of consecutive unsuccessful polls required to declare interface as down.');
138 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('PollerThreadPoolBaseSize','10','10',1,1,'I','The base thread pool size.');
139 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('PollerThreadPoolMaxSize','250','250',1,1,'I','Maximum thread pool size.');
140 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSAuthMethod','PAP','PAP',1,0,'S','RADIUS authentication method to be used (PAP, CHAP, MS-CHAPv1, MS-CHAPv2).');
141 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSNumRetries','5','5',1,0,'I','The number of retries for RADIUS authentication.');
142 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSPort','1645','1645',1,0,'I','Port number used for connection to primary RADIUS server.');
143 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecondaryPort','1645','1645',1,0,'I','Port number used for connection to secondary RADIUS server.');
144 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecondarySecret','netxms','netxms',1,0,'S','Shared secret used for communication with secondary RADIUS server.');
145 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecondaryServer','none','none',1,0,'S','Host name or IP address of secondary RADIUS server.');
146 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSSecret','netxms','netxms',1,0,'S','Shared secret used for communication with primary RADIUS server.');
147 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSServer','none','none',1,0,'S','Host name or IP address of primary RADIUS server.');
148 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RADIUSTimeout','3','3',1,0,'I','Timeout in seconds for requests to RADIUS server.');
149 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ReceiveForwardedEvents','0','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.');
150 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ReportingServerHostname','localhost','localhost',1,1,'S','The hostname of the reporting server.');
151 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ReportingServerPort','4710','4710',1,1,'I','The port of the reporting server.');
152 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ResolveDNSToIPOnStatusPoll','0','0',1,1,'B','Resolve DNS to IP on status poll.');
153 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ResolveNodeNames','1','1',1,0,'B','');
154 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RoutingTableUpdateInterval','300','300',1,1,'I','Interval in seconds between reading routing table from node.');
155 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('RunNetworkDiscovery','0','0',1,1,'B','Enable/disable automatic network discovery process. *This setting is change by Network Discovery GUI*.');
156 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerColor','','',1,0,'H','Identification color for this server');
157 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerCommandOutputTimeout','60','60',1,0,'I','');
158 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerName','','',1,0,'S','Name of this server');
159 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SMSDriver','<none>','<none>',1,1,'S','Mobile phone driver to be used for sending SMS.');
160 INSERT INTO config (var_name,var_value,default_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.');
161 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPPorts','161','161',1,0,'S','Comma separated list of UDP ports used by SNMP capable devices.');
162 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPRequestTimeout','1500','1500',1,1,'I','Timeout in milliseconds for SNMP requests sent by NetXMS server.');
163 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPTrapLogRetentionTime','90','90',1,0,'I','The time how long SNMP trap logs are retained.');
164 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SNMPTrapPort','162','162',1,1,'I','Port used for SNMP traps.');
165 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPFromAddr','netxms@localhost','netxms@localhost',1,0,'S','The address used for sending mail from.');
166 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPFromName','NetXMS Server','NetXMS Server',1,0,'S','The name used as the sender.');
167 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPPort','25','25',1,0,'I','Port used by SMTP server');
168 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPRetryCount','1','1',1,0,'I','Number of retries for sending mail.');
169 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SMTPServer','localhost','localhost',1,0,'S','An SMTP server used for sending mail.');
170 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusCalculationAlgorithm','1','1',1,1,'I','');
171 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusPollingInterval','60','60',1,1,'I','Interval in seconds between status polls.');
172 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusPropagationAlgorithm','1','1',1,1,'C','Algorithm for status propagation (how object''s status affects its child object statuses).');
173 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusShift','0','0',1,1,'I','');
174 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusSingleThreshold','75','75',1,1,'I','');
175 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusThresholds','503C2814','503C2814',1,1,'S','');
176 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusTranslation','01020304','01020304',1,1,'S','');
177 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StrictAlarmStatusFlow','0','0',1,0,'B','Enable/disable strict alarm status flow (alarm can be terminated only after it has been resolved).');
178 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SyncInterval','60','60',1,1,'I','Interval in seconds between writing object changes to the database.');
179 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SyncNodeNamesWithDNS','0','0',1,0,'B','Enable/disable synchronization of node names with DNS on each configuration poll.');
180 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogIgnoreMessageTimestamp','0','0',1,0,'B','Ignore timestamp received in syslog messages and always use server time.');
181 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogListenPort','514','514',1,1,'I','UDP port used by built-in syslog server.');
182 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogNodeMatchingPolicy','0','0',1,1,'C','Node matching policy for built-in syslog daemon.');
183 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('SyslogRetentionTime','90','90',1,0,'I','Retention time in days for records in syslog. All records older than specified will be deleted by housekeeping process.');
184 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ThresholdRepeatInterval','0','0',1,1,'I','System-wide interval in seconds for resending threshold violation events. Value of 0 disables event resending.');
185 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('TileServerURL','http://tile.openstreetmap.org/','http://tile.openstreetmap.org/',1,0,'S','The URL for the Tile server.');
186 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('TopologyDiscoveryRadius','3','3',1,0,'I','');
187 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('TopologyExpirationTime','900','900',1,0,'I','');
188 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('TopologyPollingInterval','1800','1800',1,1,'I','Interval in seconds between topology polls.');
189 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('TrapSourcesInAllZones','0','0',1,1,'B','Search all zones to match trap/syslog source address to node.');
190 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('UseDNSNameForDiscoveredNodes','0','0',1,0,'B','Enable/disable the use of DNS name instead of IP address as primary name for newly discovered nodes.');
191 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('UseFQDNForNodeNames','1','1',1,1,'B','Enable/disable the use of fully qualified domain names as primary names for newly discovered nodes.');
192 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('UseIfXTable','1','1',1,0,'B','Enable/disable the use of SNMP ifXTable instead of ifTable for interface configuration polling.');
193 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('UseInterfaceAliases','0','0',1,0,'C','Control usage of interface aliases (or descriptions).');
194 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('UseSNMPTrapsForDiscovery','0','0',1,1,'B','Use SNMP trap information for new node discovery.');
195 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('UseSyslogForDiscovery','0','0',1,1,'B','Use syslog messages for new node discovery.');
196 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPLogin','netxms@localhost','netxms@localhost',1,1,'S','Login name that will be used to authentication on XMPP server.');
197 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPPassword','netxms','netxms',1,1,'S','Password that will be used to authentication on XMPP server.');
198 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPPort','5222','5222',1,1,'I','XMPP connection port.');
199 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('XMPPServer','localhost','localhost',1,1,'S','XMPP connection server.');
200
201 /*
202 ** Config possible values
203 */
204 INSERT INTO config_values (var_name,var_value) VALUES ('ClientListenerPort','65535');
205 INSERT INTO config_values (var_name,var_value) VALUES ('ExternalAuditPort','65535');
206 INSERT INTO config_values (var_name,var_value) VALUES ('MobileDeviceListenerPort','65535');
207 INSERT INTO config_values (var_name,var_value) VALUES ('RADIUSPort','65535');
208 INSERT INTO config_values (var_name,var_value) VALUES ('RADIUSSecondaryPort','65535');
209 INSERT INTO config_values (var_name,var_value) VALUES ('ReportingServerPort','65535');
210 INSERT INTO config_values (var_name,var_value) VALUES ('SNMPPorts','65535');
211 INSERT INTO config_values (var_name,var_value) VALUES ('SNMPTrapPort','65535');
212 INSERT INTO config_values (var_name,var_value) VALUES ('SyslogListenPort','65535');
213 INSERT INTO config_values (var_name,var_value) VALUES ('XMPPPort','65535');
214 INSERT INTO config_values (var_name,var_value) VALUES ('AllowedCiphers','63');
215 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentCacheMode','1','On');
216 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentCacheMode','2','Off');
217 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentProtocolCompressionMode','1','Enabled');
218 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentProtocolCompressionMode','2','Disabled');
219 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','0','UP');
220 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','1','DOWN');
221 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','2','IGNORE');
222 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','0','Disabled');
223 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','1','Allowed');
224 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','2','Preferred');
225 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','3','Required');
226 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','0','Default');
227 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','1','Unchanged');
228 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','2','Fixed');
229 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','3','Relative');
230 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','4','Translated');
231 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','0','Don''t use aliases');
232 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','1','Use aliases when possible');
233 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','2','Concatenate alias and name');
234 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','3','Concatenate name and alias');
235 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('SyslogNodeMatchingPolicy','0','IP,, then hostname');
236 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('SyslogNodeMatchingPolicy','1','Hostname, then IP');
237 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('LdapUserDeleteAction','0','Delete user');
238 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('LdapUserDeleteAction','1','Disable user');
239
240 /*
241 ** System user
242 */
243 INSERT INTO users (id,name,password,system_access,flags,full_name,
244 description,grace_logins,auth_method,guid,
245 cert_mapping_method,cert_mapping_data,
246 auth_failures,last_passwd_change,min_passwd_length,
247 disabled_until,last_login,created)
248 VALUES (0,'system',
249 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
250 274877906943,12,'','Built-in system account',5,0, /* Flags: change password + disabled */
251 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0,0
252 );
253
254 /*
255 ** Default admin user
256 */
257 INSERT INTO users (id,name,password,system_access,flags,full_name,
258 description,grace_logins,auth_method,guid,
259 cert_mapping_method,cert_mapping_data,
260 auth_failures,last_passwd_change,min_passwd_length,
261 disabled_until,last_login,created)
262 VALUES (1,'admin',
263 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
264 0,8,'','Default administrator account',5,0,
265 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0,0
266 );
267
268 /*
269 ** Special "Everyone" user group
270 */
271 INSERT INTO user_groups (id,name,system_access,flags,description,guid,created)
272 VALUES (-2147483648, 'Everyone', 274877906960, 0, 'Built-in everyone group',
273 '00000000-0000-0000-0000-000000000000',0
274 );
275
276 /*
277 ** Default "Admins" group
278 */
279 INSERT INTO user_groups (id,name,system_access,flags,description,guid,created)
280 VALUES (-2147483647, 'Admins', 549755813887, 0, 'Default administrative group',
281 '00000000-0000-0000-0000-000000000000',0
282 );
283
284 INSERT INTO user_group_members (group_id,user_id) VALUES (-2147483647,1);
285
286 INSERT INTO acl (object_id,user_id,access_rights) VALUES (1,-2147483647,524287);
287 INSERT INTO acl (object_id,user_id,access_rights) VALUES (2,-2147483647,524287);
288 INSERT INTO acl (object_id,user_id,access_rights) VALUES (3,-2147483647,524287);
289 INSERT INTO acl (object_id,user_id,access_rights) VALUES (4,-2147483647,524287);
290 INSERT INTO acl (object_id,user_id,access_rights) VALUES (5,-2147483647,524287);
291 INSERT INTO acl (object_id,user_id,access_rights) VALUES (6,-2147483647,524287);
292 INSERT INTO acl (object_id,user_id,access_rights) VALUES (7,-2147483647,524287);
293 INSERT INTO acl (object_id,user_id,access_rights) VALUES (8,-2147483647,524287);
294 INSERT INTO acl (object_id,user_id,access_rights) VALUES (9,-2147483647,524287);
295
296 /*
297 ** Default event groups
298 */
299
300 #define ID_GROUP_1 -2147483647
301 #define ID_GROUP_2 -2147483646
302
303 INSERT INTO event_groups (guid,id,name,description)
304 VALUES ('04b326c0-5cc0-411f-8587-2836cb87c920',ID_GROUP_1,'NodeStatus','All events reporting about node status change');
305 INSERT INTO event_groups (guid,id,name,description)
306 VALUES ('b61859c6-1768-4a61-a0cf-eed07d688f66',ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
307
308 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
309 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
310 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
311 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
312 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
313 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
314 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
315
316 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
317 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
318 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
319
320 /*
321 ** Default community string
322 */
323 INSERT INTO snmp_communities (id,community) VALUES(1,'public');