Jump to content

MySQL server is currently offline


Recommended Posts

Posted (edited)

Symptoms

Updating from MariaDB 10.3.22 to 10.3.23 breaks the cPanel -> MySQL Databases interface. This MariaDB update occurs automatically when updating cPanel with a version that includes support for MariaDB 10.3.

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_cpdamak3oz' on host 'localhost' DBDISKUSED cpuser_user 0 DISKUSED 0 DB cpuser_user USER cpuser_db"

I44GUZH.png 

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_cpdamak3oz' 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_cpdamak3oz' 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.

For reference, the case number is CPANEL-32712. Follow this article to receive an email notification when a solution is published in the product. 

 

Workaround

A fix is being worked on by our developers, however, there is no known workaround at this time. We recommend updating to cPanel version 88, presently in the CURRENT build tier if an immediate solution is required.

 

https://support.cpanel.net/hc/en-us/articles/360048322953-Updating-to-MariaDB-10-3-23-on-cPanel-breaks-the-MySQL-Databases-interface

https://forums.cpanel.net/threads/cpanel-32712-updating-to-mariadb-10-3-23-on-cpanel-breaks-the-mysql-databases-interface.672141/

Edited by Thiago Sabaia
Inclusão do Link do Forum
Link to post
Share on other sites
  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Posts

Symptoms Updating from MariaDB 10.3.22 to 10.3.23 breaks the cPanel -> MySQL Databases interface. This MariaDB update occurs automatically when updating cPanel with a version that includes sup

Por aqui, optei por atualizar a versão do cpanel (pois usamos versão stable), a versão current resolveu o problema...

E respondendo a pergunta do colega, aqui utilizamos cloudlinux sim...

Um detalhe, o multiphp.ini ta sem opção...ou seja, o cliente obrigatóriamente precisa editar o php.ini na aba editor.

Aconteceu isso com mais alguém que optou pela atualização do cpanel?

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.




Chat

Chat

    You don't have permission to chat.
    ×
    ×
    • Create New...