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

cPanelLauren · May 13, 2020

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.

hasnisyed · May 13, 2020

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.

murmaider · May 13, 2020

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

m_ally_m · May 13, 2020

Softaculous is unable to deploy new WordPress instance, it can't create DBs.

Vijayakumar J R · May 13, 2020

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

Vijayakumar J R · May 13, 2020

Iam waiting for your response.
Its bit urgent for me

hossein · May 13, 2020

i think your problem is [CPANEL-32712]
do not update your MariaDB .

rezaahmadi · May 13, 2020

Hi , how we can pervert MariaDB from updating ?
Thanks .

itdatatelecom · May 13, 2020

Hello, I also reconfirm this case, it works perfectly with downgrade to MariaDB 10.3.22!

Inna · May 13, 2020

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.

KhaedAlkhamesi · May 13, 2020

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.

eagle1maledetto · May 13, 2020

murmaider said:
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!

KhaedAlkhamesi · May 13, 2020

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:

SOLVED - [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...

forums.cpanel.net

anton_latvia · May 13, 2020

I have the same issue on 2 servers, WHM v86, MariaDB 10.3.

Kyle Holmes · May 13, 2020

This is a known issue, Pending Publication - [CPANEL-32712] Updating to MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface

Either upgrade to version 88 of cPanel or downgrade MariaDB - for a quick fix or wait until cPanel releases a patch for it.

Vijayakumar J R · May 13, 2020

murmaider said:
This may help you - Pending Publication - [CPANEL-32712] Updating to MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface

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

texo · May 13, 2020

I am seeing this issue on 3 of my servers.

cPanelLauren · May 13, 2020

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:

https://mariadb.com/kb/en/mariadb-10323-release-notes/

Fixes for the following security vulnerabilities:
CVE-2020-2752
CVE-2020-2812
CVE-2020-2814
CVE-2020-2760

Click to expand...

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.

serpent_driver · May 13, 2020

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?

Wallu · May 13, 2020

serpent_driver said:
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

Thread starter	Similar threads	Forum	Replies	Date
C	Difference in size shown between cpanel and in mysql folder	Databases	3	Tuesday at 7:52 PM
L	phpmyadmin 500 internal server error when accessed from users cpanel	Databases	4	May 18, 2023
G	/usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 855	Databases	1	May 15, 2023
H	Aborted connection 3 to db: 'unconnected' user: 'Cpanel::MysqlUtils::Unprivileged' host: 'localhost' (Got an error writing communication packets)	Databases	2	Apr 15, 2023
H	cpanel restoration error	Databases	1	Apr 7, 2023

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

Product Owner II

Member

Member

Registered

Active Member

Attachments

Active Member

Active Member

Registered

Registered

Active Member

Member

Attachments

Member

Member

Well-Known Member

Registered

Active Member

Attachments

Well-Known Member

Product Owner II

Well-Known Member

Well-Known Member