1
alter table config add work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL;
2
alter table graphs add show_work_period int(1) DEFAULT '1' NOT NULL;
3
alter table graphs add show_triggers int(1) DEFAULT '1' NOT NULL;
5
alter table profiles change value value varchar(255) DEFAULT '' NOT NULL;
6
alter table profiles add valuetype int(4) DEFAULT 0 NOT NULL;
11
CREATE TABLE applications (
12
applicationid int(4) NOT NULL auto_increment,
13
hostid int(4) DEFAULT '0' NOT NULL,
14
name varchar(255) DEFAULT '' NOT NULL,
15
templateid int(4) DEFAULT '0' NOT NULL,
16
PRIMARY KEY (applicationid),
18
KEY templateid (templateid),
19
UNIQUE appname (hostid,name)
25
CREATE TABLE items_applications (
26
applicationid int(4) DEFAULT '0' NOT NULL,
27
itemid int(4) DEFAULT '0' NOT NULL,
28
PRIMARY KEY (applicationid,itemid)
32
alter table audit rename auditlog;
34
alter table auditlog add resourcetype int(4) DEFAULT '0' NOT NULL;
35
update auditlog set resourcetype=resource;
36
alter table auditlog drop resource;
38
alter table screens add hsize int(4) DEFAULT '1' NOT NULL;
39
alter table screens add vsize int(4) DEFAULT '1' NOT NULL;
40
update screens set hsize=cols;
41
update screens set vsize=rows;
42
alter table screens drop cols;
43
alter table screens drop rows;
45
alter table screens_items add resourcetype int(4) DEFAULT '0' NOT NULL;
46
update screens_items set resourcetype=resource;
47
alter table screens_items drop resource;
49
alter table functions change function function varchar(12) DEFAULT '' NOT NULL;
51
CREATE TABLE help_items (
52
itemtype int(4) DEFAULT '0' NOT NULL,
53
key_ varchar(64) DEFAULT '' NOT NULL,
54
description varchar(255) DEFAULT '' NOT NULL,
55
PRIMARY KEY (itemtype, key_)
59
insert into help_items values (3,'icmpping','Checks if server accessible by ICMP ping 0 - ICMP ping fails 1 - ICMP ping successful One of zabbix_server processes performs ICMP pings once per PingerFrequency seconds.');
60
insert into help_items values (3,'icmppingsec','Return ICMP ping response time Number of seconds Example: 0.02');
61
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');
62
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');
63
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');
64
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');
65
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');
66
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');
67
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');
68
insert into help_items values (3,'tcp,port','Checks if TCP service is running and accepting connections on port 0 - the serivce on the por t is down 1 - the service is running');
69
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 milliseconds spent connecting to FTP server');
70
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 milliseconds spent connecting to HTTP server');
71
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 milliseconds spent connecting to IMAP server');
72
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 milliseconds spent connecting to NNTP server');
73
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');
74
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 milliseconds spent connecting to SMTP server');
75
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 milliseconds spent connecting to SSH server');
77
insert into help_items values (5,'zabbix[history]','Number of values stored in table HISTORY');
78
insert into help_items values (5,'zabbix[history_str]','Number of values stored in table HISTORY_STR');
79
insert into help_items values (5,'zabbix[items]','Number of items in ZABBIX database');
80
insert into help_items values (5,'zabbix[items_unsupported]','Number of unsupported items in ZABBIX database');
81
insert into help_items values (5,'zabbix[log]','Stores warning and error messages generated by ZABBIX server.');
82
insert into help_items values (5,'zabbix[queue]','Number of items in the queue');
83
insert into help_items values (5,'zabbix[trends]','Number of values stored in table TRENDS');
84
insert into help_items values (5,'zabbix[triggers]','Number of triggers in ZABBIX database');
86
insert into help_items values (8,'grpfunc(<Group>,<Key>,<func>,<param>)','Aggregate checks does not require any agent running on a host being monitored. ZABBIX server collects aggregate information by doing direct database queries. See ZABBIX Manual.');
88
insert into help_items values(0,'agent.ping','Check the agent usability. Always return 1. Can be used as a TCP ping.');
89
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');
90
insert into help_items values(0,'kernel.maxfiles','Maximum number of opened file supported by OS.');
91
insert into help_items values(0,'kernel.maxproc','Maximum number of processes supported by OS.');
92
insert into help_items values(0,'net.if.collisions[if]','Out-of-window collision. Collisions count.');
93
insert into help_items values(0,'net.if.in[if <,mode>]','Network interfice input statistic. Integer value. If mode is missing <b>bytes</b> is used.');
94
insert into help_items values(0,'net.if.out[if <,mode>]','Network interfice output statistic. Integer value. If mode is missing <b>bytes</b> is used.');
95
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.');
96
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.');
97
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]');
98
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].');
99
insert into help_items values(0,'net.tcp.service.perf[service <,ip> <,port>]','Check performance of service server. 0 - service server is down, <sec> - number of seconds spent on connection to the service server. If ip is missing 127.0.0.1 is used. If port number is missing, default service port is used.');
100
insert into help_items values(0,'proc.mem[<name> <,user> <,mode>]','Memory used of process with name name running under user <b>user</b>. Memory used by processes. Process name, user and mode is optional. If name or user is missing all processes will be calculated. If <b>mode</b> is missing <b>sum</b> is used. Examples: proc.mem[,root]');
101
insert into help_items values(0,'proc.num[<name> <,user> <,state>]','Number of processes with name <b>name</b> running under user <b>user</b> having state <b>state</b>. Process name, user and state are optional. Example: proc.num[,root]');
102
insert into help_items values(0,'system.cpu.intr','Device interrupts.');
103
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 <b>all</b> is used. If mode is missing <b>avg1</b> is used. Note that this is not percentage.');
104
insert into help_items values(0,'system.cpu.switches','Context switches.');
105
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 <b>all</b> is used. If type is missing <b>user</b> is used. If mode is missing <b>avg1</b> is used.</b>');
106
insert into help_items values(0,'system.hostname','Return host name. String value. Example of returned value: www.zabbix.com');
107
insert into help_items values(0,'system.localtime','System local time. Time in seconds.');
108
insert into help_items values(0,'system.swap.in[<swap> <,type>]','Swap in. If type is <b>count<b> - swapins is returned. If type is <b>pages</b> - pages swapped in is returned. If swap is missing <b>all</b> is used.');
109
insert into help_items values(0,'system.swap.out[<swap> <,type>]','Swap out. If type is <b>count</b> - swapouts is returned. If type is <b>pages</b> - pages swapped in is returned. If swap is missing <b>all</b> is used.');
110
insert into help_items values(0,'system.swap.size[<swap> <,mode>]','Swap space. Number of bytes. If swap is missing <b>all</b> is used. If mode is missing <b>free</b> is used.');
111
insert into help_items values(0,'system.uname','Returns detailed host information. String value');
112
insert into help_items values(0,'system.uptime','System uptime in seconds.');
113
insert into help_items values(0,'system.users.num','Number of users connected. Command <b>who</b> is used on agent side.');
114
insert into help_items values(0,'vfs.dev.read[device <,type> <,mode>]','Device read statistics.');
115
insert into help_items values(0,'vfs.dev.write[device <,type> <,mode>]','Device write statistics.');
116
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]');
117
insert into help_items values(0,'vfs.file.exists[file]','Check file existance. 0 - file does not exists, 1 - file exists');
118
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]');
119
insert into help_items values(0,'vfs.file.regexp[file, user]','');
120
insert into help_items values(0,'vfs.file.regmatch[file, user]','');
121
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]');
122
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 <b>modify</b> is used.');
123
insert into help_items values(0,'vfs.fs.inode[fs <,mode>]','Number of inodes for a given volume. If mode is missing <b>total</b> is used.');
124
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 <b>total</b> is used. In case of mounted volume, unused disk space for local file system is returned. Example: vfs.fs.size[/tmp,free].');
125
insert into help_items values(0,'vm.memory.size[<mode>]','Amount of memory size in bytes. If mode is missing <b>total</b> is used.');