Drupal Console + Aegir

[mstenta]

Drupal Console does not seem to be working with sites installed via Aegir. I think there may be two separate issues that are preventing it from working.

1. Aegir uses Drupal multisite for all sites that it installs.

Based on the Console documentation, and #755, it seems like Console does support multisite installations, but it also seems that it is not currently working. I believe part of the issue is #2002

2. Aegir does not store database credentials in settings.php.

As an extra security measure, Aegir stores database credentials in the Apache virtual host that it creates, and loads them dynamically into settings.php temporarily. Once the database connection is established, it clears the credential variables so that they cannot be accessed by anyone with PHP access (or phpinfo()) within the site itself.

In order for Drush to work, Aegir also stores the database credentials in sites/[site-uri]/drushrc.php.

Perhaps Console could also look in drushrc.php for credentials, if it doesn't find them in settings.php? This could be done conditionally, so that we don't have to depend on Drush of course.

[colans]

@jmolivas Would you be able to at least point us to the code location where we could add a patch for this, for number 2 above? Thanks.

[jmolivas]

@colans What will be the easies way to test this myself? I mean to have an Aegir setup locally?

[colans]

Folks traditionally use Valkyrie, but I use a real Dev VM hosted somewhere.

@ergonlogic: Is there a newer/better way nowadays?

[ergonlogic]

Valkyrie should work, but also adds a number of components specific to local development. An alternative would be to launch a Vagrant VM from https://github.com/ergonlogic/ansible-role-aegir, which should be much closer to a stock Aegir install. There are also some Docker-based deployment options, but I'm not familiar enough with them to suggest whether they'd be helpful here.

[ttadegraaff]

It looks as if only problem nr. 1 is an issue. If I add a symbolic link sites/default/settings.php pointing to the sites/my-site.org/settings.php then drupal console seems to be functional with the database from my-site.org.

[esolitos]

Yes that works, and if you have 1 site per platform it's ok, but if you have more (which is the case, usually), this is not a solution.

[ttadegraaff]

Well I didn't say it's a solution. I only specified that only problem nr. 1 mentioned in the first post seems to be an issue, and thus problem nr. 2 not. ;)

This seems to me to be important information for someone willing to fix the problem mentioned in this thread. It's probably not an aegir problem, so probably no need to create Aegir instances for testing purposes etc. There might already be another issue pointing to the lack of drupal console support for multisite, so this issue might be closed...?

[mstenta]

@ttadegraaff What Console commands did you test? Can you test one that interacts with the Drupal database?

If you tested one that does not require a connection to the Drupal database, then it did not test whether or not the 2nd problem I described is still an issue. The second problem I described is that Aegir does not put database credentials inside settings.php - it puts them inside the Apache virtual host - which means that Console will only be able to get the database credentials if it is able to get those from the virtual host as well (running in the context of an Apache request).

[mstenta]

PS: There is already an open issue about Console not working with multisite: #2002

If it is true that a symlinked settings.php works with the database, then that is good news - it means we can close this issue and focus on #2002 - because like you said it is not an Aegir issue.

[ttadegraaff]

I did a

drupal debug:user

with result:

// Welcome to the Drupal user debug

---

User ID Username Roles Status

---

1 spadmin Authenticated user, Administrator Enabled

---

[mstenta]

@ttadegraaff Ok that's great! Thanks for confirming!

I think that confirms that this is not an Aegir issue, and we can focus efforts on #2002 instead. Does everyone agree?

I am curious about HOW Console is getting the database credentials when they are not in settings.php... I don't know the inner workings of Console enough, though. Does it perform an Apache request that then loads up the virtual host information?

[mstenta]

As I stated in the issue description:

In order for Drush to work, Aegir also stores the database credentials in sites/[site-uri]/drushrc.php.

Perhaps Console could also look in drushrc.php for credentials, if it doesn't find them in settings.php? > This could be done conditionally, so that we don't have to depend on Drush of course.

Is Console looking in drushrc.php? Will this still work if drushrc.php is not present?

[ttadegraaff]

Curious... I've renamed drushrc.php to drushrc.php.backup, and drupal console is still functional, same output as above. What's even more interesting, and troubling... drush also continues functional, for example a cache-rebuild.