Aegir install fails at last step - drush hostmaster-install fails with mysql errors

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
alanburke's picture

Hi all,
I'm installing Aegir on my Workstation Ubuntu 8.10.
The workstation has been acting fine as my dev box, apache, mysql and php all working fine.

The installation at described in the install.txt file
has been followed to the letter, as far as I can see.

The directory at /var/aegir seems to be installed fine and a setting.php is generated at
/var/aegir/hostmaster-0.4-alpha14/sites/ubuntu-dell/setting.php
[ubuntu-dell is the machine name]

I'm running the script from my normal user account like so

 su -s /bin/sh aegir -c "sh install-aegir.sh ubuntu-dell"

[I did have to set a password on the Aegir user account at one stage to I could drop into that user's shell to see what's happening]

The errors appear at the end of the install.

...
install_profile_api downloaded from http://ftp.drupal.org/files/projects/install_profile_api-6.x-2.1.tar.gz.  [ok]
jquery_ui downloaded from http://ftp.drupal.org/files/projects/jquery_ui-6.x-1.3.tar.gz.                      [ok]
modalframe downloaded from http://ftp.drupal.org/files/projects/modalframe-6.x-1.6.tar.gz.                    [ok]
jquery_ui downloaded from http://jquery-ui.googlecode.com/files/jquery.ui-1.6.zip.                            [ok]
Admin user e-mail [webmaster@localhost]: alan@proactive.ie
Dummy connection failed to fail: mysql: Error reading file 'UNOPENED' (Errcode: 11)                          [error]
Dummy connection failed to fail: mysql: Error reading file 'UNOPENED' (Errcode: 11)                          [error]
Created ubuntudell database                                                                                   [success]
An error occurred at function : drush_db_pre_provision_install                                                [error]
Dummy connection failed to fail: mysql: Error reading file 'UNOPENED' (Errcode: 11)                          [error]
Dummy connection failed to fail: mysql: Error reading file 'UNOPENED' (Errcode: 11)                          [error]
Could not find a Drupal settings.php file at ./sites/default/settings.php.                                    [error]
An error occurred at function : drush_provision_drupal_provision_verify_validate                              [error]
An error occurred at function : drush_provision_hostmaster_install                                            [error]

I ammended the last line of the script to read

 $DRUSH hostmaster-install --debug  ...

Ran the command again
And got the following errors

Running: /var/aegir/drush/drush.php  @hostmaster provision-install --backend [6.77 sec, 5.47 MB]                [command]
Drush bootstrap phase : _drush_bootstrap_drush() [7.08 sec, 5.74 MB]                                          [bootstrap]
Load alias @hostmaster [7.09 sec, 5.74 MB]                                                                       [notice]
Drush bootstrap phase : _drush_bootstrap_drupal_root() [7.09 sec, 5.74 MB]                                    [bootstrap]
Loading drushrc "/var/aegir/hostmaster-0.4-alpha14/drushrc.php" into "drupal" scope. [7.09 sec, 5.74 MB]      [bootstrap]
Initialized Drupal 6.19 root directory at /var/aegir/hostmaster-0.4-alpha14 [7.09 sec, 5.74 MB]                  [notice]
Found command: provision-install (commandfile=provision) [7.09 sec, 5.75 MB]                                  [bootstrap]
Initializing drush commandfile: drush_make [7.09 sec, 5.75 MB]                                                [bootstrap]
Initializing drush commandfile: drush_make_d_o [7.09 sec, 5.75 MB]                                            [bootstrap]
Initializing drush commandfile: provision [7.09 sec, 5.75 MB]                                                 [bootstrap]
Load alias @platform_hostmaster [7.09 sec, 5.75 MB]                                                              [notice]
Load alias @server_master [7.09 sec, 5.75 MB]                                                                    [notice]
Loading mysql driver for the db service [7.09 sec, 5.75 MB]                                                      [notice]
Loading apache driver for the http service [7.09 sec, 5.75 MB]                                                   [notice]
Including /var/aegir/.drush/provision/db/install.provision.inc [7.09 sec, 5.75 MB]                            [bootstrap]
Including /var/aegir/.drush/provision/example/install.provision.inc [7.09 sec, 5.75 MB]                       [bootstrap]
Including /var/aegir/.drush/provision/http/install.provision.inc [7.09 sec, 5.75 MB]                          [bootstrap]
Including /var/aegir/.drush/provision/platform/install.provision.inc [7.1 sec, 5.76 MB]                       [bootstrap]
PROVISION_SITE_INSTALLED [7.1 sec, 5.76 MB]                                                                   [error]
An error occurred at function : drush_provision_drupal_provision_install_validate [7.1 sec, 5.76 MB]          [error]
Command dispatch complete [7.1 sec, 5.76 MB]                                                                     [notice]
Peak memory usage was 6.75 MB [7.1 sec, 5.76 MB]                                                                 [memory]
Running: /var/aegir/drush/drush.php  @hostmaster provision-verify --backend [7.1 sec, 5.66 MB]                  [command]
The external command could not be executed due to an application error. [7.36 sec, 5.7 MB]                    [error]
Drush bootstrap phase : _drush_bootstrap_drush() [7.36 sec, 5.96 MB]                                          [bootstrap]
Load alias @hostmaster [7.36 sec, 5.97 MB]                                                                       [notice]
Found command: provision-verify (commandfile=provision) [7.36 sec, 5.97 MB]                                   [bootstrap]
Initializing drush commandfile: drush_make [7.36 sec, 5.97 MB]                                                [bootstrap]
Initializing drush commandfile: drush_make_d_o [7.36 sec, 5.97 MB]                                            [bootstrap]
Initializing drush commandfile: provision [7.36 sec, 5.97 MB]                                                 [bootstrap]
Load alias @platform_hostmaster [7.37 sec, 5.97 MB]                                                              [notice]
Load alias @server_master [7.37 sec, 5.97 MB]                                                                    [notice]
Loading mysql driver for the db service [7.37 sec, 5.98 MB]                                                      [notice]
Loading apache driver for the http service [7.37 sec, 5.98 MB]                                                   [notice]
Including /var/aegir/.drush/provision/platform/backupmigrate/verify.provision.inc [7.37 sec, 5.98 MB]         [bootstrap]
Including /var/aegir/.drush/provision/platform/verify.provision.inc [7.37 sec, 5.98 MB]                       [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drupal_root() [7.37 sec, 5.98 MB]                                    [bootstrap]
Loading drushrc "/var/aegir/hostmaster-0.4-alpha14/drushrc.php" into "drupal" scope. [7.37 sec, 5.98 MB]      [bootstrap]
Initialized Drupal 6.19 root directory at /var/aegir/hostmaster-0.4-alpha14 [7.37 sec, 5.98 MB]                  [notice]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [7.37 sec, 5.98 MB]                                    [bootstrap]
Initialized Drupal site ubuntu-dell at sites/ubuntu-dell [7.37 sec, 5.98 MB]                                     [notice]
Template loaded: /var/aegir/.drush/provision/platform/provision_drupal_settings.tpl.php [7.37 sec, 5.98 MB]      [notice]
Changed permissions of /var/aegir/hostmaster-0.4-alpha14/sites/ubuntu-dell/settings.php to 640 [7.37 sec, 5.98  [message]
MB]
Generated config Drupal settings.php file [7.38 sec, 5.99 MB]                                                   [message]
Changed permissions of /var/aegir/hostmaster-0.4-alpha14/sites/ubuntu-dell/settings.php to 440 [7.38 sec, 5.99  [message]
MB]
Change group ownership of /var/aegir/hostmaster-0.4-alpha14/sites/ubuntu-dell/settings.php to www-data [7.38    [message]
sec, 5.99 MB]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [7.38 sec, 5.99 MB]                           [bootstrap]
Drush command could not be completed. [7.38 sec, 5.99 MB]                                                     [error]
Output from failed command :                                                                                  [error]
  [7.38 sec, 5.99 MB]
An error occurred at function : drush_provision_hostmaster_install [7.38 sec, 5.53 MB]                        [error]
Command dispatch complete [7.38 sec, 5.51 MB]                                                                    [notice]
Peak memory usage was 6.03 MB [7.38 sec, 5.51 MB]  

Which seem less useful...

Any clues?

The closest error I have seem was at
http://groups.drupal.org/node/85234
but that was back at Alpha 7

Regards
Alan

Comments

Database config

timwood's picture

Did you make sure you followed the section "Database configuration"?

Does the installer ever prompt you for your mysql root password? If not I suspect it's a connection to MySQL issue. Specifically the mysql root user being unable to connect to the database due to mysql access rights. Maybe this thread will help: http://groups.drupal.org/node/86604.

I vaguely remember having to configure my mysql.user table to allow the root user to connect from all host aliases for my machine. Alternatively you could use % as a wildcard to cover all hosts. This is a result of allowing mysql connections from hosts other then localhost. Once you've updated the mysql.user table make sure you flush privileges.

-Tim

No joy

alanburke's picture

Hi Tim
Thanks for the help.

I went back over the DB config section.
I've followed all the steps, as far as I can see.

As as part of the install script, I do get prompted for the root password.
I checked the mysql table after the script has failed as I can three entries for the user 'aegir_root', one each for 127.0.0.1, localhost and ubuntu-dell.

I flushed privileges, restarted mysql, ran the script again, same problems.

Damn

timwood's picture

Sorry my suggestions didn't help. I hope someone else can step up and suggest something better.

Another option, if you have the computer resources, is to try the setup in a VM with a more recent version of Ubuntu.

Update?

kurth's picture

Did you get this resolved?

version issues

snlnz's picture

Aegir alpha14 install script doesn't complete successfully on clean ubuntu 8 install.

If you have ability to load a new vhost/vps/cloud server then:
Ubuntu 10 allows the install script to run for alpha14

If you have to install aegir on Ubuntu 8 I've had success running the install script for alpha5.

Hope that helps.

resolved: Ubuntu OS version too old

snlnz's picture

I had same problems with Ubuntu 8.x try going to Ubuntu 10 works a treat.

MySQL permissions might be the culprit

Robin van Emden's picture

Maybe the MySQL settings differ between 8.x en 10.x?
If that is the case, the solution mentioned here might contain the solution to this problem as well:
removing the anonymous mysql users, ie:

mysql> DELETE FROM user WHERE user = '';
mysql> FLUSH PRIVILEGES;

More secure anyway.

MySQL 5.0.89

vadym.kononenko's picture

I use ALTLinux with MySQL-server-5.0.89-alt1. Yours suggestion had solved the same problem. Thanks.

Even better, invoke the

vegardx's picture

Even better, invoke the proper command to remove temporary data and anonymous users. See "mysql_secure_installation".

--
Vegard

Moving to Ubuntu 10.04 didn't help

alanburke's picture

I've upgraded the dev box to 10.04, but that in itself didn't fix the problem.
I tried the removing anonymous access to mysql too, as mentioned above.

I'll go down though the instructions again, and double check everything.

Thanks for all the help so far.

Up and running

alanburke's picture

So I double checked everything,
Removed everything in /var/aegir
and ran the script again.
This time all went well, and it's time to play with Aegir!

Thanks for all the help

Just what I needed!!!

tomhung's picture

Just what I needed!!! Thanks!

Greg

Just wondering if you have

snlnz's picture

oops, didn't see the bit that said,
all went well, lol.

my bad!

Same issue, MySQL user issue

HaloFX's picture

Just ran into the same thing with Beta1 on Ubuntu 8.04.

Alpha14 ran fine on a Ubuntu 10.10 VM I setup to test Aegir.

But it was choking as mentioned above on the dev 8.04 VM.
Removing the 2 'ANY' users from the MySQL privileges table fixed it.

The Ubuntu 8.04 is using MySQL 5.0.51a and the 10.10 is using 5.1.49.

I am having the same exact

pyxio's picture

I am having the same exact problem. The install script fails at the hostmaster-make command. I'm using the Centos5 distro. Has there been any progress is on this issue. Frustrating :o( Thanks. Kevin

Aegir hosting system

Group organizers

Group categories

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week