Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22550

Upgrade to MariaDB 10.3.23 broke the cPanel Databases interface

    XMLWordPrintable

    Details

      Description

      Details

      After 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

            Activity

              People

              Assignee:
              rinat.ibragimov Rinat Ibragimov
              Reporter:
              cPanelSTA cPanel Senior Tech's
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration