6c909edace6d68371dad3452637b5792950183b8
[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 ('DBConnectionPoolBaseSize','10','10',1,1,'I','A number of connections to the database created on the server startup.');
36 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolCooldownTime','300','300',1,1,'I','');
37 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBConnectionPoolMaxLifetime','14400','14400',1,1,'I','');
38 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.');
39 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockInfo','','',0,0,'S','');
40 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockPID','0','0',0,0,'I','');
41 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DBLockStatus','UNLOCKED','UNLOCKED',0,1,'S','');
42 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');
43 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');
44 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.');
45 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.');
46 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.');
47 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).');
48 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).');
49 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.');
50 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.');
51 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.');
52 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.');
53 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.');
54 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.');
55 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.');
56 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.');
57 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.');
58 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryFilter','none','none',1,0,'S','');
59 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('DiscoveryFilterFlags','0','0',1,0,'I','');
60 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.');
61 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');
62 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.');
63 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableCheckPointSNMP','0','0',1,0,'B','');
64 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableReportingServer','0','0',1,1,'B','');
65 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableEventStormDetection','0','0',1,1,'B','');
66 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.');
67 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).');
68 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableObjectTransactions','0','0',1,1,'B','');
69 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.');
70 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.');
71 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.');
72 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EnableTimedAlarmAck','1','1',1,1,'B','');
73 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).');
74 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');
75 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EscapeLocalCommands','0','0',1,0,'B','');
76 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EventLogRetentionTime','90','90',1,0,'I','');
77 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('EventStormDuration','15','15',1,1,'I','');
78 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');
79 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.');
80 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.');
81 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.');
82 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.');
83 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.');
84 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.');
85 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('FirstFreeObjectId','100','100',0,1,'I','');
86 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('FixedStatusValue','0','0',1,1,'I','');
87 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');
88 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('HelpDeskLink','none','none',1,1,'S','');
89 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.');
90 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.');
91 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).');
92 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.');
93 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).');
94 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.');
95 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('IntruderLockoutThreshold','0','0',1,0,'I','');
96 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('IntruderLockoutTime','30','30',1,0,'I','');
97 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraIssueType','Task','Task',1,0,'S','');
98 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.');
99 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraPassword','','',1,1,'S','Jira password');
100 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');
101 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JiraProjectComponent','','',1,0,'S','');
102 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');
103 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('JobHistoryRetentionTime','90','90',1,0,'I','');
104 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.');
105 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.');
106 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.');
107 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapGroupUniqueId','','',1,0,'S','');
108 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.');
109 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.');
110 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.');
111 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.');
112 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.');
113 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.');
114 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.');
115 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.');
116 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.');
117 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.');
118 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.');
119 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.');
120 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LdapUserUniqueId','','',1,0,'S','');
121 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('LockTimeout','60000','60000',1,1,'I','');
122 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.');
123 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)');
124 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.');
125 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.');
126 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.');
127 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('MinViewRefreshInterval','1000','1000',1,0,'I','');
128 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('MobileDeviceListenerPort','4747','4747',1,1,'I','');
129 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('NumberOfDataCollectors','25','25',1,1,'I','The number of threads used for data collection.');
130 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).');
131 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.');
132 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.');
133 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.');
134 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.');
135 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.');
136 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.');
137 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.');
138 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).');
139 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.');
140 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.');
141 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.');
142 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.');
143 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.');
144 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.');
145 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.');
146 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.');
147 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.');
148 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.');
149 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.');
150 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.');
151 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ResolveNodeNames','1','1',1,0,'B','');
152 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.');
153 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*.');
154 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');
155 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('ServerCommandOutputTimeout','60','60',1,0,'I','');
156 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');
157 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.');
158 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.');
159 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.');
160 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.');
161 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.');
162 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.');
163 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.');
164 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.');
165 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');
166 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.');
167 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.');
168 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusCalculationAlgorithm','1','1',1,1,'I','');
169 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.');
170 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).');
171 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusShift','0','0',1,1,'I','');
172 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusSingleThreshold','75','75',1,1,'I','');
173 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusThresholds','503C2814','503C2814',1,1,'S','');
174 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('StatusTranslation','01020304','01020304',1,1,'S','');
175 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).');
176 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.');
177 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.');
178 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.');
179 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.');
180 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.');
181 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.');
182 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.');
183 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.');
184 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('TopologyDiscoveryRadius','3','3',1,0,'I','');
185 INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,data_type,description) VALUES ('TopologyExpirationTime','900','900',1,0,'I','');
186 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.');
187 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.');
188 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.');
189 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.');
190 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.');
191 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).');
192 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.');
193 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.');
194 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.');
195 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.');
196 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.');
197 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.');
198
199 /*
200 ** Config possible values
201 */
202 INSERT INTO config_values (var_name,var_value) VALUES ('ClientListenerPort','65535');
203 INSERT INTO config_values (var_name,var_value) VALUES ('ExternalAuditPort','65535');
204 INSERT INTO config_values (var_name,var_value) VALUES ('MobileDeviceListenerPort','65535');
205 INSERT INTO config_values (var_name,var_value) VALUES ('RADIUSPort','65535');
206 INSERT INTO config_values (var_name,var_value) VALUES ('RADIUSSecondaryPort','65535');
207 INSERT INTO config_values (var_name,var_value) VALUES ('ReportingServerPort','65535');
208 INSERT INTO config_values (var_name,var_value) VALUES ('SNMPPorts','65535');
209 INSERT INTO config_values (var_name,var_value) VALUES ('SNMPTrapPort','65535');
210 INSERT INTO config_values (var_name,var_value) VALUES ('SyslogListenPort','65535');
211 INSERT INTO config_values (var_name,var_value) VALUES ('XMPPPort','65535');
212 INSERT INTO config_values (var_name,var_value) VALUES ('AllowedCiphers','63');
213 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentCacheMode','1','On');
214 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentCacheMode','2','Off');
215 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentProtocolCompressionMode','1','Enabled');
216 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultAgentProtocolCompressionMode','2','Disabled');
217 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','0','UP');
218 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','1','DOWN');
219 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultInterfaceExpectedState','2','IGNORE');
220 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','0','Disabled');
221 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','1','Allowed');
222 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','2','Preferred');
223 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('DefaultEncryptionPolicy','3','Required');
224 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','0','Default');
225 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','1','Unchanged');
226 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','2','Fixed');
227 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','3','Relative');
228 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('StatusPropagationAlgorithm','4','Translated');
229 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','0','Don''t use aliases');
230 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','1','Use aliases when possible');
231 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','2','Concatenate alias and name');
232 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('UseInterfaceAliases','3','Concatenate name and alias');
233 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('SyslogNodeMatchingPolicy','0','IP,, then hostname');
234 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('SyslogNodeMatchingPolicy','1','Hostname, then IP');
235 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('LdapUserDeleteAction','0','Delete user');
236 INSERT INTO config_values (var_name,var_value,var_description) VALUES ('LdapUserDeleteAction','1','Disable user');
237
238 /*
239 ** System user
240 */
241 INSERT INTO users (id,name,password,system_access,flags,full_name,
242 description,grace_logins,auth_method,guid,
243 cert_mapping_method,cert_mapping_data,
244 auth_failures,last_passwd_change,min_passwd_length,
245 disabled_until,last_login,created)
246 VALUES (0,'system',
247 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
248 274877906943,12,'','Built-in system account',5,0, /* Flags: change password + disabled */
249 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0,0
250 );
251
252 /*
253 ** Default admin user
254 */
255 INSERT INTO users (id,name,password,system_access,flags,full_name,
256 description,grace_logins,auth_method,guid,
257 cert_mapping_method,cert_mapping_data,
258 auth_failures,last_passwd_change,min_passwd_length,
259 disabled_until,last_login,created)
260 VALUES (1,'admin',
261 '3A445C0072CD69D9030CC6644020E5C4576051B1', /* Default password: netxms */
262 0,8,'','Default administrator account',5,0,
263 '00000000-0000-0000-0000-000000000000',0,'',0,0,0,0,0,0
264 );
265
266 /*
267 ** Special "Everyone" user group
268 */
269 INSERT INTO user_groups (id,name,system_access,flags,description,guid,created)
270 VALUES (-2147483648, 'Everyone', 274877906960, 0, 'Built-in everyone group',
271 '00000000-0000-0000-0000-000000000000',0
272 );
273
274 /*
275 ** Default "Admins" group
276 */
277 INSERT INTO user_groups (id,name,system_access,flags,description,guid,created)
278 VALUES (-2147483647, 'Admins', 549755813887, 0, 'Default administrative group',
279 '00000000-0000-0000-0000-000000000000',0
280 );
281
282 INSERT INTO user_group_members (group_id,user_id) VALUES (-2147483647,1);
283
284 INSERT INTO acl (object_id,user_id,access_rights) VALUES (1,-2147483647,65535);
285 INSERT INTO acl (object_id,user_id,access_rights) VALUES (2,-2147483647,65535);
286 INSERT INTO acl (object_id,user_id,access_rights) VALUES (3,-2147483647,65535);
287 INSERT INTO acl (object_id,user_id,access_rights) VALUES (4,-2147483647,65535);
288 INSERT INTO acl (object_id,user_id,access_rights) VALUES (5,-2147483647,65535);
289 INSERT INTO acl (object_id,user_id,access_rights) VALUES (6,-2147483647,65535);
290 INSERT INTO acl (object_id,user_id,access_rights) VALUES (7,-2147483647,65535);
291 INSERT INTO acl (object_id,user_id,access_rights) VALUES (8,-2147483647,65535);
292 INSERT INTO acl (object_id,user_id,access_rights) VALUES (9,-2147483647,65535);
293
294 /*
295 ** Default event groups
296 */
297
298 #define ID_GROUP_1 -2147483647
299 #define ID_GROUP_2 -2147483646
300
301 INSERT INTO event_groups (guid,id,name,description)
302 VALUES ('04b326c0-5cc0-411f-8587-2836cb87c920',ID_GROUP_1,'NodeStatus','All events reporting about node status change');
303 INSERT INTO event_groups (guid,id,name,description)
304 VALUES ('b61859c6-1768-4a61-a0cf-eed07d688f66',ID_GROUP_2,'NewObjects','All events reporting about new objects creation');
305
306 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_NORMAL);
307 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MINOR);
308 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_WARNING);
309 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_MAJOR);
310 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_CRITICAL);
311 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNKNOWN);
312 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_1,EVENT_NODE_UNMANAGED);
313
314 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_NODE_ADDED);
315 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_SUBNET_ADDED);
316 INSERT INTO event_group_members (group_id,event_code) VALUES (ID_GROUP_2,EVENT_INTERFACE_ADDED);
317
318 /*
319 ** Default community string
320 */
321 INSERT INTO snmp_communities (id,community) VALUES(1,'public');