Ad Widget

**coudy** · 17-06-2020, 20:56

Any help ?

I have php-mysql installed, so I don't know what is wrong.

**tim.mooney** · 17-06-2020, 21:33

Originally posted by coudy

I had some problem with backend, so I had to manually patch zabbix database

So that part is pretty vague, but it's also possibly relevant for the problem you're facing. When asking for help, you're more likely to get a response if you provide all the information that might be needed to zero in on the problem.

You've said you have php-mysql installed, but the error message you posted (which is coming from ui/include/classes/core/CConfigFile.php only happens if 'getSupportedDatabases()' doesn't include 'MySQL'. Since your error message doesn't also say "Possible values" with some list of possible DB types, you have no supported databases.

Looking at getSupportedDatabases() (ui/include/classes/setup/CFrontendSetup.php), it will only include MySQL in the list if all of these PHP functions are callable:

'mysqli_close', 'mysqli_connect', 'mysqli_connect_error', 'mysqli_error', 'mysqli_fetch_assoc', 'mysqli_free_result', 'mysqli_query', 'mysqli_real_escape_string'

That implies that either your php-mysql isn't actually present or isn't getting loaded or it's missing one or more of these functions.

What happens if you browse to your server's /zabbix/setup.php as if you were going to do a new install of Zabbix, and then review the "Check of pre-requisites"? Does that find MySQL?

**coudy** · 18-06-2020, 20:33

I had some error during upgrade database, so I solved it manually, some columns, indexes etc, didn't exist in tables, so I've created them manually. After that, upgrade finished, and server started.

My version of php-mysql is:

Code:

Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-==============-============-============-=================================
ii php-mysql 2:7.3+69 all MySQL module for PHP [default]

This is output from php version:

When I launch setup.php, I see setup wizard,

but after NEXT STEP, page is blank, and errors 500 in setup.php:

and I've found this in error.log

Code:

2020/06/18 20:34:50 [error] 2723967#2723967: *33884 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught Error: Call to undefined function ctype_digit() in /usr/share/zabbix/include/func.inc.
php:442
Stack trace:
#0 /usr/share/zabbix/include/classes/setup/CFrontendSetup.php(117): str2mem('128M')
#1 /usr/share/zabbix/include/classes/setup/CFrontendSetup.php(62): CFrontendSetup->checkPhpMemoryLimit()
#2 /usr/share/zabbix/include/classes/setup/CSetupWizard.php(168): CFrontendSetup->checkRequirements()
#3 /usr/share/zabbix/include/classes/setup/CSetupWizard.php(150): CSetupWizard->stage1()
#4 /usr/share/zabbix/include/classes/setup/CSetupWizard.php(101): CSetupWizard->getStage()
#5 /usr/share/zabbix/include/classes/html/CTag.php(97): CSetupWizard->bodyToString()
#6 /usr/share/zabbix/include/classes/html/CObject.php(89): CTag->toString(false)
#7 /usr/share/zabbix/include/classes/html/CObject.php(66): unpack_object(Object(CSetupWizard))
#8 /usr/share/zabbix/include/classes/html/CTag.php(117): CObject->addItem(Object(CSetupWizard))
#9 /usr/share/zabbix/include/classes/" while reading response header from upstream, client: 192.168.2.1, server: localhost, request: "POST /zabbix/setup.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/
php/zabbix.sock:", host: "<host>", referrer: "http://<host>/zabbix/setup.php"

**tim.mooney** · 18-06-2020, 21:45

Does Debian separate the PHP ctype code into a separate package? It would probably be called something like 'php-ctype' or similar. If it does, you need to install that too.

**coudy** · 18-06-2020, 22:12

I've checked that. Ctype is in php-commom, and I've that package installed.

Code:

root@nas:~# LC_ALL=C apt-cache search ctype | grep php
php7.3-common - documentation, examples and common module for PHP
php7.4-common - documentation, examples and common module for PHP
php-symfony-polyfill-ctype - Symfony polyfill for ctype functions

root@nas:~# LC_ALL=C apt install php7.3-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
php7.3-common is already the newest version (7.3.15-3).
php7.3-common set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 41 not upgraded.
root@nas:~#

And loaded in modules too

**coudy** · 19-06-2020, 22:20

I've played little with ctype_digit() function, and discovered, that it does not work globally. So I've uninstalled and installed php-common, php7.3-common zabbix-nginx-conf and after that, frontend is working again.

How to close this thread and mark it as solved ?

Ad Widget

Zabbix 5.0.1 > DB type "MYSQL" is not supported by current setup.

Zabbix 5.0.1 > DB type "MYSQL" is not supported by current setup.

Comment

Comment

Comment

Comment

Comment

Comment