Zabbix
Maintenance
Query most triggered items
SELECT DISTINCT `history_uint`.`itemid`, count(`history_uint`.`itemid`) AS CountOf, `items`.`itemid`, `items`.`name` FROM `history_uint` LEFT JOIN `items` ON `history_uint`.`itemid` = `items`.`itemid` GROUP BY `history_uint`.`itemid` ORDER BY CountOf DESC
Configuration
Host name
{psl}.{ber|dus}.{ns125|rds26}.{vh|hh|fb|hh|...}.{ug|eg|1og|...}.{kind e.g. vserver}.{machine name, e.g. pslsrv32}. Example:
psl.dus.ns125.fb.1ug.vserver.pslsrv15
Visible name
{PSL} | {BER|DUS} | {NS125|RDS26} | {VH|HH|FB|HH|...} | {UG|EG|1OG|...} | {kind e.g. vServer} | {machine name, e.g. PSLSRV15} ({Short Description}). Example:
PSL | DUS | NS125 | FB | 1UG | vServer | PSLSRV15 (Preview Webserver)
Hostgroups
- By Kind, e.g. "#Apache2 Webservers"
- By Logical Group, e.g. "*Parasol OS", "*ANM"
- By Purpose, e.g. "Storage Units", "Rendernodes"
- By Availability Level, e.g. "_Mission Critical 24/7"
Templates
#OS Linux (Template)
Monitoring System Health (Filesystem, CPU, ...) of Linux Servers. Needs Zabbix Agent installed.
##HTTPS Webserver (Template Group)
Links the following Temapltes:
#Google PageSpeed Insights API for Websites (Template)
Google PageSpeed Metrics for the GUI. Uses {$HOSTURL}
#HTTPS Service (Template)
TLS Health.
#ICMP Ping (Template)
Availability.
Monitoring
- Install Zabbix Agent.
- Make sure, 10050/tcp is open (Testen mit 'nc -zvw3 35.234.72.203 10050')
- Make sure, the my.cnf is .my.cnf
SQL
https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql
CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '{PASSWORD}';
GRANT USAGE,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%';
Use Client templates from /etc/zabbix/zabbix_agentd.d
Apache2
https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/app/apache_agent
Require ip 37.201.227.143
Snippets
RegEx Replace Text Output to Int
https://www.schatenseite.de/2018/04/05/zabbix-item-preprocessing-und-regular-expressions/
(.*) > \1:Off=0:On=1 (On|Off)(?=.*:\1=(\d)) > \2