{"action":"created","issue":{"url":"https://api.github.com/repos/drush-ops/drush/issues/1369","repository_url":"https://api.github.com/repos/drush-ops/drush","labels_url":"https://api.github.com/repos/drush-ops/drush/issues/1369/labels{/name}","comments_url":"https://api.github.com/repos/drush-ops/drush/issues/1369/comments","events_url":"https://api.github.com/repos/drush-ops/drush/issues/1369/events","html_url":"https://github.com/drush-ops/drush/issues/1369","id":74419357,"number":1369,"title":"Remove shell alias replacements","user":{"login":"ann--b","id":9339807,"avatar_url":"https://avatars.githubusercontent.com/u/9339807?v=3","gravatar_id":"","url":"https://api.github.com/users/ann--b","html_url":"https://github.com/ann--b","followers_url":"https://api.github.com/users/ann--b/followers","following_url":"https://api.github.com/users/ann--b/following{/other_user}","gists_url":"https://api.github.com/users/ann--b/gists{/gist_id}","starred_url":"https://api.github.com/users/ann--b/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ann--b/subscriptions","organizations_url":"https://api.github.com/users/ann--b/orgs","repos_url":"https://api.github.com/users/ann--b/repos","events_url":"https://api.github.com/users/ann--b/events{/privacy}","received_events_url":"https://api.github.com/users/ann--b/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2015-05-08T16:31:08Z","updated_at":"2016-12-22T14:07:41Z","closed_at":null,"body":"$drush --version ---> 7.0-dev\n\n---\n\nThe following command works:\n\n$ drush sql-sync @stg @dev --create-db --sanitize\n\n---\n\nThe following command, using shell alias replacements,  does not work:\n\n$drush @dev pull-db -v\n\n---\n\ndrushrc.php\n\n$options['shell-aliases']['pull-db'] = 'sql-sync {{#stg}} {{@target}} --create-db --sanitize';\n\n---\n\naliases.drushrc.php:\n\n$aliases['dev'] = array(\n        'uri' = 'local_uri',\n        'root' = 'local_drupal_root',\n    'variables' = array('mail_system' = array('default-system' = 'DevelMailLog')),\n    'path-aliases' = array(\n            '%dump' = '/home/local_user/drush-dump/dev-foo-' . date('Ymdhis') . '.sql',\n    ),\n    '#stg' = '@stg', \n    '#drupal-root' = 'local_drupal_root',\n    );\n$aliases['stg'] = array(\n    'uri' = 'remote_ip',\n    'root' = 'remote_drupal_root',\n    'remote-host' = 'remote_ip',\n    'remote-user' = 'remote_user',\n    'path-aliases' = array(\n            '%dump' = '/home/remote_user/drush-dump/stg-foo-' . date('Ymdhis') . '.sql',\n    ) \n);\n\n---\n\nOutput from $drush @dev pull-db -v:\n\nLoaded alias @dev from file /home/local_user/.drush/aliases.drushrc.php                                           [notice]\nInitialized Drupal 7.33 root directory at local_drupal_root                                                 [notice]\nInitialized Drupal site local_uri at sites/default                                                     [notice]\nLoaded alias @stg from file /home/local_user/.drush/aliases.drushrc.php                                           [notice]\nssh -o PasswordAuthentication=no remote_user@remote_ip 'COLUMNS=120 drush  --backend=2 --verbose --uri=remote_ip   [notice]\n--root=remote_drupal_root  sql-conf   --all 2&1' 2&1\n/usr/bin/php /usr/local/lib/drush/drush.php --php=/usr/bin/php  --backend=2 --verbose                           [notice]\n--uri=local_uri --root=local_drupal_root  sql-conf   --all 2&1\nYou will destroy data in db_name and replace with data from remote_ip/db_name.\nDo you really want to continue? (y/n): y\nStarting to create database on Destination.                                                                  [ok]\n/usr/bin/php /usr/local/lib/drush/drush.php --php=/usr/bin/php  --backend=2 --verbose                           [notice]\n--uri=local_uri --root=local_drupal_root --strict=0  sql-create   --create-db --sanitize 2&1\nInitialized Drupal 7.33 root directory at local_drupal_root                                                 [notice]\nInitialized Drupal site local_uri at sites/default                                                     [notice]\nCreating database db_name. Any possible existing database will be dropped!\nDo you really want to continue? (y/n): y\nExecuting: mysql --defaults-extra-file=/tmp/drush_uKQ4PV --database=information_schema --host=localhost --silent   /tmp/drush_2dnfDM\nCommand dispatch complete                                                                                       [notice]\nStarting to dump database on Source.                                                                         [ok]\nssh -o PasswordAuthentication=no remote_user@remote_ip 'COLUMNS=120 drush  --backend=2 --verbose                      [notice]\n--uri=local_uri --root=local_drupal_root --strict=0  sql-dump   --create-db --sanitize --gzip\n--result-file 2&1' 2&1\nUnable to load class Drush\\Sql\\Sql                                                                           [error]\nexception 'Drush\\Sql\\SqlException' with message 'Unable to find a matching SQL Class. Drush cannot find your [error]\ndatabase connection details.' in /usr/local/lib/drush/commands/sql/sql.drush.inc:669\nStack trace:\n#0 /usr/local/lib/drush/commands/sql/sql.drush.inc(348): drush_sql_get_class()\n#1 [internal function]: drush_sql_dump()\n#2 /usr/local/lib/drush/includes/command.inc(359): call_user_func_array('drush_sql_dump', Array)\n#3 /usr/local/lib/drush/includes/command.inc(210): _drush_invoke_hooks(Array, Array)\n#4 [internal function]: drush_command()\n#5 /usr/local/lib/drush/includes/command.inc(178): call_user_func_array('drush_command', Array)\n#6 /usr/local/lib/drush/lib/Drush/Boot/DrupalBoot.php(46): drush_dispatch(Array)\n#7 /usr/local/lib/drush/drush.php(76): Drush\\Boot\\DrupalBoot-bootstrap_and_dispatch()\n#8 /usr/local/lib/drush/drush.php(16): drush_main()\n#9 {main}\n\nCommand dispatch complete                                                                                       [notice]\nsql-dump failed.                                                                                             [error]\nCommand dispatch complete   \n\n---\n\nIt appears the local uri and local drupal root were sent to the remote server.\n\nssh -o PasswordAuthentication=no remote_user@remote_ip 'COLUMNS=120 drush  --backend=2 --verbose                      [notice]\n--uri=local_uri --root=local_drupal_root --strict=0  sql-dump   --create-db --sanitize --gzip\n--result-file 2&1' 2&1\n\nThank you.\n"},"comment":{"url":"https://api.github.com/repos/drush-ops/drush/issues/comments/268806364","html_url":"https://github.com/drush-ops/drush/issues/1369#issuecomment-268806364","issue_url":"https://api.github.com/repos/drush-ops/drush/issues/1369","id":268806364,"user":{"login":"weitzman","id":7740,"avatar_url":"https://avatars.githubusercontent.com/u/7740?v=3","gravatar_id":"","url":"https://api.github.com/users/weitzman","html_url":"https://github.com/weitzman","followers_url":"https://api.github.com/users/weitzman/followers","following_url":"https://api.github.com/users/weitzman/following{/other_user}","gists_url":"https://api.github.com/users/weitzman/gists{/gist_id}","starred_url":"https://api.github.com/users/weitzman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/weitzman/subscriptions","organizations_url":"https://api.github.com/users/weitzman/orgs","repos_url":"https://api.github.com/users/weitzman/repos","events_url":"https://api.github.com/users/weitzman/events{/privacy}","received_events_url":"https://api.github.com/users/weitzman/received_events","type":"User","site_admin":false},"created_at":"2016-12-22T14:07:41Z","updated_at":"2016-12-22T14:07:41Z","body":"I dont think anyone has gotten around to simplifying shell aliases. Thanks for the reminder to adjust docs when that does happen."}}
{"actor":{"display_login":"weitzman"}}