Zabbix

Add Host

Test: zabbix_get -s <IP / DNS> -p 10050 -k "agent.ping"

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"

Monitoring

• Install Zabbix Agent
  • https://www.zabbix.com/documentation/current/manual/installation/upgrade/packages/debian_ubuntu
  • Make sure, 10050/tcp is open (Testen mit 'nc -zvw3 zabbix 10050')
  • configure "/etc/zabbix/zabbix_agent2.conf"
    • Server=zabbix
    • ServerActive=zabbix
    • Hostname={Hostname configured in Zabbix Server}
• service zabbix-agent2 restart

SQL

Source: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mysql_agent2

On the Host (Zabbix Agent installed)

• mysql

<syntaxhighlight lang="mysql"> CREATE USER 'zbx_monitor'@'%' IDENTIFIED BY '<password>'; GRANT USAGE,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO 'zbx_monitor'@'%'; </syntaxhighlight>

• configure "/etc/zabbix/zabbix_agent2.conf"
  • Plugins.Mysql.Sessions.mysql01.Uri=unix:/var/run/mysqld/mysqld.sock
  • Plugins.Mysql.Sessions.mysql01.User=zbx_monitor
  • Plugins.Mysql.Sessions.mysql01.Password=b1RhaAh43ZALR
• service zabbix-agent2 restart

In Zabbix

• Marco: {$MYSQL.DSN} = mysql01

Apache2

Source: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/app/apache_agent

On the Host (Zabbix Agent installed)

1. a2enmod status
2. Create "/etc/apache2/conf-available/zabbix.conf", e.g. "nano /etc/apache2/conf-available/zabbix.conf"

<syntaxhighlight lang="apache"> <Location "/server-status">

 SetHandler server-status

 Require host localhost
 Require ip 127.0.0.1
 Require ip 192.168
 Require ip 10

</Location> </syntaxhighlight>

1. a2enconf zabbix
2. service apache2 restart

In Zabbix

1. Enable Template: "Template App Apache by Zabbix agent"

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

Error creating thumbnail: File missing