1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
|
--
-- Data for table config
--
insert into config (smtp_server,smtp_helo,smtp_email) values ('localhost','localhost','zabbix@localhost');
--
-- Data for table groups
--
insert into groups (groupid,name) values (1,'Administrators');
insert into groups (groupid,name) values (2,'Zabbix user');
--
-- Data for table users
--
insert into users (userid,groupid,alias,name,surname,passwd) values (1,1,'Admin','Zabbix','Administrator','d41d8cd98f00b204e9800998ecf8427e');
--
-- Data for table items_template
--
insert into items_template (itemtemplateid,description,key_,delay)
values (1,'Free memory','memory[free]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (2,'Free disk space on /','diskfree[/]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (3,'Free disk space on /tmp','diskfree[/tmp]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (4,'Free disk space on /usr','diskfree[/usr]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (5,'Free number of inodes on /','inodefree[/]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (6,'Free number of inodes on /opt','inodefree[/opt]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (7,'Free number of inodes on /tmp','inodefree[/tmp]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (8,'Free number of inodes on /usr','inodefree[/usr]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (9,'Number of processes','system[proccount]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (10,'Processor load','system[procload]', 5);
insert into items_template (itemtemplateid,description,key_,delay)
values (11,'Processor load5','system[procload5]', 10);
insert into items_template (itemtemplateid,description,key_,delay)
values (12,'Processor load15','system[procload15]', 20);
insert into items_template (itemtemplateid,description,key_,delay)
values (13,'Number of running processes','system[procrunning]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (14,'Free swap space (Kb)','swap[free]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (16,'Size of /var/log/syslog','filesize[/var/log/syslog]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (17,'Number of users connected','system[users]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (18,'Number of established TCP connections','tcp_count', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (19,'Checksum of /etc/inetd.conf','cksum[/etc/inetd_conf]', 600);
insert into items_template (itemtemplateid,description,key_,delay)
values (20,'Checksum of /vmlinuz','cksum[/vmlinuz]', 600);
insert into items_template (itemtemplateid,description,key_,delay)
values (21,'Checksum of /etc/passwd','cksum[/etc/passwd]', 600);
insert into items_template (itemtemplateid,description,key_,delay)
values (22,'Ping to the server (TCP)','ping', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (23,'Free disk space on /home','diskfree[/home]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (24,'Free number of inodes on /home','inodefree[/home]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (25,'Free disk space on /var','diskfree[/var]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (26,'Free disk space on /opt','diskfree[/opt]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (27,'Host uptime (in sec)','system[uptime]', 300);
insert into items_template (itemtemplateid,description,key_,delay)
values (28,'Total memory (kB)','memory[total]', 1800);
insert into items_template (itemtemplateid,description,key_,delay)
values (29,'Shared memory (kB)','memory[shared]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (30,'Buffers memory (kB)','memory[buffers]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (31,'Cached memory (kB)','memory[cached]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (32,'Total swap space (Kb)','swap[total]', 1800);
--insert into items_template (itemtemplateid,description,key_,delay)
-- values (33,'Amount of memory swapped in from disk (kB/s)','swap[in]', 30);
--insert into items_template (itemtemplateid,description,key_,delay)
-- values (34,'Amount of memory swapped to disk (kB/s)','swap[out]', 30);
--insert into items_template (itemtemplateid,description,key_,delay)
-- values (35,'Blocks sent to a block device (blocks/s)','io[in]', 30);
--insert into items_template (itemtemplateid,description,key_,delay)
-- values (36,'Blocks received from a block device (blocks/s)','io[out]', 30);
--insert into items_template (itemtemplateid,description,key_,delay)
-- values (37,'The number of interrupts per second, including the clock','system[interrupts]', 30);
--insert into items_template (itemtemplateid,description,key_,delay)
-- values (38,'The number of context switches per second','system[switches]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (39,'Email (SMTP) server is running','net[listen_25]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (40,'FTP server is running','net[listen_21]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (41,'SSH server is running','net[listen_22]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (42,'Telnet server is running','net[listen_23]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (43,'WEB server is running','net[listen_80]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (44,'POP3 server is running','net[listen_110]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (45,'IMAP server is running','net[listen_143]', 60);
insert into items_template (itemtemplateid,description,key_,delay)
values (46,'Checksum of /usr/sbin/sshd','cksum[/usr/sbin/sshd]', 600);
insert into items_template (itemtemplateid,description,key_,delay)
values (47,'Checksum of /usr/bin/ssh','cksum[/usr/bin/ssh]', 600);
insert into items_template (itemtemplateid,description,key_,delay)
values (48,'Checksum of /etc/services','cksum[/etc/services]', 600);
insert into items_template (itemtemplateid,description,key_,delay)
values (49,'Number of disks read/write operations','io[disk_io]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (50,'Number of disks read operations','io[disk_rio]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (51,'Number of disks write operations','io[disk_wio]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (52,'Number of block read from disks','io[disk_rblk]', 30);
insert into items_template (itemtemplateid,description,key_,delay)
values (53,'Number of block written to disks','io[disk_wblk]', 30);
--
-- Data for table triggers_template
--
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (1,1,'Lack of free memory on server %s','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (2,2,'Low free disk space on %s\'s volume /','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (3,3,'Low free disk space on %s\'s volume /tmp','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (4,4,'Low free disk space on %s\'s volume /usr','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (5,5,'Low number of free inodes on %s\'s volume /','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (6,6,'Low number of free inodes on %s\'s volume /opt','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (7,7,'Low number of free inodes on %s\'s volume /tmp','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (8,8,'Low number of free inodes on %s\'s volume /usr','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (9,9,'Too many processes running on %s','{:.last(0)}>300');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (10,10,'Processor load is too high on %s','{:.last(0)}>5');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (13,13,'Too many processes running on %s','{:.last(0)}>10');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (14,14,'Lack of free swap space on %s','{:.last(0)}<100000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (17,17,'Too may users connected on server %s','{:.last(0)}>50');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (18,18,'Too may established TCP connections on server %s','{:.last(0)}>500');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (19,19,'/etc/inetd.conf has been changed on server %s','{:.diff(0)}>0');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (20,20,'/vmlinuz has been changed on server %s','{:.diff(0)}>0');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (21,21,'/passwd has been changed on server %s','{:.diff(0)}>0');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (23,23,'Low free disk space on %s\'s volume /home','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (24,24,'Low number of free inodes on %s\' volume /home','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (25,25,'Low free disk space on %s\'s volume /var','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (26,26,'Low free disk space on %s\'s volume /opt','{:.last(0)}<10000');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (27,27,'%s have just been restarted','{:.last(0)}<600');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (39,39,'Email (SMTP) server is down on %s','{:.last(0)}<1');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (40,40,'FTP server is down on %s','{:.last(0)}<1');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (41,41,'SSH server is down on %s','{:.last(0)}<1');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (42,42,'Telnet server is down on %s','{:.last(0)}<1');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (43,43,'WEB server is down on %s','{:.last(0)}<1');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (44,44,'POP3 server is down on %s','{:.last(0)}<1');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (45,45,'IMAP server is down on %s','{:.last(0)}<1');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (46,46,'/usr/sbin/sshd has been changed on server %s','{:.diff(0)}>0');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (47,47,'/usr/bin/sshd has been changed on server %s','{:.diff(0)}>0');
insert into triggers_template (triggertemplateid,itemtemplateid,description,expression)
values (48,48,'/etc/services has been changed on server %s','{:.diff(0)}>0');
|
