Pre-migration warnings are shown by Plesk Migrator: Failed to decrypt password of auxiliary user ‘jdoe’. Password may be reset

Symptoms

• Pre-migration warning is shown when migrating a site at Plesk > Tools & Settings > Migration & Transfer Manager:

  Failed to decrypt password of auxiliary user 'jdoe'. Password may be reset

• Migration of the databases fails with the errors:

  MySQL databases:

  Failed to copy content of database 'example_db'
  Migration tools tried to perform operation in 3 attempts: Command execution failed on the source server 'source' (203.0.113.2) with non-zero exit code.
  command: "C:Program Files (x86)ParallelsPleskMySQLbinmysqldump" -h localhost -P 3306 -uadmin -p***hidden*** example_db --result-file=C:plesk_migratordb_backup_example.com_example_db.sql --routines --events
  exit code: 2
  stdout:
  stderr: mysqldump: [Warning] Using a password on the command line interface can be insecure.
  mysqldump: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: YES) when trying to connect

  MSSQL databases:

  Failed to copy content of database 'Example_db'
  ...
  Failed to execute SQL query: Login failed for user 'sa'. DB-Lib error message 18456, severity 14:
  General SQL Server error: Check messages from the SQL Server
  DB-Lib error message 20002, severity 9:
  Adaptive Server connection failed
  DB-Lib error message 18456, severity 14:

Cause

The file %plesk_dir%adminbinphp.exe file is missing from the Plesk source server.

Resolution

1. Connect to the source server via RDP

2. Create the directory C:plesksupport

3. Download the package plesk-engine.msi

   1. Open Plesk for Windows repository

   2. Find the package for the Plesk version in use and download file plesk-engine.msi:

      For example:

      • Plesk Onyx 17.8: https://autoinstall-win.plesk.com/PANEL-WIN_17.8.11/dist-windows/plesk-engine.msi
      • Plesk Obsidian 18.0.31: https://autoinstall-win.plesk.com/PANEL-WIN_18.0.31/dist-windows/plesk-engine.msi

4. Open CMD as administrator

5. Extract the files from the downloaded package into C:plesksupport:

   C:> msiexec /a "C:UsersAdministratorDownloadsplesk-engine.msi" /qb TARGETDIR=C:plesksupport

6. Copy the C:plesksupportProgram FilesPleskadminbinphp.exe into %plesk_dir%adminbin directory;

7. Log into the target Plesk server

8. Go to Tools & Settings > Migration & Transfer Manager > 203.0.113.2 > click 'Reload source data'

9. Proceed with migration