SOLVED [CPANEL-22101] Account list in Transfer Tool empty when migrating from Plesk

[dstana]

I have a server currently running Plesk that needs to be migrated to another host. While I'm at it, I figured I might as well move it over to WHM. In the docs, the transfer tool is supposed to be compatible with Plesk.

As a test, I logged in via the transfer tool with root creds on one of my other servers. Login is successful, but it doesn't show any accounts.

Is there something else that needs to be done to make the accounts available for transfer?

 

[cPanelMichael]

Hello @dstana,

No additional steps beyond entering the remote server's login credentials in WHM >> Transfer Tool should be required to fetch the list of accounts to migrate. Can you open a support ticket so that our Migrations team can take a closer look to see why the accounts from the Plesk server are not showing up? We document how to open the support ticket to our Migrations team at:

cPanel Migration Services and Guides - cPanel Knowledge Base - cPanel Documentation

Thank you.

 

[cPanelMichael]

Hello,

We're currently tracking an issue where WHM >> Transfer Tool fails to return a list of accounts when the source server uses Plesk version 17 and is missing the /root/.my.cnf file. The internal case number is CPANEL-22101. I'll monitor the case and update this thread with more information as it becomes available. In the meantime, the temporary workaround is to generate the /root/.my.cnf file on the Plesk server and initiate the transfer again. Here's an example of how /root/.my.cnf should look:

# cat /root/.my.cnf
[client]
user=root
password=my-root-mysql-password

Thank you.

 

[Christos_To]

Hello everyone, i just registered to submit the same issue, i will try with my.cnf

 

[cPanelMichael]

Hello everyone, i just registered to submit the same issue, i will try with my.cnf

Hello @Christos_To,

Sounds good. Let us know how it goes.

Thank you.

 

[dstana]

I guess this makes sense because Plesk doesn't have a root mysql user by default.

You run

plesk db

To access mysql from the shell.

 

[dstana]

So what's the solution for this? Do a root grant on everything and add /root/.my.cnf with root credentials?

 

[cPanelMichael]

So what's the solution for this? Do a root grant on everything and add /root/.my.cnf with root credentials?

Hello,

You shouldn't need to adjust the MySQL grants. Simply creating the /root/.my.cnf with the proper credentials should act as a workaround. Or, feel free to submit a complimentary migration request using the steps documented below and one of our Migration Specialists will complete this for you:

cPanel Migration Services and Guides - cPanel Knowledge Base - cPanel Documentation

Thank you.

 

[dstana]

I just tested this and it doesn't work.

I think the problem is that by default, root isn't a mysql user in Plesk. They have it renamed to 'admin'.

I'll try the grants and report back.

 

[dstana]

So I got this to work by using the results of

cat /etc/psa/.psa.shadow

As the password setting user=admin

 

[cPanelMichael]

Hi @dstana,

Thanks for sharing the workaround. Work on case CPANEL-22101 is now finished and the fix is planned for publication with cPanel & WHM version 76.

Thank you.

 

[mhatred]

I am having same issue but remote server has pleks 12.5

Can any give me steps to resolve this issue so that we can go ahead and do the migration
I am getting message "The source server is using plesk. Service Configuration transfer is only available when the source server is using cPanel & WHM."

Let me know what changes to be made on remote plesk server so that WHM can fetch account list from plesk server

 

[cPanelMichael]

I am getting message "The source server is using plesk. Service Configuration transfer is only available when the source server is using cPanel & WHM."

Hello @mhatred,

You should be able to utilize the same workaround instructions from my earlier post. Can you let me know if that helps?

Thank you.

 

[cPanelMichael]

Hello,

To update, while it's not referenced in our change logs, this is fixed as of cPanel & WHM version 76.0.14.

Thanks!