Following the merge of db and web server node types the variables hosting_default_db_server and hosting_own_db_server should be updated to match hosting_default_web_server:

Vertice ‣ we merged the 2 node types
Vertice ‣ but forgot to update the record of the db server

Vertice ‣ we don't update the variable
Vertice ‣ and we should
Vertice ‣ and there's no interface to change it

Occurs: after upgrade of provision/hostmaster to aegir-0.4alpha6

Symptoms:
provision-verify breaks, unable to verify a new platform (verifying existing platforms, or new sites on existing platforms does work).

debug:
/var/aegir/drush/drush.php --root='/path/to/hostmaster' --uri='aegir.example.com' hosting-task $nid --debug
where $nid is the node of ID of the provision-verify task.

debug output shows incorrect db credentials:
Could not connect to the master database server (Access denied for user [error]
'aegir'@'localhost' (using password: NO)). [0.52 sec, 17.62 MB]
An error occurred at function : drush_provision_mysql_provision_verify_validate [0.52[error]

Workaround:
Correct the variables hosting_default_db_server and hosting_own_db_server to point to the correct node id for your server in your hostmaster database by hand.

Comments

tnightingale’s picture

tnightingale commented

I have also struck this with verifying any new platforms after updating to Alpha6.

Adrinux's suggestion fixed for me. Some more detail on the method:

The nid of my server is 3 so the following commands from my /var/aegir/hostmaster-0.4-alpha6/sites/sitename directory fixed the problem:

$ drush vset --yes hosting_default_db_server 3
$ drush vset --yes hosting_own_db_server 3
Rok Žlender’s picture

Rok Žlender commented

Settings the vars fixed the problem for me too.

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Fixed

Fixed in HEAD

DanielJohnston’s picture

DanielJohnston commented

Getting a somewhat wacky response using the above workaround:

base-uk:~/welfcoukplatform/sites/welfaretowork.co.uk$ php /var/aegir/drush/drush.php vset --yes hosting_default_db_server 2

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 4864 bytes) in /var/aegir/welfcoukplatform/sites/all/modules/rules/rules/rules.install on line 23
Drush command could not be completed.                                                                             [error]

(note - 2 is the node id of the server on my setup)

Anonymous’s picture

Anonymous (not verified) commented

So raise your php cli memory_limit ...

DanielJohnston’s picture

DanielJohnston commented

Solved by upping the php5 CLI memory limit, was a bit surprised that it was trying to call an install function tho'.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

yareckon’s picture

yareckon commented

thank you thank you thank you! with alpha6 still the last version out, this is very relevant.

KrisBulman’s picture

KrisBulman commented

This worked for me, thanks.

I agree with above statement.. issue is still relevant.