CREATE INDEX actions_1 on actions (eventsource,status);
CREATE TABLE auditlog_details (
auditdetailid bigint DEFAULT '0' NOT NULL,
auditid bigint DEFAULT '0' NOT NULL,
table_name varchar(64) DEFAULT '' NOT NULL,
field_name varchar(64) DEFAULT '' NOT NULL,
oldvalue text DEFAULT '' NOT NULL,
newvalue text DEFAULT '' NOT NULL,
PRIMARY KEY (auditdetailid)
) with OIDS;
CREATE INDEX auditlog_details_1 on auditlog_details (auditid);
alter table auditlog add ip varchar(39) DEFAULT '' NOT NULL;
alter table auditlog add resourceid bigint DEFAULT '0' NOT NULL;
alter table auditlog add resourcename varchar(255) DEFAULT '' NOT NULL;
CREATE TABLE autoreg_host (
autoreg_hostid bigint DEFAULT '0' NOT NULL,
proxy_hostid bigint DEFAULT '0' NOT NULL,
host varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (autoreg_hostid)
) with OIDS;
CREATE INDEX autoreg_host_1 on autoreg_host (proxy_hostid,host);
alter table config add dropdown_first_entry integer DEFAULT '1' NOT NULL;
alter table config add dropdown_first_remember integer DEFAULT '1' NOT NULL;
alter table config add discovery_groupid bigint DEFAULT '0' NOT NULL;
alter table config add max_in_table integer DEFAULT '50' NOT NULL;
alter table config add search_limit integer DEFAULT '1000' NOT NULL;
alter table dchecks add snmpv3_securityname varchar(64) DEFAULT '' NOT NULL;
alter table dchecks add snmpv3_securitylevel integer DEFAULT '0' NOT NULL;
alter table dchecks add snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL;
alter table dchecks add snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL;
CREATE INDEX dchecks_1 on dchecks (druleid);
alter table dservices add dcheckid bigint DEFAULT '0' NOT NULL;
alter table dservices add ip varchar(39) DEFAULT '' NOT NULL;
update dservices set ip=(select dhosts.ip from dhosts where dservices.dhostid=dhosts.dhostid);
alter table dhosts drop ip;
CREATE INDEX dhosts_1 on dhosts (druleid);
alter table drules add unique_dcheckid bigint DEFAULT '0' NOT NULL;
-- See also dhosts.sql
CREATE UNIQUE INDEX dservices_1 on dservices (dcheckid,type,key_,ip,port);
CREATE INDEX dservices_2 on dservices (dhostid);
CREATE INDEX escalations_2 on escalations (status,nextcheck);
DROP INDEX events_2;
CREATE INDEX events_2 on events (clock, objectid);
CREATE TABLE expressions (
expressionid bigint DEFAULT '0' NOT NULL,
regexpid bigint DEFAULT '0' NOT NULL,
expression varchar(255) DEFAULT '' NOT NULL,
expression_type integer DEFAULT '0' NOT NULL,
exp_delimiter varchar(1) DEFAULT '' NOT NULL,
case_sensitive integer DEFAULT '0' NOT NULL,
PRIMARY KEY (expressionid)
) with OIDS;
CREATE INDEX expressions_1 on expressions (regexpid);
CREATE TABLE globalmacro (
globalmacroid bigint DEFAULT '0' NOT NULL,
macro varchar(64) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (globalmacroid)
) with OIDS;
CREATE INDEX globalmacro_1 on globalmacro (macro);
CREATE TABLE graphs_items_tmp (
gitemid bigint DEFAULT '0' NOT NULL,
graphid bigint DEFAULT '0' NOT NULL,
itemid bigint DEFAULT '0' NOT NULL,
drawtype integer DEFAULT '0' NOT NULL,
sortorder integer DEFAULT '0' NOT NULL,
color varchar(6) DEFAULT '009600' NOT NULL,
yaxisside integer DEFAULT '1' NOT NULL,
calc_fnc integer DEFAULT '2' NOT NULL,
type integer DEFAULT '0' NOT NULL,
periods_cnt integer DEFAULT '5' NOT NULL,
PRIMARY KEY (gitemid)
) with OIDS;
insert into graphs_items_tmp select gitemid,graphid,itemid,drawtype,sortorder,color,yaxisside,calc_fnc,type,periods_cnt from graphs_items;
drop table graphs_items;
alter table graphs_items_tmp rename to graphs_items;
CREATE INDEX graphs_items_1 on graphs_items (itemid);
CREATE INDEX graphs_items_2 on graphs_items (graphid);
alter table graphs add ymin_type integer DEFAULT '0' NOT NULL;
alter table graphs add ymax_type integer DEFAULT '0' NOT NULL;
alter table graphs add ymin_itemid bigint DEFAULT '0' NOT NULL;
alter table graphs add ymax_itemid bigint DEFAULT '0' NOT NULL;
update graphs set ymin_type=yaxistype;
update graphs set ymax_type=yaxistype;
alter table graphs drop yaxistype;
CREATE TABLE graph_theme (
graphthemeid bigint DEFAULT '0' NOT NULL,
description varchar(64) DEFAULT '' NOT NULL,
theme varchar(64) DEFAULT '' NOT NULL,
backgroundcolor varchar(6) DEFAULT 'F0F0F0' NOT NULL,
graphcolor varchar(6) DEFAULT 'FFFFFF' NOT NULL,
graphbordercolor varchar(6) DEFAULT '222222' NOT NULL,
gridcolor varchar(6) DEFAULT 'CCCCCC' NOT NULL,
maingridcolor varchar(6) DEFAULT 'AAAAAA' NOT NULL,
gridbordercolor varchar(6) DEFAULT '000000' NOT NULL,
textcolor varchar(6) DEFAULT '202020' NOT NULL,
highlightcolor varchar(6) DEFAULT 'AA4444' NOT NULL,
leftpercentilecolor varchar(6) DEFAULT '11CC11' NOT NULL,
rightpercentilecolor varchar(6) DEFAULT 'CC1111' NOT NULL,
noneworktimecolor varchar(6) DEFAULT 'E0E0E0' NOT NULL,
gridview integer DEFAULT 1 NOT NULL,
legendview integer DEFAULT 1 NOT NULL,
PRIMARY KEY (graphthemeid)
) with OIDS;
CREATE INDEX graph_theme_1 on graph_theme (description);
CREATE INDEX graph_theme_2 on graph_theme (theme);
INSERT INTO graph_theme VALUES (1,'Original Blue','css_ob.css','F0F0F0','FFFFFF','333333','CCCCCC','AAAAAA','000000','222222','AA4444','11CC11','CC1111','E0E0E0',1,1);
INSERT INTO graph_theme VALUES (2,'Black & Blue','css_bb.css','333333','0A0A0A','888888','222222','4F4F4F','EFEFEF','0088FF','CC4444','1111FF','FF1111','1F1F1F',1,1);
alter table groups add internal integer DEFAULT '0' NOT NULL;
drop table help_items;
CREATE TABLE help_items (
itemtype integer DEFAULT '0' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
description varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (itemtype,key_)
) with OIDS;
insert into help_items values (3,'icmpping[<ip>,<count>,<interval>,<size>,<timeout>]','Checks if server is accessible by ICMP ping. 0 - ICMP ping fails. 1 - ICMP ping successful. One of zabbix_server processes performs ICMP pings once per PingerFrequency seconds.');
insert into help_items values (3,'icmppingloss[<ip>,<count>,<interval>,<size>,<timeout>]','Returns percentage of lost ICMP ping packets.');
insert into help_items values (3,'icmppingsec[<ip>,<count>,<interval>,<size>,<timeout>,<type>]','Returns ICMP ping response time in seconds. Example: 0.02');
insert into help_items values (3,'ftp<,port>','Checks if FTP server is running and accepting connections. 0 - FTP server is down. 1 - FTP server is running.');
insert into help_items values (3,'http<,port>','Checks if HTTP (WEB) server is running and accepting connections. 0 - HTTP server is down. 1 - HTTP server is running.');
insert into help_items values (3,'imap<,port>','Checks if IMAP server is running and accepting connections. 0 - IMAP server is down. 1 - IMAP server is running.');
insert into help_items values (3,'ldap<,port>','Checks if LDAP server is running and accepting connections. 0 - LDAP server is down. 1 - LDAP server is running.');
insert into help_items values (3,'nntp<,port>','Checks if NNTP server is running and accepting connections. 0 - NNTP server is down. 1 - NNTP server is running.');
insert into help_items values (3,'ntp<,port>','Checks if NTP server is running and accepting connections. 0 - NTP server is down. 1 - NTP server is running.');
insert into help_items values (3,'pop<,port>','Checks if POP server is running and accepting connections. 0 - POP server is down. 1 - POP server is running.');
insert into help_items values (3,'smtp<,port>','Checks if SMTP server is running and accepting connections. 0 - SMTP server is down. 1 - SMTP server is running.');
insert into help_items values (3,'ssh<,port>','Checks if SSH server is running and accepting connections. 0 - SSH server is down. 1 - SSH server is running.');
insert into help_items values (3,'tcp,port','Checks if TCP service is running and accepting connections on port. 0 - the service on the port is down. 1 - the service is running.');
insert into help_items values (3,'ftp_perf<,port>','Checks if FTP server is running and accepting connections. 0 - FTP server is down. Otherwise, number of seconds spent connecting to FTP server.');
insert into help_items values (3,'http_perf<,port>','Checks if HTTP (WEB) server is running and accepting connections. 0 - HTTP server is down. Otherwise, number of seconds spent connecting to HTTP server.');
insert into help_items values (3,'imap_perf<,port>','Checks if IMAP server is running and accepting connections. 0 - IMAP server is down. Otherwise, number of seconds spent connecting to IMAP server.');
insert into help_items values (3,'ldap_perf<,port>','Checks if LDAP server is running and accepting connections. 0 - LDAP server is down. Otherwise, number of seconds spent connecting to LDAP server.');
insert into help_items values (3,'nntp_perf<,port>','Checks if NNTP server is running and accepting connections. 0 - NNTP server is down. Otherwise, number of seconds spent connecting to NNTP server.');
insert into help_items values (3,'ntp_perf<,port>','Checks if NTP server is running and accepting connections. 0 - NTP server is down. Otherwise, number of seconds spent connecting to NTP server.');
insert into help_items values (3,'pop_perf<,port>','Checks if POP server is running and accepting connections. 0 - POP server is down. Otherwise, number of milliseconds spent connecting to POP server.');
insert into help_items values (3,'smtp_perf<,port>','Checks if SMTP server is running and accepting connections. 0 - SMTP server is down. Otherwise, number of seconds spent connecting to SMTP server.');
insert into help_items values (3,'ssh_perf<,port>','Checks if SSH server is running and accepting connections. 0 - SSH server is down. Otherwise, number of seconds spent connecting to SSH server.');
insert into help_items values (3,'tcp_perf,port','Checks if TCP service is running and accepting connections on port. 0 - the service on the port is down. Otherwise, number of seconds spent connecting to TCP service.');
insert into help_items values (5,'zabbix[history]','Number of values stored in table HISTORY.');
insert into help_items values (5,'zabbix[history_log]','Number of values stored in table HISTORY_LOG.');
insert into help_items values (5,'zabbix[history_str]','Number of values stored in table HISTORY_STR.');
insert into help_items values (5,'zabbix[history_text]','Number of values stored in table HISTORY_TEXT.');
insert into help_items values (5,'zabbix[history_uint]','Number of values stored in table HISTORY_UINT.');
insert into help_items values (5,'zabbix[items]','Number of items in Zabbix database.');
insert into help_items values (5,'zabbix[items_unsupported]','Number of unsupported items in Zabbix database.');
insert into help_items values (5,'zabbix[log]','Stores warning and error messages generated by Zabbix server.');
insert into help_items values (5,'zabbix[queue<,from><,to>]','Number of items in the queue which are delayed by from to to seconds, inclusive.');
insert into help_items values (5,'zabbix[trends]','Number of values stored in table TRENDS.');
insert into help_items values (5,'zabbix[trends_uint]','Number of values stored in table TRENDS_UINT.');
insert into help_items values (5,'zabbix[triggers]','Number of triggers in Zabbix database.');
insert into help_items values (8,'grpfunc[<Group>,<Key>,<func>,<param>]','Aggregate checks do not require any agent running on a host being monitored. Zabbix server collects aggregate information by doing direct database queries. See Zabbix Manual.');
insert into help_items values(0,'agent.ping','Check the agent usability. Always return 1. Can be used as a TCP ping.');
insert into help_items values(0,'agent.version','Version of zabbix_agent(d) running on monitored host. String value. Example of returned value: 1.1');
insert into help_items values(0,'kernel.maxfiles','Maximum number of opened files supported by OS.');
insert into help_items values(0,'kernel.maxproc','Maximum number of processes supported by OS.');
insert into help_items values(0,'net.if.collisions[if]','Out-of-window collision. Collisions count.');
insert into help_items values(0,'net.if.in[if <,mode>]','Network interface input statistic. Integer value. If mode is missing bytes is used.');
insert into help_items values(0,'net.if.out[if <,mode>]','Network interface output statistic. Integer value. If mode is missing bytes is used.');
insert into help_items values(0,'net.tcp.dns[ip, zone]','Checks if DNS service is up. 0 - DNS is down, 1 - DNS is up.');
insert into help_items values(0,'net.tcp.dns.query[ip, zone, type]','Performs a query for the record type specified by the parameter type');
insert into help_items values(0,'net.tcp.listen[port]','Checks if this port is in LISTEN state. 0 - it is not, 1 - it is in LISTEN state.');
insert into help_items values(0,'net.tcp.port[<ip>, port]','Check, if it is possible to make TCP connection to the port number. 0 - cannot connect, 1 - can connect. IP address is optional. If ip is missing, 127.0.0.1 is used. Example: net.tcp.port[,80]');
insert into help_items values(0,'net.tcp.service[service <,ip> <,port>]','Check if service server is running and accepting connections. 0 - service is down, 1 - service is running. If ip is missing 127.0.0.1 is used. If port number is missing, default service port is used. Example: net.tcp.service[ftp,,45].');
insert into help_items values(0,'net.tcp.service.perf[service <,ip> <,port>]','Check performance of service "service". 0 - service is down, sec - number of seconds spent on connection to the service. If ip is missing 127.0.0.1 is used. If port number is missing, default service port is used.');
insert into help_items values(0,'proc.mem[<name> <,user> <,mode> <,cmdline>]','Memory used by process with name name running under user user. Memory used by processes. Process name, user and mode is optional. If name or user is missing all processes will be calculated. If mode is missing sum is used. Example: proc.mem[,root]');
insert into help_items values(0,'proc.num[<name> <,user> <,state> <,cmdline>]','Number of processes with name name running under user user having state state. Process name, user and state are optional. Examples: proc.num[,mysql]; proc.num[apache2,www-data]; proc.num[,oracle,sleep,oracleZABBIX]');
insert into help_items values(0,'system.cpu.intr','Device interrupts.');
insert into help_items values(0,'system.cpu.load[<cpu> <,mode>]','CPU(s) load. Processor load. The cpu and mode are optional. If cpu is missing all is used. If mode is missing avg1 is used. Note that this is not percentage.');
insert into help_items values(0,'system.cpu.switches','Context switches.');
insert into help_items values(0,'system.cpu.util[<cpu> <,type> <,mode>]','CPU(s) utilisation. Processor load in percents. The cpu, type and mode are optional. If cpu is missing all is used. If type is missing user is used. If mode is missing avg1 is used.');
insert into help_items values(0,'system.boottime','Timestamp of system boot.');
insert into help_items values(0,'system.cpu.num','Number of available proccessors.');
insert into help_items values(0,'system.hostname','Return host name. String value. Example of returned value: www.zabbix.com');
insert into help_items values(0,'system.localtime','System local time. Time in seconds.');
insert into help_items values(0,'system.run[command,<mode>]','Run specified command on the host.');
insert into help_items values(0,'system.swap.in[<swap> <,type>]','Swap in. If type is count - swapins is returned. If type is pages - pages swapped in is returned. If swap is missing all is used.');
insert into help_items values(0,'system.swap.out[<swap> <,type>]','Swap out. If type is count - swapouts is returned. If type is pages - pages swapped in is returned. If swap is missing all is used.');
insert into help_items values(0,'system.swap.size[<swap> <,mode>]','Swap space. Number of bytes. If swap is missing all is used. If mode is missing free is used.');
insert into help_items values(0,'system.uname','Returns detailed host information. String value');
insert into help_items values(0,'system.uptime','System uptime in seconds.');
insert into help_items values(0,'system.users.num','Number of users connected. Command who is used on agent side.');
insert into help_items values(0,'vfs.dev.read[device <,type> <,mode>]','Device read statistics.');
insert into help_items values(0,'vfs.dev.write[device <,type> <,mode>]','Device write statistics.');
insert into help_items values(0,'vfs.file.cksum[file]','Calculate check sum of a given file. Check sum of the file calculate by standard algorithm used by UNIX utility cksum. Example: vfs.file.cksum[/etc/passwd]');
insert into help_items values(0,'vfs.file.exists[file]','Check file existance. 0 - file does not exist, 1 - file exists');
insert into help_items values(0,'vfs.file.md5sum[file]','Calculate MD5 check sum of a given file. String MD5 hash of the file. Can be used for files less than 64MB, unsupported otherwise. Example: vfs.file.md5sum[/etc/zabbix/zabbix_agentd.conf]');
insert into help_items values(0,'vfs.file.regexp[file,regexp]','Find string in a file. Matched string');
insert into help_items values(0,'vfs.file.regmatch[file,regexp]','Find string in a file. 0 - expression not found, 1 - found');
insert into help_items values(0,'vfs.file.size[file]','Size of a given file. Size in bytes. File must have read permissions for user zabbix. Example: vfs.file.size[/var/log/syslog]');
insert into help_items values(0,'vfs.file.time[file<, mode>]','File time information. Number of seconds. The mode is optional. If mode is missing modify is used.');
insert into help_items values(0,'vfs.fs.inode[fs <,mode>]','Number of inodes for a given volume. If mode is missing total is used.');
insert into help_items values(0,'vfs.fs.size[fs <,mode>]','Calculate disk space for a given volume. Disk space in KB. If mode is missing total is used. In case of mounted volume, unused disk space for local file system is returned. Example: vfs.fs.size[/tmp,free].');
insert into help_items values(0,'vm.memory.size[<mode>]','Amount of memory size in bytes. If mode is missing total is used.');
insert into help_items values(0,'web.page.get[host,<path>,<port>]','Get content of WEB page. Default path is /');
insert into help_items values(0,'web.page.perf[host,<path>,<port>]','Get timing of loading full WEB page. Default path is /');
insert into help_items values(0,'web.page.regexp[host,<path>,<port>,<regexp>,<length>]','Get first occurence of regexp in WEB page. Default path is /');
insert into help_items values(0,'perf_counter[counter]','Value of any performance counter, where parameter is the counter path.');
insert into help_items values(0,'service_state[service]','State of service. 0 - running, 1 - paused, 2 - start pending, 3 - pause pending, 4 - continue pending, 5 - stop pending, 6 - stopped, 7 - unknown, 255 - no such service');
insert into help_items values(0,'proc_info[<process>,<attribute>,<type>]','Different information about specific process(es)');
insert into help_items values(7,'agent.ping','Check the agent usability. Always return 1. Can be used as a TCP ping.');
insert into help_items values(7,'agent.version','Version of zabbix_agent(d) running on monitored host. String value. Example of returned value: 1.1');
insert into help_items values(7,'kernel.maxfiles','Maximum number of opened files supported by OS.');
insert into help_items values(7,'kernel.maxproc','Maximum number of processes supported by OS.');
insert into help_items values(7,'net.if.collisions[if]','Out-of-window collision. Collisions count.');
insert into help_items values(7,'net.if.in[if <,mode>]','Network interface input statistic. Integer value. If mode is missing bytes is used.');
insert into help_items values(7,'net.if.out[if <,mode>]','Network interface output statistic. Integer value. If mode is missing bytes is used.');
insert into help_items values(7,'net.tcp.dns[ip, zone]','Checks if DNS service is up. 0 - DNS is down, 1 - DNS is up.');
insert into help_items values(7,'net.tcp.dns.query[ip, zone, type]','Performs a query for the record type specified by the parameter type');
insert into help_items values(7,'net.tcp.listen[port]','Checks if this port is in LISTEN state. 0 - it is not, 1 - it is in LISTEN state.');
insert into help_items values(7,'net.tcp.port[<ip>, port]','Check, if it is possible to make TCP connection to the port number. 0 - cannot connect, 1 - can connect. IP address is optional. If ip is missing, 127.0.0.1 is used. Example: net.tcp.port[,80]');
insert into help_items values(7,'net.tcp.service[service <,ip> <,port>]','Check if service server is running and accepting connections. 0 - service is down, 1 - service is running. If ip is missing 127.0.0.1 is used. If port number is missing, default service port is used. Example: net.tcp.service[ftp,,45].');
insert into help_items values(7,'net.tcp.service.perf[service <,ip> <,port>]','Check performance of service "service". 0 - service is down, sec - number of seconds spent on connection to the service. If ip is missing 127.0.0.1 is used. If port number is missing, default service port is used.');
insert into help_items values(7,'proc.mem[<name> <,user> <,mode> <,cmdline>]','Memory used by process with name name running under user user. Memory used by processes. Process name, user and mode is optional. If name or user is missing all processes will be calculated. If mode is missing sum is used. Example: proc.mem[,root]');
insert into help_items values(7,'proc.num[<name> <,user> <,state> <,cmdline>]','Number of processes with name name running under user user having state state. Process name, user and state are optional. Examples: proc.num[,mysql]; proc.num[apache2,www-data]; proc.num[,oracle,sleep,oracleZABBIX]');
insert into help_items values(7,'system.cpu.intr','Device interrupts.');
insert into help_items values(7,'system.cpu.load[<cpu> <,mode>]','CPU(s) load. Processor load. The cpu and mode are optional. If cpu is missing all is used. If mode is missing avg1 is used. Note that this is not percentage.');
insert into help_items values(7,'system.cpu.switches','Context switches.');
insert into help_items values(7,'system.cpu.util[<cpu> <,type> <,mode>]','CPU(s) utilisation. Processor load in percents. The cpu, type and mode are optional. If cpu is missing all is used. If type is missing user is used. If mode is missing avg1 is used.');
insert into help_items values(7,'system.boottime','Timestamp of system boot.');
insert into help_items values(7,'system.cpu.num','Number of available proccessors.');
insert into help_items values(7,'system.hostname','Return host name. String value. Example of returned value: www.zabbix.com');
insert into help_items values(7,'system.localtime','System local time. Time in seconds.');
insert into help_items values(7,'system.run[command,<mode>]','Run specified command on the host.');
insert into help_items values(7,'system.swap.in[<swap> <,type>]','Swap in. If type is count - swapins is returned. If type is pages - pages swapped in is returned. If swap is missing all is used.');
insert into help_items values(7,'system.swap.out[<swap> <,type>]','Swap out. If type is count - swapouts is returned. If type is pages - pages swapped in is returned. If swap is missing all is used.');
insert into help_items values(7,'system.swap.size[<swap> <,mode>]','Swap space. Number of bytes. If swap is missing all is used. If mode is missing free is used.');
insert into help_items values(7,'system.uname','Returns detailed host information. String value');
insert into help_items values(7,'system.uptime','System uptime in seconds.');
insert into help_items values(7,'system.users.num','Number of users connected. Command who is used on agent side.');
insert into help_items values(7,'vfs.dev.read[device <,type> <,mode>]','Device read statistics.');
insert into help_items values(7,'vfs.dev.write[device <,type> <,mode>]','Device write statistics.');
insert into help_items values(7,'vfs.file.cksum[file]','Calculate check sum of a given file. Check sum of the file calculate by standard algorithm used by UNIX utility cksum. Example: vfs.file.cksum[/etc/passwd]');
insert into help_items values(7,'vfs.file.exists[file]','Check file existance. 0 - file does not exist, 1 - file exists');
insert into help_items values(7,'vfs.file.md5sum[file]','Calculate MD5 check sum of a given file. String MD5 hash of the file. Can be used for files less than 64MB, unsupported otherwise. Example: vfs.file.md5sum[/etc/zabbix/zabbix_agentd.conf]');
insert into help_items values(7,'vfs.file.regexp[file,regexp]','Find string in a file. Matched string');
insert into help_items values(7,'vfs.file.regmatch[file,regexp]','Find string in a file. 0 - expression not found, 1 - found');
insert into help_items values(7,'vfs.file.size[file]','Size of a given file. Size in bytes. File must have read permissions for user zabbix. Example: vfs.file.size[/var/log/syslog]');
insert into help_items values(7,'vfs.file.time[file<, mode>]','File time information. Number of seconds. The mode is optional. If mode is missing modify is used.');
insert into help_items values(7,'vfs.fs.inode[fs <,mode>]','Number of inodes for a given volume. If mode is missing total is used.');
insert into help_items values(7,'vfs.fs.size[fs <,mode>]','Calculate disk space for a given volume. Disk space in KB. If mode is missing total is used. In case of mounted volume, unused disk space for local file system is returned. Example: vfs.fs.size[/tmp,free].');
insert into help_items values(7,'vm.memory.size[<mode>]','Amount of memory size in bytes. If mode is missing total is used.');
insert into help_items values(7,'web.page.get[host,<path>,<port>]','Get content of WEB page. Default path is /');
insert into help_items values(7,'web.page.perf[host,<path>,<port>]','Get timing of loading full WEB page. Default path is /');
insert into help_items values(7,'web.page.regexp[host,<path>,<port>,<regexp>,<length>]','Get first occurence of regexp in WEB page. Default path is /');
insert into help_items values(7,'perf_counter[counter]','Value of any performance counter, where parameter is the counter path.');
insert into help_items values(7,'service_state[service]','State of service. 0 - running, 1 - paused, 2 - start pending, 3 - pause pending, 4 - continue pending, 5 - stop pending, 6 - stopped, 7 - unknown, 255 - no such service');
insert into help_items values(7,'proc_info[<process>,<attribute>,<type>]','Different information about specific process(es)');
insert into help_items values(7,'log[file,<pattern>,<encoding>,<maxlines>]','Monitoring of log file. pattern - regular expression');
insert into help_items values(7,'logrt[file_format,<pattern>,<encoding>,<maxlines>]', 'Monitoring of log file with rotation. fileformat - [path][regexp], pattern - regular expression');
insert into help_items values(7,'eventlog[logtype,<pattern>,<severity>,<source>,<eventid>,<maxlines>]','Monitoring of Windows event logs. pattern, severity, eventid - regular expressions');
alter table history_log add logeventid integer DEFAULT '0' NOT NULL;
CREATE UNIQUE INDEX history_log_2 on history_log (itemid,id);
CREATE UNIQUE INDEX history_text_2 on history_text (itemid,id);
ALTER TABLE history_uint ALTER COLUMN value TYPE numeric(20);
ALTER TABLE history_uint ALTER COLUMN value SET DEFAULT '0';
ALTER TABLE history_uint ALTER COLUMN value SET NOT NULL;
ALTER TABLE history_uint_sync ALTER COLUMN value TYPE numeric(20);
ALTER TABLE history_uint_sync ALTER COLUMN value SET DEFAULT '0';
ALTER TABLE history_uint_sync ALTER COLUMN value SET NOT NULL;
CREATE TABLE hostmacro (
hostmacroid bigint DEFAULT '0' NOT NULL,
hostid bigint DEFAULT '0' NOT NULL,
macro varchar(64) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (hostmacroid)
) with OIDS;
CREATE INDEX hostmacro_1 on hostmacro (hostid,macro);
drop index hosts_groups_groups_1;
CREATE INDEX hosts_groups_1 on hosts_groups (hostid,groupid);
CREATE INDEX hosts_groups_2 on hosts_groups (groupid);
alter table hosts add maintenanceid bigint DEFAULT '0' NOT NULL;
alter table hosts add maintenance_status integer DEFAULT '0' NOT NULL;
alter table hosts add maintenance_type integer DEFAULT '0' NOT NULL;
alter table hosts add maintenance_from integer DEFAULT '0' NOT NULL;
alter table hosts add ipmi_ip varchar(64) DEFAULT '127.0.0.1' NOT NULL;
alter table hosts add ipmi_errors_from integer DEFAULT '0' NOT NULL;
alter table hosts add snmp_errors_from integer DEFAULT '0' NOT NULL;
alter table hosts add ipmi_error varchar(128) DEFAULT '' NOT NULL;
alter table hosts add snmp_error varchar(128) DEFAULT '' NOT NULL;
ALTER TABLE hosts ALTER COLUMN inbytes TYPE numeric(20);
ALTER TABLE hosts ALTER COLUMN inbytes SET DEFAULT '0';
ALTER TABLE hosts ALTER COLUMN inbytes SET NOT NULL;
ALTER TABLE hosts ALTER COLUMN outbytes TYPE numeric(20);
ALTER TABLE hosts ALTER COLUMN outbytes SET DEFAULT '0';
ALTER TABLE hosts ALTER COLUMN outbytes SET NOT NULL;
CREATE INDEX hosts_templates_2 on hosts_templates (templateid);
alter table httptest add authentication integer DEFAULT '0' NOT NULL;
alter table httptest add http_user varchar(64) DEFAULT '' NOT NULL;
alter table httptest add http_password varchar(64) DEFAULT '' NOT NULL;
CREATE INDEX httptest_2 on httptest (name);
CREATE INDEX httptest_3 on httptest (status);
alter table items drop nextcheck;
alter table items add data_type integer DEFAULT '0' NOT NULL;
alter table items add authtype integer DEFAULT '0' NOT NULL;
alter table items add username varchar(64) DEFAULT '' NOT NULL;
alter table items add password varchar(64) DEFAULT '' NOT NULL;
alter table items add publickey varchar(64) DEFAULT '' NOT NULL;
alter table items add privatekey varchar(64) DEFAULT '' NOT NULL;
alter table items add mtime integer DEFAULT '0' NOT NULL;
UPDATE items SET units='Bps' WHERE type=9 AND units='bps';CREATE TABLE maintenances_groups (
maintenance_groupid bigint DEFAULT '0' NOT NULL,
maintenanceid bigint DEFAULT '0' NOT NULL,
groupid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (maintenance_groupid)
) with OIDS;
CREATE INDEX maintenances_groups_1 on maintenances_groups (maintenanceid,groupid);
CREATE TABLE maintenances_hosts (
maintenance_hostid bigint DEFAULT '0' NOT NULL,
maintenanceid bigint DEFAULT '0' NOT NULL,
hostid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (maintenance_hostid)
) with OIDS;
CREATE INDEX maintenances_hosts_1 on maintenances_hosts (maintenanceid,hostid);
CREATE TABLE maintenances (
maintenanceid bigint DEFAULT '0' NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
maintenance_type integer DEFAULT '0' NOT NULL,
description text DEFAULT '' NOT NULL,
active_since integer DEFAULT '0' NOT NULL,
active_till integer DEFAULT '0' NOT NULL,
PRIMARY KEY (maintenanceid)
) with OIDS;
CREATE INDEX maintenances_1 on maintenances (active_since,active_till);
CREATE TABLE maintenances_windows (
maintenance_timeperiodid bigint DEFAULT '0' NOT NULL,
maintenanceid bigint DEFAULT '0' NOT NULL,
timeperiodid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (maintenance_timeperiodid)
) with OIDS;
CREATE INDEX maintenances_windows_1 on maintenances_windows (maintenanceid,timeperiodid);
DROP TABLE node_cksum;
CREATE TABLE node_cksum (
nodeid integer DEFAULT '0' NOT NULL,
tablename varchar(64) DEFAULT '' NOT NULL,
recordid bigint DEFAULT '0' NOT NULL,
cksumtype integer DEFAULT '0' NOT NULL,
cksum text DEFAULT '' NOT NULL,
sync char(128) DEFAULT '' NOT NULL
) with OIDS;
CREATE INDEX node_cksum_1 on node_cksum (nodeid,cksumtype,tablename,recordid);
CREATE TABLE opmediatypes (
opmediatypeid bigint DEFAULT '0' NOT NULL,
operationid bigint DEFAULT '0' NOT NULL,
mediatypeid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (opmediatypeid)
) with OIDS;
CREATE UNIQUE INDEX opmediatypes_1 on opmediatypes (operationid);
CREATE INDEX profiles_2 on profiles (userid,profileid);
CREATE TABLE proxy_autoreg_host (
id serial NOT NULL,
clock integer DEFAULT '0' NOT NULL,
host varchar(64) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
) with OIDS;
CREATE INDEX proxy_autoreg_host_1 on proxy_autoreg_host (clock);
CREATE TABLE proxy_dhistory_tmp (
id serial NOT NULL,
clock integer DEFAULT '0' NOT NULL,
druleid bigint DEFAULT '0' NOT NULL,
type integer DEFAULT '0' NOT NULL,
ip varchar(39) DEFAULT '' NOT NULL,
port integer DEFAULT '0' NOT NULL,
key_ varchar(255) DEFAULT '' NOT NULL,
value varchar(255) DEFAULT '' NOT NULL,
status integer DEFAULT '0' NOT NULL,
dcheckid bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
) with OIDS;
insert into proxy_dhistory_tmp select id,clock,druleid,type,ip,port,key_,value,status,0 from proxy_dhistory;
drop table proxy_dhistory;
alter table proxy_dhistory_tmp rename to proxy_dhistory;
CREATE INDEX proxy_dhistory_1 on proxy_dhistory (clock);
alter table proxy_history add logeventid integer DEFAULT '0' NOT NULL;
CREATE TABLE regexps (
regexpid bigint DEFAULT '0' NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
test_string text DEFAULT '' NOT NULL,
PRIMARY KEY (regexpid)
) with OIDS;
CREATE INDEX regexps_1 on regexps (name);
CREATE INDEX rights_2 on rights (id);
CREATE INDEX services_1 on services (triggerid);
CREATE INDEX sessions_1 on sessions (userid, status);
CREATE TABLE sysmaps_elements_tmp (
selementid bigint DEFAULT '0' NOT NULL,
sysmapid bigint DEFAULT '0' NOT NULL,
elementid bigint DEFAULT '0' NOT NULL,
elementtype integer DEFAULT '0' NOT NULL,
iconid_off bigint DEFAULT '0' NOT NULL,
iconid_on bigint DEFAULT '0' NOT NULL,
iconid_unknown bigint DEFAULT '0' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
label_location integer NULL,
x integer DEFAULT '0' NOT NULL,
y integer DEFAULT '0' NOT NULL,
url varchar(255) DEFAULT '' NOT NULL,
iconid_disabled bigint DEFAULT '0' NOT NULL,
iconid_maintenance bigint DEFAULT '0' NOT NULL,
PRIMARY KEY (selementid)
) with OIDS;
insert into sysmaps_elements_tmp select selementid,sysmapid,elementid,elementtype,iconid_off,iconid_on,iconid_unknown,label,label_location,x,y,url,iconid_disabled from sysmaps_elements;
drop table sysmaps_elements;
alter table sysmaps_elements_tmp rename to sysmaps_elements;
CREATE TABLE sysmaps_links_tmp (
linkid bigint DEFAULT 0 NOT NULL,
sysmapid bigint DEFAULT 0 NOT NULL,
selementid1 bigint DEFAULT 0 NOT NULL,
selementid2 bigint DEFAULT 0 NOT NULL,
drawtype integer DEFAULT 0 NOT NULL,
color varchar(6) DEFAULT '000000' NOT NULL,
label varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (linkid)
) with OIDS;
insert into sysmaps_links_tmp select linkid,sysmapid,selementid1,selementid2,drawtype,color,'' from sysmaps_links;
drop table sysmaps_links;
alter table sysmaps_links_tmp rename to sysmaps_links;
CREATE TABLE sysmaps_tmp (
sysmapid bigint DEFAULT '0' NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
width integer DEFAULT '0' NOT NULL,
height integer DEFAULT '0' NOT NULL,
backgroundid bigint DEFAULT '0' NOT NULL,
label_type integer DEFAULT '0' NOT NULL,
label_location integer DEFAULT '0' NOT NULL,
highlight integer DEFAULT '1' NOT NULL,
PRIMARY KEY (sysmapid)
) with OIDS;
insert into sysmaps_tmp select sysmapid,name,width,height,backgroundid,label_type,label_location,1 from sysmaps;
drop table sysmaps;
alter table sysmaps_tmp rename to sysmaps;
CREATE INDEX sysmaps_1 on sysmaps (name);
CREATE TABLE timeperiods (
timeperiodid bigint DEFAULT '0' NOT NULL,
timeperiod_type integer DEFAULT '0' NOT NULL,
every integer DEFAULT '0' NOT NULL,
month integer DEFAULT '0' NOT NULL,
dayofweek integer DEFAULT '0' NOT NULL,
day integer DEFAULT '0' NOT NULL,
start_time integer DEFAULT '0' NOT NULL,
period integer DEFAULT '0' NOT NULL,
start_date integer DEFAULT '0' NOT NULL,
PRIMARY KEY (timeperiodid)
) with OIDS;
ALTER TABLE trends_uint ALTER COLUMN value_min TYPE numeric(20);
ALTER TABLE trends_uint ALTER COLUMN value_avg TYPE numeric(20);
ALTER TABLE trends_uint ALTER COLUMN value_max TYPE numeric(20);
ALTER TABLE trends_uint ALTER COLUMN value_min SET DEFAULT '0';
ALTER TABLE trends_uint ALTER COLUMN value_avg SET DEFAULT '0';
ALTER TABLE trends_uint ALTER COLUMN value_max SET DEFAULT '0';
ALTER TABLE trends_uint ALTER COLUMN value_min SET NOT NULL;
ALTER TABLE trends_uint ALTER COLUMN value_avg SET NOT NULL;
ALTER TABLE trends_uint ALTER COLUMN value_max SET NOT NULL;
CREATE TABLE user_history (
userhistoryid bigint DEFAULT '0' NOT NULL,
userid bigint DEFAULT '0' NOT NULL,
title1 varchar(255) DEFAULT '' NOT NULL,
url1 varchar(255) DEFAULT '' NOT NULL,
title2 varchar(255) DEFAULT '' NOT NULL,
url2 varchar(255) DEFAULT '' NOT NULL,
title3 varchar(255) DEFAULT '' NOT NULL,
url3 varchar(255) DEFAULT '' NOT NULL,
title4 varchar(255) DEFAULT '' NOT NULL,
url4 varchar(255) DEFAULT '' NOT NULL,
title5 varchar(255) DEFAULT '' NOT NULL,
url5 varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (userhistoryid)
) with OIDS;
CREATE UNIQUE INDEX user_history_1 on user_history (userid);
alter table users add rows_per_page integer DEFAULT 50 NOT NULL;
alter table usrgrp add api_access integer DEFAULT '0' NOT NULL;
alter table usrgrp add debug_mode integer DEFAULT '0' NOT NULL;
