cPanel update mistakenly assuming to be running MySQL 5.5

Bretas

Member
Jun 10, 2018
12
2
3
Brazil
cPanel Access Level
Root Administrator
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:

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

Code:
$ mysqld --version
mysqld  Ver 5.6.44 for Linux on x86_64 (MySQL Community Server (GPL))
Code:
$ 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!
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,488
188
193
Chesapeake, VA
greenolivetree.net
cPanel Access Level
DataCenter Provider
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.
 

Bretas

Member
Jun 10, 2018
12
2
3
Brazil
cPanel Access Level
Root Administrator
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:

https://forums.cpanel.net/threads/fresh-cpanel-unable-to-update-file-conflicts.633477

I'm not sure what may have modified this file in both occasions but I'll keep an eye on it following future migrations.

Update went on great now. Thank you, sir/mam! Have a great week!
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
6,815
541
263
Houston
cPanel Access Level
DataCenter Provider
Thanks @GOT!

@Bretas glad the issue is resolved now and you were able to update successfully.