SOLVED [CPANEL-32712] Updating to MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface

cPanelLauren

Technical Support Community Manager
Staff member
Nov 14, 2017
13,304
1,247
313
Houston
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:



Code:
[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, <STDIN> line 1.
Code:
Invalid grant string: GRANT USAGE ON *.* TO `cptech_db`@`localhost` IDENTIFIED BY PASSWORD '*redacted'
Code:
[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.

  • Note that while the interface indicates it is down it is only the interface the server is still running.
  • This is only occurring on versions of cPanel & WHM v86 which support MariaDB 10.3.23
  • This is not occurring on cPanel & WHM v88
  • For more information see: https://go.cpanel.net/CPANEL-32712


We'll be updating this with more information as it becomes available.
 
Last edited:
Jul 15, 2019
23
0
1
banglore
cPanel Access Level
Root Administrator
Hello team

Iam not able to access mysql database module from Cpanel gui.


Please refer attached screenshot.

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

Attachments

May 13, 2020
5
0
1
Yemen
cPanel Access Level
Root Administrator
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.
 

Attachments

Dec 15, 2019
6
1
3
Italy
cPanel Access Level
DataCenter Provider
I can confirm downgrading mariadb from 10.3.23 to 10.3.22 resolves the issue

Code:
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!
 
May 13, 2020
5
0
1
Yemen
cPanel Access Level
Root Administrator
I applied this solution and it worked:
Code:
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
this solution from:
 
Jul 15, 2019
23
0
1
banglore
cPanel Access Level
Root Administrator

Thanks for your reply.

After i updated mysql root password, I am facing still facing same issue.


Please refer the attached screenshot.

Error
Code:
The MySQL server is currently offline.
Error while connecting to MySQL: (XID tmpy5n) The system failed to connect to the “MySQL” database “mysql” because of an error: 1044 (Access denied for user 'root'@'localhost' to database 'mysql') Error while connecting to MySQL: (XID tmpy5n) The system failed to connect to the “MySQL” database “mysql” because of an error: 1044 (Access denied for user 'root'@'localhost' to database 'mysql') at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1.
I have attached screenshot Please refer
 

Attachments

cPanelLauren

Technical Support Community Manager
Staff member
Nov 14, 2017
13,304
1,247
313
Houston
Hey guys,

I want to clarify a few things this morning.

*** 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.
 
Last edited:
  • Like
Reactions: cPanelDon

Wallu

Active Member
Jan 13, 2020
28
7
3
Finland
cPanel Access Level
Root Administrator
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.

- Wallu
 
  • Like
Reactions: eagle1maledetto