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!

WHM 11.44 Upgrade Issue with Remote MySQL

Discussion in 'General Discussion' started by jamesterror, Jun 4, 2014.

  1. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
    #1 jamesterror, Jun 4, 2014
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    If you are seeing that warning message, then it means that MySQL did not upgrade successfully. Please post the output from:

    Code:
    mysql -V
rpm -qa|grep MySQL
grep mysql-version /var/cpanel/cpanel.config
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jun 5, 2014
  3. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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 -

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

    Code:
    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
     
    #3 jamesterror, Jun 5, 2014
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Jun 6, 2014
  5. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
    #5 jamesterror, Jun 6, 2014
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Jun 6, 2014
  7. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi Michael,

    Request id is: 5049191

    Thanks,
    James
     
    #7 jamesterror, Jun 6, 2014
  8. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    575
    Likes Received:
    20
    Trophy Points:
    143
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.

    Code:
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelPeter, Jun 8, 2014
  9. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi Peter,

    Thanks - yes that is correct.

    All resolved, thank you to cPanel for the quick assistance solving this.

    Regards,
    James
     
    #9 jamesterror, Jun 9, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Upgrade Issue Remote
  1. indoc0der

    SOLVED WordPress Issue When Install/Upgrade Plugins or Themes

    indoc0der, Apr 24, 2017, in forum: General Discussion
    Replies:
    5
    Views:
    1,642
    indoc0der
    May 17, 2017
  2. Mikhail

    Database issues? WHMCS upgrade

    Mikhail, Jan 1, 2017, in forum: Database Discussion
    Replies:
    6
    Views:
    1,478
    Infopro
    Jan 3, 2017
  3. tamalero

    SOLVED Mysql 5.5 to 5.6 Upgrade issue

    tamalero, Nov 30, 2016, in forum: General Discussion
    Replies:
    8
    Views:
    2,524
    tamalero
    Dec 21, 2016
  4. XxUnkn0wnxX

    phpMyAdmin Issues After MySQL Upgrade

    XxUnkn0wnxX, Oct 25, 2016, in forum: Database Discussion
    Replies:
    7
    Views:
    2,042
    cPanelMichael
    Nov 2, 2016
  5. GoZen

    New Thread MariaDB upgrade

    GoZen, Oct 19, 2018 at 6:16 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    29
    GOT
    Oct 19, 2018 at 12:49 PM

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.
    Accept Learn More...
    Dismiss Notice