SOLVED ALT-PHP MySQLi typo3 problems

[Havri]

Hello,

Has anyone encountered errors with MySQLi on TYPO3 installations or any other CMS? We are getting 503 errors if we setup TYPO3 to use the MySQLi driver but it runs just fine if we change the driver to pdo_mysql.

The first solution is to edit the TYPO3 conf file for this to work:

/home/myuser/typo3conf/LocalConfiguration.php

This is a new server running Cloudlinux 7, CageFS, LVE, Alt-PHP, MariaDB 10.2 and Litespeed.

As a second solution, if we change the PHP version from Alt-PHP 7.2 to Multi PHP 7.2 for that domain, it also works.

Just curious if someone that installed the latest OS, packages, etc. has the same errors with MySQLi Alt-PHP extension.

Thank you.

 

[cPanelMichael]

Hello @Havri,

Can you check to verify the mysqli extension is enabled for the individual account as part of the PHP Selector functionality? You can test this with the following command:

selectorctl --user myuser --list-extensions --version=7.2 | grep mysql

Thank you.

 

[Havri]

Hello,

Yes, mysql and mysqli extensions were enabled. After opening a ticket with Cloudlinux, they suggested that I replace mysqli,mysql,pdo_mysql with nd_mysqli,mysqlnd,nd_pdo_mysql. Seems that MariaDB 10.2 needs a different MySQL driver in some situations:

stackoverflow.com/questions/46414868/what-is-the-difference-between-the-nd-pdo-mysql-and-pdo-mysql-extensions

Here is the response from Cloudlinux

You are right about MariaDB 10.2. Native Driver (ND) extensions were developed by different teams actually:
stackoverflow.com/questions/21534468/what-the-different-between-mysql-native-driver-and-mysql-client-library

Thus it is known that Native Driver libraries can resolve certain issues with database access.

This was the case in our typo3 installs but later on we also had some requests on other various CMS'.

Hope this helps someone.