Issue Plesk Migrator fails on mysql connection

[KDawson]

Server operating system version

Ubuntu 24.04 LTS

Plesk version and microupdate number

18.0.61

Running Plesk migrator shows:

Failed to fetch information from target servers

Cause: Command execution failed on the local server with non-zero exit code.

command: MYSQL_PWD="$(cat /etc/psa/.psa.shadow)" mysql --silent --skip-column-names -u admin psa -e 'SHOW VARIABLES LIKE '"'"'socket'"'"''
exit code: 1

stdout:

stderr: ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)
How do I get past this?

 

[KDawson]

For what it's worth, here are the mysql versions on migration source & target.

Source:
> mysql --version
mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1

Target:
> mysql --version
mysql Ver 15.1 Distrib 10.11.7-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

I was migrating sites between this pair without problems yesterday. Overnight, Plesk Obsidian 18.0.61 Update 5 was installed (f that matters).

 

[KDawson]

Also FWIW, /run/mysqld/mysqld.sock exists (it has all along). It ends with an "=" in an ls listing and the file utillity shows its type as "socket."

Doing ps -ax | grep mysql returns nothing, but ps ax | grep maria shows a mariadb process running.

 

[Kaspar@Plesk]

I am not sure. I suggest opening a ticket with Plesk support for assistance on the issue. To sign-in to support please go to https://support.plesk.com

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not provide support, here is an alternative:
https://support.plesk.com/hc/en-us/articles/12388090147095-How-to-get-support-directly-from-Plesk

 

[KDawson]

Thank you. I got my license directly from Plesk. Ticket created ( https://support.plesk.com/hc/en-us/requests/95277552 ).