problem to CWP->CWP Migration

Started by bablil, October 29, 2019, 04:11:04 PM

Previous topic - Next topic

bablil

There is a problem with the CWP-> CWP Migration system

I used the system to move websites from one server to another
Only files and emails are moved, databases are not moved
what's the problem ?



gemisu

Hello everyone, today I have exactly the same problem, and I have been trying to migrate for more than a week without result.

ejsolutions

#4
There's a gotcha in that port 2304 needs to be opened on both firewalls, plus your ssh port(s).
After updating authorized_keys..

Appears to work fine.
When you create/edit the API key, in addition to clicking CWP to CWP, ensure that you also click the appropriate entries in the List column i.e.
Account    
Account Details    
Account Quota    
AutoSSL    
Cronjobs Users    
Domains and Subdomains    
Emails
Ftp Manager    
Metadata Account    
MySQL Databases    
MySQL Users    
Packages    
Quota limit

josemnunez

You can check the cause of the problem in the error log

/var/log/cwp/account_transfer.log

gemisu

Hi friend.
It doesn't work for me.
I deactivated the firewall on the two servers to avoid any blockage, and created the api with everything checked, and even so when transferring one or more accounts, only the files pass (all) but not the data bases.

josemnunez

Can you send the fragment of the logs where it shows the result of the mysql transfer?

tail -n 100 /var/log/cwp/account_transfer.log

gemisu


2020-04-06 14:09:03 Resp acc list: OK
2020-04-06 14:09:04 Resp acc list: OK
2020-04-06 14:09:04 Resp acc list: OK
2020-04-06 14:09:05 Resp acc list: OK
2020-04-06 15:36:23 true
--> export SSHPASS='mypass@'; /usr/bin/sshpass -e /usr/bin/ssh -p myport -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o LogLevel=quiet  root@myip test -d /usr/local/cwp/ && echo 'true' || echo 'false' 2>&1
2020-04-06 15:36:23 true
--> /usr/bin/ssh -p myport -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -o LogLevel=quiet root@myip test -d /usr/local/cwp/ && echo 'true' || echo 'false' 2>&1
2020-04-06 15:36:34 Resp acc list: OK
2020-04-06 15:36:40 Resp acc list: OK
2020-04-06 15:36:40 Resp acc list: OK
2020-04-06 15:36:41 Resp acc list: OK
2020-04-06 15:36:43 Resp acc list: OK
2020-04-06 15:36:43 Resp acc list: OK
2020-04-06 15:36:44 Resp acc list: OK
2020-04-06 15:36:44 Resp acc list: OK
2020-04-06 15:36:45 Resp acc list: OK
2020-04-06 15:36:45 Resp acc list: OK
2020-04-06 15:36:45 Resp acc list: OK
2020-04-06 15:36:46 Resp acc list: OK
2020-04-06 15:36:57 Resp acc list: OK
2020-04-06 15:36:57 Resp acc list: OK
2020-04-06 15:36:59 Resp acc list: OK
2020-04-06 15:36:59 Resp acc list: OK
2020-04-06 15:37:07 Resp acc list: OK
2020-04-06 15:37:07 Resp acc list: OK
2020-04-06 15:37:08 Resp acc list: OK
2020-04-06 15:37:08 Resp acc list: OK
2020-04-06 15:37:08 Resp acc list: OK
2020-04-06 15:37:09 Resp acc list: OK
2020-04-06 15:37:09 Resp acc list: OK
2020-04-06 15:37:09 Resp acc list: OK
2020-04-06 15:37:10 Resp acc list: OK
[root@cloud1 ~]#

gemisu

the previous answer is the log you asked me for

any ideas ?

ejsolutions

Crikey! 20 minutes later, looking for answers on a free forum!  ::)

ejsolutions

From reading another unrelated thread..
The list mentioned above should have Autologin included. Though not apparent what it does, seemingly this is for phpmyadmin functionality, so you'll want that included too.

CWP Lovers

#12
hi, is anyone have the solution? I have same problem too when doing cwp to cwp migration, database not copied, it's crazy when we put this panel to production. need to think 1000 times for using this panel for hosting production.

cinique

Quote from: Onfirecloud ID on July 30, 2020, 03:09:24 AM
hi, is anyone have the solution? I have same problem too when doing cwp to cwp migration, database not copied, it's crazy when we put this panel to production. need to think 1000 times for using this panel for hosting production.
Posting the same thing in multiple threads is known as spamming.
I have warned people for months/years that CWP is akin to beta software and to be extremely cautious about its' use in a production environment. If the devs were more open and take onboard suggestions/criticism then things may change.
I haven't tried a migration in quite some time but it worked (mainly) back then and there is the alternative of a backup/restore. A combination of the two might be required; plus there is the posted custom backup.
CWP can assist in the running of a server but it doesn't replace the need for more than rudimentary knowledge in being a sysadmin.
/soapbox

geeth

I am attempting to migrate user accounts from CWP to CWP. Unfortunately, only 7 out of 9 accounts are syncing. The other 2 accounts are not appearing in the remote server list. If someone can help with this issue would be appreciated.