Resolved Plesk Backup Fails

[Melika]

Hi everyone,
I have this problem I hope you can help me with ...
When I try to generate a backup from inside a subscription in Plesk i get this error :

Dump failed
The following domains were not found on the host
No objects to dump found

I tried this solution :
Backups are failing: The following domains were not found on the host

and unfortunately, this didn't work because libdbd-mysql-perl was already installed.

I checked the backup.log file and my error is a bit different than what is mentioned in the KB article. Here is my error:

DBI connect('dbname=psa;host=localhost;port=3306','admin',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

I use MariaDB on my server and i can see that there is no mysql.sock in /tmp
Also, I use Plesk Onyx 17.5.3 Update #21

Any ideas?

 

[UFHH01]

Hi Melika,

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

there is no mysql.sock in /tmp

Did you consider to CREATE the missing link?

Example command ( logged in as user "root" over SSH ):

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

If the "mysql.sock" is not located at the path from the above example, pls. consider to locate the correct path and name - definition by inspecting your database - server - configuration files:

find /etc -type f -name "*.cnf" -exec grep --color -Hni "mysql.sock" {} \;

or

find /etc -type f -name "*.cnf" -exec grep --color -Hni "mysqld.sock" {} \;

OR

find /etc -type f -name "*.cnf" -exec grep --color -Hni "sock" {} \;

 

[Melika]

Thank you very much for your reply.

I tried the solution above.
My mysql.sock file was located in /var/run/mysqld/mysqld.sock so i ran the command like this :

ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

Now even though mysql.sock exists in /tmp but still i get the exact same error.

I ran this command to check the symlink :

ls -l /tmp/mysql.sock

The output seems to be fine :

lrwxrwxrwx 1 root root 26 Sep 16 16:01 /tmp/mysql.sock -> /var/run/mysqld/mysql.sock

 

[Melika]

uh ... opps! i was missing a "d" at the end!
the problem is solved now.
Thank you very much for your support