Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values .

[anishkvmca]

Installed zabbix-3.0.1.tar.gz successfully on RHEL 6

Zabbiz front end php package configured.

When opening in browser : Configuration file error

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

Mysql is configured properly and all grant privileges added to zabbix.


Below are the dependency package installed

[root@oc2024625308 ~]# rpm -qa | grep php
php-pecl-zip-1.13.2-1.el6.remi.5.5.x86_64
php-5.5.35-1.el6.remi.x86_64
php-common-5.5.35-1.el6.remi.x86_64
php-cli-5.5.35-1.el6.remi.x86_64
php-pecl-jsonc-1.3.9-1.el6.remi.5.5.x86_64
[root@oc2024625308 ~]# rpm -qa | grep mysql
mysql-libs-5.1.73-5.el6_7.1.x86_64
mysql-server-5.1.73-5.el6_7.1.x86_64
mysql-devel-5.1.73-5.el6_7.1.x86_64
mysql-5.1.73-5.el6_7.1.x86_64
[root@oc2024625308 ~]# rpm -qa | grep php
php-pecl-zip-1.13.2-1.el6.remi.5.5.x86_64
php-5.5.35-1.el6.remi.x86_64
php-common-5.5.35-1.el6.remi.x86_64
php-cli-5.5.35-1.el6.remi.x86_64
php-pecl-jsonc-1.3.9-1.el6.remi.5.5.x86_64
[root@oc2024625308 ~]#


Please Advise?

[kloczek]

So .. how did you install zabbix on this box?

[anishkvmca]

Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values

Thank you for the reply.
I've installed Zaabix from source "zabbix-3.0.1.tar.gz" and followed "4 Installation from sources" steps.

I believe Zabbix is running as daemon in backend.

But the problem is only associated with front end PHP and MySQL configuration.

It might be a defect :-)

location of 4 zabbix.conf.php is /var/www/html/zabbix/conf

Also no MYSQL connectivity Errors from zabbix_server.log.

I hope you can help me to figured out

[kloczek]

1st: check zabbix server log do you see in first few lines logged information that this binary has compiled in mysql support.
2nd: as this error message is shown within web frontend and I don't see on the list of your php packages php-mysql probably this is causing your error message.
3rd: on list of installed php packages there is no php-xml so you will be not able ti import/export templates. I don't see php-gd so you will have problems with displaying all graphs/maps.

[anishkvmca]

Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values

Thank you very much.

2. Sure I'll install missing rest of PHP packages.
1. zabbix_server.log

Please advise me how We can re-configure Zabbix with MySQL post installation ?



[root@oc2024625308 logs]# cat /tmp/zabbix_server.log

6198:20160430:075732.146 Starting Zabbix Server. Zabbix 3.0.1 (revision 58734).
6198:20160430:075732.147 ****** Enabled features ******
6198:20160430:075732.147 SNMP monitoring: NO
6198:20160430:075732.148 IPMI monitoring: NO
6198:20160430:075732.149 Web monitoring: YES
6198:20160430:075732.149 VMware monitoring: YES
6198:20160430:075732.150 SMTP authentication: NO
6198:20160430:075732.150 Jabber notifications: NO
6198:20160430:075732.151 Ez Texting notifications: YES
6198:20160430:075732.152 ODBC: NO
6198:20160430:075732.152 SSH2 support: NO
6198:20160430:075732.153 IPv6 support: YES
6198:20160430:075732.154 TLS support: NO
6198:20160430:075732.154 ******************************
6198:20160430:075732.155 using configuration file: /usr/local/etc/zabbix_server.conf
6198:20160430:075732.361 current database version (mandatory/optional): 03000000/03000000
6198:20160430:075732.362 required mandatory version: 03000000
6198:20160430:075732.769 server #0 started [main process]
6206:20160430:075732.772 server #1 started [configuration syncer #1]
6207:20160430:075732.774 server #2 started [db watchdog #1]
6208:20160430:075732.775 server #3 started [poller #1]
6209:20160430:075732.778 server #4 started [poller #2]
6210:20160430:075732.779 server #5 started [poller #3]
6211:20160430:075732.781 server #6 started [poller #4]
6212:20160430:075732.782 server #7 started [poller #5]
6213:20160430:075732.784 server #8 started [unreachable poller #1]
6214:20160430:075732.786 server #9 started [trapper #1]

[anishkvmca]

Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values

Dear team,


Please advise me how We can re-configure Zabbix with MySQL post installation ?

[kloczek]

Looking on logs it looks like zabbix server is without any db backend.
Could you please show output of "ldd zabbix_server"?

[anishkvmca]

Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values

5262:20160502:205224.028 server #10 started [trapper #2]
5263:20160502:205224.028 server #11 started [trapper #3]
5264:20160502:205224.029 server #12 started [trapper #4]
5265:20160502:205224.030 server #13 started [trapper #5]
5266:20160502:205224.031 server #14 started [icmp pinger #1]
5267:20160502:205224.031 server #15 started [alerter #1]
5268:20160502:205224.032 server #16 started [housekeeper #1]
5269:20160502:205224.033 server #17 started [timer #1]
5270:20160502:205224.033 server #18 started [http poller #1]
5271:20160502:205224.034 server #19 started [discoverer #1]
5273:20160502:205224.035 server #20 started [history syncer #1]
5274:20160502:205224.035 server #21 started [history syncer #2]
5275:20160502:205224.036 server #22 started [history syncer #3]
5276:20160502:205224.037 server #23 started [history syncer #4]
5277:20160502:205224.038 server #24 started [escalator #1]
5278:20160502:205224.038 server #25 started [proxy poller #1]
5279:20160502:205224.039 server #26 started [self-monitoring #1]
zabbix_server [5797]: Is this process already running? Could not lock PID file [/tmp/zabbix_server.pid]: [11] Resource temporarily unavailable


[root@oc2024625308 ~]# locate zabbix_server.pid
[root@oc2024625308 ~]# ldd zabbix_server
ldd: ./zabbix_server: No such file or directory



[root@oc2024625308 ~]# ps -ef | grep zabbix
zabbix 5245 1 0 20:52 ? 00:00:00 zabbix_server
zabbix 5253 5245 0 20:52 ? 00:00:00 zabbix_server: configuration syncer [synced configuration in 0.007337 sec, idle 60 sec]
zabbix 5254 5245 0 20:52 ? 00:00:00 zabbix_server: db watchdog [synced alerts config in 0.005359 sec, idle 60 sec]
zabbix 5255 5245 0 20:52 ? 00:00:00 zabbix_server: poller #1 [got 0 values in 0.000009 sec, idle 5 sec]
zabbix 5256 5245 0 20:52 ? 00:00:00 zabbix_server: poller #2 [got 0 values in 0.000009 sec, idle 5 sec]
zabbix 5257 5245 0 20:52 ? 00:00:00 zabbix_server: poller #3 [got 0 values in 0.000014 sec, idle 5 sec]
zabbix 5258 5245 0 20:52 ? 00:00:00 zabbix_server: poller #4 [got 0 values in 0.000016 sec, idle 5 sec]
zabbix 5259 5245 0 20:52 ? 00:00:00 zabbix_server: poller #5 [got 0 values in 0.000036 sec, idle 5 sec]
zabbix 5260 5245 0 20:52 ? 00:00:00 zabbix_server: unreachable poller #1 [got 0 values in 0.000008 sec, idle 5 sec]
zabbix 5261 5245 0 20:52 ? 00:00:00 zabbix_server: trapper #1 [processed data in 0.000000 sec, waiting for connection]
zabbix 5262 5245 0 20:52 ? 00:00:00 zabbix_server: trapper #2 [processed data in 0.000000 sec, waiting for connection]
zabbix 5263 5245 0 20:52 ? 00:00:00 zabbix_server: trapper #3 [processed data in 0.000000 sec, waiting for connection]
zabbix 5264 5245 0 20:52 ? 00:00:00 zabbix_server: trapper #4 [processed data in 0.000000 sec, waiting for connection]
zabbix 5265 5245 0 20:52 ? 00:00:00 zabbix_server: trapper #5 [processed data in 0.000000 sec, waiting for connection]
zabbix 5266 5245 0 20:52 ? 00:00:00 zabbix_server: icmp pinger #1 [got 0 values in 0.000006 sec, idle 5 sec]
zabbix 5267 5245 0 20:52 ? 00:00:00 zabbix_server: alerter [sent alerts: 0 success, 0 fail in 0.000571 sec, idle 30 sec]
zabbix 5268 5245 0 20:52 ? 00:00:00 zabbix_server: housekeeper [startup idle for 30 minutes]
zabbix 5269 5245 0 20:52 ? 00:00:00 zabbix_server: timer #1 [processed 0 triggers, 0 events in 0.000020 sec, 0 maintenances in 0.000989 sec, idle 30 sec]
zabbix 5270 5245 0 20:52 ? 00:00:00 zabbix_server: http poller #1 [got 0 values in 0.000798 sec, idle 5 sec]
zabbix 5271 5245 0 20:52 ? 00:00:00 zabbix_server: discoverer #1 [processed 0 rules in 0.000630 sec, idle 60 sec]
zabbix 5273 5245 0 20:52 ? 00:00:00 zabbix_server: history syncer #1 [synced 0 items in 0.000002 sec, idle 1 sec]
zabbix 5274 5245 0 20:52 ? 00:00:00 zabbix_server: history syncer #2 [synced 0 items in 0.000003 sec, idle 1 sec]
zabbix 5275 5245 0 20:52 ? 00:00:00 zabbix_server: history syncer #3 [synced 0 items in 0.000001 sec, idle 1 sec]
zabbix 5276 5245 0 20:52 ? 00:00:00 zabbix_server: history syncer #4 [synced 0 items in 0.000002 sec, idle 1 sec]
zabbix 5277 5245 0 20:52 ? 00:00:00 zabbix_server: escalator #1 [processed 0 escalations in 0.001293 sec, idle 3 sec]
zabbix 5278 5245 0 20:52 ? 00:00:00 zabbix_server: proxy poller #1 [exchanged data with 0 proxies in 0.000012 sec, idle 5 sec]
zabbix 5279 5245 0 20:52 ? 00:00:00 zabbix_server: self-monitoring [processed data in 0.000060 sec, idle 1 sec]
root 6086 4970 0 21:01 pts/0 00:00:00 grep zabbix
[root@oc2024625308 ~]#

[root@oc2024625308 ~]# ldd zabbix_server
ldd: ./zabbix_server: No such file or directory
[root@oc2024625308 ~]#

[kloczek]

You are starting already somehow zabbix_server process .. over systemd, initscripts or even manually so you should know where zabbix_server binary is installed in your system

[anishkvmca]

Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values

[root@oc2024625308 sbin]# pwd
/usr/local/sbin

[root@oc2024625308 sbin]# ls -lrt zabbix_server
-rwxr-xr-x. 1 root root 3821179 Apr 27 21:46 zabbix_server

[root@oc2024625308 sbin]# ldd zabbix_server
linux-vdso.so.1 => (0x00007fffb11d5000)
libmysqlclient.so.16 => /usr/lib64/mysql/libmysqlclient.so.16 (0x0000003ed1e00000)
libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x0000003c83400000)
libcurl.so.4 => /usr/lib64/libcurl.so.4 (0x00000036f4e00000)
libm.so.6 => /lib64/libm.so.6 (0x0000003c7bc00000)
libdl.so.2 => /lib64/libdl.so.2 (0x0000003c7c400000)
librt.so.1 => /lib64/librt.so.1 (0x0000003c7c800000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x0000003c7d800000)
libc.so.6 => /lib64/libc.so.6 (0x0000003c7b800000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000003c87800000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x0000003c8d800000)
libssl.so.10 => /usr/lib64/libssl.so.10 (0x0000003286400000)
libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x0000003c0b400000)
libz.so.1 => /lib64/libz.so.1 (0x0000003c7cc00000)
libidn.so.11 => /lib64/libidn.so.11 (0x0000003c91000000)
libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00000036f4a00000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x0000003285400000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x0000003285c00000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x0000003285800000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x0000003c88400000)
libssl3.so => /usr/lib64/libssl3.so (0x00000036f3e00000)
libsmime3.so => /usr/lib64/libsmime3.so (0x00000036f4200000)
libnss3.so => /usr/lib64/libnss3.so (0x00000036f3600000)
libnssutil3.so => /usr/lib64/libnssutil3.so (0x00000036f3a00000)
libplds4.so => /lib64/libplds4.so (0x00000036f2e00000)
libplc4.so => /lib64/libplc4.so (0x00000036f2a00000)
libnspr4.so => /lib64/libnspr4.so (0x00000036f3200000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003c7c000000)
libssh2.so.1 => /usr/lib64/libssh2.so.1 (0x0000003286c00000)
/lib64/ld-linux-x86-64.so.2 (0x0000003c7b400000)
libfreebl3.so => /lib64/libfreebl3.so (0x0000003c87c00000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00000036f4600000)
libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003c8f400000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x0000003286000000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x0000003c8b400000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x0000003c7d400000)
[root@oc2024625308 sbin]#

[anishkvmca]

Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values

Please review ldd output thanks

[anishkvmca]

I've installed same Zabbix version 3.0 in CentOS6.7 box also with Mysql 5.6 and PHP 5.5.

There also getting same Error " Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values" while opening from browser localhost/zabbix

For debugging purpose I've removed /etc/httpd/html/zabbix/conf/zabbix.conf removed and then loading setup page. But in zabbix setup page "PHP Database Support" for MySQL is "failed" status.

Rest of all dependencies are passing successfully and only issue with this MySQL.

/tmp/zabbix_server.log also free from errors.

Someone from Zabbix please advise Why zabbix is mess sup with MySQL ?

[kloczek]

I've installed same Zabbix version 3.0 in CentOS6.7 box also with Mysql 5.6 and PHP 5.5.

There also getting same Error " Zabbix 3.0 DB type "MYSQL" is not supported by current setup. Possible values" while opening from browser localhost/zabbix

For debugging purpose I've removed /etc/httpd/html/zabbix/conf/zabbix.conf removed and then loading setup page. But in zabbix setup page "PHP Database Support" for MySQL is "failed" status.

Rest of all dependencies are passing successfully and only issue with this MySQL.

/tmp/zabbix_server.log also free from errors.

Someone from Zabbix please advise Why zabbix is mess sup with MySQL ?

Above has nothing to do with zabbix server so checking zabbix_server.log is pointless.
If you have installed php with proper set of extensions installed on checking phpinfo() over command like

$ php -r "phpinfo();" 2>/dev/null | egrep -i ^mysql | grep Support

You should see in output:

MySQL Support => enabled
MysqlI Support => enabled

[anishkvmca]

Thank you very much for your valuable guidelines and resolved the issue.

I've installed all PHP packages and reinstalled again.

That errors resolved and new error from cat /etc/httpd/logs/error_log :


[Fri May 06 16:20:49 2016] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Fri May 06 16:20:49 2016] [notice] Digest: generating secret for digest authentication ...
[Fri May 06 16:20:49 2016] [notice] Digest: done
[Fri May 06 16:20:49 2016] [notice] Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 configured -- resuming normal operations
[Fri May 06 16:20:52 2016] [error] [client 127.0.0.1] PHP Parse error: syntax error, unexpected '[' in /var/www/html/zabbix/index.php on line 29
[Fri May 06 16:20:53 2016] [error] [client 127.0.0.1] PHP Parse error: syntax error, unexpected '[' in /var/www/html/zabbix/index.php on line 29


Please advise ?

[Atsushi]

PHP 5.4 or later is required for Zabbix 3.0 frontend.
PHP 5.3.3 does not work with.

https://www.zabbix.com/documentation/3.0/manual/installation/requirements#software