Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'CloudLinux' started by Edwin Tjallings, Jun 13, 2018.

Tags:
  1. Edwin Tjallings

    Edwin Tjallings Registered

    Joined:
    May 23, 2018
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Edwin Tjallings

    Edwin Tjallings Registered

    Joined:
    May 23, 2018
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. Edwin Tjallings

    Edwin Tjallings Registered

    Joined:
    May 23, 2018
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Netherlands
    cPanel Access Level:
    Root Administrator
    Support ticket open with cloudlinux id 37566
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice