Unable to upgrade to MySQL 5.6

autumnwalker123

• July 08, 2014 14:19

Hello, when trying to upgrade to MySQL 5.6 I get the following output. Beginning MySQL upgrade... Running: /usr/local/cpanel/scripts/check_cpanel_rpms --targets=MySQL55,MySQL56 --fix [20140708.155932] [20140708.155932] Problems were detected with cPanel-provided files which are RPM controlled. [20140708.155932] If you did not make these changes intentionally, you can correct them by running: [20140708.155932] [20140708.155932] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix [20140708.155932] The following RPMs are missing from your system: [20140708.155932] MySQL56-client-5.6.17-1.cp1142 [20140708.155932] MySQL56-devel-5.6.17-1.cp1142 [20140708.155932] MySQL56-server-5.6.17-1.cp1142 [20140708.155932] MySQL56-shared-5.6.17-1.cp1142 [20140708.155932] MySQL56-test-5.6.17-1.cp1142 [20140708.155932] [20140708.155932] The following RPMs are unneeded on your system and should be uninstalled: [20140708.155932] MySQL55-client-5.5.37-1.cp1136 [20140708.155932] MySQL55-devel-5.5.37-1.cp1136 [20140708.155932] MySQL55-server-5.5.37-1.cp1136 [20140708.155932] MySQL55-shared-5.5.37-1.cp1136 [20140708.155932] MySQL55-test-5.5.37-1.cp1136 warning: cannot get shared lock on /var/lib/rpm/Packages [20140708.155932] Removing 0 broken rpms: [20140708.155932] rpm: no packages given for erase 404 - HTTP/1.0 404 Not Found [20140708.155933] Downloading http://httpupdate.cpanel.net/RPM/11.42/centos/unknown/x86_64/rpm.md5 [20140708.155933] ***** FATAL: 404 - HTTP/1.0 404 Not Found [20140708.155933] The Administrator will be notified to review this output when this script completes Failed while upgrading to 5.6...aborting! MySQL upgrade failed!
I have tried running /usr/local/cpanel/scripts/check_cpanel_rpms --fix and I get the same FATAL 404 message. Thoughts? EDIT: I can see that the URL for RPMs are wrong - how do I fix this? I'm also running WHM 11.44 - not 11.42... something isn't right here.

• 

  Eric

  • July 09, 2014 13:17

  Howdy, It looks like you're update is looking for... where it picks the version of CentOS you're on. What version of CentOS are you running? Thanks!

  0
• 

  autumnwalker123

  • July 09, 2014 14:20

  CentOS 6.5 x86_64.

  0
• 

  JaredR.

  • July 09, 2014 14:31

  What is the output of this command? # cat /etc/redhat-release
  

  0
• 

  autumnwalker123

  • July 09, 2014 15:11

  CentOS release 6.5 (Final) [COLOR="silver">- - - Updated - - - So the upgrade decided to start after a server reboot. Now easyapache is outputting the following and HTTPD / MySQL are both down. Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 135

  0
• 

  JaredR.

  • July 09, 2014 15:14

  Please submit a ticket using the link in my signature. We can likely find the problem relatively quickly if we have direct access to the server, much quicker than going back-and-forth in a forum. You can post the ticket number here so we can follow up.

  0
• 

  autumnwalker123

  • July 09, 2014 15:20

  Request ID 5199291

  0
• 

  JaredR.

  • July 09, 2014 19:10

  The cause of this problem was InnoDB corruption. MySQL started once InnoDB was disabled.

  0

Please sign in to leave a comment.