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

May 23, 2018
5
0
1
Netherlands
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
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:

Code:
/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.
 
May 23, 2018
5
0
1
Netherlands
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
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:

Code:
/usr/bin/alt-php-mysql-reconfigure.py
Thank you.