MySQL Connection Error

Community Support Mail
1

Hello,

I connected to my VPS through SSH, I changed the root PWD for MySQL since I could not remember it, and I needed access to PHP myAdmin. After that I started receiving an email from “Hestia Control Panel” literally every 5 minutes, I’m full of emails now. The email reports the following:

Subject: MySQL connection error on v3.reboot

Can’t connect to MySQL localhost
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

And when I try to log to webmail I can’t anymore, I see this on the webpage:

Oops… something went wrong!

An internal error has occurred. Your request cannot be processed at this time.

For administrators: Please check the application and/or server error logs for more information.

Any suggestion?

Thank you very much!

2

You need to update the password in /usr/local/hestia/conf/mysql.conf

2 Likes
3

and in /root/my.cnf

2 Likes
4

Hello,

Thank you very much for your help, I change the pwd here as you and ScIT mentioned:

/usr/local/hestia/conf/mysql.conf
/root/my.cnf

The emails finally stopped, but no access to webmail yet, maybe I have to change the pwd also somewhere else?

Thank you!

Renato

5

For webmail check /var/log/nginx/domain/webmail.xxxx.com.conf

1 Like
6

Hi Eris,

Thank you, but I can’t manage to fix it, I really need to access to my emails. I checked the log file that you mentioned but doesn’t report anything useful, look:

165.225.196.228 - - [09/Mar/2023:11:52:57 +0000] “GET / HTTP/1.1” 500 426 “-” "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/1>

165.225.196.228 - - [09/Mar/2023:11:52:57 +0000] “GET / HTTP/1.1” 500 426 “-” "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/1>

165.225.196.228 - - [09/Mar/2023:11:52:58 +0000] “GET /favicon.ico HTTP/1.1” 404 1434 “https://webmail.json.ie/” "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/>

165.225.196.228 - - [09/Mar/2023:11:54:34 +0000] “GET / HTTP/1.1” 500 426 “-” "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/1>

165.225.196.228 - - [09/Mar/2023:11:54:37 +0000] “GET / HTTP/1.1” 500 426 “-” "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/1>

165.225.196.228 - - [09/Mar/2023:11:54:38 +0000] “GET / HTTP/1.1” 500 426 “-” "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/1>

I can’t see any error, what I can do to troubleshoot? That’s since I changed mysql pwd.

Thank you very much, your help is always very much appreciated.

Renato

7

/var/log/nginx/domain/webmail.xxxx.com.errror.log

1 Like
8

You won’t believe it, webmail.json.ie.error.log is in that folder but it’s an empty file:

root@v3:/var/log/nginx/domains# ls -al
total 44
drwxr-xr-x 2 root root 4096 Mar 9 12:25 .
drwxr-xr-x 3 root root 4096 Feb 12 03:29 …
-rw-r–r-- 1 www-data root 0 Oct 11 18:04 webmail.json.ie.error.log
-rw-r----- 1 www-data root 16323 Mar 9 12:06 webmail.json.ie.log
-rw-r----- 1 www-data root 4896 Mar 3 04:00 webmail.json.ie.log.1
-rw-r----- 1 www-data root 1020 Feb 22 10:59 webmail.json.ie.log.2.gz
-rw-r----- 1 www-data root 2429 Feb 18 18:02 webmail.json.ie.log.3.gz
-rw-r----- 1 www-data root 902 Feb 12 01:29 webmail.json.ie.log.4.gz
root@v3:/var/log/nginx/domains#

10

Try /var/log/roundcube/

11

Hi Eris,

I had to restore a previous snapshot on the server since I needed to access to my email, thank you and no worries, at the moment it’s fine like that, in the future I’m going to read more documentation to have more knowledge about how this works. I will open a new ticket as soon as I can because of a daily email that I’ve been receiving from the server with “Error: hestia-php update failed”, but when I have time. Thank you for your help, very much appreciated.

Renato