[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.
-
We're hoping for tonight/tomorrow for this to be pushed with v86.0.20 - I'll update when I have more solid information. 0 -
I've seen the advantage of updating software many times in my life and this one is no exception. Updated to 88 on the day it came to "Current :cool: 0 -
I've seen the advantage of updating software many times in my life and this one is no exception. Updated to 88 on the day it came to "Current :cool:
Seen the flip side too. If it doesn't say "Stable", it can make it or break it.0 -
I've seen the advantage of updating software many times in my life and this one is no exception. Updated to 88 on the day it came to "Current :cool:
I have a similar chance by choosing mysql instead of mariadb. :)0 -
I was told by cPanel support to upgrade cPanel to v88. Now it's even worse. Softaculous won't even open. It shows: Incorrect binary permission Child failed to make LIVEAPI connection to cPanel. We can't manage existing installs from Softaculous now. Which means tons of scripts have no access for us or the customer. At least before we could access the installs, we just couldn't add new ones. 0 -
I will suggest to downgrade mysql untill they fix the issue in the current stable release as it is not good to upgrade a production server to more issues like these. Please change the tier back and then do upcp once more and then better downgrade mysql 0 -
Cool, the update is available now! Apply it! 0 -
I was told by cPanel support to upgrade cPanel to v88. Now it's even worse. Softaculous won't even open. It shows: Incorrect binary permission Child failed to make LIVEAPI connection to cPanel. We can't manage existing installs from Softaculous now. Which means tons of scripts have no access for us or the customer. At least before we could access the installs, we just couldn't add new ones.
Regarding the issue with Softaculous binary permission please try the following command and check if you still face the issue : chown root:root /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/bin/soft chmod 4555 /usr/local/cpanel/whostmgr/docroot/cgi/softaculous/bin/soft If you still face the issue please open a support ticket with us and we will check it asap. Regards, Brijesh Kothari Project Manager Softaculous0 -
Hell guys After update to v86.0.20 still iam issue with mysql database. The MySQL server is currently offline. Error while connecting to MySQL: (XID tyc4wb) 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 tyc4wb) 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, line 1.
Please see attached error screenshot Please provide some solution asap.0 -
Hell guys After update to line 1.
Please see attached error screenshot Please provide some solution asap.
Update cpanel to version 88.020 -
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
It was working on the same version before. Why is that so?0 -
I can confirm - update to v86.0.20 resolves problems with MariaDB 10.3.23 0 -
I can also confirm 86.0.20 has fixed the issue on our servers, and all database functions are back - Nice work cPanel 0 -
Hello, I can also confirm that - update to v86.0.20 resolves problems with MariaDB 10.3.23 0 -
The problem was resolved in version 86.0.20 and everything is working as expected. Thank you! 0 -
Dear All, Upgrading to WHM/CPANEL v88 will resolve the problem with MariaDB 10.3.23. 0 -
I have the same issue on 2 servers, WHM v86, MariaDB 10.3.
Just updated to v86.0.20 and the problem will go completely.0 -
Good Morning - v86.0.20 Just officially went to stable/release but you were able to get it late last night. Please let us know if you continue to experience issues. 0 -
Hell guys After update to v86.0.20 still iam issue with mysql database.
The MySQL server is currently offline. Error while connecting to MySQL: (XID tyc4wb) 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 tyc4wb) 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, line 1.
Please see attached error screenshot Please provide some solution asap.
Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved. Thanks!0 -
I can also confirm that - update to v86.0.20 resolves problems with MariaDB 10.3.23 0 -
While this is resolved I also wanted to note in here for those of you indicating that you wanted to stop MariaDB updates, the update to MariaDB was a minor release and minor point releases should not contain large changes. Because of this we actually opened a case with MariaDB [MDEV-22550] Upgrade to MariaDB 10.3.23 broke the cPanel Databases interface (likely MDEV-20076?) - Jira to have attention brought to this issue. 0 -
Upgrade the mysql server to latest version. if its already in latest version, then try to downgrade it with following command. yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel 0 -
Doesn't work for me: The MySQL server is currently offline. DBDISKUSED phebert_wp 24412160 DBDISKUSED phebert_rot 9420800 DBDISKUSED phebert_ca_wp 19891662 DBDISKUSED phebert_rd 0 DISKUSED 53724622 DB phebert_ca_wp DBUSER phebert_ca_wp phebert_ca_wp DB phebert_rot DBUSER phebert_rot phebert_rot DB phebert_wp DBUSER phebert_wp phebert_wp DB phebert_rd USER phebert_rde
v88.0.10 MySQL 8.0.20 Was working fine, created new DB, new USER assigned USER to DB with all privileges. Go to install phpbb and it say's can't connect, now cPanel Database page is broken!? I am admin of the WHM/cPanel server. I don't know how to fix this, please help.0 -
This issue is completely unrelated to the issue noted in this thread @pheberta if you're still experiencing issues with this Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved. Thanks! 0 -
There's a problem again with 10.3.26-MariaDB I downgraded to 10.3.25-MariaDB And it's working again. When it's on .26 it's showing: The MySQL server is currently offline. adminbin Cpanel/cpmysql/DBCACHE: exit 11 This is the error: warn [cpmysql] Error (Invalid grant string: SET DEFAULT ROLE 0 FOR 'mycpaneluser'@'localhost' ) while parsing grant: SET DEFAULT ROLE 0 FOR 'mycpaneluser'@'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 956, line 1. 0 -
We had same issue, and solution was to downgrade as well. 0 -
Thanks for posting this!!! I was going nuts trying to figure this out. The yum downgrade worked: [CODE=bash]yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel 0 -
Thanks for posting this!!! I was going nuts trying to figure this out. The yum downgrade worked: [CODE=bash]yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Same - all servers were the same after the last update. Broken the cPanel Database interface yet again. Thanks for the temporary fix.0 -
Same here... but i wont downgrade, any updates of this broken the cPanel Database interface ?? 0 -
Hi, Again with the same problems: Broken the cPanel Database.. How long is that? Fix: yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel 0
Please sign in to leave a comment.
Comments
68 comments