[Zabbix FrontEnd] : Error: At least one of MySQL, PostgreSQL, Oracle, SQLite3 or IBM

[Vijaya Raghavan]

Hi All,

Am trying to setup Zabbix and followed instruction for latest zabbix version : 3.0.3.

I followed exactly same steps mentioned in instructions and setup zabbix server /database. When setting up frontend, I get below error in "Check of pre-requisites" page. error is :

At least one of MySQL, PostgreSQL, Oracle, SQLite3 or IBM DB2 should be supported.

I did check php.info + backend, I do have mysql installed.

from backend :

php -m | grep mysql
mysql
mysqlnd

from php.info page :

attached.

Not sure, what am doing wrong.

more info :

php -v
PHP 5.6.23 (cli) (built: Jul 6 2016 09:13:56)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies


mysql> show databases;
--------------
show databases
--------------

+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| zabbix |
+--------------------+
4 rows in set (0.00 sec)


Any help is much appreciated.

[Vijaya Raghavan]

Hi All,

I found the root cause of this issue.

basically i missed mysqli extension. once I reconfigured php with all required extension, this is got resolved and was able to go to next step.

Incase, if anyone come across same issue then solutions would be : check if you have all required php extension.

php configure command :

./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql --with-gd --with-png-dir --with-jpeg-dir --enable-gd-native-ttf --with-freetype-dir --enable-bcmath --enable-ctype --with-php-xml --with-php-session --enable-sockets --enable-mbstring --with-gettext --with-mysqli

PS : above configure command used for Zabbix3.0.3 version.

[zabx_ks]

Hi Vijaya,

Which Linux distribution you have?

And have you installed php-mysql or php5-mysqli ?

zabx_ks

[Atsushi]

In my environment(CentOS 7.2.1511), it was the following results.

# php -m | grep mysql
mysql
mysqli
pdo_mysql
#

The setup process is to check whether the some 'mysqli_*' functions can be used.