Zabbix Sophos

Posted on  by admin

Zabbix + Sophos. Available solutions. Link Source Compatibility Type, Technology Created Updated Rating; Template Sophos UTM v 9.6. An easy-to-use, fully composable observability stack. Create your free account.

  1. Zabbix Sophos Security
  2. Zabbix Sophos
  3. Zabbix Sophos Antivirus
  4. Zabbix Sophos Antivirus


Zabbix is an open source enterprise software that monitors networks and applications

Zabbix sophos software

It is designed to help network administrators monitor and monitor the status of other network services, servers and network hardware intelligently to ensure the system is always stable

How to configure

Step 1: Install Apache2/httpd

  • Install httpd
  • After installing the httpd service, run the start command to “open” the service and enable the service to “run smoothly”
  • To make sure httpd is running on CentOS, we use the following command: # netstat -plntu

Step 2: Install and configure PHP on CentOS 7

  • Add the webtatic and EPEL repository to the system
  • Install PHP packages from the webtatic repository using yum: # yum -y install mod_php72w php72w-cli php72w-common php72w-devel php72w-pear php72w-gd php72w-mbstring php72w-mysql php72w-xml php72w-bcmath
  • Edit file vi /etc/php.ini
  • Enter i to insert or edit the values
  • You have to make sure that the value fields change do not have the # or the (;) in front
  • After finished running, we will restart the httpd service

Step 3: Install and configure MariaDB

  • Install mariadb-server with the command below
  • After successful installation, you run the command like the above httpd service is “start” and “enable”
  • Configure password for root MariaDB
  • Here we have created MariaDB database and finished configuring the root password for Database
  • Create a database to install Zabbix
  • In this example will create a database called ‘zabbix’

Step 4: Install and configure Zabbix

  • This step is the step of installing and configuring Zabbix (Zabbix-server and Zabbix-agent)
  • Install Zabbix Packages:
  • # yum -y install
  • # yum -y install zabbix-get zabbix-server-mysql zabbix-web-mysql zabbix-agent
  • Enter the path: cd /usr/share/doc/zabbix-server-mysql-…………../
  • The above folder may change depending on your mysql version, it is best to click the zabbix-server tab to point the correct path
  • Import the sample database into the “zabbix” database with the command: # mysql -u root -p zabbix < create.sql
  • Configure Zabbix Server
  • # vi /etc/zabbix/zabbix_server.conf
  • DBHost=localhost
  • DBPassword=password declared for database
  • After start and enable
  • Configure Zabbix Agent
  • # vi /etc/zabbix/zabbix_agentd.conf
  • Declare the values below
  • After start and enable

Zabbix Sophos Security

Zabbix Sophos
  • Install firewall service
  • After start and enable
  • Open http and https ports for Zabbix-server and Zabbix-agent (port 10051 and 10050)

Step 5: Zabbix Initial Setup

  • vi /use/lib/systemd/system/zabbix-server.service
  • Delete the line TimeoutSec=xxxxx
  • Next, run 2 commands
  • Then run 3 commands below
  • Access to web interface’s zabbix server
  • Finish
  • Login with default user ‘admin‘ and password ‘zabbix

** If you have difficulty in configuring Sophos products in Viet Nam, please contact us:

Hotline: 02862711677

Email: [email protected]



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

Zabbix Sophos

Configure on Ubuntu Server (MySQL)

  • Create user monitoring to manage MySQL
# 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-Nawk'{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.
# '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$([[$,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 ''

Zabbix Sophos Antivirus

  • Restart zabbix-agent service

systemctl restart zabbix-agent

Configure on web interface Zabbix Server

Zabbix sophos software
  • Create host on Zabbix Server
  • Choose template Template DB MySQL

Zabbix Sophos Antivirus

  • Check that the MySQL monitoring service on zabbix is ​​working