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

cPanelLauren

• May 13, 2020 01:12

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

• 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:

• 

  Steini Petur

  • November 06, 2020 08:04

  Same here... but i wont downgrade, any updates of this broken the cPanel Database interface ??

  
  I can confirm that the downgrading is 100% successrate on 9 nodes in our fleet, then /etc/cpupdate.conf turned RPMUP to manual until cPanel releases a patch. Already had 4 support tickets on this, couldn't just leave this for days. You should be fairly safe with going down a version.

  0
• 

  dgprasetya

  • November 06, 2020 08:09

  I can confirm that the downgrading is 100% successrate on 9 nodes in our fleet, then /etc/cpupdate.conf turned RPMUP to manual until cPanel releases a patch. Already had 4 support tickets on this, couldn't just leave this for days. You should be fairly safe with going down a version.

  
  i think i don't need to downgrade, cPanel has updated on their articles: Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline. just need time for this alter mysql, tonight maybe ...

  0
• 

  dgprasetya

  • November 06, 2020 17:11

  ok solved, just run : /scripts/autorepair fix_mariadb_show_grants_roles
  but dump first our mysql db for backup mysqldump mysql > backup-mysqltables.sql
  

  0
• 

  Benito

  • November 07, 2020 12:54

  The fix didn't work for me and i had to downgrade and lock again.

  0
• 

  webmastergreg

  • November 08, 2020 00:09

  Hi do you think this could be the cause of my issue with a script that I use ? Since the November 4, now when I login in this particular website, the connexion takes forever and mysql process bump in full load, then process killed and sql server gone away. But all my others site are completely ok. and I'm with MDB 10.2.35 php7.4.11 (sorry if off topic) Edit: Ok I think yes this is totally related, some users complain about version 10.2.35 see here: MariaDB 10.2.35 - Major performance issues - ZABBIX Forums And this is my exact same case, but how can we roll back to 10.2.34, if only we could choose in WHM which version to use...so much simpler.

  0
• 

  jonam_mafia

  • November 08, 2020 21:32

  Edit: Ok I think yes this is totally related, some users complain about version 10.2.35 see here:

  0
• 

  Benito

  • November 09, 2020 13:18

  In my case, i still have the problem with one customer. His sites stopped comunicating with the databases. The solution was changing his php version from 7.2 to 7.3 Regards,

  0
• 

  webmastergreg

  • December 03, 2020 17:20

  Hi all, we are now with MariaDB 10.2.36 And no more issue

  0

Please sign in to leave a comment.