Skip to main content

[CPANEL-28105] Upgrade to MySQL 5.7 Failed

Comments

7 comments

  • cPanelMichael
    Hello @renatoandrade, It's possible this relates to an internal case that's open (CPANEL-28105) where an invalid mysql-version entry in /var/cpanel/cpanel.config breaks the MySQL upgrade process, however we'll need to take a closer look at your system to verify if that's the case. Could you open a
    0
  • Michael-Inet
    After the command I did the update procedure, gave the following errors, RPM conflict, the system detected issues with the current "/etc/my.cnf" file and MySQL enables "strict mode" by default as of version 5.7

    I had custom setting in my.cnf and got the same error. The solution that worked for me was to back up my.cnf, delete my.cnf, and then restart the update. my.cnf then gets created clean and you can re-add any custom settings afterwards. Best, Michael
    0
  • renatoandrade
    I had custom setting in my.cnf and got the same error. The solution that worked for me was to back up my.cnf, delete my.cnf, and then restart the update. my.cnf then gets created clean and you can re-add any custom settings afterwards. Best, Michael

    I tried this and it did not work, I believe I will have to open a ticket in the cpanel to upgrade.
    0
  • cPanelMichael
    I tried this and it did not work, I believe I will have to open a ticket in the cpanel to upgrade.

    Hello @renatoandrade, Could you post the ticket number here once it's opened? I'll link this thread to it and share the outcome here once it's closed. Thank you.
    0
  • renatoandrade
    Hello @renatoandrade, It's possible this relates to an internal case that's open (CPANEL-28105) where an invalid mysql-version entry in /var/cpanel/cpanel.config breaks the MySQL upgrade process, however we'll need to take a closer look at your system to verify if that's the case. Could you open a
    0
  • renatoandrade
    [QUOTE] Hello, The first time I reattempted the upgrade it failed because MySQL 5.6 was configured as installed in /var/cpanel/rpm.versions.d/local.versions: ========= [01:30:49 server root@12797665 ~]cPs# grep -i 'mysql' !$ grep -i 'mysql' /var/cpanel/rpm.versions.d/local.versions MySQL56: installed
    This was causing the RPM's for MySQL 5.6 to not be properly removed during the upgrade. To resolve this, I ran the following to remove "MySQL56: installed" from /var/cpanel/rpm.versions.d/local.versions: [06:08:25 server root@12797665 ~]cPs# /scripts/update_local_rpm_versions --del target_settings.MySQL56
    Once completed, I tried running the MySQL upgrade again and it completed successfully. MySQL 5.7 is now running on the server: [06:09:02 server root@12797665 ~]cPs# mysql -V mysql Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using EditLine wrapper
    Please let us know if you have any questions about this or experience any issues after this upgrade. Thank you, -- John Reyes Technical Analyst cPanel, L.L.C.
    0
  • cPanelLauren
    Hello, This is just an update to let you know that this issue is marked as resolved in v90 of cPanel & WHM and can be referenced in our changelogs here: 90 Change Log | cPanel & WHM Documentation
    0

Please sign in to leave a comment.