Mysql 5.7 upgrade cpanel v70: alt php not working

[wowon01]

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?

[ighertesco]

Hello,

Could you please post the outputs of the following commands:

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

[edwin.tjallings]

After the commands underneath, the issue was fixed. Running these commands after the upgrade fixes the issue.
# /usr/bin/alt-php-mysql-reconfigure.py -v
# rpm -qa |grep -i mysql |grep -v alt

Update the commands do not work for every site and it looks some account are changed to php 7 while they where on 5.6. Im am opening a support request because we want to upgrade almost 60 servers..