Zabbix Server not able to identify db.

[manu_leo]

Hi Experts,

I installed zabbix server 3.0.4 on my linux box and I am using Mariadb MYSQL as the database. However when I try connecting to its setup page, I get the below error :-

Configuration file error
DB type "MYSQL" is not supported by current setup. Possible values .

Below are the config files for zabbix :-

cat /etc/zabbix/zabbix_server.conf
DBHost=localhost
DBName=abc_db
DBUser=abc_user
DBPassword=abc

cat /etc/zabbix/web/zabbix.conf.php
<?php
// Zabbix GUI configuration file.
global $DB;

$DB['TYPE'] = 'MYSQL';
$DB['SERVER'] = 'localhost';
$DB['PORT'] = '0';
$DB['DATABASE'] = 'abc_db';
$DB['USER'] = 'abc_user';
$DB['PASSWORD'] = 'abc';

// Schema name. Used for IBM DB2 and PostgreSQL.
$DB['SCHEMA'] = '';

$ZBX_SERVER = 'localhost';
$ZBX_SERVER_PORT = '10051';
$ZBX_SERVER_NAME = 'zzzz';

$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;
?>

cat /etc/httpd/conf.d/zabbix.conf
#
# Zabbix monitoring system php web frontend
#

Alias /zabbix /usr/share/zabbix

<Directory "/usr/share/zabbix">
Options FollowSymLinks
AllowOverride None
Require all granted
# Require ip 127.0.0.1 192.168.101.0/24
<IfModule mod_php5.c>
php_value max_execution_time 300
php_value memory_limit 128M
php_value post_max_size 16M
php_value upload_max_filesize 2M
php_value max_input_time 300
php_value always_populate_raw_post_data -1
php_value date.timezone Asia/Kolkata
</IfModule>
</Directory>

<Directory "/usr/share/zabbix/conf">
Require all denied
</Directory>

<Directory "/usr/share/zabbix/include">
Require all denied
</Directory>

And zabbix log when I restart the zabbix services

7155:20160903:204936.240 Got signal [signal:15(SIGTERM),sender_pid:4752,sender_uid:0,re ason:0]. Exiting ...
4756:20160903:204936.251 Starting Zabbix Server. Zabbix 3.0.4 (revision 61185).
4756:20160903:204936.251 ****** Enabled features ******
4756:20160903:204936.251 SNMP monitoring: YES
4756:20160903:204936.251 IPMI monitoring: YES
4756:20160903:204936.251 Web monitoring: YES
4756:20160903:204936.251 VMware monitoring: YES
4756:20160903:204936.251 SMTP authentication: YES
4756:20160903:204936.251 Jabber notifications: YES
4756:20160903:204936.251 Ez Texting notifications: YES
4756:20160903:204936.251 ODBC: YES
4756:20160903:204936.251 SSH2 support: YES
4756:20160903:204936.251 IPv6 support: YES
4756:20160903:204936.251 TLS support: YES
4756:20160903:204936.251 ******************************
4756:20160903:204936.251 using configuration file: /etc/zabbix/zabbix_server.conf
4756:20160903:204936.253 current database version (mandatory/optional): 03000000/03000000
4756:20160903:204936.253 required mandatory version: 03000000
4756:20160903:204936.257 listener failed: zbx_tcp_listen() fatal error: unable to serve on any address [[127.0.0.1]:10051]
zabbix_server [7155]: [file:'dbconfig.c',line:5524] lock failed: [43] Identifier removed
4767:20160903:204946.268 Starting Zabbix Server. Zabbix 3.0.4 (revision 61185).
4767:20160903:204946.268 ****** Enabled features ******
4767:20160903:204946.268 SNMP monitoring: YES
4767:20160903:204946.268 IPMI monitoring: YES
4767:20160903:204946.268 Web monitoring: YES
4767:20160903:204946.268 VMware monitoring: YES
4767:20160903:204946.268 SMTP authentication: YES
4767:20160903:204946.268 Jabber notifications: YES
4767:20160903:204946.268 Ez Texting notifications: YES
4767:20160903:204946.268 ODBC: YES
4767:20160903:204946.268 SSH2 support: YES
4767:20160903:204946.268 IPv6 support: YES
4767:20160903:204946.268 TLS support: YES
4767:20160903:204946.268 ******************************
4767:20160903:204946.268 using configuration file: /etc/zabbix/zabbix_server.conf
4767:20160903:204946.273 current database version (mandatory/optional): 03000000/03000000
4767:20160903:204946.273 required mandatory version: 03000000
4767:20160903:204946.277 server #0 started [main process]
4772:20160903:204946.277 server #1 started [configuration syncer #1]
4773:20160903:204946.278 server #2 started [db watchdog #1]
4774:20160903:204946.278 server #3 started [poller #1]
4776:20160903:204946.278 server #4 started [poller #2]
4777:20160903:204946.278 server #5 started [poller #3]
4778:20160903:204946.278 server #6 started [poller #4]

Please suggest if I am missing something here or doing anything silly. Appreciate all your help and time on this.

Thanks in advance.

[andris]

PHP frontend cannot connect to DB., but Zabbix server starts normally. Could it be that MySQL driver (php5-mysql ?) for PHP is not istalled or configured ? Just a guess.

[tritsako]

Hi Manu-leo,

are the drivers installed? Is mysqld started?

" listener failed: zbx_tcp_listen() fatal error: unable to serve on any address"

For a reason Zabbix cannot communicate with MySQL

Costas

[kloczek]

Hi Manu-leo,

are the drivers installed? Is mysqld started?

" listener failed: zbx_tcp_listen() fatal error: unable to serve on any address"

For a reason Zabbix cannot communicate with MySQL

Usually something like this happend when you still have some zabbix server processes running and listening on 10051/tcp.
Try stop zabbix server abd after this "netstat -tapln | grep 10051" and if you will see any zabbix_server or other processes listening on 10051 just kill the.
Usuall scenarion with above error message happens when someone iis trying to run on the same host server and proxy (both arfe listening on the same port).