SOLVED [CPANEL-16829] Transfer Tool with shared remote MySQL server

[Masimo]

I was getting a cluster configured with two web nodes and a dedicated MySQL server.
When I selected the Databases option when transferring the account, this is what appears in the logs:

[ 29940][RESTORE:1 ][A:mynewdom ]: Mysql
[ 29940][RESTORE:1 ][A:mynewdom ]: Preparing MySQL restore …
[ 29940][RESTORE:1 ][A:mynewdom ]: The system will not restore MySQL databases because this system shares a MySQL server with the source system.
[ 29940][RESTORE:1 ][A:mynewdom ]: Restoring MySQL privileges
[ 29940][RESTORE:1 ][A:mynewdom ]: Restoring MySQL grants
[ 29940][RESTORE:1 ][A:mynewdom ]:
[ 29940][RESTORE:1 ][A:mynewdom ]: Restoring MySQL access hosts
[ 29940][RESTORE:1 ][A:mynewdom ]: Storing MySQL Grants
[ 29940][RESTORE:1 ][A:mynewdom ]: Mysql

Because both servers use the same server for MySQL, there's no need to transfer the databases.
Interestingly enough, even though the grants are restored, I'm still unable to view the database in the cPanel account on the new server.

cPanel developers have determined that this is in fact a bug with the Transfer Tool.

The case ID is CPANEL-16829 and should keep an eye on cPanel change log for the update:
68 Change Log - Change Logs - cPanel Documentation

Hope to have an update soon!

 

[cPanelMichael]

Hello,

Thank you for sharing. I'll monitor this case and update this thread with more information on it's status as it becomes available.

Thank you.

 

[Masimo]

Hello,

Thank you for sharing. I'll monitor this case and update this thread with more information on it's status as it becomes available.

Thank you.

Thank you!
Hope to be release soon, i have two huge server pending upgrade and transfer

 

[Novin]

Hello,
So far looking forward to fix this bug.

 

[cPanelMichael]

Hello,

I'll continue to monitor the case and update this thread once it's published.

Thank you.

 

[Novin]

Hello,

I'll continue to monitor the case and update this thread once it's published.

Thank you.

Thank you,
When fix this case?
We are waiting for a few months.
Please ....

 

[cPanelMichael]

Hello @Novin,

The case is tentatively scheduled for inclusion with cPanel & WHM version 72. I'll update this thread again once it's published. In the meantime, the temporary workaround is to manually backup the account on the source server, move the backup archive to the destination server, and then restore the backup archive on the destination server. We document how to backup and restore accounts from the command line at:

The pkgacct Script - Version 70 Documentation - cPanel Documentation
The restorepkg Script - Version 70 Documentation - cPanel Documentation

Let me know if you have any questions.

Thank you.

 

[Novin]

Hello,
Now published v72, when solve this problem?
we cant transfer manually, because huge of server (+4000 Account).

 

[cPanelLauren]

Hello,


This should be pushed soon for v72 but does not appear to be merged yet. We will update here once it's updated.

Thanks!

 

[Novin]

Hello,
I want transfer server, fix this problem or not?
Thanks

 

[cPanelMichael]

Hello @Novin,

Internal case CPANEL-16829 is not yet published and remains open. I don't have a specific time frame to offer at this time, however I'll update this thread with more information as soon as it's available. I've also linked this forums thread to the case to increase awareness.

Thank you.

 

[Novin]

Hello,
cPanel v76.0.14 is now Stable.
This problem when publish?
I'm waiting for 3 years, i cant move manually because I have more than +1200 accounts on the server

 

[cPanelMichael]

Hello @Novin,

The solution is not included with cPanel & WHM version 76. I don't have a specific time frame to offer at this time, but I'll continue to monitor the case and update this thread with more information as soon as it's available.

Thank you.

 

[cPanelMichael]

Hello Everyone,

The fix for CPANEL-16829 will come with cPanel & WHM version 82. You can monitor releases.cpanel.net to see more information about version 82 once it's closer to public release.

Let us know if you have any questions.

Thanks!

 

[Mrg]

We get the same issue with v86.0.18 :

we transfer in new cluster. so local db ip is the same for server from and server to. but the db server is a different one. (because new clsuter in other datacenter). how can we use transfer tool. may we can disable the check.
Preparing MySQL restore …
The system will not restore MySQL databases because this system shares a MySQL server with the source system.