Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Fix
-
10.3.23
-
None
Description
DetailsAfter the update yesterday to MariaDB 10.3.23 (from 10.3.22), we have had a lot of reports of the cPanel Database page not working (in cPanel version 86). This appears related to the change recently made, because of MDEV-20076 ("SHOW GRANTS does not quote role names properly") / commit https://github.com/MariaDB/server/commit/fafb35ee51. This type of big change in a point release shouldn't happen.
The cPanel >> Databases page shows:
|
|
"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 are shown in the cPanel error log at /usr/local/cpanel/logs/error_log:
|
|
[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. |
|
|
|
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. |
|
We are not advising customers to downgrade, as there were problems and the update has CVE fixes in them. Customers can upgrade to version 88 (CURRENT tier), but that is not our STABLE or RELEASE tier at this time.
Attachments
Issue Links
- relates to
-
-
- Closed
-