Zabbix Server 4.0

Debian - Repositorios

https://repo.zabbix.com/zabbix/4.0/debian/pool/main/z/zabbix-release/

* Debian 10.0
wget https://repo.zabbix.com/zabbix/4.0/debian/pool/main/z/zabbix-release/zabbix-release_4.0-3%2Bbuster_all.deb

Install Zabbix server, frontend, agent

* Apache/MySQL
apt install zabbix-server-mysql zabbix-frontend-php

* Apache/PostgreSQL
apt install zabbix-server-pgsql zabbix-frontend-php php7.3-pgsql

Create initial database

Root password mysql

-centos
service mysqld stop
-debian
service mysql stop
mysqld_safe --skip-grant-tables &
mysql
UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';
FLUSH PRIVILEGES; exit;
mysqladmin -u root -p shutdown
-centos
service mysqld start
-debian
service mysql start 

Mysql

mysql -uroot -p
password
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';
mysql> quit;
-----
Bug: ERROR 1118 (42000) at line 1278: Row size too large (> 8126) 
SET SESSION innodb_strict_mode=OFF;
SET SESSION innodb_strict_mode=ON;
-----
zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbix

PostgreSQL

su - postgres
 createuser --pwprompt zabbix
 createdb -O zabbix zabbix
 
 zcat /usr/share/doc/zabbix-server-pgsql/create.sql.gz | psql -U zabbix zabbix

Configure the database for Zabbix server

vim /etc/zabbix/zabbix_server.conf
DBPassword=zabbix

Configure PHP for Zabbix frontend

vim /etc/apache2/conf-available/zabbix.conf
php_value date.timezone America/Sao_Paulo

Start Zabbix server

systemctl restart zabbix-server apache2
systemctl enable zabbix-server apache2

CentOS - Repositorios

https://repo.zabbix.com/zabbix/4.0/rhel/8/x86_64/

* CentOS 8.0
rpm -Uvh https://repo.zabbix.com/zabbix/4.0/rhel/8/x86_64/zabbix-release-4.0-2.el8.noarch.rpm
dnf clean all

Install Zabbix server, frontend, agent

* Apache/MySQL
dnf install zabbix40-server-mysql zabbix40-web-mysql

* Apache/PostgreSQL
dnf install zabbix-server-pgsql zabbix-web-pgsql 

Create initial database

* MySQL
mysql -uroot -p
password
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';
mysql> quit;
zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix

* PostgreSQL
postgres createuser --pwprompt zabbix
postgres createdb -O zabbix zabbix
zcat /usr/share/doc/zabbix-server-pgsql*/create.sql.gz | sudo -u zabbix psql zabbix

Configure the database for Zabbix server

vim /etc/zabbix/zabbix_server.conf
DBPassword=password

Configure PHP for Zabbix frontend

vim /etc/php-fpm.d/zabbix.conf
php_value date.timezone America/Sao_Paulo

Start Zabbix server

systemctl restart zabbix-server httpd php-fpm
systemctl enable zabbix-server httpd php-fpm