Issue plesk migration

[SFonoyet]

Server operating system version

os_Ubuntu 20.04

Plesk version and microupdate number

v18.0.73_build1800251009.17

Hello,

I am trying to replace an old Plesk server with a new one, both in different vlans on the same network (I am changing the hypervisor from vmware to virtuozzo)
I have both Plesk up and running.
The old server is a all in one server installation, the new server have the database and fileserver decentralized
The old server is a Plesk Obsidian v18.0.73_build1800251009.17 os_Ubuntu 20.04
The new server is a Plesk Obsidian v18.0.73_build1800251009.17 os_Ubuntu 24.04
As database both use MariaDB old one version 10.3.39 and the new 12.0.2
The old server has a "Web Pro Edition" 30 domains license, the new one has the 1-month trial license that comes with the installation, when I finish the migration, I will move the license from the old to the new.

 

[SFonoyet]

When I tried the migration extension I got this error:

Failed to generate migration list file
Cause: Command execution failed on the local server with non-zero exit code.
command: MYSQL_PWD="$(cat /etc/psa/.psa.shadow)" /usr/bin/mariadb --defaults-file=/etc/mysql/my.cnf --silent --skip-column-names -u admin psa -e 'SHOW VARIABLES LIKE '"'"'socket'"'"''
exit code: 1
stdout:
stderr: ERROR 1698 (28000): Access denied for user 'admin'@'localhost'

That is a critical error, migration was stopped.

I can run the command manually from the new server with the credentials i configured on the migration extension:

root@gallant-williams:/home/ubuntu# ssh root@192.*.*.26
root@192.*.*.26's password:
This server is powered by Plesk.
Run the 'plesk login' command and log in by browsing either of the links received in the output.
Use the 'plesk' command to manage the server. Run 'plesk help' for more info.

root@plesk06:~# MYSQL_PWD="$(cat /etc/psa/.psa.shadow)" /usr/bin/mariadb --defaults-file=/etc/mysql/my.cnf --silent --skip-column-names -u admin psa -e 'SHOW VARIABLES LIKE '"'"'socket'"'"''
socket /run/mysqld/mysqld.sock
root@plesk06:~#

I used some solutions I found around the forum to solve previous problems but i can’t find anything about this one.

Any clues?

 

[Sebahat.hadzhi]

@SFonoyet , have you tried the solution from the following article:

• https://support.plesk.com/hc/en-us/...-fails-Access-denied-for-user-admin-localhost

 

[SFonoyet]

hello,
i skiped that one because I have acces to the database:

root@plesk06:~# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 92331
Server version: 10.3.39-MariaDB-0ubuntu0.20.04.2 Ubuntu 20.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [psa]> status
--------------
mysql Ver 15.1 Distrib 10.3.39-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Connection id: 92331
Current database: psa
Current user: admin@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.3.39-MariaDB-0ubuntu0.20.04.2 Ubuntu 20.04
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 3 hours 35 min 33 sec

Threads: 109 Questions: 38313575 Slow queries: 16 Opens: 9944 Flush tables: 1 Open tables: 2000 Queries per second avg: 2962.466
--------------

MariaDB [psa]>

 

[Sebahat.hadzhi]

Thank you for the confirmation. Could you please still double-check if any of the following files exist on the server and contain invalid credentials:

• /root/.my.cnf
• /etc/mysql/conf.d/client-mariadb.cnf
• /etc/mysql/debian.cnf