cPanel / WHM Mysql offline

[Quintanilha-RJ]

Good afternoon, I wanted to ask the help of the friends of the forum!

I currently have a cpanel/whm server with cloudlinux 8.6.0, and Database MariaDB 10.5

I'm having a problem with my database, it's suddenly going offline, to get back online I have to go online again. but this is happening constantly and I don't find the solution.

I currently have installed:

firewall configserver Security & Firewall
configserver Exploit Scanner
configserver Outgoing Spam Monitor

I also checked the server and noticed that I have some services with pending status on the server as shown in the print below.

I also tried changing the port in mysql in the file

/etc/my.cnf

But I was not successful also according to the cpanel tutorial in this link

https://support.cpanel.net/hc/en-us/articles/4403290601879-How-to-change-MySQL-Port-

If anyone can help me, I would appreciate it, thank you all in advance

 

[ffeingol]

Without some logs from MariaDB I doubt anyone will be able to help you much.

 

[Quintanilha-RJ]

Can you provide me with the command that I can generate this mariaDB log!

 

[ServerHealers]

I'd suggest checking at /var/lib/mysql/HOSTNAME.err (make sure to replace HOSTNAME with your actual server hostname. If this isn't there, then I would suggest checking this article https://support.cpanel.net/hc/en-us...able-or-Set-the-Error-Log-in-MySQL-or-MariaDB on how to enable logging in MySQL/MariaDB.

 

[kodeslogic]

If logs are not in /var/lib/mysql/HOSTNAME.err then check the MySQL configuration file (/etc/my.cnf) it should have information about the MySQL log file.

Something like:

log-error=/path/to/the/log-file