I followed the intstructions at http://drupal.org/node/1845826#comment-6759336 - everything seemed to go well aside from missing some paths on the seds (I'm only running barracuda, not octopus). Chive and some non-drupal sites run perfectly fine, so the basic system config is working, there must be some lingering IP address issue somewhere - basically http://drupal.org/node/1878062 except the lack of octopus sites. FYI the series of sed replaces missed /var/xdrago/firewall/check/scan_nginx.

grep -r "BAD.IP" /var only shows results for /var/backups/, /var/aegir/backups/, and /var/aegir/install.log. I double checked in my hostmaster db and the ip address col under hosting_ip_addresses all show the new IP.

I've run "barracuda up-stable" and bounced my server after all the changes and I get the same behaviour.

I suppose I could just start from a fresh wheezy install once 2.0.9 comes out and restore from backups, but it'd be nice to get the process working as people will want to change servers for whatever reason. :)

syslog shows the following recurring errors:

May  8 23:42:01 hq mysqld: 130508 23:42:01 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
May  8 23:42:01 hq mysqld: 130508 23:42:01 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
May  8 23:42:01 hq mysqld: 130508 23:42:01 [Warning] Access denied for user 'hqerutannet'@'li106-19.members.linode.com' (using password: YES)
May  8 23:42:01 hq /USR/SBIN/CRON[7333]: (CRON) error (grandchild #7339 failed with exit status 1)
May  8 23:42:11 hq mysqld: 130508 23:42:11 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
May  8 23:42:11 hq mysqld: 130508 23:42:11 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
May  8 23:42:21 hq mysqld: 130508 23:42:21 [Warning] Access denied for user 'root'@'localhost' (using password: YES)
May  8 23:42:21 hq mysqld: 130508 23:42:21 [Warning] Access denied for user 'root'@'localhost' (using password: YES)

Both chive on the www and mysql -p in an ssh session worked. Looks similar to http://stackoverflow.com/questions/6445917/connect-failed-access-denied-....

I tried running GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'foobar' WITH GRANT OPTION; and then changing the /var/aegir/host_master/004/sites/foo/settings.php to run from root to see if that'd fix anything but no dice.

I'm guessing the script you had was missing a step? UPDATE `mysql`.`db` SET Host = REPLACE(Host, 'WRONG.IP.ADDRESS', 'CORRECT.IP.ADDRESS'); didn't return any results

Comments

erutan’s picture

erutan commented

Upgrading to BOA 2.0.9 gave me these error messages during the install process:

Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [1.01 sec, 8.11  [bootstrap]
MB]
Access denied for user 'foobar'@'foo.members.linode.com' (using        [bootstrap]
password: YES) [1.01 sec, 8.11 MB]
Drush was not able to start (bootstrap) the Drupal database.                     [error]
Hint: This error often occurs when Drush is trying to bootstrap a site that has
not been installed or does not have a configured database.

I checked resolv.conf and it contained:

domain members.linode.com
search members.linode.com
omega8cc’s picture

omega8cc commented
Component: Code » Documentation
Status: Active » Closed (cannot reproduce)

No idea. The how-to we provide has been well tested many times and it just works. Of course the mysql root password must work in the first place, or everything else will fail. I'm sorry, but I see no other choice than close this ticket at this stage.