ALT-PHP MySQLi typo3 problems

Havri

• January 22, 2019 03:37

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

  • January 23, 2019 20:23

  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.

  0
• 

  Havri

  • January 24, 2019 20:36

  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 [QUOTE]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.

  0

Please sign in to leave a comment.