install fails with prefixes [#659678]

It seems the post install is rougher than the initial install... Here's my system info for debugging:

FreeBSD

$ uname -a
FreeBSD freebsd2.example.net 7.2-RELEASE-p4 FreeBSD 7.2-RELEASE-p4 #0: Fri Oct  2 12:21:39 UTC 2009     root@i386-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC  i386

Aegir-HEAD
Drush-HEAD
drush_make 2.0-beta2

install.sh version options

AEGIR_VERSION=HEAD
DRUSH_VERSION=All-Versions-HEAD
$DRUSH dl drush_make-6.x-2.0-beta2 --destination=$AEGIR_HOME/.drush

PHP

$ php -v
PHP 5.2.11 with Suhosin-Patch 0.9.7 (cli) (built: Dec 12 2009 08:22:51)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies

MYSQL

$ mysql -v
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9701
Server version: 5.0.88 FreeBSD port: mysql-server-5.0.88

apache 2.2

$ sudo apachectl -v
Server version: Apache/2.2.14 (FreeBSD)
Server built:   Dec 12 2009 03:11:50

$ sudo apachectl configtest
Syntax OK

httpd.conf modified values

Listen 80
ServerAdmin sysadmin@example.com
ServerName www.example.com:80
Include /www/aegir/config/vhost.d/

$ id
uid=1002(aegir) gid=1002(aegir) groups=1002(aegir),80(www),1003(www-data)

drush provision verify output

$ /www/aegir/drush/drush --debug provision verify
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.029 sec]   [bootstrap]
Loading drushrc "/rest/aegir/platforms/hostmaster-HEAD/drushrc.php"  [bootstrap]
into "drupal" scope. [0.029 sec]
Initialized Drupal 6.14 root directory at                               [notice]
/www/aegir/platforms/hostmaster-HEAD [0.036 sec]
Found command: provision verify [0.038 sec]                          [bootstrap]
Initializing drush commandfile: provision_apache [0.038 sec]         [bootstrap]
Undefined index:  base_url [0.039 sec]                                  [notice]
Initializing drush commandfile: provision_drupal [0.039 sec]         [bootstrap]
Initializing drush commandfile: provision_mysql [0.039 sec]          [bootstrap]
Undefined index:  db_url [0.039 sec]                                    [notice]
Including                                                            [bootstrap]
/home/aegir/.drush/provision/web_server/verify.provision.inc [0.039
sec]
Including /home/aegir/.drush/provision/platform/verify.provision.inc [bootstrap]
[0.039 sec]
Including /home/aegir/.drush/provision/db_server/verify.provision.inc[bootstrap]
[0.04 sec]
Including /home/aegir/.drush/provision/ssl/verify.provision.inc [0.04[bootstrap]
sec]
Virtual host configuration path exists. [0.043 sec]                    [message]
Virtual host configuration ownership of path has been changed to       [message]
aegir. [0.043 sec]
Virtual host configuration permissions of path have been changed to    [message]
0700. [0.043 sec]
Virtual host configuration path is writable. [0.043 sec]               [message]
Generating apache host configuration file aegir.example.net.server.     [notice]
[0.043 sec]
Executing: sudo /usr/local/sbin/apachectl graceful [0.044 sec]          [notice]
Apache has been restarted [0.115 sec]                                   [notice]
Provision configuration path exists. [0.115 sec]                       [message]
Provision configuration ownership of path has been changed to aegir.   [message]
[0.115 sec]
Provision configuration permissions of path have been changed to       [message]
0711. [0.115 sec]
Provision configuration path is writable. [0.116 sec]                  [message]
Provision PHP configuration path exists. [0.116 sec]                   [message]
Provision PHP configuration ownership of path has been changed to      [message]
aegir. [0.116 sec]
Provision PHP configuration permissions of path have been changed to   [message]
0711. [0.116 sec]
Provision PHP configuration path is writable. [0.116 sec]              [message]
Global configuration file exists [0.116 sec]                           [message]
Backup path exists. [0.116 sec]                                        [message]
Backup ownership of path has been changed to aegir. [0.117 sec]        [message]
Backup permissions of path have been changed to 0700. [0.117 sec]      [message]
Backup path is writable. [0.117 sec]                                   [message]
Drupal sites directory is writable by the provisioning script [0.117   [message]
sec]
This platform is running drupal 6.14 [0.117 sec]                        [notice]
Including non-version specific file :                                   [notice]
/home/aegir/.drush/provision/platform/drupal/packages.inc [0.117 sec]
Found 33 modules in base [0.135 sec]                                    [notice]
Found 6 themes in base [0.139 sec]                                      [notice]
Found install profile default [0.141 sec]                               [notice]
Found install profile hostmaster [0.142 sec]                            [notice]
Found 19 modules in profiles/hostmaster [0.164 sec]                     [notice]
Found 1 themes in profiles/hostmaster [0.165 sec]                       [notice]
Changed permissions of <code>sites/all

to 0755 [0.167 sec] [message]
Changed permissions of sites/all/themes to 2775 [0.167 [message]
sec]
Changed permissions of sites/all/modules to 2775 [0.167 [message]
sec]
Changed permissions of sites/all/libraries to 2775 [message]
[0.167 sec]
Mysql can create new databases. [0.168 sec] [message]
Found existing drushrc.php file [0.169 sec] [notice]
Changed permissions of drushrc.php to 0600 [0.169 sec] [message]
Drushrc file (/www/aegir/platforms/hostmaster-HEAD/drushrc.php) was [notice]
written successfully [0.17 sec]
Changed permissions of drushrc.php to 0400 [0.171 sec] [message]
Command dispatch complete [0.171 sec] [notice]

DEBUG INFO

Here I have attached all the debugging info pertaining to my installation

First output is from 'hosting dispatch':

$ /usr/local/bin/php '/www/aegir/drush/drush.php' --debug hosting dispatch --root='/www/aegir/public_html' --uri='http://aegir.example.net'
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.029 sec]   [bootstrap]
Loading drushrc "/rest/aegir/platforms/hostmaster-HEAD/drushrc.php"  [bootstrap]
into "drupal" scope. [0.029 sec]
Initialized Drupal 6.14 root directory at /www/aegir/public_html        [notice]
[0.036 sec]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [0.038 sec]   [bootstrap]
Initialized Drupal site aegir.example.net at sites/aegir.example.net    [notice]
[0.038 sec]
Loading drushrc                                                      [bootstrap]
"/rest/aegir/platforms/hostmaster-HEAD/sites/aegir.example.net/drushrc.php"
into "site" scope. [0.038 sec]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration()      [bootstrap]
[0.041 sec]
Drush bootstrap phase : _drush_bootstrap_drupal_database() [0.045    [bootstrap]
sec]
Successfully connected to the Drupal database. [0.045 sec]           [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drupal_full() [0.05 sec]    [bootstrap]
Table &#039;aegir.system&#039; doesn&#039;t exist                    [error]
query: SELECT name, filename, throttle FROM system WHERE type =
&#039;module&#039; AND status = 1 ORDER BY weight ASC, filename ASC
in /rest/aegir/platforms/hostmaster-HEAD/includes/module.inc on line
64. [0.077 sec]
The command 'drush.php hosting dispatch' could not be found. [0.077  [error]
sec]

output from /var/log/messages:
>code>
Dec 14 05:52:35 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/usr/home/bsdadmin ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 05:57:23 freebsd2 sudo: aegir : TTY=unknown ; PWD=/rest/aegir/hostmaster-HEAD ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:00:58 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/usr/home/bsdadmin ; USER=root ; COMMAND=/usr/sbin/cron
Dec 14 06:02:01 freebsd2 sudo: aegir : TTY=unknown ; PWD=/rest/aegir/hostmaster-HEAD ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:13:45 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:14:29 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:14:59 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:18:58 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:28:18 freebsd2 sudo: aegir : TTY=unknown ; PWD=/rest/aegir/platforms/hostmaster-HEAD ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:32:01 freebsd2 sudo: aegir : TTY=unknown ; PWD=/rest/aegir/platforms/hostmaster-HEAD ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:37:01 freebsd2 sudo: aegir : TTY=unknown ; PWD=/rest/aegir/platforms/hostmaster-HEAD ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:39:34 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/sbin/cron
Dec 14 06:41:28 freebsd2 sudo: aegir : pam_authenticate: conversation failure ; TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=apachctl graceful
Dec 14 06:41:33 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:48:45 freebsd2 sudo: aegir : TTY=unknown ; PWD=/rest/aegir/platforms/hostmaster-HEAD ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:51:19 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:51:57 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/local/sbin/apachectl graceful
Dec 14 06:52:33 freebsd2 sudo: aegir : TTY=ttyp0 ; PWD=/rest/aegir ; USER=root ; COMMAND=/usr/sbin/cron

Right before aegir fails..

I receive a strange error in my httpd log:

[Mon Dec 14 13:09:04 2009] [error] [client 96.19.51.46] PHP Notice:  Undefined variable: variables in /rest/aegir/platforms/hostmaster-HEAD/includes/bootstrap.inc on line 480

This error first shows up AFTER initial verify of main install and initial import, it is after second verify task runs that this error appears and then my httpd-error.log is flooded with the following errors:

[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.access&#039; doesn&#039;t exist\nquery: SELECT 1 FROM access WHERE type = &#039;host&#039; AND LOWER(&#039;96.19.51.46&#039;) LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.users&#039; doesn&#039;t exist\nquery: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = &#039;61tvkkjulgmogflj3e1f77se53&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.cache&#039; doesn&#039;t exist\nquery: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = &#039;variables&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.variable&#039; doesn&#039;t exist\nquery: SELECT * FROM variable in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Notice:  Undefined variable: variables in /rest/aegir/platforms/hostmaster-HEAD/includes/bootstrap.inc on line 480, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.cache&#039; doesn&#039;t exist\nquery: UPDATE cache SET data = &#039;&#039;, created = 1260817233, expire = 0, headers = &#039;&#039;, serialized = 0 WHERE cid = &#039;variables&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.cache_page&#039; doesn&#039;t exist\nquery: SELECT data, created, headers, expire, serialized FROM cache_page WHERE cid = &#039;http://aegir.example.net/&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.system&#039; doesn&#039;t exist\nquery: SELECT name, filename, throttle FROM system WHERE type = &#039;module&#039; AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.url_alias&#039; doesn&#039;t exist\nquery: SELECT COUNT(pid) FROM url_alias in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.access&#039; doesn&#039;t exist\nquery: SELECT 1 FROM access WHERE type = &#039;host&#039; AND LOWER(&#039;96.19.51.46&#039;) LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.users&#039; doesn&#039;t exist\nquery: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = &#039;61tvkkjulgmogflj3e1f77se53&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.cache&#039; doesn&#039;t exist\nquery: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = &#039;variables&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.variable&#039; doesn&#039;t exist\nquery: SELECT * FROM variable in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Notice:  Undefined variable: variables in /rest/aegir/platforms/hostmaster-HEAD/includes/bootstrap.inc on line 480, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.cache&#039; doesn&#039;t exist\nquery: UPDATE cache SET data = &#039;&#039;, created = 1260817269, expire = 0, headers = &#039;&#039;, serialized = 0 WHERE cid = &#039;variables&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.cache_page&#039; doesn&#039;t exist\nquery: SELECT data, created, headers, expire, serialized FROM cache_page WHERE cid = &#039;http://aegir.example.net/hosting/tasks/queue&#039; in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.system&#039; doesn&#039;t exist\nquery: SELECT name, filename, throttle FROM system WHERE type = &#039;module&#039; AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information
[Mon Dec 14 13:01:09 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.url_alias&#039; doesn&#039;t exist\nquery: SELECT COUNT(pid) FROM url_alias in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information

Line 480 bootstrap.inc

Here's the code snippet that causes the error but I must admit i'm not even sure why it breaks the site

Line 480: cache_set('variables', $variables);

function variable_init($conf = array()) {
  // NOTE: caching the variables improves performance by 20% when serving cached pages.
  if ($cached = cache_get('variables', 'cache')) {
    $variables = $cached->data;
  }
  else {
    $result = db_query('SELECT * FROM {variable}');
    while ($variable = db_fetch_object($result)) {
      $variables[$variable->name] = unserialize($variable->value);
    }
    cache_set('variables', $variables);
  }

  foreach ($conf as $name => $value) {
    $variables[$name] = $value;
  }

  return $variables;
}

database errors:

mysql> select * from dwhm_hosting_platform;
+-----+-----+--------------------------------------+------------+------------+------------+
| vid | nid | publish_path                         | web_server | release_id | verified   |
+-----+-----+--------------------------------------+------------+------------+------------+
|   5 |   5 | /www/aegir/platforms/hostmaster-HEAD |          3 |          0 | 1260816829 |
+-----+-----+--------------------------------------+------------+------------+------------+
1 row in set (0.00 sec)

mysql> select * from dwhm_hosting_task;
+-----+-----+-----------+-----+-------------+------------+-------+
| vid | nid | task_type | rid | task_status | executed   | delta |
+-----+-----+-----------+-----+-------------+------------+-------+
|   6 |   6 | verify    |   5 |           1 | 1260816829 |     0 |
|  69 |  69 | import    |  68 |           1 | 1260817008 |     0 |
|  70 |  70 | verify    |  68 |           2 | 1260817214 |     0 |
+-----+-----+-----------+-----+-------------+------------+-------+
3 rows in set (0.00 sec)

If I try to manually run hosting task I am unable to parse the url:

$ /usr/local/bin/php /www/aegir/drush/drush.php --debug --root=/www/aegir/platforms/hostmaster-HEAD --url=http://www.example.net hosting task 70

Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.029 sec]   [bootstrap]
Loading drushrc "/rest/aegir/platforms/hostmaster-HEAD/drushrc.php"  [bootstrap]
into "drupal" scope. [0.029 sec]
Initialized Drupal 6.14 root directory at                               [notice]
/www/aegir/platforms/hostmaster-HEAD [0.036 sec]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [0.038 sec]   [bootstrap]
Initialized Drupal site default at sites/default [0.038 sec]            [notice]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [0.04[bootstrap]
sec]
Undefined index:  db_type [0.041 sec]                                   [notice]
Undefined index:  db_name [0.041 sec]                                   [notice]
Undefined index:  db_user [0.041 sec]                                   [notice]
Undefined index:  db_passwd [0.041 sec]                                 [notice]
Undefined index:  db_host [0.041 sec]                                   [notice]
Undefined index:  db_type [0.041 sec]                                   [notice]
Undefined index:  db_user [0.041 sec]                                   [notice]
Undefined index:  db_passwd [0.041 sec]                                 [notice]
Undefined index:  db_host [0.041 sec]                                   [notice]
Undefined index:  db_name [0.041 sec]                                   [notice]
parse_url(://:@/): Unable to parse URL [0.068 sec]                   [warning]
PHP Fatal error:  Unsupported operand types in /rest/aegir/drush/includes/environment.inc on line 664

Fatal error: Unsupported operand types in /rest/aegir/drush/includes/environment.inc on line 664
Drush command could not be completed. [0.068 sec]                    [error]

Any help is appreciated

After Aegir fails and all my requests get routed to a blank page I am not even able to run hosting setup again: I would assume that using the same command should process identically but something changes from first verify to second verify and they only way I can "stop the break" is to disable cron but then i cannot run any task after that second verify

$ /usr/local/bin/php /www/aegir/drush/drush.php --debug --root=/www/aegir/platforms/hostmaster-HEAD --url=http://www.exarnet.net hosting setup

Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.028 sec] [bootstrap]
Loading drushrc "/rest/aegir/platforms/hostmaster-HEAD/drushrc.php" [bootstrap]
into "drupal" scope. [0.029 sec]
Initialized Drupal 6.14 root directory at [notice]
/www/aegir/platforms/hostmaster-HEAD [0.036 sec]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [0.038 sec] [bootstrap]
Initialized Drupal site default at sites/default [0.038 sec] [notice]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [0.04[bootstrap]
sec]
Undefined index: db_type [0.041 sec] [notice]
Undefined index: db_name [0.041 sec] [notice]
Undefined index: db_user [0.041 sec] [notice]
Undefined index: db_passwd [0.041 sec] [notice]
Undefined index: db_host [0.041 sec] [notice]
Undefined index: db_type [0.041 sec] [notice]
Undefined index: db_user [0.041 sec] [notice]
Undefined index: db_passwd [0.041 sec] [notice]
Undefined index: db_host [0.041 sec] [notice]
Undefined index: db_name [0.041 sec] [notice]
parse_url(://:@/): Unable to parse URL [0.041 sec] [warning]
PHP Fatal error: Unsupported operand types in /rest/aegir/drush/includes/environment.inc on line 664

Fatal error: Unsupported operand types in /rest/aegir/drush/includes/environment.inc on line 664
Drush command could not be completed. [0.041 sec] [error]

Comment	File	Size	Author
#1	dwhm_hosting_task_log.tbl121409.sql_.tar_.gz	2.95 KB	tiato

Comments

Comment #1

tiato commented 14 December 2009 at 21:36

Title:	install fails with prefixes	» FreeBSD Post Install (hosting_task_log)s
Category:	support	» bug
Status:	Postponed (maintainer needs more info)	» Active

Status	File	Size
new	dwhm_hosting_task_log.tbl121409.sql_.tar_.gz	2.95 KB

I forgot to attach to original post but here is a dump of the hosting_task_log table, the last entries are the errors that caused aegir to break and i cannot copy paste without breaking spacing, so here is the table, should be able to import with root sql user and then just view through queries

EDIT: This might be worth looking into for this -> http://groups.drupal.org/node/4247

Comment #2

Anonymous (not verified) commented 14 December 2009 at 20:40

There's like a million different things going on here..

I have to run out the door but something very quick that I noticed: discrepancy between database or prefixes or something?

[Mon Dec 14 13:00:33 2009] [error] [client 96.19.51.46] PHP Warning:  Table &#039;aegir.variable&#039; doesn&#039;t exist\nquery: SELECT * FROM variable in /rest/aegir/platforms/hostmaster-HEAD/includes/database.mysqli.inc on line 128, referer: http://aegir.example.net/admin/settings/site-information

'aegir.variable'

mysql> select * from dwhm_hosting_task;

Is the database 'aegir' but with 'dwhm' table prefixes? If so I guess it's not detecting the prefixes

Comment #3

tiato commented 14 December 2009 at 21:06

Okay, very odd, very very odd. So I went ahead and called http://www.example.com/install.php again WITHOUT rebuilding Aegir & Friends (deps)

It is worth noting some SQL duplicate errors were popping up but I simply ignored and setup the config again. And it worked! All tasks are verified, cron is running, and i can restart apache fine and literally no error logs, anywhere, i need to further investigate the logs but it literally looks like it was errored out, aegir requested restart, and *poof* no more errors.

Will post my findings.

Comment #4

tiato commented 14 December 2009 at 21:14

That's exactly it, I use table prefixes and honestly have been using them on every single install attempt.

I can actually confirm your suspicion, after you mentioned this i went into the database and did a quick '> show tables;' which confirms this:

mysql> show tables;
+--------------------------------+
| Tables_in_aegir                |
+--------------------------------+
| access                         |
| actions                        |
| actions_aid                    |
| authmap                        |
| batch                          |
| blocks                         |
| blocks_roles                   |
| boxes                          |
| cache                          |
| cache_block                    |
| cache_filter                   |
| cache_form                     |
| cache_menu                     |
| cache_page                     |
| cache_update                   |
| comments                       |
| dwhm_access                    |
| dwhm_actions                   |
| dwhm_actions_aid               |
| dwhm_authmap                   |
| dwhm_batch                     |
| dwhm_blocks                    |
| dwhm_blocks_roles              |
| dwhm_boxes                     |
| dwhm_cache                     |
| dwhm_cache_block               |
| dwhm_cache_filter              |
| dwhm_cache_form                |
| dwhm_cache_menu                |
| dwhm_cache_page                |
| dwhm_cache_update              |
| dwhm_comments                  |

Notice there are no two entries, one with prefix and one without. Prefix is my original install which is obviously broken now, I mus have not even noticed forgetting the prefix but lucky i did. I am convinced this is it, aegir is running beautifully right now.

Comment #5

anarcat commented 14 December 2009 at 21:23

Title:	FreeBSD Post Install	» install fails with prefixes
Category:	bug	» support
Status:	Active	» Postponed (maintainer needs more info)

So the problem here is lack of prefix support. Please try again without prefixes to see if the install works. See #483346: allow importing of table-prefixed database setup

Comment #6

tiato commented 15 December 2009 at 11:47

Title:	FreeBSD Post Install (hosting_task_log)s	» install fails with prefixes
Category:	bug	» support
Status:	Active	» Postponed (maintainer needs more info)

Did try it without prefixes and the install works fine, Verifies and Imports without errors.

I unfortunately had to rename each table without the prefix to get it working, it was the quickest solution for me. Question is which is the better route? trying to add better prefix_ support as it seems to be an issue with how Drupal handles prefixes or convert a database with prefixes to drush friendly database without prefixes?

I opted for the latter myself as it seemed the quickest result.

I am going to make a script to automatically rename the tables, I am using sql to generate the table list and execute the rename but need to create a script to dynamically generate the rename sql query from the sql result for prefixed tables

dump tables with prefix from DB, saved as get_prefix_list.sql:

use mysql_db;
show tables where `Tables_in_mysql_db` like 'prefix_%';

executes with:

mysql -uroot_user -pXXXXXX < get_prefix_list.sql > prefix_list

I opted for alter to rename the tables as it is more reliable, generated as prefix_rename.sql:

use mysql_db;
alter table prefix_table_name rename table_name;

executes with:

mysql -uroot_user -pXXXXXX < prefix_rename.sql

I am leaning towards using a shell script to handle generating the sql queries, executing the queries, then cleaning itself up. Seems converting the db to be drush friendly would be easier than trying to hack how drupal handles $db_prefix

Comment #7

tiato commented 16 December 2009 at 04:56

some issues with permissions after site imports & installs with custom php scripts, i believe this is an isolated issue as i created a different username than what original db user was, will revert to original username and test out.

Comment #8

tiato commented 16 December 2009 at 15:18

well, using the exact same user seems to have done the trick, the aegir platform installed, verified, and seems to be working properly. However, when I import a site (with prefixed db) it works, somewhat, for a couple crons and then fails.

By somewhat any custom PHP script does not execute even with the PHP filter enabled, i believe this to be isolated to BSD however and am still debugging, site goes to white page after a couple cron jobs.

Points of interest:
After enabling more aggressive error logging (output HTML errors) on apache and php I see the following in my logs:

drush PHP Warning:  Cannot load module 'pdo_mysql' because required module 'pdo' is not loaded in Unknown on line 0

A quick check for configure options results in this output:

/www/apache22 # /usr/local/bin/php --info | grep configure
Configure Command =>  './configure'  '--with-layout=GNU' '--with-config-file-scan-dir=/usr/local/etc/php' '--disable-all' '--enable-libxml' '--with-libxml-dir=/usr/local' '--enable-reflection' '--program-prefix=' '--enable-fastcgi' '--with-apxs2=/usr/local/sbin/apxs' '--with-regex=php' '--with-zend-vm=CALL' '--disable-ipv6' '--prefix=/usr/local' '--mandir=/usr/local/man' '--infodir=/usr/local/info/' '--build=i386-portbld-freebsd7.2'
bsdadmin@freebsd2:/usr/ports/www/apache22 # /usr/local/bin/php --info | grep configure

Notice there's no pdo, however PDO is compiled from php5-extensions and enabled in php.ini. I think reinstalling apache and php5 may fix this I will also double check mysql to make sure it supports PDO. Interstingly enough, this error does not affect the aegir platform only imported sites with converted databases (prefixed removed) a brand spanking new site (no import) works fine even after cron. I am still debugging so unsure if there could also be another module causing these errors an in turn breaking the sites, the site being imported has 18 active modules as it is and that number is quite high.

Note the error only appears while apache is booting, it does not halt the boot process and afterward when HTTP requests are made to example.com i receive the following output in httpd-error.log:

[notice] child pid 98677 exit signal Illegal instruction (4)

the matching entry in httpd_access.log is:

[16/Dec/2009:09:09:56 -0600] "GET /status HTTP/1.1" 301 - "-" "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5 (.NET CLR 3.5.30729)"

notice where the web address should appear (after 301) the value passed is "-" which I believe to be incorrect. I will continue debugging this and post my results

extras: though no errors exist on the aegir import and verify task logs these entries appear and stir my curiousity:

Undefined index: base_url
Initializing drush commandfile: provision_drupal
Initializing drush commandfile: provision_mysql
Undefined index: db_url

Comment #9

anarcat commented 13 January 2010 at 22:18

Status:

Postponed (maintainer needs more info)

» Fixed

I'm not sure what issue remains here so I'm closing this support request. Try to be more terse next time so we can more easily figure out what you're actually looking for.

Comment #10

Coornail commented 21 January 2010 at 13:54

Category:	support	» bug
Status:	Fixed	» Active

I have exactly the same error with 6.x-0.4 on a standard debian installation.

The error lays somewhere in the hosting_db_server.module:59

function hosting_db_server_as_url($nid) {                                                                │                        
  $node = node_load($nid);                                                                               │                        
  return sprintf("%s://%s:%s@%s", $node->db_type, $node->db_user, $node->db_passwd, $node->title);       │                        
}

Where the $node->db_type is not populated. I'll dive deeper.

Comment #11

Coornail commented 21 January 2010 at 14:11

Maybe It was a bit too early to tell the error is there.

When I run drush in debug mode I got the following:

Granting privileges to stud1tryoutpro_12@localhost on                   [notice]
stud1tryoutpro_12 [0.114 sec]
String 'stud1tryoutpro_12' is too long for user name (should be no   [error]
longer than 16)
query: GRANT ALL PRIVILEGES ON `stud1tryoutpro_12`.* TO
`stud1tryoutpro_12`@`localhost` IDENTIFIED BY 'iKL3gCE5qH' [0.114
sec]
Could not GRANT user access. [0.114 sec]                             [warning]

Comment #12

Coornail commented 21 January 2010 at 15:09

Digged deeper:

In _provision_drupal_create_settings_file() $options['db_type'] and $options['db_host'] is NULL.

If I enter those it works.

Comment #13

anarcat commented 30 January 2010 at 17:03

Category:	bug	» support
Status:	Active	» Fixed

@Coornail - which "exact same error"? This bug report is unusable exactly because there are about 20 different and sometimes unrelated error messages. What we need here is a concise report of the issue at hand. Keep in mind that we are *aware* of table-prefixes causing problems, it's well documented in #483346: allow importing of table-prefixed database setup and as long as that other issue is not fixed, people using $db_prefix will have problems with aegir.

Please open a new issue if you feel this is a bug report, as the original post here was more a micmac of different support requests than a real bug report.

Comment #14

13 February 2010 at 17:10