cPanel update mistakenly assuming to be running MySQL 5.5
Upgrade to Latest VersionHy, everyone!
One of our servers is now having cPanel upgrades blocked because it assumes to be running on MySQL 5.5 for whatever reason:
However, that's clearly not the case:
Both phpMyAdmin as well as WHM's "MySQL/MariaDB Upgrade" menu attest the same (Currently installed: 5.6.44). This box is brand new, it was setup just a couple of weeks from scratch with cPanel v80 so it couldn't possibly have been provisioned on MySQL 5.5. Not sure if this is related somehow but the server where we migrated its accounts from was running MySQL 5.5. Migration was performed via Transfer Tool, I don't see why the attributes of the old/deactivated (such as MySQL) version might have been transferred as well but I thought it was worth bringing it up. The server is currently running cPanel v80.0.15. I tried manually running the upgrade via WHM (Upgrade to Latest Version) to no avail. Thanks!
[2019-07-01 21:18:16 -0300] W NOTE: A system upgrade was not possible due to the following blockers:
[2019-07-01 21:18:16 -0300] W [FATAL] - Newer releases of cPanel & WHM are not compatible with your local MySQL version: 5.5. You must upgrade your local MySQL server to a version greater or equal to 5.6 using the MySQL/MariaDB Upgrade interface.
=> Log closed Mon Jul 1 21:18:16 2019
However, that's clearly not the case:
$ mysqld --version
mysqld Ver 5.6.44 for Linux on x86_64 (MySQL Community Server (GPL))
$ cat /root/cpanel_profile/cpanel.config
mysql-version=5.6
Both phpMyAdmin as well as WHM's "MySQL/MariaDB Upgrade" menu attest the same (Currently installed: 5.6.44). This box is brand new, it was setup just a couple of weeks from scratch with cPanel v80 so it couldn't possibly have been provisioned on MySQL 5.5. Not sure if this is related somehow but the server where we migrated its accounts from was running MySQL 5.5. Migration was performed via Transfer Tool, I don't see why the attributes of the old/deactivated (such as MySQL) version might have been transferred as well but I thought it was worth bringing it up. The server is currently running cPanel v80.0.15. I tried manually running the upgrade via WHM (Upgrade to Latest Version) to no avail. Thanks!
-
I am not entire sure of the exact file name but look in /var/cpanel/cpanel.config I am pretty confident there is a mysql version line in there and I bet the config migration messed that up. Just manually edit it and run the command it says to tun at the top of the file when you make changes and then run upcp. 0 -
I am not entire sure of the exact file name but look in /var/cpanel/cpanel.config
Thanks for your prompt response, @GOT! You're right, that did it. Somehow I mistook "/root/cpanel_profile/cpanel.config" (the file where MySQL version is set prior to installing cPanel) with "/var/cpanel/cpanel.config", which is why I mentioned the former. Now that you mentioned it, I recall I had a very similar issue a year ago shortly after a migration as well on a different server, same solution was applied back then:0 -
Had to be the settings transfer tool. Glad I could help! 0 -
Thanks @GOT! @Bretas glad the issue is resolved now and you were able to update successfully. 0
Please sign in to leave a comment.
Comments
4 comments