Zabbix Sophos

Zabbix Sophos Xg Firewall
Zabbix Sophos Red
Zabbix Sophos Software
Zabbix Monitor Sophos Utm

Overview

The article show how to configure MySQL Monitoring on Zabbix. The system consists of Zabbix Server installed on CentOS and MySQL installed on Ubuntu Server

Monitor Sophos XG System with Zabbix / SNMP. Does anyone monitor system metrics on their Sophos XG with Zabbix or something similar? There is built in stuff that monitors some things, but I would also like to see things RAM usage. I just wondered how people are monitoring system metrics with the Sophos XG. I have imported one template under ZABBIX for monitoring my sophos firewall but it does not contain any check for interfaces up / down and it's traffic status. Does anyone has new template (.xml) for zabbix monitoring tool? In Zabbix server 5.0.3 with TSDB I had an issue where for some unknown reason housekeeping (Override history item period and Override trends item period) did not honor the retention Continue Reading Manual clean Zabbix TimescaleDB with dropchunks.

How to configure

Configure on Ubuntu Server (MySQL)

Create user monitoring to manage MySQL

</div><table><tbody><tr><td><div>2</div></td><td><div><span>grant </span><span>usage </span><span>on *</span><span>.</span>*<span>TO</span><span>'monitoring'</span><span>@</span><span>'%'</span><span>indentified </span><span>by</span><span>'zabbix'</span><span>;</span></div></td></tr></tbody></table><ul><li>Declare the newly created user</li></ul><table><tbody><tr><td><div>2</div></td><td><div><span>vi</span>/<span>var</span>/<span>lib</span>/<span>zabbix</span>/<span>.</span><span>my</span><span>.</span><span>cnf</span></div></td></tr></tbody></table><ul><li>Write to the file <strong>.my.cnf</strong> content as follows</li></ul><table><tbody><tr><td><div>2</div></td><td><div><span>user</span>=<span>monitoring</span></div></td></tr></tbody></table><h3 id='zabbix-sophos-xg-firewall'>Zabbix Sophos Xg Firewall</h3><ul><li>Check that <strong>/etc/zabbix/zabbix_agentd.conf</strong> has the following line</li></ul><p><code>Include=/etc/zabbix/zabbix_agentd.d/*.conf</code></p><ul><li>Check in <strong>/etc/zabbix/zabbix_agentd.d</strong> directory with ls command to have <strong>userparameter_mysql.conf</strong> file</li><li>Edit file <strong>userparameter_mysql.conf </strong>with vi with the content as below</li></ul><h3 id='zabbix-sophos-red'>Zabbix Sophos Red</h3><div><textarea wrap='soft' readonly='># For all the following commands HOME should be set to the directory that has .my.cnf file with password information.# Flexible parameter to grab global variables. On the frontend side, use keys like mysql.status[Com_insert].# Key syntax is mysql.status[variable].UserParameter=mysql.status[*],echo 'show global status where Variable_name='$1';' | HOME=/etc/zabbix mysql -N | awk '{print $$2}'# Flexible parameter to determine database or table size. On the frontend side, use keys like mysql.size[zabbix,history,data].# Key syntax is mysql.size[&lt;database&gt;,&lt;table&gt;,&lt;type&gt;].# Database may be a database name or 'all'. Default is 'all'.# Table may be a table name or 'all'. Default is 'all'.# Type may be 'data', 'index', 'free' or 'both'. Both is a sum of data and index. Default is 'both'.# Database is mandatory if a table is specified. Type may be specified always.# Returns value in bytes.# 'sum' on data_length or index_length alone needed when we are getting this information for whole database instead of a single tableUserParameter=mysql.size[*],echo 'select sum($(case '$3' in both|') echo 'data_length+index_length';; data|index) echo '$3_length';; free) echo 'data_free';; esac)) from information_schema.tables$([[$#Default belowUserParameter=mysql.ping,HOME=/etc/zabbix mysqladmin ping | grep -c aliveUserParameter=mysql.uptime,HOME=/etc/zabbix mysqladmin status | cut -f2 -d ':' | cut -f1 -d 'T' | tr -d ' 'UserParameter=mysql.threads,HOME=/etc/zabbix mysqladmin status | cut -f3 -d ':' | cut -f1 -d 'Q' | tr -d ' 'UserParameter=mysql.questions,HOME=/etc/zabbix mysqladmin status | cut -f4 -d ':'|cut -f1 -d 'S' | tr -d ' 'UserParameter=mysql.slowqueries,HOME=/etc/zabbix mysqladmin status | cut -f5 -d ':' | cut -f1 -d 'O' | tr -d ' 'UserParameter=mysql.qps,HOME=/etc/zabbix mysqladmin status | cut -f9 -d ':' | tr -d ' 'UserParameter=mysql.version,mysql -V

# For all the following commands HOME should be set to the directory that has .my.cnf file with password information.

# Flexible parameter to grab global variables. On the frontend side, use keys like mysql.status[Com_insert].

UserParameter=mysql.status[*],echo'show global status where Variable_name='$1';'|HOME=/etc/zabbix mysql-N|awk'{print $$2}'

# Flexible parameter to determine database or table size. On the frontend side, use keys like mysql.size[zabbix,history,data].

# Key syntax is mysql.size[<database>,<table>,<type>].

# Database may be a database name or 'all'. Default is 'all'.

# Table may be a table name or 'all'. Default is 'all'.

# Type may be 'data', 'index', 'free' or 'both'. Both is a sum of data and index. Default is 'both'.

# Database is mandatory if a table is specified. Type may be specified always.

# 'sum' on data_length or index_length alone needed when we are getting this information for whole database instead of a single table

UserParameter=mysql.size[*],echo'select sum($(case '$3' in both|'') echo 'data_length+index_length';; data|index) echo '$3_length';; free) echo 'data_free';; esac)) from information_schema.tables$([[$

UserParameter=mysql.ping,HOME=/etc/zabbix mysqladmin ping | grep -c alive

UserParameter=mysql.uptime,HOME=/etc/zabbix mysqladmin status | cut -f2 -d ':' | cut -f1 -d 'T' | tr -d ''

UserParameter=mysql.threads,HOME=/etc/zabbix mysqladmin status | cut -f3 -d ':' | cut -f1 -d 'Q' | tr -d ''

UserParameter=mysql.questions,HOME=/etc/zabbix mysqladmin status | cut -f4 -d ':'|cut -f1 -d 'S' | tr -d ''

UserParameter=mysql.slowqueries,HOME=/etc/zabbix mysqladmin status | cut -f5 -d ':' | cut -f1 -d 'O' | tr -d ''

UserParameter=mysql.qps,HOME=/etc/zabbix mysqladmin status | cut -f9 -d ':' | tr -d ''

Restart zabbix-agent service

systemctl restart zabbix-agent

Configure on web interface Zabbix Server

Create host on Zabbix Server

Zabbix Sophos Software

Choose template Template DB MySQL

Zabbix Monitor Sophos Utm

Check that the MySQL monitoring service on zabbix is working