SOLVED [CloudLinux ALTPHP-524] Alt-php not working after mysql 5.7 upgrade

[Edwin Tjallings]

Today we upgraded one of our cloudlinux 6.9 servers to mysql 5.7 with the mysql/mariadb upgrade option. We do not use mysql governor.

After the upgrade every site with alt-php and mysql stops working. Recompiling easyapache4, yum update, cagefsctl -- reinit and forced cpanel update did not fix it.

Only with the following commands for each alt-php version we use, its fixed.

rm /opt/alt/php70/usr/lib64/php/modules/mysqli.so
ln -s /opt/alt/php70/etc/mysql5.7/mysqli.so /opt/alt/php70/usr/lib64/php/modules/mysqli.so
rm /opt/alt/php70/usr/lib64/php/modules/pdo_mysql.so
ln -s /opt/alt/php70/etc/mysql5.7/pdo_mysql.so /opt/alt/php70/usr/lib64/php/modules/pdo_mysql.so

Question, does this mean that cloudlinux has no build in proces for upgrading to mysql 5.7 without governor installed?

 

[cPanelMichael]

After the upgrade every site with alt-php and mysql stops working.

Hello @Edwin Tjallings,

As I understand, CloudLinux provides the following script to automatically link alt-php to the correct MySQL libraries:

/usr/bin/alt-php-mysql-reconfigure.py

However, if this is not running automatically or working as expected, then it suggests it's possible there's a bug with CloudLinux's software. I see you have opened a support request on their forums at:

Mysql 5.7 upgrade cpanel v70: alt php not working

I'll monitor that support request and update this thread with the outcome.

Thank you.

 

[Edwin Tjallings]

Michael, thanks for you reply. The command you posted was not known by us.

Still waiting for a conclusion from cloudlinux but after running the commands they posted we solved the issue directly after upgrade we fixed the issue very fast. The commands to run:

# /usr/bin/alt-php-mysql-reconfigure.py -v
# rpm -qa |grep -i mysql |grep -v alt

Maybe it can help other people before there is a fix from cloudlinux. We tested more then one server, also cloudlinux centos 7 with latest cpanel 70.48.

 

[cPanelMichael]

Hello @Edwin Tjallings,

I see your support request is still open on their forums. I recommend submitting a ticket directly using the following URL:

Submit a request – CloudLinux

Let us know the ticket number once it's opened and we can track the progress.

Thank you.

 

[Edwin Tjallings]

Support ticket open with cloudlinux id 37566

 

[cPanelMichael]

Hello @Edwin Tjallings,

Thanks for the report. It's now tracked as part of internal case ALTPHP-524 with CloudLinux. I'll monitor the progress of this CloudLinux case and update this thread with more information as it's available. In the meantime, the temporary workaround is to run the following command:

/usr/bin/alt-php-mysql-reconfigure.py

Thank you.

 

[cPanelMichael]

Hello,

To update, CloudLinux published a solution to this issue as part of an Alt-PHP update:

• ALTPHP-524: fixed automatic MySQL libraries reconfiguration when MySQL 5.7 is installed.

Thanks!