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!

Upgrading from MySQL 5.5 to MySQL 5.6

Discussion in 'Database Discussion' started by Shane76, Mar 7, 2019.

  1. Shane76

    Shane76 Member

    Joined:
    Mar 31, 2016
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    South Africa
    cPanel Access Level:
    Root Administrator
    Hi

    I recently tried to updated to MySQL 5.6. I have two main issues. The first relates to:

    Critical: The following users use pre-4.1-style MySQL passwords: leechprotect eximstats cpldap horde cphulkd logaholic modsecWe recommend that you update all of your accounts to longer MySQL password hashes before you perform this upgrade. Failure to do so could disrupt database access for accounts or applications that use pre-4.1-style MySQL passwords.

    Can I simply update these passwords under "Home »SQL Services »Change MySQL User Password"? I tried changing MySQL root password and restarting service but that didn't take away the error.

    Secondly, when attempting the upgrade it fails and I get the following output:

    Starting process with log file at /var/cpanel/logs/mysql_upgrade.20190307-204547/upgrade_mysql_with_status.log
    Obtained version information from system.
    Proceeding with MySQL/MariaDB upgrade despite the following:
    Critical: The following users use pre-4.1-style MySQL passwords: leechprotect eximstats cpldap horde cphulkd logaholic modsecWe recommend that you update all of your accounts to longer MySQL password hashes before you perform this upgrade. Failure to do so could disrupt database access for accounts or applications that use pre-4.1-style MySQL passwords.
    Obtained version information from system.
    Ensuring MySQL RPMs for version “5.6”.
    Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56,MySQL57,MariaDB100,MariaDB101,MariaDB102,MariaDB103 --fix
    [2019-03-07 20:45:48 +0200]
    [2019-03-07 20:45:48 +0200] Problems were detected with cPanel-provided files which are RPM controlled.
    [2019-03-07 20:45:48 +0200] If you did not make these changes intentionally, you can correct them by running:
    [2019-03-07 20:45:48 +0200]
    [2019-03-07 20:45:48 +0200] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    [2019-03-07 20:45:48 +0200] The following RPMs are missing from your system:
    [2019-03-07 20:45:48 +0200] MySQL56-server-5.6.43-2.cp1170
    [2019-03-07 20:45:50 +0200] Removing 0 broken rpms:
    [2019-03-07 20:45:50 +0200] rpm: no packages given for erase
    [2019-03-07 20:45:50 +0200] Downloading http://httpupdate.cpanel.net/RPM/11.70/centos/6/x86_64/rpm.sha512
    [2019-03-07 20:45:51 +0200] Successfully verified signature for cpanel (key types: release).
    [2019-03-07 20:45:51 +0200] MySQL56-server-5.6.43-2.cp1170.x86_64.rpm already downloaded
    [2019-03-07 20:45:51 +0200] Disabling service monitoring.
    [2019-03-07 20:45:51 +0200] Hooks system enabled.
    [2019-03-07 20:45:51 +0200] Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed
    [2019-03-07 20:45:51 +0200] All required 'pre' hooks have been run
    [2019-03-07 20:45:51 +0200] No RPMS need to be uninstalled
    [2019-03-07 20:45:51 +0200] Installing new rpms: MySQL56-server-5.6.43-2.cp1170.x86_64.rpm
    [2019-03-07 20:45:51 +0200] Preparing packages for installation...
    [2019-03-07 20:45:52 +0200]
    [2019-03-07 20:45:52 +0200] ******************************************************************
    [2019-03-07 20:45:52 +0200] A MySQL server package (MySQL55-server-5.5.62-1.cp1162.x86_64) is installed.
    [2019-03-07 20:45:52 +0200]
    [2019-03-07 20:45:52 +0200] Upgrading directly from MySQL 5.5 to MySQL 5.6 may not
    [2019-03-07 20:45:52 +0200] be safe in all cases. A manual dump and restore using mysqldump is
    [2019-03-07 20:45:52 +0200] recommended. It is important to review the MySQL manual's Upgrading
    [2019-03-07 20:45:52 +0200] section for version-specific incompatibilities.
    [2019-03-07 20:45:52 +0200]
    [2019-03-07 20:45:52 +0200] A manual upgrade is required.
    [2019-03-07 20:45:52 +0200]
    [2019-03-07 20:45:52 +0200] - Ensure that you have a complete, working backup of your data and my.cnf
    [2019-03-07 20:45:52 +0200] files
    [2019-03-07 20:45:52 +0200] - Shut down the MySQL server cleanly
    [2019-03-07 20:45:52 +0200] - Remove the existing MySQL packages. Usually this command will
    [2019-03-07 20:45:52 +0200] list the packages you should remove:
    [2019-03-07 20:45:52 +0200] rpm -qa | grep -i '^mysql-'
    [2019-03-07 20:45:52 +0200]
    [2019-03-07 20:45:52 +0200] You may choose to use 'rpm --nodeps -ev <package-name>' to remove
    [2019-03-07 20:45:52 +0200] the package which contains the mysqlclient shared library. The
    [2019-03-07 20:45:52 +0200] library will be reinstalled by the MySQL-shared-compat package.
    [2019-03-07 20:45:52 +0200] - Install the new MySQL packages supplied by Oracle and/or its affiliates
    [2019-03-07 20:45:52 +0200] - Ensure that the MySQL server is started
    [2019-03-07 20:45:52 +0200] - Run the 'mysql_upgrade' program
    [2019-03-07 20:45:52 +0200]
    [2019-03-07 20:45:52 +0200] This is a brief description of the upgrade process. Important details
    [2019-03-07 20:45:52 +0200] can be found in the MySQL manual, in the Upgrading section.
    [2019-03-07 20:45:52 +0200] ******************************************************************
    [2019-03-07 20:45:52 +0200] error: %pre(MySQL56-server-5.6.43-2.cp1170.x86_64) scriptlet failed, exit status 1
    [2019-03-07 20:45:52 +0200] error: install: %pre scriptlet failed (2), skipping MySQL56-server-5.6.43-2.cp1170
    [2019-03-07 20:45:52 +0200] W Error Code: 1
    [2019-03-07 20:45:52 +0200] E The following possible errors were detected while installing RPMs:
    [2019-03-07 20:45:52 +0200] E %pre(MySQL56-server-5.6.43-2.cp1170.x86_64) scriptlet failed, exit status 1 install
    [2019-03-07 20:45:52 +0200] The Administrator will be notified to review this output when this script completes
    [2019-03-07 20:45:52 +0200] Hooks system enabled.
    [2019-03-07 20:45:52 +0200] Checking for and running RPM::Versions 'post' hooks for any RPMs about to be installed
    [2019-03-07 20:45:52 +0200] All required 'post' hooks have been run
    [2019-03-07 20:45:52 +0200] Restoring service monitoring.
    Restarting mysql service.
    Waiting for “mysql” to restart ……waiting for “mysql” to initialize ………finished.

    Service Status
    mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=server1.noffy.info.err --open-files-limit=10000 --pid-file=/var/lib/mysql/server1.noffy.info.pid) is running as mysql with PID 13011 (pidfile+/proc check method).

    Startup Log
    Starting MySQL..[ OK ]

    Log Messages
    190307 20:45:57 [Note] /usr/sbin/mysqld: ready for connections.
    190307 20:45:56 [Note] /usr/sbin/mysqld: Shutdown complete
    190307 20:45:53 [Note] /usr/sbin/mysqld: Normal shutdown
    190307 20:39:48 [Note] /usr/sbin/mysqld: ready for connections.
    190307 20:39:47 [Note] /usr/sbin/mysqld: Shutdown complete
    190307 20:39:45 [Note] /usr/sbin/mysqld: Normal shutdown
    190307 20:39:06 [Note] /usr/sbin/mysqld: ready for connections.
    190307 20:39:05 [Note] /usr/sbin/mysqld: Shutdown complete
    190307 20:39:02 [Note] /usr/sbin/mysqld: Normal shutdown
    190307 20:35:37 [Note] /usr/sbin/mysqld: ready for connections.
    190307 20:35:36 [Note] /usr/sbin/mysqld: Shutdown complete
    190307 20:35:32 [Note] /usr/sbin/mysqld: Normal shutdown
    190307 20:31:35 [Note] /usr/sbin/mysqld: ready for connections.
    190307 20:31:33 [Note] /usr/sbin/mysqld: Shutdown complete
    190307 20:31:31 [Note] /usr/sbin/mysqld: Normal shutdown
    190307 6:02:44 [Note] /usr/sbin/mysqld: ready for connections.

    mysql restarted successfully.
    Failed to update RPM: :The “/usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56,MySQL57,MariaDB100,MariaDB101,MariaDB102,MariaDB103 --fix” command (process 12589) reported error number 2 when it ended. at /usr/local/cpanel/Cpanel/MysqlUtils/Install.pm line 100.
    Obtained version information from system.
    Proceeding with MySQL/MariaDB upgrade despite the following:
    Critical: The following users use pre-4.1-style MySQL passwords: leechprotect eximstats cpldap horde cphulkd logaholic modsecWe recommend that you update all of your accounts to longer MySQL password hashes before you perform this upgrade. Failure to do so could disrupt database access for accounts or applications that use pre-4.1-style MySQL passwords.

    Any idea where I can start?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,141
    Likes Received:
    474
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @Shane76


    Can you tell me what version of cPanel you're running? Older versions of the software have a setting to update this. You can go to WHM>>Server Configuration>>Tweak Settings -> Turn Use pre-4.1-style MySQL® passwords from ON to OFF

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Shane76

    Shane76 Member

    Joined:
    Mar 31, 2016
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    South Africa
    cPanel Access Level:
    Root Administrator
    Hi

    I'm using v78.0.16

    The "Use pre-4.1-style MySQL® passwords" is already set from ON to OFF

    Thank you
     
  4. Shane76

    Shane76 Member

    Joined:
    Mar 31, 2016
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    South Africa
    cPanel Access Level:
    Root Administrator
    Hi

    Further to my reply above, I have cleared the passwords error by manually updating the PW for certain users in MySQL.

    So now that error is no longer there. However when I try to run the upgrade again it is still unsuccessful - here is the log:

    Code:
    Starting process with log file at /var/cpanel/logs/mysql_upgrade.20190309-051646/upgrade_mysql_with_status.log
    Obtained version information from system.
    Obtained version information from system.
    Ensuring MySQL RPMs for version “5.6”.
    Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL41,MySQL50,MySQL51,MySQL55,MySQL56,MySQL57,MariaDB100,MariaDB101,MariaDB102,MariaDB103 --fix
    Restarting mysql service.
    Waiting for “mysql” to restart ……waiting for “mysql” to initialize ………finished.
    
    Service Status
    mysql (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=server1.noffy.info.err --open-files-limit=10000 --pid-file=/var/lib/mysql/server1.noffy.info.pid) is running as mysql with PID 600 (pidfile+/proc check method).
    
    Startup Log
    Starting MySQL..[ OK ] 
    
    Log Messages
    190309 5:16:52 [Note] /usr/sbin/mysqld: ready for connections.
    190309 5:16:50 [Note] /usr/sbin/mysqld: Shutdown complete
    190309 5:16:47 [Note] /usr/sbin/mysqld: Normal shutdown
    190309 5:15:07 [Note] /usr/sbin/mysqld: ready for connections.
    190309 5:15:05 [Note] /usr/sbin/mysqld: Shutdown complete
    190309 5:15:04 [Note] /usr/sbin/mysqld: Normal shutdown
    190309 5:11:14 [Note] /usr/sbin/mysqld: ready for connections.
    190309 5:11:13 [Note] /usr/sbin/mysqld: Shutdown complete
    190309 5:11:09 [Note] /usr/sbin/mysqld: Normal shutdown
    190309 5:06:36 [Note] /usr/sbin/mysqld: ready for connections.
    190309 5:06:35 [Note] /usr/sbin/mysqld: Shutdown complete
    190309 5:06:31 [Note] /usr/sbin/mysqld: Normal shutdown
    190309 5:04:55 [Note] /usr/sbin/mysqld: ready for connections.
    190309 5:04:53 [Note] /usr/sbin/mysqld: Shutdown complete
    190309 5:04:52 [Note] /usr/sbin/mysqld: Normal shutdown
    190309 5:04:03 [Note] /usr/sbin/mysqld: ready for connections.
    
    mysql restarted successfully.
    We expected to upgrade to 5.6; however, the system is currently on version 5.5. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 898.
    Obtained version information from system.
     
    #4 Shane76, Mar 8, 2019
    Last edited by a moderator: Mar 9, 2019
  5. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,141
    Likes Received:
    474
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @Shane76


    Can you tell me the output of the following?

    Code:
    mysql -v
    Code:
    grep -i mysql-version /var/cpanel/cpanel.config
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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