search

welaika / wordmove

Multi-stage command line deploy/mirroring and task runner for Wordpress
https://wptools.it/wordmove
MIT License
1.87k stars 165 forks source link

wordmove push/pull database fails without an error #286

Closed mattydaw closed 6 years ago

mattydaw commented 8 years ago

Hi. I have managed to iron out a few of the snags i have been hitting trying to get Wordmove running for the first time. Unfortunately when I run wordmove push -d it comples without any errors but the remote database doesn't change.

Has anyone else experienced this or can offer any suggestions?

I am on osx running the wordmove command from ssh inside a virtual box (vagrant - Ubuntu 14.04.4).

The terminal output i get is:

▬▬ ✓ Pushing Database ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ mysqldump --host=xx.xxx.x.xx --user=xxxxxx --password=xxxxxx xxxxxx --result-file=/var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql remote | mysqldump --host=xx.xxx.x.xx --user=xxxxxx --password=xxxxxx xxxxxx --result-file=/var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql Text will be echoed in the clear. Please install the HighLine or Termios libraries to suppress echoed text. xxxxxx@xxxxxx's password:xxxxxx remote | get: /var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql /srv/www/xxxxxx/htdocs/wp-content/live-backup-1456322525.sql remote | delete: /var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql mysqldump --host=127.0.0.1 --user=root --password=root xxxxxx --result-file=/srv/www/xxxxxx/htdocs/wp-content/dump.sql local | mysqldump --host=127.0.0.1 --user=root --password=root xxxxxx --result-file=/srv/www/xxxxxx/htdocs/wp-content/dump.sql local | adapt dump remote | put: /srv/www/xxxxxx/htdocs/wp-content/dump.sql /var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql mysql --host=xx.xxx.x.xx --user=xxxxxx --password=xxxxxx --database=xxxxxx --execute=SOURCE\ /var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql remote | mysql --host=xx.xxx.x.xx --user=xxxxxx --password=xxxxxx --database=xxxxxx --execute=SOURCE\ /var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql remote | delete: /var/sites/t/xxxxxx.co.uk/public_html/wp-content/dump.sql local | rm /srv/www/xxxxxx/htdocs/wp-content/dump.sql

Then i am back to the command prompt.

Thanks in advance. Matt

leifjohn commented 8 years ago

I am having the exact same issue right now. Running wordmove on VVV ssh. #282

leifjohn commented 8 years ago

I have found that if I switch to ftp in my movefile that I am able push files no problem, but then I receive an error when it tries to push the database. If I update my movefile back to ssh and push the database - no errors, but the remote database was not actually updated. #282

mattydaw commented 8 years ago

Hi @leifjohn it is frustrating isn't it. It feels like i am very close to it working as well.

I should have added that everything other than the database pushes and pulls fine. I tried to get ftp working as a temp solution but that failed with errors. Looked like it was due to lftp being missing on the remote server (and i don't have permission to add it) so that was a brick wall.

And i am using VVV too.

leifjohn commented 8 years ago

So quick update, I just tried to SSH via the terminal into my remote server and I get this errror

This account is restricted by rssh.
Allowed commands: sftp
mattydaw commented 8 years ago

I can ssh into my remote server and the local virtualbox successfully. Although I can't get the key authentication to work with my remote server (again host limitation - whilst experimenting with getting this dev workflow established I have just been using a shared host - starting to think I need my own box so can control the services better - I have limited systems experience!). The remote server asks for my password each time when I run wordmove too.

However we have in common the fact that it completes without throwing an error. I find that even stranger with your experience as I would expect a ssh connection error to be returned.

On 24 Feb 2016, at 18:03, leifjohn notifications@github.com wrote:

So quick update, I just tried to SSH via the terminal into my remote server and I get this errror

This account is restricted by rssh. Allowed commands: sftp — Reply to this email directly or view it on GitHub.

leifjohn commented 8 years ago

I switched to a different remote server where I had full SSH capabilities and managed to get things working. I followed the wiki on getting wordmove installed inside the vvv environment and running it inside vagrant.

mattydaw commented 8 years ago

Haha. We must be working in parallel @leifjohn ! I tried a few providers yesterday and successfully got it working only this morning too. Glad we are both up and running now.

A couple of snags i hit were:

I am trying out https://www.digitalocean.com at the mo, who have some great integrations. You can even build droplets direct from vagrant on local - although i have not tried this yet.

alessandro-fazzi commented 8 years ago

Guys glad to see you're finding a path. Some thoughts follows

First of all I think errors should be returned if something goes wrong on the remote side. And through SSH this should be easier. It's really strange @mattydaw didn't noticed the lack of mysqldump, for example. The command is invoked so I'd expect you to see a "command not found" or similar on the terminal...I'm a bit confused.

Secondly: Wordmove is written to work in the majority of cases...but we have to say: sometime hosting providers do their best to keep its work hard.

In the last few weeks we've done a lot of improvements to the documentation, so a advise you to take the time to go through the new README and the new wiki articles. Some of your doubts should have been preliminary fixed. And please, feel free to improve the documentation.

About the VVV doc we all are in debt with the great work done by @joeguilmette :)

We're following you both in your adventure. Good luck. And remember to close the issue when you are done.

Cheers