Mysql 5.7 upgrade cpanel v70: alt php not working
Forum
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. Edwin Tjallings
  2. Wednesday, 13 June 2018
  3.  Subscribe via email
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?
Rate this post:
  1. 14.06.2018 15:06:18
  2. # 1
Igor Ghertesco Accepted Answer
Posts: 154
Joined: 07.08.2015
0
Votes
Undo
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
  1. 15.06.2018 09:06:31
  2. # 2
Edwin Tjallings Accepted Answer
Posts: 2
Joined: 15.06.2018
0
Votes
Undo
On the server where mysql 5.7 is installed and we manual solved the issue:

/usr/bin/alt-php-mysql-reconfigure.py -v
INFO : installed alt-php versions are
alt-php: ('44', '/opt/alt/php44')
alt-php: ('51', '/opt/alt/php51')
alt-php: ('52', '/opt/alt/php52')
alt-php: ('53', '/opt/alt/php53')
alt-php: ('54', '/opt/alt/php54')
alt-php: ('55', '/opt/alt/php55')
alt-php: ('56', '/opt/alt/php56')
alt-php: ('70', '/opt/alt/php70')
alt-php: ('71', '/opt/alt/php71')
alt-php: ('72', '/opt/alt/php72')
DEBUG : SQL version string is '/usr/bin/mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper'
INFO : available SQL so files are
/usr/lib64/mysql/libmysqlclient.so.20.3.9 (mysql-5.7)
/usr/lib64/mysql/libmysqlclient.so.16.0.0 (mysql-5.1)
/usr/lib64/libmysqlclient.so.15.0.0 (mysql-5.0)
DEBUG : system SQL binary path is /usr/bin/mysql
DEBUG : SQL version string is '/usr/bin/mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper'
DEBUG : system SQL is mysql-5.7
INFO : /opt/alt/php44/usr/lib64/php/modules/mysql.so was reconfigured to /opt/alt/php44/etc/mysql5.7/mysql.so
INFO : /opt/alt/php51/usr/lib64/php/modules/mysql.so was reconfigured to /opt/alt/php51/etc/mysql5.7/mysql.so
INFO : /opt/alt/php51/usr/lib64/php/modules/mysqli.so was reconfigured to /opt/alt/php51/etc/mysql5.7/mysqli.so
INFO : /opt/alt/php51/usr/lib64/php/modules/pdo_mysql.so was reconfigured to /opt/alt/php51/etc/mysql5.7/pdo_mysql.so
INFO : /opt/alt/php52/usr/lib64/php/modules/mysql.so was reconfigured to /opt/alt/php52/etc/mysql5.7/mysql.so
INFO : /opt/alt/php52/usr/lib64/php/modules/mysqli.so was reconfigured to /opt/alt/php52/etc/mysql5.7/mysqli.so
INFO : /opt/alt/php52/usr/lib64/php/modules/pdo_mysql.so was reconfigured to /opt/alt/php52/etc/mysql5.7/pdo_mysql.so
INFO : /opt/alt/php53/usr/lib64/php/modules/mysql.so was reconfigured to /opt/alt/php53/etc/mysql5.7/mysql.so
INFO : /opt/alt/php53/usr/lib64/php/modules/mysqli.so was reconfigured to /opt/alt/php53/etc/mysql5.7/mysqli.so
INFO : /opt/alt/php53/usr/lib64/php/modules/pdo_mysql.so was reconfigured to /opt/alt/php53/etc/mysql5.7/pdo_mysql.so
INFO : /opt/alt/php54/usr/lib64/php/modules/mysql.so was reconfigured to /opt/alt/php54/etc/mysql5.7/mysql.so
INFO : /opt/alt/php54/usr/lib64/php/modules/mysqli.so was reconfigured to /opt/alt/php54/etc/mysql5.7/mysqli.so
INFO : /opt/alt/php54/usr/lib64/php/modules/pdo_mysql.so was reconfigured to /opt/alt/php54/etc/mysql5.7/pdo_mysql.so
INFO : /opt/alt/php55/usr/lib64/php/modules/mysql.so was reconfigured to /opt/alt/php55/etc/mysql5.7/mysql.so
INFO : /opt/alt/php55/usr/lib64/php/modules/mysqli.so was reconfigured to /opt/alt/php55/etc/mysql5.7/mysqli.so
INFO : /opt/alt/php55/usr/lib64/php/modules/pdo_mysql.so was reconfigured to /opt/alt/php55/etc/mysql5.7/pdo_mysql.so
DEBUG : /opt/alt/php56/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php70/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php70/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php71/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php71/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php72/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php72/usr/lib64/php/modules/pdo_mysql.so is already updated

rpm -qa |grep -i mysql |grep -v alt
cpanel-perl-526-MySQL-Diff-0.50-1.cp1170.noarch
ea-php56-php-mysqlnd-5.6.36-1.el6.cloudlinux.1.x86_64
mysql-community-client-5.7.22-1.el6.x86_64
ea-php54-php-mysqlnd-5.4.45-54.el6.cloudlinux.1.x86_64
compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
mysql-community-common-5.7.22-1.el6.x86_64
cpanel-mysql-5.1.73-1.cp1156.x86_64
mysql-community-libs-compat-5.7.22-1.el6.x86_64
ea-php55-php-mysqlnd-5.5.38-37.el6.cloudlinux.1.x86_64
cpanel-mysql-libs-5.1.73-1.cp1156.x86_64
mysql-community-devel-5.7.22-1.el6.x86_64
mysql57-community-release-el6-11.noarch
cpanel-perl-526-DBD-mysql-4.043-1.cp1170.x86_64
mysql-community-server-5.7.22-1.el6.x86_64
mysql-community-libs-5.7.22-1.el6.x86_64

On a other server before upgrade tot mysql 5.7, after upgrade same problem.

/usr/bin/alt-php-mysql-reconfigure.py -v
INFO : installed alt-php versions are
alt-php: ('44', '/opt/alt/php44')
alt-php: ('51', '/opt/alt/php51')
alt-php: ('52', '/opt/alt/php52')
alt-php: ('53', '/opt/alt/php53')
alt-php: ('54', '/opt/alt/php54')
alt-php: ('55', '/opt/alt/php55')
alt-php: ('56', '/opt/alt/php56')
alt-php: ('70', '/opt/alt/php70')
alt-php: ('71', '/opt/alt/php71')
alt-php: ('72', '/opt/alt/php72')
DEBUG : SQL version string is '/usr/bin/mysql Ver 14.14 Distrib 5.6.39, for Linux (x86_64) using EditLine wrapper'
INFO : available SQL so files are
/usr/lib64/libmysqlclient.so.18.1.0 (mysql-5.6)
/usr/lib64/libmysqlclient.so.16.0.0 (mysql-5.1)
/usr/lib64/libmysqlclient.so.15.0.0 (mysql-5.0)
DEBUG : system SQL binary path is /usr/bin/mysql
DEBUG : SQL version string is '/usr/bin/mysql Ver 14.14 Distrib 5.6.39, for Linux (x86_64) using EditLine wrapper'
DEBUG : system SQL is mysql-5.6
DEBUG : /opt/alt/php44/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php51/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php51/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php51/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php52/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php52/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php52/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php53/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php53/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php53/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php54/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php54/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php54/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php55/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php55/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php55/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php70/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php70/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php71/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php71/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php72/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php72/usr/lib64/php/modules/pdo_mysql.so is already updated

rpm -qa |grep -i mysql |grep -v alt
compat-MySQL51-shared-5.1.73-1.cp1150.x86_64
MySQL56-devel-5.6.39-1.cp1162.x86_64
MySQL56-shared-5.6.39-1.cp1162.x86_64
cpanel-perl-526-MySQL-Diff-0.50-1.cp1170.noarch
MySQL56-client-5.6.39-1.cp1162.x86_64
MySQL56-server-5.6.39-1.cp1162.x86_64
cpanel-mysql-libs-5.1.73-1.cp1156.x86_64
ea-php54-php-mysqlnd-5.4.45-54.el6.cloudlinux.1.x86_64
MySQL56-test-5.6.39-1.cp1162.x86_64
compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
cpanel-mysql-5.1.73-1.cp1156.x86_64
ea-php56-php-mysqlnd-5.6.36-1.el6.cloudlinux.1.x86_64
cpanel-perl-526-DBD-mysql-4.043-1.cp1170.x86_64
ea-php55-php-mysqlnd-5.5.38-37.el6.cloudlinux.1.x86_64

And output after upgrade without fixing issue:

/usr/bin/alt-php-mysql-reconfigure.py -v
INFO : installed alt-php versions are
alt-php: ('44', '/opt/alt/php44')
alt-php: ('51', '/opt/alt/php51')
alt-php: ('52', '/opt/alt/php52')
alt-php: ('53', '/opt/alt/php53')
alt-php: ('54', '/opt/alt/php54')
alt-php: ('55', '/opt/alt/php55')
alt-php: ('56', '/opt/alt/php56')
alt-php: ('70', '/opt/alt/php70')
alt-php: ('71', '/opt/alt/php71')
alt-php: ('72', '/opt/alt/php72')
DEBUG : SQL version string is '/usr/bin/mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper'
INFO : available SQL so files are
/usr/lib64/mysql/libmysqlclient.so.20.3.9 (mysql-5.7)
/usr/lib64/mysql/libmysqlclient.so.16.0.0 (mysql-5.1)
/usr/lib64/libmysqlclient.so.15.0.0 (mysql-5.0)
DEBUG : system SQL binary path is /usr/bin/mysql
DEBUG : SQL version string is '/usr/bin/mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper'
DEBUG : system SQL is mysql-5.7
DEBUG : /opt/alt/php44/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php51/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php51/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php51/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php52/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php52/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php52/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php53/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php53/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php53/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php54/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php54/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php54/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php55/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php55/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php55/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/mysql.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php56/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php70/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php70/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php71/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php71/usr/lib64/php/modules/pdo_mysql.so is already updated
DEBUG : /opt/alt/php72/usr/lib64/php/modules/mysqli.so is already updated
DEBUG : /opt/alt/php72/usr/lib64/php/modules/pdo_mysql.so is already updated

rpm -qa |grep -i mysql |grep -v alt
cpanel-perl-526-MySQL-Diff-0.50-1.cp1170.noarch
mysql-community-libs-5.7.22-1.el6.x86_64
mysql-community-libs-compat-5.7.22-1.el6.x86_64
mysql-community-common-5.7.22-1.el6.x86_64
mysql-community-client-5.7.22-1.el6.x86_64
cpanel-mysql-libs-5.1.73-1.cp1156.x86_64
ea-php54-php-mysqlnd-5.4.45-54.el6.cloudlinux.1.x86_64
mysql57-community-release-el6-11.noarch
compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
mysql-community-devel-5.7.22-1.el6.x86_64
mysql-community-server-5.7.22-1.el6.x86_64
cpanel-mysql-5.1.73-1.cp1156.x86_64
ea-php56-php-mysqlnd-5.6.36-1.el6.cloudlinux.1.x86_64
cpanel-perl-526-DBD-mysql-4.043-1.cp1170.x86_64
ea-php55-php-mysqlnd-5.5.38-37.el6.cloudlinux.1.x86_64
  1. 15.06.2018 10:06:03
  2. # 3
Edwin Tjallings Accepted Answer
Posts: 2
Joined: 15.06.2018
0
Votes
Undo
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..
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.