provision-verify fails on hostmaster install with remote database [#722286]

HEAD version downloaded 2/18.

Hostmaster was successfullly installed with a remote db server. The provision verify task created on install fails as can be seen in provision-verify.png (attached).

drush sql-conf and sql-cli work:

[aegir@adm-10-cms ~]$ cd hostmaster-HEAD/
[aegir@adm-10-cms hostmaster-HEAD]$ ~/drush/drush.php sql-conf -l aegir.example.com
Array
(
    [driver] => mysql
    [username] => aegir
    [password] => secret
    [port] => 3197
    [host] => db.example.com
    [database] => aegir
)

[aegir@adm-10-cms hostmaster-HEAD]$ ~/drush/drush.php sql-cli -l aegir.example.com
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23510
Server version: 5.0.67-log Build revision 6

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit
Bye

Attempting to manually validate the site from the cli fails. Seems it can't parse $db_url

[aegir@adm-10-cms hostmaster-HEAD]$ /var/aegir/drush/drush.php -d --root='/var/aegir/hostmaster-HEAD' provision-verify
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.11 sec, 4.18 MB]      [bootstrap]
Initialized Drupal 6.15 root directory at /var/aegir/hostmaster-HEAD [0.12 sec,    [notice]
4.97 MB]
Found command: provision-verify (commandfile=provision) [0.13 sec, 4.96 MB]     [bootstrap]
Initializing drush commandfile: drush_make [0.13 sec, 4.97 MB]                  [bootstrap]
Initializing drush commandfile: drush_make_d_o [0.13 sec, 4.97 MB]              [bootstrap]
Initializing drush commandfile: provision [0.13 sec, 4.97 MB]                   [bootstrap]
Initializing drush commandfile: provision_apache [0.13 sec, 4.97 MB]            [bootstrap]
Undefined index:  base_url [0.14 sec, 4.98 MB]                                     [notice]
Initializing drush commandfile: provision_drupal [0.14 sec, 4.98 MB]            [bootstrap]
Initializing drush commandfile: provision_mysql [0.14 sec, 4.98 MB]             [bootstrap]
Undefined index:  db_url [0.14 sec, 4.98 MB]                                       [notice]
Undefined index:  user [0.14 sec, 4.98 MB]                                         [notice]
Undefined index:  pass [0.14 sec, 4.99 MB]                                         [notice]
Undefined index:  host [0.14 sec, 4.99 MB]                                         [notice]
Undefined index:  host [0.14 sec, 4.99 MB]                                         [notice]
Undefined index:  scheme [0.14 sec, 4.99 MB]                                       [notice]
Undefined index:  scheme [0.14 sec, 4.99 MB]                                       [notice]
Including /var/aegir/.drush/provision/web_server/verify.provision.inc [0.14 sec,[bootstrap]
4.99 MB]
Including /var/aegir/.drush/provision/platform/verify.provision.inc [0.14 sec,  [bootstrap]
5.01 MB]
Including /var/aegir/.drush/provision/db_server/verify.provision.inc [0.14 sec, [bootstrap]
5.04 MB]
Including /var/aegir/.drush/provision/ssl/verify.provision.inc [0.14 sec, 5.04  [bootstrap]
MB]
Could not connect to the master database server (Can't connect to local MySQL   [error]
server through socket '/var/lib/mysql/mysql.sock' (2)). [0.14 sec, 5.06 MB]
An error occurred at function : drush_provision_mysql_provision_verify_validate [error]
[0.14 sec, 5.06 MB]
Command dispatch complete [0.14 sec, 5.04 MB]                                      [notice]
Peak memory usage was 5.64 MB [0.14 sec, 5.04 MB]                                  [memory]

Comment	File	Size	Author
#8	aegir_verify_ubuntu_remote_dbserver.png	116.61 KB	bwood
#6	Screen shot 2010-02-25 at 3.32.41 PM.png	18.32 KB	adrian
#2	provision-verify.png	69.73 KB	bwood

Comments

Comment #1

bwood commented 22 February 2010 at 20:57

Inspite of the above error I went ahead and attempted to create 1) a webserver and 2) a platform on the new webserver. Creating the webserver succeeded. Creating the platform failed. I got a very similar error on verification of the new platform. Here is my attempt to verify the platform manually from the hostmaster server:

		[aegir@adm-10-cms hostmaster-HEAD]$ ssh -o PasswordAuthentication=no 'aegir'@'dev-10-example.com' ' /var/aegir/drush/drush.php -d --root='\''/var/aegir/platforms/dev/drupal-6.15'\'' provision-verify'
		Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.07 sec,    [bootstrap]
		4.18 MB]
		Initialized Drupal 6.15 root directory at                               [notice]
		/var/aegir/platforms/dev/drupal-6.15 [0.08 sec, 4.97 MB]
		Found command: provision-verify (commandfile=provision) [0.09 sec,   [bootstrap]
		4.96 MB]
		Initializing drush commandfile: drush_make [0.09 sec, 4.97 MB]       [bootstrap]
		Initializing drush commandfile: drush_make_d_o [0.09 sec, 4.97 MB]   [bootstrap]
		Initializing drush commandfile: provision [0.09 sec, 4.97 MB]        [bootstrap]
		Initializing drush commandfile: provision_apache [0.09 sec, 4.97 MB] [bootstrap]
		Undefined index:  base_url [0.09 sec, 4.98 MB]                          [notice]
		Initializing drush commandfile: provision_drupal [0.09 sec, 4.98 MB] [bootstrap]
		Initializing drush commandfile: provision_mysql [0.09 sec, 4.98 MB]  [bootstrap]
		Undefined index:  db_url [0.09 sec, 4.98 MB]                            [notice]
		Undefined index:  user [0.09 sec, 4.98 MB]                              [notice]
		Undefined index:  pass [0.09 sec, 4.98 MB]                              [notice]
		Undefined index:  host [0.09 sec, 4.99 MB]                              [notice]
		Undefined index:  host [0.09 sec, 4.99 MB]                              [notice]
		Undefined index:  scheme [0.09 sec, 4.99 MB]                            [notice]
		Undefined index:  scheme [0.09 sec, 4.99 MB]                            [notice]
		Including /var/aegir/.drush/provision/web_server/verify.provision.inc[bootstrap]
		[0.09 sec, 4.99 MB]
		Including /var/aegir/.drush/provision/platform/verify.provision.inc  [bootstrap]
		[0.09 sec, 5.01 MB]
		Including /var/aegir/.drush/provision/db_server/verify.provision.inc [bootstrap]
		[0.09 sec, 5.04 MB]
		Including /var/aegir/.drush/provision/ssl/verify.provision.inc [0.09 [bootstrap]
		sec, 5.04 MB]
		Drush command could not be completed. [0.1 sec, 5.06 MB]                 [error]
		[aegir@adm-10-cms hostmaster-HEAD]$

Attempting a manual provision-verify from the the webserver (not via ssh -o) fails identically.

Comment #2

bwood commented 22 February 2010 at 21:04

Status	File	Size
new	provision-verify.png	69.73 KB

I guess attachments get lost if you preview your post and then Save it... Here it is.

Comment #3

bwood commented 23 February 2010 at 01:29

Per mig5's suggestion in irc I did the following:

1. applied these patches: http://drupal.org/node/712016#comment-2622678
2. dropped all the tables in the aegir db
3. replaced settings.php with default
4. reinstalled hostmaster

provision-verify on the hostmaster site FAILED

5. created a webserver
6. installed a platform (provision/drush) on the webserver. Created aegir user and installed keys.
7. created the platform node in hostmaster

provision verify on the platform FAILED.

Comment #4

adrian commented 24 February 2010 at 20:28

Status:

Active

» Postponed (maintainer needs more info)

If you can test with the latest HEAD of provision / hostmaster.

I fixed the issue i think you were having, see :

#712016: Provision-intsall fails due to db_host defaulting to localhost, FQDN expected

Comment #5

bwood commented 25 February 2010 at 01:22

Afraid that my problem is not fixed.

I'm new to git. Here's what I did to update to the latest HEAD:

cd ~aegir/.drush/provision
$ git pull
Updating bb9fcbb..5bdd9b9
Fast forward
INSTALL.txt | 22 ++++----
UPGRADE.txt | 23 +++++++
db_server/provision_mysql.drush.inc | 14 +----
install.sh.txt | 42 ++++++++++++--
platform/drupal/deploy.inc | 4 +-
platform/provision_drupal.drush.inc | 5 +-
provision.inc | 13 ++++
ssl/provision_ssl.drush.inc | 2 +-
web_server/delete.provision.inc | 2 +-
web_server/provision_apache.drush.inc | 88 ++++++++++++++++-----------
web_server/provision_apache_server.tpl.php | 7 ++
web_server/verify.provision.inc | 8 +--
12 files changed, 156 insertions(+), 74 deletions(-)

I also updated profiles/hostmaster:

1. renamed the old hostmaster dir
2. git clone git://git.aegirproject.org/hostmaster.git
3. dropped all the tables in the aegir db
4. replaced settings.php with default
5. reinstalled hostmaster

provision-verify on the hostmaster site FAILED

But the db connection is working:

[aegir@adm hostmaster-HEAD]$ ~/drush/drush.php sql-cli -l aegir.example.com
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 36742
Server version: 5.0.67-log Build revision 6

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Here's manual verify attempt:

[aegir@adm hostmaster-HEAD]$ /var/aegir/drush/drush.php -d --root='/var/aegir/hostmaster-HEAD' provision-verify
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.11 sec, 4.19 MB]       [bootstrap]
Initialized Drupal 6.15 root directory at /var/aegir/hostmaster-HEAD [0.13 sec,     [notice]
4.98 MB]
Found command: provision-verify (commandfile=provision) [0.14 sec, 4.97 MB]      [bootstrap]
Initializing drush commandfile: drush_make [0.14 sec, 4.98 MB]                   [bootstrap]
Initializing drush commandfile: drush_make_d_o [0.14 sec, 4.98 MB]               [bootstrap]
Initializing drush commandfile: provision [0.14 sec, 4.98 MB]                    [bootstrap]
Initializing drush commandfile: provision_apache [0.14 sec, 4.98 MB]             [bootstrap]
Undefined index:  base_url [0.14 sec, 4.99 MB]                                      [notice]
Initializing drush commandfile: provision_drupal [0.14 sec, 4.99 MB]             [bootstrap]
Initializing drush commandfile: provision_mysql [0.14 sec, 4.99 MB]              [bootstrap]
Undefined index:  db_url [0.14 sec, 5 MB]                                           [notice]
Undefined index:  user [0.14 sec, 5 MB]                                             [notice]
Undefined index:  pass [0.14 sec, 5 MB]                                             [notice]
Undefined index:  host [0.14 sec, 5 MB]                                             [notice]
Undefined index:  host [0.14 sec, 5 MB]                                             [notice]
Undefined index:  scheme [0.14 sec, 5 MB]                                           [notice]
Undefined index:  scheme [0.14 sec, 5 MB]                                           [notice]
Including /var/aegir/.drush/provision/web_server/verify.provision.inc [0.14 sec, [bootstrap]
5.01 MB]
Including /var/aegir/.drush/provision/platform/verify.provision.inc [0.14 sec,   [bootstrap]
5.02 MB]
Including /var/aegir/.drush/provision/db_server/verify.provision.inc [0.14 sec,  [bootstrap]
5.05 MB]
Including /var/aegir/.drush/provision/ssl/verify.provision.inc [0.14 sec, 5.06   [bootstrap]
MB]
Could not connect to the master database server (Can't connect to local MySQL    [error]
server through socket '/var/lib/mysql/mysql.sock' (2)). [0.14 sec, 5.08 MB]
An error occurred at function : drush_provision_mysql_provision_verify_validate  [error]
[0.14 sec, 5.08 MB]
Command dispatch complete [0.14 sec, 5.05 MB]                                       [notice]
Peak memory usage was 5.65 MB [0.14 sec, 5.05 MB]                                   [memory]
[aegir@adm-10-cms hostmaster-HEAD]$

Comment #6

adrian commented 25 February 2010 at 13:36

Status	File	Size
new	Screen shot 2010-02-25 at 3.32.41 PM.png	18.32 KB

I jut did a completely new install. using a remote database as the db for the hostmaster site itself.

it correctly generated the server node types (see screenshot)

I have the issue though, that i had previous sites on this platform, that had been installed using the LOCAL db server. Because no entry existed for them .. the import was failing.

This will be sorted by the site alias / shortname functionality, in that we can generate nodes based on the information in the backend.

The site itself however, imported correctly.
As did all sites created with the remote database server.

Comment #7

bwood commented 25 February 2010 at 18:06

1. Did a git pull of latest hostmaster and provision.
2. reinstalled using a LOCAL db server

Initial verify of hostmaster site succeeds.

3. removed settings.php
4. emptied REMOTE db
5. reinstalled with REMOTE db.

Initial verify of hostmaster site FAILS.

However, now when I attempt a manual verify I don't see the undefined index messages related to db_url (see above) and this manual verify attempt appears to succeed:

]$ /var/aegir/drush/drush.php -d --root='/var/aegir/hostmaster-HEAD' provision-verify
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.11 sec, 4.2 MB]         [bootstrap]
Loading drushrc "/var/aegir/hostmaster-HEAD/drushrc.php" into "drupal" scope.     [bootstrap]
[0.11 sec, 4.2 MB]
Initialized Drupal 6.15 root directory at /var/aegir/hostmaster-HEAD [0.13 sec,      [notice]
5.2 MB]
Found command: provision-verify (commandfile=provision) [0.14 sec, 5.19 MB]       [bootstrap]
Initializing drush commandfile: drush_make [0.14 sec, 5.2 MB]                     [bootstrap]
Initializing drush commandfile: drush_make_d_o [0.14 sec, 5.2 MB]                 [bootstrap]
Initializing drush commandfile: provision [0.14 sec, 5.2 MB]                      [bootstrap]
Initializing drush commandfile: provision_apache [0.14 sec, 5.2 MB]               [bootstrap]
Undefined index:  base_url [0.14 sec, 5.21 MB]                                       [notice]
Initializing drush commandfile: provision_drupal [0.14 sec, 5.21 MB]              [bootstrap]
Initializing drush commandfile: provision_mysql [0.14 sec, 5.21 MB]               [bootstrap]
Undefined index:  db_url [0.14 sec, 5.21 MB]                                         [notice]
Including /var/aegir/.drush/provision/web_server/verify.provision.inc [0.14 sec,  [bootstrap]
5.22 MB]
Including /var/aegir/.drush/provision/platform/verify.provision.inc [0.14 sec,    [bootstrap]
5.23 MB]
Including /var/aegir/.drush/provision/db_server/verify.provision.inc [0.14 sec,   [bootstrap]
5.26 MB]
Including /var/aegir/.drush/provision/ssl/verify.provision.inc [0.14 sec, 5.27 MB][bootstrap]
Virtual host configuration path exists. [0.15 sec, 5.29 MB]                         [message]
Virtual host configuration ownership of path has been changed to aegir. [0.15 sec,  [message]
5.29 MB]
Virtual host configuration permissions of path have been changed to 0700. [0.15     [message]
sec, 5.29 MB]
Virtual host configuration path is writable. [0.15 sec, 5.29 MB]                    [message]
Platforms configuration path exists. [0.15 sec, 5.29 MB]                            [message]
Platforms configuration ownership of path has been changed to aegir. [0.15 sec,     [message]
5.29 MB]
Platforms configuration permissions of path have been changed to 0700. [0.15 sec,   [message]
5.3 MB]
Platforms configuration path is writable. [0.15 sec, 5.3 MB]                        [message]
Undefined variable: file [0.15 sec, 5.3 MB]                                          [notice]
Generating apache server configuration file . [0.15 sec, 5.3 MB]                     [notice]
Executing: sudo /usr/sbin/apachectl graceful [0.15 sec, 5.3 MB]                      [notice]
  [Thu Feb 25 09:54:30 2010] [warn] _default_ VirtualHost overlap on port 80, the first has precedence
Apache has been restarted [0.29 sec, 5.3 MB]                                         [notice]
Provision configuration path exists. [0.29 sec, 5.3 MB]                             [message]
Provision configuration ownership of path has been changed to aegir. [0.29 sec,     [message]
5.31 MB]
Provision configuration permissions of path have been changed to 0711. [0.29 sec,   [message]
5.31 MB]
Provision configuration path is writable. [0.29 sec, 5.31 MB]                       [message]
Provision PHP configuration path exists. [0.29 sec, 5.31 MB]                        [message]
Provision PHP configuration ownership of path has been changed to aegir. [0.29      [message]
sec, 5.31 MB]
Provision PHP configuration permissions of path have been changed to 0711. [0.29    [message]
sec, 5.31 MB]
Provision PHP configuration path is writable. [0.3 sec, 5.31 MB]                    [message]
Global configuration file exists [0.3 sec, 5.31 MB]                                 [message]
Backup path exists. [0.3 sec, 5.31 MB]                                              [message]
Backup ownership of path has been changed to aegir. [0.3 sec, 5.32 MB]              [message]
Backup permissions of path have been changed to 0700. [0.3 sec, 5.32 MB]            [message]
Backup path is writable. [0.3 sec, 5.32 MB]                                         [message]
Drupal sites directory is writable by the provisioning script [0.3 sec, 5.32 MB]    [message]
This platform is running drupal 6.15 [0.3 sec, 5.32 MB]                              [notice]
Including non-version specific file :                                                [notice]
/var/aegir/.drush/provision/platform/drupal/packages.inc [0.3 sec, 5.33 MB]
Found 33 modules in base [0.34 sec, 5.47 MB]                                         [notice]
Found 6 themes in base [0.34 sec, 5.49 MB]                                           [notice]
Found install profile hostmaster [0.35 sec, 5.78 MB]                                 [notice]
Found install profile default [0.35 sec, 5.81 MB]                                    [notice]
Found 19 modules in profiles/hostmaster [0.36 sec, 5.87 MB]                          [notice]
Found 1 themes in profiles/hostmaster [0.37 sec, 5.88 MB]                            [notice]
Changed permissions of -code-sites/all-/code- to 0755 [0.37 sec, 5.68 MB]           [message]
Changed permissions of -code-sites/all/themes-/code- to 2775 [0.37 sec, 5.68 MB]    [message]
Changed permissions of -code-sites/all/modules-/code- to 2775 [0.37 sec, 5.68 MB]   [message]
Changed permissions of -code-sites/all/libraries-/code- to 2775 [0.37 sec, 5.68     [message]
MB]
Changed permissions of -code-sites/all/private-/code- to 0755 [0.37 sec, 5.68 MB]   [message]
Changed permissions of -code-sites/all/private/files-/code- to 2770 [0.37 sec,      [message]
5.68 MB]
Changed permissions of -code-sites/all/private/temp-/code- to 2770 [0.37 sec, 5.68  [message]
MB]
Mysql can create new databases. [0.38 sec, 5.68 MB]                                 [message]
Found existing drushrc.php file [0.38 sec, 5.66 MB]                                  [notice]
Changed permissions of drushrc.php to 0600 [0.38 sec, 5.66 MB]                      [message]
Drushrc file (/var/aegir/hostmaster-HEAD/drushrc.php) was written successfully       [notice]
[0.38 sec, 5.66 MB]
Changed permissions of drushrc.php to 0400 [0.38 sec, 5.67 MB]                      [message]
Command dispatch complete [0.38 sec, 5.66 MB]                                        [notice]
Peak memory usage was 6.21 MB [0.39 sec, 5.66 MB]                                    [memory]

I am using (against my will) RHEL 5.4. Selinux is DISABLED:

# sestatus -v
SELinux status:                 disabled

To make sure that there is no other RHELL black magic foiling me, I will now do an install of the latest on trusty Ubuntu Server 8.04.

Comment #8

bwood commented 25 February 2010 at 19:55

Status	File	Size
new	aegir_verify_ubuntu_remote_dbserver.png	116.61 KB

I just completed a fresh install of HEAD on Ubuntu 8.04 with identical results as the RHEL tests above. This makes me confident that their is no RHEL-specific stuff like selinux causing trouble on RHEL.

On Ubuntu:

After install the initial verify fails: aegir_verify_ubuntu_remote_dbserver.png

settings.php looks correct:

aegir@bwvb100:~/hostmaster-HEAD$ ~/drush/drush sql-conf -l aegir.bwvb100.localhost
Array
(
    [driver] => mysql
    [username] => aegir
    [password] => 3206UpTwny
    [port] => 3197
    [host] => sierra.example.com
    [database] => aegir_bwvb100_head
)

I can connect to db

aegir@bwvb100:~/hostmaster-HEAD$ ~/drush/drush sql-cli -l aegir.bwvb100.localhost
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 43124
Server version: 5.0.67-log Build revision 6

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Manual verify fails with different errors than I've seen before--probably just some new code in this latest git pull...

aegir@bwvb100:~/hostmaster-HEAD$ /var/aegir/drush/drush.php -d --root='/var/aegir/hostmaster-HEAD' provision-verify
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.23 sec, 2.98 MB]        [bootstrap]
Initialized Drupal 6.15 root directory at /var/aegir/hostmaster-HEAD [0.27 sec,      [notice]
3.53 MB]
Found command: provision-verify (commandfile=provision) [0.3 sec, 3.58 MB]        [bootstrap]
Initializing drush commandfile: drush_make [0.3 sec, 3.58 MB]                     [bootstrap]
Initializing drush commandfile: drush_make_d_o [0.34 sec, 3.58 MB]                [bootstrap]
Initializing drush commandfile: provision [0.34 sec, 3.58 MB]                     [bootstrap]
Initializing drush commandfile: provision_apache [0.34 sec, 3.58 MB]              [bootstrap]
Undefined index:  base_url [0.34 sec, 3.58 MB]                                       [notice]
Initializing drush commandfile: provision_drupal [0.35 sec, 3.58 MB]              [bootstrap]
Initializing drush commandfile: provision_mysql [0.35 sec, 3.58 MB]               [bootstrap]
Undefined index:  db_url [0.35 sec, 3.58 MB]                                         [notice]
Undefined index:  user [0.35 sec, 3.58 MB]                                           [notice]
Undefined index:  pass [0.36 sec, 3.58 MB]                                           [notice]
Undefined index:  host [0.36 sec, 3.59 MB]                                           [notice]
Undefined index:  host [0.36 sec, 3.59 MB]                                           [notice]
Undefined index:  scheme [0.36 sec, 3.59 MB]                                         [notice]
Undefined index:  scheme [0.37 sec, 3.59 MB]                                         [notice]
Including /var/aegir/.drush/provision/web_server/verify.provision.inc [0.37 sec,  [bootstrap]
3.59 MB]
Including /var/aegir/.drush/provision/platform/verify.provision.inc [0.37 sec, 3.6[bootstrap]
MB]
Including /var/aegir/.drush/provision/db_server/verify.provision.inc [0.39 sec,   [bootstrap]
3.62 MB]
Including /var/aegir/.drush/provision/ssl/verify.provision.inc [0.39 sec, 3.62 MB][bootstrap]
Virtual host configuration path exists. [0.41 sec, 3.63 MB]                         [message]
Virtual host configuration ownership of path has been changed to aegir. [0.41 sec,  [message]
3.64 MB]
Virtual host configuration permissions of path have been changed to 0700. [0.42     [message]
sec, 3.64 MB]
Virtual host configuration path is writable. [0.43 sec, 3.64 MB]                    [message]
Platforms configuration path exists. [0.43 sec, 3.64 MB]                            [message]
Platforms configuration ownership of path has been changed to aegir. [0.43 sec,     [message]
3.64 MB]
Platforms configuration permissions of path have been changed to 0700. [0.44 sec,   [message]
3.64 MB]
Platforms configuration path is writable. [0.44 sec, 3.64 MB]                       [message]
Undefined variable: file [0.44 sec, 3.64 MB]                                         [notice]
Generating apache server configuration file . [0.44 sec, 3.64 MB]                    [notice]
Executing: sudo /usr/sbin/apache2ctl graceful [0.45 sec, 3.64 MB]                    [notice]
  apache2: Could not reliably determine the server's fully qualified domain name, using 169.229.220.121 for ServerName
  [Sun Feb 21 23:13:03 2010] [error] VirtualHost *:80 -- mixing * ports and non-* ports with a NameVirtualHost address is not supported, proceeding with undefined results
Apache has been restarted [1.1 sec, 3.64 MB]                                         [notice]
Provision configuration path exists. [1.1 sec, 3.64 MB]                             [message]
Provision configuration ownership of path has been changed to aegir. [1.1 sec,      [message]
3.64 MB]
Provision configuration permissions of path have been changed to 0711. [1.1 sec,    [message]
3.64 MB]
Provision configuration path is writable. [1.1 sec, 3.64 MB]                        [message]
Provision PHP configuration path does not exist. [1.1 sec, 3.64 MB]               [warning]
Provision PHP configuration path has been created. [1.11 sec, 3.64 MB]              [message]
Provision PHP configuration ownership of path has been changed to aegir. [1.11      [message]
sec, 3.64 MB]
Provision PHP configuration permissions of path have been changed to 0711. [1.11    [message]
sec, 3.65 MB]
Provision PHP configuration path is writable. [1.11 sec, 3.65 MB]                   [message]
Backup path exists. [1.11 sec, 3.65 MB]                                             [message]
Backup ownership of path has been changed to aegir. [1.11 sec, 3.65 MB]             [message]
Backup permissions of path have been changed to 0700. [1.11 sec, 3.65 MB]           [message]
Backup path is writable. [1.11 sec, 3.65 MB]                                        [message]
Drupal sites directory is writable by the provisioning script [1.11 sec, 3.65 MB]   [message]
This platform is running drupal 6.15 [1.11 sec, 3.65 MB]                             [notice]
Including non-version specific file :                                                [notice]
/var/aegir/.drush/provision/platform/drupal/packages.inc [1.11 sec, 3.65 MB]
Found 33 modules in base [1.24 sec, 3.78 MB]                                         [notice]
Found 6 themes in base [1.34 sec, 3.79 MB]                                           [notice]
Found install profile default [1.37 sec, 3.93 MB]                                    [notice]
Found install profile hostmaster [1.39 sec, 4 MB]                                    [notice]
Found 20 modules in profiles/hostmaster [1.53 sec, 4.06 MB]                          [notice]
Found 1 themes in profiles/hostmaster [1.54 sec, 4.07 MB]                            [notice]
Changed permissions of &lt;code&gt;sites/all&lt;/code&gt; to 0755 [1.55 sec, 4.1 MB]            [message]
Created &lt;code&gt;sites/all/themes&lt;/code&gt; [1.56 sec, 4.1 MB]                            [message]
Changed permissions of &lt;code&gt;sites/all/themes&lt;/code&gt; to 2775 [1.56 sec, 4.1 MB]     [message]
Created &lt;code&gt;sites/all/modules&lt;/code&gt; [1.57 sec, 4.1 MB]                           [message]
Changed permissions of &lt;code&gt;sites/all/modules&lt;/code&gt; to 2775 [1.57 sec, 4.1 MB]    [message]
Created &lt;code&gt;sites/all/libraries&lt;/code&gt; [1.59 sec, 4.1 MB]                         [message]
Changed permissions of &lt;code&gt;sites/all/libraries&lt;/code&gt; to 2775 [1.59 sec, 4.1 MB]  [message]
Created &lt;code&gt;sites/all/private&lt;/code&gt; [1.59 sec, 4.1 MB]                           [message]
Changed permissions of &lt;code&gt;sites/all/private&lt;/code&gt; to 0755 [1.59 sec, 4.1 MB]    [message]
Created &lt;code&gt;sites/all/private/files&lt;/code&gt; [1.6 sec, 4.1 MB]                      [message]
Changed permissions of &lt;code&gt;sites/all/private/files&lt;/code&gt; to 2770 [1.6 sec, 4.1   [message]
MB]
Created &lt;code&gt;sites/all/private/temp&lt;/code&gt; [1.6 sec, 4.1 MB]                       [message]
Changed permissions of &lt;code&gt;sites/all/private/temp&lt;/code&gt; to 2770 [1.61 sec, 4.1   [message]
MB]
Access denied for user ''@'localhost' to database 'site_test'                     [error]
query: CREATE DATABASE site_test [1.63 sec, 4.1 MB]
Unable to create new databases. [1.63 sec, 4.1 MB]                                [error]
An error occurred at function : drush_provision_mysql_provision_verify [1.64 sec, [error]
4.1 MB]
Command dispatch complete [1.64 sec, 4.09 MB]                                        [notice]
Peak memory usage was 4.3 MB [1.64 sec, 4.09 MB]                                     [memory]

Comment #9

adrian commented 25 February 2010 at 22:45


Access denied for user ''@'localhost' to database 'site_test'                     [error]
query: CREATE DATABASE site_test [1.63 sec, 4.1 MB]

you need to have used the front end to fill in and pass the details to the back end.

find the task $nid , and run

drush.php --root=/path/to/hostmaster --uri=aegir.site.com hosting-task $nid --debug

Comment #10

bwood commented 26 February 2010 at 00:42

Running that command I see:

...
Running:  /var/aegir/drush/drush.php                                                [command]
--master_db='mysqli://aegir:foo%24bar@sierra.ist.berkeley.edu'
...

There should be a $ where that %24 is.

Reinstalled and set the aegir_root password without any symbols. Updated the grant in mysql.

From the webserver I can connect to mysql as aegir_root with the new password.

Initial verify still fails.

hosting-task --debug:

$ ~/drush/drush.php --root=/var/aegir/hostmaster-HEAD --uri=aegir.adm.example.com hosting-task 6 --debug
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.12 sec, 4.19 MB]        [bootstrap]
Loading drushrc "/var/aegir/hostmaster-HEAD/drushrc.php" into "drupal" scope.     [bootstrap]
[0.12 sec, 4.2 MB]
Initialized Drupal 6.15 root directory at /var/aegir/hostmaster-HEAD [0.13 sec,      [notice]
5.19 MB]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [0.15 sec, 5.19 MB]        [bootstrap]
Initialized Drupal site aegir.adm.example.com at                             [notice]
sites/aegir.adm.example.com [0.15 sec, 5.19 MB]
Loading drushrc                                                                   [bootstrap]
"/var/aegir/hostmaster-HEAD/sites/aegir.adm.example.com/drushrc.php" into
"site" scope. [0.15 sec, 5.2 MB]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [0.16 sec, 5.45   [bootstrap]
MB]
Drush bootstrap phase : _drush_bootstrap_drupal_database() [0.18 sec, 5.46 MB]    [bootstrap]
Successfully connected to the Drupal database. [0.19 sec, 5.46 MB]                [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drupal_full() [0.21 sec, 5.77 MB]        [bootstrap]
Including version specific file :                                                    [notice]
/var/aegir/drush/commands/core/drupal/environment_6.inc [0.37 sec, 13.93 MB]
Found command: hosting-task (commandfile=hosting) [0.51 sec, 14.25 MB]            [bootstrap]
Initializing drush commandfile: drush_make [0.51 sec, 14.25 MB]                   [bootstrap]
Initializing drush commandfile: drush_make_d_o [0.51 sec, 14.26 MB]               [bootstrap]
Initializing drush commandfile: provision [0.51 sec, 14.26 MB]                    [bootstrap]
Initializing drush commandfile: provision_apache [0.51 sec, 14.26 MB]             [bootstrap]
Initializing drush commandfile: provision_drupal [0.51 sec, 14.26 MB]             [bootstrap]
Initializing drush commandfile: provision_mysql [0.51 sec, 14.26 MB]              [bootstrap]
Including profiles/hostmaster/modules/hosting/task.hosting.inc [0.51 sec, 14.27   [bootstrap]
MB]
The drush command hook naming conventions have changed; the function              [error]
drush_hosting_hosting_task_validate must be renamed to
drush_hosting_task_validate.  The old function will be called, but this will be
removed shortly. [0.51 sec, 14.3 MB]
The drush command hook naming conventions have changed; the function              [error]
drush_hosting_hosting_task must be renamed to drush_hosting_task.  The old
function will be called, but this will be removed shortly. [0.51 sec, 14.32 MB]
Drush bootstrap phase : _drush_bootstrap_drupal_login() [0.51 sec, 14.33 MB]      [bootstrap]
Task starts processing [0.56 sec, 14.84 MB]                                           [queue]
Running:  /var/aegir/drush/drush.php                                                [command]
--master_db='mysqli://aegir_root:secret@sierra.ist.berkeley.edu'
--platform='5' --publish_path='/var/aegir/hostmaster-HEAD'
--master_url='http://aegir.adm.example.com'
--drush_path='/var/aegir/drush/drush.php' --web_ip='169.229.216.92'
--script_user='aegir' --config_path='/var/aegir/config'
--backup_path='/var/aegir/backups' --web_id='2'
--web_host='aegir.adm.example.com' --web_group='apache'
--restart_cmd='sudo /usr/sbin/apachectl graceful'
--root='/var/aegir/hostmaster-HEAD' provision-verify --backend [0.58 sec, 14.96
MB]
Drush bootstrap phase : _drush_bootstrap_drush() [60.82 sec, 15.29 MB]            [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drupal_root() [60.82 sec, 15.29 MB]      [bootstrap]
Loading drushrc "/var/aegir/hostmaster-HEAD/drushrc.php" into "drupal" scope.     [bootstrap]
[60.82 sec, 15.3 MB]
Initialized Drupal 6.15 root directory at /var/aegir/hostmaster-HEAD [60.82 sec,     [notice]
15.3 MB]
Found command: provision-verify (commandfile=provision) [60.82 sec, 15.3 MB]      [bootstrap]
Initializing drush commandfile: drush_make [60.82 sec, 15.3 MB]                   [bootstrap]
Initializing drush commandfile: drush_make_d_o [60.83 sec, 15.3 MB]               [bootstrap]
Initializing drush commandfile: provision [60.83 sec, 15.3 MB]                    [bootstrap]
Initializing drush commandfile: provision_apache [60.83 sec, 15.3 MB]             [bootstrap]
Undefined index:  base_url [60.83 sec, 15.3 MB]                                      [notice]
Initializing drush commandfile: provision_drupal [60.83 sec, 15.3 MB]             [bootstrap]
Initializing drush commandfile: provision_mysql [60.83 sec, 15.3 MB]              [bootstrap]
Undefined index:  db_url [60.83 sec, 15.3 MB]                                        [notice]
Including /var/aegir/.drush/provision/web_server/verify.provision.inc [60.83 sec, [bootstrap]
15.31 MB]
Including /var/aegir/.drush/provision/platform/verify.provision.inc [60.84 sec,   [bootstrap]
15.31 MB]
Including /var/aegir/.drush/provision/db_server/verify.provision.inc [60.84 sec,  [bootstrap]
15.31 MB]
Including /var/aegir/.drush/provision/ssl/verify.provision.inc [60.84 sec, 15.31  [bootstrap]
MB]
Could not connect to the master database server (Can't connect to MySQL server on [error]
'sierra.ist.berkeley.edu' (4)). [60.84 sec, 15.31 MB]
An error occurred at function : drush_provision_mysql_provision_verify_validate   [error]
[60.84 sec, 15.31 MB]
Command dispatch complete [60.84 sec, 15.31 MB]                                      [notice]
Peak memory usage was 5.92 MB [60.84 sec, 15.31 MB]                                  [memory]
An error occurred at function : drush_hosting_hosting_task [60.86 sec, 15.21 MB]  [error]
Changes for drush_hosting_hosting_task module have been rolled back. [60.86 sec,   [rollback]
15.22 MB]
Command dispatch complete [60.86 sec, 15.18 MB]                                      [notice]
Timer 'page' is  60.71 sec. [60.87 sec, 15.18 MB]                                     [timer]
Peak memory usage was 15.41 MB [60.87 sec, 15.18 MB]                                 [memory]

Comment #11

axolx commented 12 March 2010 at 00:35

I believe I'm running into the same issue on 0.4-alpha6 (server is Debian lenny): I'm creating a platform in a remote server and failing at the Verify task. Per above, I ran the platform verify task through Drush:

drush --root='/home/aegir/hostmaster-0.4-alpha6' --uri='http://{URL_FOR_LOCAL_HOSTMASTER}' --debug hosting-task {TASK_NID}

And this is the command Drush tries to run on the remove server where the platform lives:

ssh -o PasswordAuthentication=no 'aegir'@'{REMOTE_HOSTMASTER_IP}' ' /home/aegir/drush/drush.php                                           
--master_db='\''mysqli://{DB_USER}:{DB_PW}@{LOCAL_HOSTMASTER_HOSTNAME}'\'' --platform='\''74'\''
--publish_path='\''/home/aegir/hostmaster-0.4-alpha6'\'' --master_url='\''http://{LOCAL_HOSTMASTER_HOSTNAME}'\''
--drush_path='\''/home/aegir/drush/drush.php'\'' --web_ip='\''{REMOTE_HOSTMASTER_IP}'\'' --script_user='\''aegir'\''
--config_path='\''/home/aegir/config'\'' --backup_path='\''/home/aegir/backups'\'' --web_id='\''71'\''
--web_host='\''{REMOTE_HOSTMASTER_HOSTNAME}'\'' --web_group='\''www-data'\'' --restart_cmd='\''sudo /usr/sbin/apache2ctl graceful'\''
--root='\''/home/aegir/hostmaster-0.4-alpha6'\'' provision-verify --backend'

The failure happens here:

Could not connect to the master database server (Unknown MySQL server host '{LOCAL_HOSTMASTER_HOSTNAME}' (1)).

If I'm not mistaken the problem is the use of LOCAL_HOSTMASTER_HOSTNAME above. I'm fairly new to Aegir, so any help or any direction for how I could help would be great!

Postponed (maintainer needs more info)

» Fixed

This is resolved in HEAD.

the db server is stored as part of a server alias in it's own config, and the site has a db_server field associated to it.

Comment #15

2 July 2010 at 06:50

Status:

Fixed

» Closed (fixed)

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

provision-verify fails on hostmaster install with remote database

Comments

Comment #1

Comment #2

Comment #3

Comment #4

Comment #5

Comment #6

Comment #7

Comment #8

Comment #9

Comment #10

Comment #11

Comment #12

Comment #13

Comment #14

Comment #15

News items

Our community

Documentation

Drupal code base

Governance of community