I am in the process of writing support for installs with remote DB servers. I will then move on to upgrade support.

This involves hacking a bit more install.hostmaster.inc, migrate.hostmaster.inc and the profile.

This could help resolve #952144: support local socket connexions for mysql.

I think this should part of the release so i am marking this critical.

Comments

anarcat’s picture

Status: Active » Needs work
Issue tags: +aegir-0.4, +installer

dealing with installs first.

I have pushed the branch dev-multiserver-install for provision which does the first half (the backend).

for the second half, I wonder if I should check master_db or if we shouldn't just drop master_db and rely on the dbserver associated with the @hostmaster site?

either way, the frontend profile needs to be changed to create a new node if the dbserver is different from the master server.

this should be around hostmaster.profile:77.

anarcat’s picture

i guess what I mean regarding master_db is that it doesn't seem to be the right way to pass that information around. In fact, I believe it *shouldn't* be passed to the frontend at all in this case. But maybe that would break the edition of this server.

Either way, I've always been quite unconfortable with storing the mysql root password(s) in the frontend DB. But that's a separate issue.

anarcat’s picture

FWIW, i have setup a new hostmaster instance with the above patches and the only problem is that the DB server is not created in the frontend. The install is otherwise fully functional and manually creating the node fixes the problem completely.

anarcat’s picture

Status: Needs work » Needs review

Created the branch on hostmaster, we now create the DB node if it's different from master. I just need some testing now.

anarcat’s picture

So I have now completed the frontend: the last commit had a small bug... But now a node is created for the DB server in the frontend if it doesn't already exist.

I have tested this repeatedly with the following:

drush @hostmaster provision-delete
drush hostmaster-install --aegir_db_host=localhost --working-copy --client_email=anarcat@koumbit.org --makefile=/var/aegir/makefiles/aegir-koumbit.make --debug

I would like somebody to test this and the "normal" install. miguel? Once that is proven as working in most cases, mark this as RTBC and i'll merge on master.

Thanks!

sfyn’s picture

I am attempting an install in a vbox with some unusual symptoms, using hostmaster-install:

drush hostmaster-install --aegir_db_host=localhost --working-copy --debug

And I am consistently generating the same errors:

PROVISION_SITE_INSTALLED [22 sec, 4.96 MB]                                         [error]
An error occurred at function : drush_provision_drupal_provision_install_validate  [error]
[22 sec, 4.96 MB]
Command dispatch complete [22 sec, 4.96 MB]                                           [notice]
Peak memory usage was 5.78 MB [22 sec, 4.96 MB]                                       [memory]
Running: /usr/bin/php /var/aegir/drush/drush.php --php=/usr/bin/php  @hostmaster     [command]
provision-verify --backend [22 sec, 4.87 MB]
The external command could not be executed due to an application error. [22.21 sec,[error]
4.9 MB]

Vhost configuration and such appear to be completing correctly, except that for whatever reason, I am consistently getting garbage characters inserted at the beginning of my server url.

Any thoughts?

sfyn’s picture

Strangely enough this error appears to have gone away on its own...

Apparently it is sufficient to do an rm-r of the existing sites file after having run drush provision-delete to be able to safely reinstall.

anarcat’s picture

The PROVISION_SITE_INSTALLED error means what it says: the hostmaster site is already there. :) Run drush @hostmaster provision-delete first.

anarcat’s picture

So this was tested with --aegir_db_host, we need someone to test the regular install.

Anonymous’s picture

I shall, but won't get the chance for 24 hours sorry.

Maybe Grace if you are in a hurry

omega8cc’s picture

I will try that today.

anarcat’s picture

Thank you grace!!!

sfyn’s picture

Just for the record, I did use drush @hostmaster provision-delete first.

anarcat’s picture

Status: Needs review » Reviewed & tested by the community

I am able to install without the --aegir_db_host argument too, on my usual test platforms. ie. I do not think this is adding new regressions.

I think I will be merging this in after one last pass at fixing prompts and workflow.

anarcat’s picture

Status: Reviewed & tested by the community » Fixed

I have merged the branch in master now. I think this is now complete: upgrades should just follow because nodes and contexts are created properly.

Status: Fixed » Closed (fixed)
Issue tags: -aegir-0.4, -installer

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