Unable to sync database from Acquia Cloud to local Windows machine

Unable to sync database from Acquia Cloud to local Windows machine

4 posts / 0 new
Last post
gary.conroy's picture
gary.conroy
Points: 0
Unable to sync database from Acquia Cloud to local Windows machine

Following the guidance on https://docs.acquia.com/articles/synchronizing-acquia-cloud-with-local-e... and doing the Conversion from Mac to Windows (plus some Googled tips) only gets so far:

  1. Install the necessary Windows tools: Git, Drush for Windows (ensuring that the Rsync components are installed) and Acquia Desktop
  2. Download the Drush integration from the Acquia Cloud site (Drush and API link)
  3. To ensure Drush works, use puttygen to export the SSH private key for Acquia access to /users/garyc/.ssh as id_rsa
  4. Take Dev site out of live development using the Acquia Cloud website interface
  5. Clone the site locally with a Git Bash command: git clone garyconroy@svn-1605.devcloud.hosting.acquia.com:garyconroy.git
  6. Import the newly cloned codebase (garyconroy) into Acquia Desktop. Give the database a name. Change the domain from localhost to localdev
  7. Opt to create a new MySQL database and use the the same database name as the Acquia database
  8. Run the Drupal install script to step through a complete basic installation
  9. Ensure folder write permissions on the codebase (Git Bash command: chmod g+w -R garyconroy)
  10. Add local machine's login (garyc) to www-data group. (Since my laptop is Vista Home Premium, I installed User Manager from XPHomeTools to do this)
  11. Change the /tmp directory in the drush alias file (step 2, above) to /Temp and use Windows to give the www-data group full permissions to this folder
  12. Change files in docroot to be owned by garyc/www-data (Git Bash command: chown -R www-data garyconroy)
  13. Add the following line to the alias file (step 2): $command_specific['rsync'] = array('mode' => 'rlptzO'); $command_specific['sql-sync'] = array('mode' => 'rlptzO');
  14. Try to do the database sync: (Git Bash command: drush sql-sync @dev @local --no-cache)

Falls over about here. Enter the SSH key password three times, type 'y' when asked to continue. Enter the SSH key password twice more and then...

rsync: connection unexpectedly closed (0 bytes received so far) [sender]
rsync error: error in rsync protocol data stream (code 12) at io.c(601) [sender=
3.0.7]
rsync: connection unexpectedly closed (0 bytes received so far) [Receiver]
rsync error: error in rsync protocol data stream (code 12) at io.c(610) [Receive
r=3.0.8]
Could not rsync from [error]

I've run a similar process on Ubuntu (getting past this stage before hitting a wall of permissions issues) but want the GUI comforts of Windows (especially when the new Acquia Desktop arrives).

What am I not doing? What am I doing wrong? Is the answer 'Buy a Mac?'

Status: 
Unresolved
staff@outdoored.com's picture
staff
Points: 5

Gary, thanks for sharing. I am having the same issue.

Anyone get sql-sync working on Windows? How?

rvonrauchhau's picture
Richard.vonRauchhaupt
Points: 0

Yes, it is possible. But its a bit of a pain. But certainly worth the effort.

The procedure I followed is pretty well documented here: http://www.mydrupaljourney.com/articles/2012/04/20/running-drush-rsync-w...

Steps 1,2 and 3 are critical. This related youtube video: http://www.youtube.com/watch?v=LsT2lZVt4Cg&feature=youtu.be replaces the need for Step 4 and 5

Key Points: Ensure the version of ssh you are using is

Also might need to modify your Windows PATH Variables so that it contains the paths for MYSQL, Drush and MsysGit.

You can also look into running a full cygwin environment. This was a much bigger pain for me to accomplish, but there are some benefits in being in a closer "Unix" environment.

I've been a big windows guy for a long time, but Drupal does lend itself to Unix so much that I just purchased a Macbook Pro 2 weeks ago. Setup was completely painless (as much as I hate to admit). =)

Let me know if you have other questions I'll be happy to try and help.

--Rich

lorcz@uwec.edu's picture
lorcz
Points: 2

I'm following the instruction from Acquia blog and I kept getting the following error when running drush sql-sync @drupal.prod @drupal.local

The external command could not be executed due to an application error. Error: no database record could be found for target @drupal.local

Status Change: 
Unresolved