Would you like to learn how to do a Zabbix TimescaleDB installation on Ubuntu Linux? In this tutorial, we are going to show you how to install, configure and access Zabbix 4.2  on a computer running Ubuntu Linux.

• Ubuntu version: 18.04

What is Timescaledb?

TimescaleDB is an open-source time-series database.

TimescaleDB databases are optimized for fast ingest and complex queries

Zabbix Playlist:

On this page, we offer quick access to a list of videos related to Zabbix installation.

Don't forget to subscribe to our youtube channel named FKIT.

Tutorial - Zabbix TimeScaleDB Database Instalaltion

Use the following commands to set the correct timezone.

# dpkg-reconfigure tzdata

Add the PostgreSQL APT repository to Ubuntu Linux.

# apt-get install software-properties-common
# apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B97B0AFCAA1A47F044F244A07FCC7D46ACCC4CF8
# add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -c -s`-pgdg main"

Add the Timescaledb APT repository to Ubuntu Linux.

# add-apt-repository ppa:timescale/timescaledb-ppa
# apt-get update

Install PostgreSQL with TimescaleDB support.

# apt-get install timescaledb-postgresql-11

Use the following command to enable the TimescaleDB extension on PostgreSQL.

You should answer yes for all the questions.

# timescaledb-tune

Use the following command to restart the PostgreSQL service.

# service postgresql restart

You finished the TimescaleDB installation.

Tutorial - Zabbix TimescaleDB Configuration

Now, we can proceed to the Zabbix database configuration.

On the Linux console, use the following commands to create a Linux account to the Zabbix service.

# groupadd zabbix
# useradd -g zabbix -s /bin/bash zabbix

Use the following command to create a PostgreSQL user account named Zabbix.

# sudo -u postgres createuser --pwprompt zabbix

Create a PostgreSQL database named Zabbix and set the owner as the Zabbix user.

# cd /tmp
# sudo -u postgres createdb -O zabbix -E Unicode -T template0 zabbix

On the Linux console, use the following commands to download the Zabbix installation package.

# mkdir /downloads
# cd /downloads
# wget https://ufpr.dl.sourceforge.net/project/zabbix/ZABBIX%20Latest%20Stable/4.2.0/zabbix-4.2.0.tar.gz

Now, we need to import Zabbix database template inside PostgreSQL.

Extract the Zabbix installation package and import the database template inside PostgreSQL.

The system will request the password of the Zabbix PostgreSQL user every time you try to import a file.

# tar -zxvf zabbix-4.2.0.tar.gz
# cd zabbix-4.2.0/database/postgresql
# sudo -u zabbix psql zabbix < schema.sql
# sudo -u zabbix psql zabbix < images.sql
# sudo -u zabbix psql zabbix < data.sql

Use the following command to enable TimescaleDB on the Zabbix database.

# echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix

Restart the PostgreSQL service.

# service postgresql restart

You have finished the Zabbix database installation.

You have imported the Zabbix database templates on the TimescaleDB Server.

Tutorial - Zabbix Apache Installation

Next, we need to install the Apache web server and all the required software.

On the Linux console, use the following commands to install the required packages.

# apt-get install apache2 php libapache2-mod-php php-cli
# apt-get install php-mysql php-mbstring php-gd php-xml
# apt-get install php-bcmath php-ldap php-pgsql

Now, you should find the location of the php.ini file on your system.

After finding, you need to edit the php.ini file.

# updatedb
# locate php.ini
# vi /etc/php/7.2/apache2/php.ini

Keep in mind that your PHP version and the location of the file may not be the same of mine.

Here is the original file, before our configuration.

max_execution_time = 30
memory_limit = 128M
post_max_size = 8M
max_input_time = 60
; date.timezone =

Here is the new file with our configuration.

max_execution_time = 300
memory_limit = 256M
post_max_size = 32M
max_input_time = 300
date.timezone = America/Sao_Paulo

Keep in mind that you have to set your PHP timezone.

In our example, we used the timezone America/Sao_Paulo

You should also restart apache manually and verify the service status.

# service apache2 restart

You have finished the Zabbix server installation.

Tutorial - Zabbix Installation on Ubuntu

Now, we need to install the Zabbix server on Ubuntu Linux.

On the Linux console, use the following commands to install the required packages.

# apt-get update
# apt-get install build-essential libmysqlclient-dev libssl-dev libsnmp-dev libevent-dev
# apt-get install libopenipmi-dev libcurl4-openssl-dev libxml2-dev libssh2-1-dev libpcre3-dev
# apt-get install libldap2-dev libiksemel-dev libcurl4-openssl-dev libgnutls28-dev

On the Linux console, use the following commands to access the Zabbix package folder.

# cd /downloads/zabbix-4.2.0

Compile and install the Zabbix server using the following commands:

# ./configure --enable-server --enable-agent --with-postgresql --with-openssl --with-net-snmp --with-openipmi --with-libcurl --with-libxml2 --with-ssh2 --with-ldap
# make
# make install

Now, you should find the location of the zabbix_server.conf file on your system.

After finding, you need to edit the zabbix_server.conf file.

# updatedb
# locate zabbix_server.conf
# vi /usr/local/etc/zabbix_server.conf

Here is the original file, before our configuration.

LogFile=/tmp/zabbix_server.log
DBName=zabbix
DBUser=zabbix
Timeout=4
LogSlowQueries=3000

Here is the new file with our configuration.

LogFile=/tmp/zabbix_server.log
DBHost=localhost
DBName=zabbix
DBUser=zabbix
DBPassword=kamisama123
Timeout=4

After finishing the configuration, use the following command to start the Zabbix server:

# /usr/local/sbin/zabbix_server

After finishing the configuration, use the following command to start the Zabbix Agent:

# /usr/local/sbin/zabbix_agentd

The Zabbix installation package comes with a service startup script.

If you want, copy the startup script using the commands below.

# cd /downloads/zabbix-4.2.0/
# cp misc/init.d/debian/* /etc/init.d/

You can now use the following commands to start the Zabbix server service.

# /etc/init.d/zabbix-server start

You can now use the following commands to start the Zabbix agent service.

# /etc/init.d/zabbix-agent start

Move all the Zabbix frontend files to the root directory of your Apache installation.

Set the correct file permission on all moved files.

# cd /downloads/zabbix-4.2.0/frontends
# mkdir /var/www/html/zabbix
# mv php/* /var/www/html/zabbix
# chown www-data.www-data /var/www/html/zabbix/* -R

Restart the Apache service.

# service apache2 restart

Open your browser and enter the IP address of your web server plus /zabbix.

In our example, the following URL was entered in the Browser:

• http://35.162.85.57/zabbix

The Zabbix web installation interface should be presented.

Click on the Next button.

Zabbix 4 installation

On the next screen, you will have to check if all the requirements were achieved.

Click on the Next button.

zabbix requirements

Enter the Database information required to connect to the Zabbix database.

• Host: localhost
• Database Username: zabbix
• Database Password: kamisama123

On the next screen, you just have to click on the Next button.

zabbix agent

Take a look at the configuration summary and click on the Next button.

zabbix installation

Finally, you will be presented with the Zabbix login screen.

• Zabbix default username:  Admin
• Zabbix default Password: zabbix

zabbix login

After a successful login, you will be sent to the Zabbix Dashboard.

Zabbix 4 Dashboard

Congratulations, you have installed the Zabbix system on Ubuntu Linux.

Now, we need to enable the Zabbix server to monitor itself.

On the Zabbix dashboard, access the Configuration menu and select the Host option.

zabbix add host

On the top right of the screen, select the option named: Zabbix servers

Zabbix server host

Locate the host named Zabbix server and click on the word DISABLED.

This will enable the Zabbix server to monitor itself.

zabbix host disabled

The Zabbix server status will turn from DISABLED to ENABLED.

Congratulations! The Zabbix server installation was finished successfully.