Question plesk login returns DB query failed: SQLSTATE[HY000] [2002]

[mathi_reg]

Hey guys,

I had issues on my server. Upgraded the volume size today from 10gb to 20gb after finding out with df -h that 100% capacity was used.

I was able to restart plesk, apache. But mysql doesn't work. Also other weird things happening via SSH.

e.g.

plesk login

returns

DB query failed: SQLSTATE[HY000] [2002] No such file or directory

I can't start mysql or mysqld. Always says:

service mysqld start
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

This is rather urgent as my site is currently down. Anyone able to help me out here?

 

[IgorG]

Any details why MySQL can't be started from MySQL log?

Plesk for Linux services logs and configuration files

Applicable to: Plesk for Linux Question Where to find Plesk for Linux services logs and configuration files? Answer This article's sole purpose is to provide information regarding the services t...

support.plesk.com

 

[mathi_reg]

Hey @IgorG

no I don't know why.

I also can't login to my plesk anymore. If I do plesk login and click on the link I always get 18-196-2-65.plesk.page took too long to respond.

 

[IgorG]

I also can't login to my plesk anymore

Try to run

# plesk repair installation

 

[m3lezZ]

Hey @IgorG

no I don't know why.

I also can't login to my plesk anymore. If I do plesk login and click on the link I always get 18-196-2-65.plesk.page took too long to respond.

If the plesk repair doesent work, please share the log output with us, so we can investiagte for more informations to help you.

 tail -n60 /var/log/mariadb/mariadb.log

 

[mathi_reg]

Aah, also just understood that the machine has new IP address. EC2. Now when logging in I use for instance [email protected] but plesk login provides a different IP in the login page, but also changing that manually doesn't work. DNS PROBE NOT FINISHED

 

[mathi_reg]

this is not the IP address that the EC2 has.

 

[m3lezZ]

cat /etc/mysql/my.cnf | grep log_error

log_error = PATH LOG

Than run

tail -n60 PATH LOG

 

[mathi_reg]

 

[m3lezZ]

Please make a cat on your my.cnf, there you see the path where the logfile is located. PATH LOG was just a placeholder for your path.

 

[mathi_reg]

@m3lezZ sorry, I was not able to work on this last week but now I'm back on this:

Sorry, I don't know what you mean by where the log files is located. The first command works fine. The file my.cnf exists and I can do the grep log_error.

If I make a cat on the my.cnf file I get this:



There is not log path or anything in there.

 

[mathi_reg]

As pointed out further above, the IP address of the Plesk server is not matching the actual IP address of the machine (EC2) is different then when doing this How to change the IP address of the Plesk server?

Also when sshing you see the wrong address ubuntu@ … does this maybe cause the troubles of not being able to run plesk login?

 

[mow]

Try:
journalctl -x -u mysqld

Also please post the output of "ifconfig", "route -n" and "cat /etc/hostname /etc/hosts ".

 

[mathi_reg]

@mow thanks for getting back to me.

 

[mathi_reg]

@mow @m3lezZ any news here for me? thanks in advance.

 

[mow]

The IP seems to be configured correctly, the system just has no understanding that 18-196-2-61 is supposed to be an IP.
However, 172.* is an internal IP range, just like 10.* and the more widely known 192.168.*
This will NOT be reachable from outside, so it's no wonder that the address plesk shows (which is probably the 172.31...) will not work.
That you also are not able to use the 18.195.210.132 might have two reasons:
1) when mysql doesn't work, the plesk admin panel won't work either
2) the NAT router which translates 18.195.210.132 to the internal IP doesn't portforward 8443 to your machine

Did you order that EC2 instance as a public-facing server at all? Is preisvergleich123.com your site?

Try
systemctl status mysql.service
systemctl status mariadb.service
(only one of those two will work, I don't know which is the correct one for ubuntu)

journalctl -x -u mariadb
mysqld --print-defaults
dpkg -l |grep mariadb

 

[mathi_reg]

Hey @mow

fyi, the website itself which uses mysql is running though normally. I have one wordpress site running on the plesk machine and this works fine.
preisvergleich123.com is not my site, no

The EC2 was simply launched with the Plesk Environment on AWS itself.

Here is the output for all commands above:

 

[mow]

fyi, the website itself which uses mysql is running though normally. I have one wordpress site running on the plesk machine and this works fine.

What happens if you use that site's domain and add :8443 after the domain name?
Does the domain resolve to the same IP that you use for ssh login? If not, there is some very weird routing going on ...

 

[mathi_reg]

@mow … oh man, that works!

However very slow it seems. The "admin-panel" loads very very long for each new request. Do you know why that could be?
The main site is fast though, but the domain.com:8443 is very slow loading and responding.

 

[mathi_reg]

Also when logging in via SSH on the machine it says "Restart required" … how do I do that?