welaika/wordmove — Issue #3: Unable to connect
Author: odddog
Created: 2011-12-09 09:11:39+00:00
State: open

Thanks for adding more details to the output. That was helpful.

I'm still getting errors, though. The first error is:

$ wordmove pull
Pulling the DB...
SSH authentification failure, please double check the SSH credentials on your Movefile!

SSH info is correct. See here:

$ ssh root@xx.xx.xx.xx
root@xx.xx.xx.xx's password:
Last login: Thu Dec 8 13:15:31 2011 from xx.xx.xx.xx

I can SSH in, run the same mysql method you've used, and it works. Not sure why this isn't working though. I added skip-grant-tables to my.cnf file, opened up 3306 in the firewall, etc. It just won't work. Running it myself gives this:

# mysqldump --host=localhost --user=xxxxxx --password=xxxxxx abc123DBname
-- MySQL dump 10.13 Distrib 5.1.58, for redhat-linux-gnu (x86_64)
. . .
-- Dump completed on 2011-12-09 1:08:10

So, I used the skip_db option instead to see where I could get next. This is where the second error occurs. Using a tilde in the wordpress_path variable returns this:

rsync: push_dir#3 "/Users/me/dev/website/~/dev/website/wp-content" failed: No such file or directory (2)

To get around this, I've used the absolute path without the tilde and it works:

$ wordmove pull --skip_db
Pulling wp-content/uploads...
root@xx.xx.xx.xx's password:
Pulling wp-content/themes...

Do you know what's causing the database issue? This is the biggest advantage of this script and I desperately want to get it working.

Would you be able to set up this script for an atypical WordPress install – one which stores uploads into /assets instead of wp-content/uploads? Or just a way for it to skip a directory if it's not found and keep on moving?