WHM 11.44 Upgrade Issue with Remote MySQL

jamesterror

• June 04, 2014 16:31

Hi, Our Web Server has tried to upgrade to WHM 11.44 but failed and is showing the yellow error box message in WHM stating that "The last attempt to update cPanel & WHM was blocked. " - "Please correct these issues and rerun updates. fatal: Newer releases of cPanel & WHM are not compatible with your MySQL version: 5.1. Upgrade your MySQL server to a version greater or equal to 5.5". Our MySQL server has updated fine - and is running MySQL 5.5. Is there an easy fix for how we resolve this on our main Web Server? Would it be correct to edit /var/cpanel/cpanel.config and change it to mysql-version=5.5 ? Thanks! James

• 

  cPanelMichael

  • June 05, 2014 12:54

  Hello :) If you are seeing that warning message, then it means that MySQL did not upgrade successfully. Please post the output from: mysql -V rpm -qa|grep MySQL grep mysql-version /var/cpanel/cpanel.config
  Thank you.

  0
• 

  jamesterror

  • June 05, 2014 22:22

  Hey Michael, Thanks for your reply :-) Seems you are right, our MySQL on the Web Server is 5.1, however we have Remote MySQL setup - hence my confusion. The Web Server - mysql -V mysql Ver 14.14 Distrib 5.1.73, for unknown-linux-gnu (x86_64) using readline 5.1 rpm -qa|grep MySQL MySQL51-server-5.1.73-1.cp1136 MySQL51-devel-5.1.73-1.cp1136 cpanel-perl-514-MySQL-Diff-0.43-1.cp1136 MySQL51-test-5.1.73-1.cp1136 MySQL51-shared-5.1.73-1.cp1136 MySQL51-client-5.1.73-1.cp1136 grep mysql-version /var/cpanel/cpanel.config mysql-version=5.1
  The MySQL server - mysql -V mysql Ver 14.14 Distrib 5.5.37, for Linux (x86_64) using readline 5.1 rpm -qa|grep MySQL MySQL55-client-5.5.37-1.cp1136 MySQL55-devel-5.5.37-1.cp1136 MySQL55-shared-5.5.37-1.cp1136 MySQL55-server-5.5.37-1.cp1136 cpanel-perl-514-MySQL-Diff-0.43-2.cp1136 MySQL55-test-5.5.37-1.cp1136 grep mysql-version /var/cpanel/cpanel.config mysql-version=5.5
  

  0
• 

  cPanelMichael

  • June 06, 2014 14:11

  Please ensure you update your local installation of MySQL to version 5.5. You can always disable it after the update if you are not using the local installation, but a MySQL 5.1 installation will prevent cPanel updates to version 11.44. Thank you.

  0
• 

  jamesterror

  • June 06, 2014 15:26

  Hi Michael, Thanks for clarifying - the option via WHM only allows for the remote MySQL service to be upgraded so I assume we need to run this update via SSH. Is there any documentation on this? Thanks, James

  0
• 

  cPanelMichael

  • June 06, 2014 15:44

  I suggest opening a support ticket so we can take a closer look. We may need to open an internal case to address this issue. Please post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  jamesterror

  • June 06, 2014 15:56

  Hi Michael, Request id is: 5049191 Thanks, James

  0
• 

  cPanelPeter cPanel Staff

  • June 08, 2014 18:02

  Hello James, Thank you. We've confirmed that the following steps seem to fix this issue when you have both a local and remote set up of MySQL running. 1) Set mysql_version=5.5 in /var/cpanel/cpanel.config 2) Run /scripts/check_cpanel_rpms --fix 3) Run EasyApache to get PHP linked with the new MySQL client libs 4) Run /scripts/upcp --force to update to 11.44
  

  0
• 

  jamesterror

  • June 09, 2014 11:18

  Hi Peter, Thanks - yes that is correct. All resolved, thank you to cPanel for the quick assistance solving this. Regards, James

  0

Please sign in to leave a comment.