Sophos Zabbix

Zabbix Sophos Xg Firewall
Zabbix Sophos Xg
Zabbix Sophos Xg Interfaces

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

How to configure

Configure on Ubuntu Server (MySQL)

SNMP (Simple Network Management Protocol) allows you to configure Sophos XG Firewall as an SNMP agent. The device responds to multiple SNMP managers within the predefined communities. You can monitor multiple firewall devices on IP networks for device availability, CPU, memory and disk utilization, availability of critical services, and more. 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.

Create user monitoring to manage MySQL

Zabbix version (it should work on 2.2. as well, but not tested). Check on Sophos KB how to enable it on SG or XG appliances.
Zabbix Discussions and Feedback; Zabbix Help; If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to REGISTER before you can post. To start viewing messages, select the forum that you want to visit from the selection below.

</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><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><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

Choose template Template DB MySQL

Check that the MySQL monitoring service on zabbix is working

Overview

The article is tutorial that configures DELL server parameters monitoring tools via iDRAC using SNMP protocol on Zabbix

Diagram

The article is configured according to the following diagram:

How to configure

Configure on DELL Server

On iDRAC Settings -> Choose Network -> Choose Services -> On SNMP Community Name: Enter key connection between Zabbix server and DELL server

Configure on Zabbix Server

Zabbix Sophos Xg Firewall

Install tool on Zabbix Server and check Zabbix Server is retrieving the server data

yum install net-snmp net-snmp-utils -y
snmpwalk -v2c -c public 172.16.4.151

Zabbix Sophos Xg

Access web interface of Zabbix Server

On Configuration -> Click Hosts -> Click Create host

In Host name: Enter hostname
In Groups: Choose Linux servers
In SNMP Interfaces: Enter IP of DELL Server

In Templates -> Choose Template OS Linux SNMPv2 -> Click Add

On Macros -> Enter {$SNMP_COMMUNITY} => public (public is key on iDRAC)

Zabbix Sophos Xg Interfaces

Add host successfully and check the result