Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Migrate to cPanel' started by dstana, Aug 10, 2018.

Tags:
  1. dstana

    dstana Well-Known Member

    Joined:
    Jul 6, 2016
    Messages:
    70
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Phoenix, AZ
    cPanel Access Level:
    Root Administrator
    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?
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,550
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,550
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:

    Code:
    # cat /root/.my.cnf
    [client]
    user=root
    password=my-root-mysql-password
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Christos_To

    Christos_To Registered

    Joined:
    Aug 14, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Athens
    cPanel Access Level:
    Root Administrator
    Hello everyone, i just registered to submit the same issue, i will try with my.cnf :)
     
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,550
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Christos_To,

    Sounds good. Let us know how it goes.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. dstana

    dstana Well-Known Member

    Joined:
    Jul 6, 2016
    Messages:
    70
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Phoenix, AZ
    cPanel Access Level:
    Root Administrator
    I guess this makes sense because Plesk doesn't have a root mysql user by default.

    You run
    Code:
    plesk db
    To access mysql from the shell.
     
  7. dstana

    dstana Well-Known Member

    Joined:
    Jul 6, 2016
    Messages:
    70
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Phoenix, AZ
    cPanel Access Level:
    Root Administrator
    So what's the solution for this? Do a root grant on everything and add /root/.my.cnf with root credentials?
     
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,550
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  9. dstana

    dstana Well-Known Member

    Joined:
    Jul 6, 2016
    Messages:
    70
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Phoenix, AZ
    cPanel Access Level:
    Root Administrator
    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.
     
  10. dstana

    dstana Well-Known Member

    Joined:
    Jul 6, 2016
    Messages:
    70
    Likes Received:
    8
    Trophy Points:
    8
    Location:
    Phoenix, AZ
    cPanel Access Level:
    Root Administrator
    So I got this to work by using the results of

    Code:
    cat /etc/psa/.psa.shadow
    As the password setting user=admin
     
    cPanelMichael likes this.
  11. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,550
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  12. mhatred

    mhatred Registered

    Joined:
    May 20, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    50
    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
     
  13. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,550
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  14. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,550
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

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

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice