CRIN Trac: Ticket #18: Drush

hours changed; totalhours set

chris — Fri, 12 Jun 2015 16:49:34 GMT

hours changed from 0 to 0.15
totalhours set to 0.15

Here is the error:

su - www-data -s /bin/bash
/usr/local/bin/drush --root=/var/www/drupal --uri=www.crin.org -dv pm-updatestatus
...
  ERROR 1045 (28000): Access denied for user 'drupal'@'crin2' (using password: YES)
...

And this is a open issue on Github:

https://github.com/drush-ops/drush/issues/965

So I think the Drupal cron job will need to be set up to use wget rather than drush, see: ticket:6#comment:29

hours, totalhours changed

chris — Sat, 13 Jun 2015 11:44:26 GMT

hours changed from 0 to 0.2
totalhours changed from 0.15 to 0.35

Looking at setting up the Drupal cronjob, first get a one time login:

sudo -i
su - www-data -s /bin/bash
cd drupal/
drush uli

Following this documentation it turns out that the site is set to use "poor mans cron" every 3 hours, see the cron config page, so the www-data crontab was commented out.

I'm leaving this ticket open as the web developers might need to have drush available for SQl commands and stunnel or a SSH tunnel was used for the MySQL traffic then drush would fully work.

cc, hours, totalhours changed

chris — Mon, 06 Jul 2015 16:53:18 GMT

cc peter added
hours changed from 0 to 0.05
totalhours changed from 0.35 to 0.4

Peter has been added to this ticket. See also ticket:27.

Replying to chris:

I'm leaving this ticket open as the web developers might need to have drush available for SQl commands and stunnel or a SSH tunnel was used for the MySQL traffic then drush would fully work

Drush running SQL commands does appear to work as root:

sudo -i
cd /var/www/drupal
drush sqlq "show tables"
  actions
  ...

But not as another user:

sudo -i
su - www-data -s /bin/bash
cd /var/www/drupal
drush sqlq "show tables"
  Query failed.                [error]

Peter -- any better idea than simply doing everything as root (this might not be the worst idea...)?

hours, status, totalhours changed; resolution set

chris — Mon, 06 Jul 2015 17:14:54 GMT

hours changed from 0 to 0.08
status changed from new to closed
resolution set to fixed
totalhours changed from 0.4 to 0.48

I have solved this, we simply need to create ~/.my.cnf files for every user that uses MySQl on Crin2 containing:

[client]
host=crin1
ssl-cipher=DHE-RSA-AES256-SHA
ssl-ca=/etc/ssl/cacert/cacert.pem
ssl-cert=/etc/ssl/cacert/crin1_cert.pem
ssl-key=/etc/ssl/cacert/crin1_yassl_privatekey.pem

And then Drush works without a problem:

sudo -i
su - www-data -s /bin/bash
cd /var/www/drupal
drush sqlq "show tables" | less
  actions
  ...

So closing this ticket, I'll also post a comment to the Drush ticket.