[CPANEL-32712] Updating to MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface
Hey everyone,
We wanted to let you know that we have become aware of an issue updating from MariaDB 10.3.22 to 10.3.23. This is being shown to break the cPanel -> MySQL Databases interface. This MariaDB update occurs automatically when updating cPanel with a version that includes support for MariaDB 10.3.
Symptoms
The cPanel -> MySQL Databases interface will display these errors:
"The MySQL server is currently offline."
"Error encountered while fetching data: There is no such grant defined for user 'cpses_username' on host 'localhost' DBDISKUSED cpuser_user 0 DISKUSED 0 DB cpuser_user USER cpuser_db"
The following errors can also be found in cPanel's error log:
Description The issue is related to changes in grants in MariaDB 10.3.23. An internal case has been filed with our developers to get this resolved.
[2020-05-12 23:36:14 -0500] warn [cpmysql] Error encountered while fetching data: There is no such grant defined for user 'cpses_username' on host 'localhost' at /usr/local/cpanel/Cpanel/DBAdmin.pm line 186, line 1.Invalid grant string: GRANT USAGE ON *.* TO `cptech_db`@`localhost` IDENTIFIED BY PASSWORD '*redacted'[2020-05-12 23:36:14 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request adminbin Cpanel/cpmysql/DBCACHE: exit 11: namespace=[Cpanel] module=[cpmysql] function=[DBCACHE]: set error in context mysql: raw_response=[{"version":"2.4","action":"run","data":"Error encountered while fetching data: There is no such grant defined for user 'cpses_username' on host 'localhost'\nDBDISKUSED\tcptech_dbv\t0\nDISKUSED\t0\nDB\tcptech_dbv\nUSER\tcptech_db\n","timeout":0,"mode":"simple","status":1,"exit_code":2816,"error":1,"statusmsg":"adminbin Cpanel/cpmysql/DBCACHE: exit 11"}] at /usr/local/cpanel/Cpanel/Wrap.pm line 120, <$socket> line 1.Description The issue is related to changes in grants in MariaDB 10.3.23. An internal case has been filed with our developers to get this resolved.
-
Hello, I am unable to add Remote MySQL Ip into my cPanel account it shows I have tried so many IPs it is the same for all fo them. 0 -
I can confirm downgrading mariadb from 10.3.23 to 10.3.22 resolves the issue yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel0 -
Softaculous is unable to deploy new WordPress instance, it can't create DBs. 0 -
Hello team Iam not able to access mysql database module from Cpanel gui. Please refer attached screenshot. The MySQL server is currently offline. Error encountered while fetching data: There is no such grant defined for user 'cpses_lbgf0jz8bu' on host 'localhost' DBDISKUSED lbws_fb 7151616 DBDISKUSED lbws_dev 5713920 DISKUSED 12865536 DB lbws_test DB lbws_fb DBUSER lbws_fb lbws_fb DB lbws_dev DBUSER lbws_dev lbws_dev USER lbws_fb0 -
Iam waiting for your response. Its bit urgent for me 0 -
i think your problem is [CPANEL-32712] do not update your MariaDB . 0 -
Hi, how we can pervert MariaDB from updating ? Thanks . 0 -
Hello, I also reconfirm this case, it works perfectly with downgrade to MariaDB 10.3.22! 0 -
Hello, I found another resolution! cPanel/WHM v86.0.19 with MariaDB 10.3.23 has problem, but upgrading to cPanel/WHM v88.0.2 with MariaDB 10.3.23 resolves the problem. 0 -
When login to cPanel and go to MySQL" Databases the error message: The MySQL server is currently offline All sites operate normally and the customer can through the site control panel to enter data naturally, but this problem appears only when trying to login to Mysql and create database on cPanel, And phpMyAdmin on cPanel is work as good, Only when login to MySQL" Databases. 0 -
I can confirm downgrading mariadb from 10.3.23 to 10.3.22 resolves the issue
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
You just saved my life! I confrim that this just works. To upgrade to the RELEASE channel to fix this bug it's a little too much for me. Thank you!0 -
I have the same issue on 2 servers, WHM v86, MariaDB 10.3. 0 -
This may help you - line 1.
I have attached screenshot Please refer0 -
I am seeing this issue on 3 of my servers. 0 -
Hey guys, I want to clarify a few things this morning. [COLOR=rgb(124, 112, 107)]*** I've merged all related threads into this one to keep all inquiries on this issue in the same place. In case you're wondering where your thread went. 1. We DO NOT recommend you downgrade for a reason. The MariaDB version included several important CVE fixes which are detailed here: 2. While this issue is keeping interface related Items from functioning it does not prevent MariaDB from running 3. This is a pretty high severity case which prompted a blocker on further updates until the issue is resolved - there is already a patch for it being tested 4. cPanel & WHM v88 which is in CURRENT is not affected by this issue With items 1-4 in mind, we weighed the impact vs. the security risk as well as the availability for a resolution and chose to recommend moving to cPanel & WHM v88 for an immediate resolution or to hold until the case was resolved on v86 which absolutely will not be long. Please ensure you're weighing all of your options fully before performing any action. I'll continue providing updates as information becomes available. 0 -
If this issue is not occurring on cPanel & WHM v88 why don't you provide us with this version? I am still running v86 and get no upgrade if I run upgrade to "latest" version. Do I need special privileges to get v88? 0 -
If this issue is not occurring on cPanel & WHM v88 why don't you provide us with this version? I am still running v86 and get no upgrade if I run upgrade to "latest" version. Do I need special privileges to get v88?
You can go to WHM -> Server Configuration -> Update Preferences, and change your update tier there. v88 is available on CURRENT tier. (if you are running CentOS 6, the upgrade (as far as I know) is not available) Though, make sure you know what other updates / upgrades and changes would happen if you go through with it! So, I'm not recommending it, nor saying "don't do it". It is totally up to to you. - Wallu0 -
If this issue is not occurring on cPanel & WHM v88 why don't you provide us with this version? I am still running v86 and get no upgrade if I run upgrade to "latest" version. Do I need special privileges to get v88?
What? Please ensure that you're properly setting the tier you'd like to be in before you start down this path. We are most definitely offering this version - cPanel v88 is in CURRENT you need to set your tiers to reflect that in WHM as @Wallu just noted above.0 -
Any ETA as to when the patch will be released for 86? We need to know a timeframe at least. 0 -
Any ETA as to when the patch will be released for 86? We need to know a timeframe at least.
Soon - if I had anything more solid I would have noted that here. I can tell you there is a fix for this already and it's queued up for merge.0 -
Any workaround for those who urgently need to add a MySQL user? 0 -
Any workaround for those who urgently need to add a MySQL user?
The ONLY workarounds are noted in the thread.0 -
The ONLY workarounds are noted in the thread.
Oh, OK. I was getting crazy trying to see why my update preferences didn't show v88 in RELEASE as you published earlier. So it is CURRENT, not RELEASE. Guys, if you don't want to go for v88 you can add the user manually and later replace it when the interface works again. Do the things like in 1998. Don't forget to flush privileges.0 -
Oh, OK. I was getting crazy trying to see why my update preferences didn't show v88 in RELEASE as you published earlier. So it is CURRENT, not RELEASE. Guys, if you don't want to go for v88 you can add the user manually and later replace it when the interface works again. Do the things like in 1998. Don't forget to flush privileges.
That's absolutely my fault but I've fixed it now :) While that might work right now, I wouldn't recommend adding things manually either to be completely honest. It may cause unintended issues with the database configuration later. Not saying you can't do it, just that you should be cautious and it'd be unsupported.0 -
We are waiting for fast resolve the issue - for now we had upgraded only couple of servers, but our chat online is burning ... :/ 0 -
Glad to hear that there are plans to fix 86 as I've been awaiting customer to goto CentOS 8 that was slated for "early 2020" and Cent 6 being a blocker to get to 88 is really a burner for us. Hoping that Cent 8 is around the corner! :D People on Cent 6 are kinda left behind and it doesn't go EOL to end of the year. 0 -
I can confirm downgrading mariadb from 10.3.23 to 10.3.22 resolves the issue
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Downgrading MariaDB worked fine for me, thank you! Anyone knows how to disable automatic MariaDB updates, if that's recommended?0 -
Softaculous is unable to deploy new WordPress instance, it can't create DBs.
Same happened to me today, but somehow it created new databases, I can see there is more than one, but I can't access them. Any info when this will be resolved?0
Please sign in to leave a comment.
Comments
68 comments