Upgrading from MySQL 5.5 to MySQL 5.6

Shane76

• March 07, 2019 12:55

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 Any idea where I can start?

• 

  cPanelLauren

  • March 08, 2019 16:54

  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!

  0
• 

  Shane76

  • March 09, 2019 00:40

  Hi I'm using v78.0.16 The "Use pre-4.1-style MySQL" passwords" is already set from ON to OFF Thank you

  0
• 

  Shane76

  • March 09, 2019 02:21

  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: 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.
  

  0
• 

  cPanelLauren

  • March 11, 2019 17:17

  Hi @Shane76 Can you tell me the output of the following? mysql -v
grep -i mysql-version /var/cpanel/cpanel.config
  

  0

Please sign in to leave a comment.