user warning: Table 'XXX.hosting_ip_addresses' doesn't exist

Hum. This is clearly not normal, and a bug with a recent merge. Where do you get this error?

In fact, I don't understand how you can reproduce this - the hosting_ip_addresses should be created by the hosting_server.module, and has been for more than 2 years now...

I was able to reproduce in Jenkins, you're right! This is really broken, and here's the cause:

[127.0.0.1:2200] out: Key column 'vid' doesn't exist in table                 [warning]
[127.0.0.1:2200] out: query: CREATE TABLE hosting_ip_addresses (
[127.0.0.1:2200] out: `id` INT unsigned NOT NULL DEFAULT 0, 
[127.0.0.1:2200] out: `nid` INT unsigned NOT NULL DEFAULT 0, 
[127.0.0.1:2200] out: `ip_address` TINYTEXT NOT NULL, 
[127.0.0.1:2200] out: PRIMARY KEY (id), 
[127.0.0.1:2200] out: INDEX vid (vid), 
[127.0.0.1:2200] out: INDEX ip_address (ip_address)
[127.0.0.1:2200] out: ) /*!40100 DEFAULT CHARACTER SET utf8 */ database.mysqli.inc:134

fixed in alpha1 and git.

I am getting this issue, with alpha1. Still not fixed

hi,
i had the same issue but caused by a different issue. the create table query: CREATE TABLE hosting_ip_addresses failed because of the following error: "BLOB/TEXT column 'ip_address' used in key specification without a key length"
i was able to manually create the table using the following query:

CREATE TABLE hosting_ip_addresses (
`id` INT unsigned NOT NULL DEFAULT 0, 
`nid` INT unsigned NOT NULL DEFAULT 0, 
`ip_address` TINYTEXT NOT NULL, 
PRIMARY KEY (id), 
INDEX nid (nid), 
INDEX ip_address (ip_address(15))
);

more info here: http://stackoverflow.com/questions/1827063/mysql-error-key-specification...

Wow okay that's weird. The code is fixed in git and in the debian package, how could it fail through a manual install??

how did you install aegir? Where did you get the code?

I can confirm this is still happening in alpha 1.

user warning: Table 'aegirxxxxxxxcom.hosting_ip_addresses' doesn't exist query: SELECT ip_address FROM hosting_ip_addresses WHERE nid=4 in /var/aegir/hostmaster-6.x-2.0-alpha1/profiles/hostmaster/modules/hosting/server/hosting.ip.inc on line 72.

I installed via Debian package.

I have tested both manual install and automated install now with drush 5.8.0 on Debian Squeeze, identical environment, but different instances and the errors below still exist on both.

user warning: Table 'aegir2.hosting_ip_addresses' doesn't exist query: SELECT ip_address FROM hosting_ip_addresses WHERE nid=4 in /var/aegir/hostmaster-6.x-2.0-alpha1/profiles/hostmaster/modules/hosting/server/hosting.ip.inc on line 72.
user warning: Table 'aegir2.hosting_ip_addresses' doesn't exist query: SELECT ip_address FROM hosting_ip_addresses WHERE nid=2 in /var/aegir/hostmaster-6.x-2.0-alpha1/profiles/hostmaster/modules/hosting/server/hosting.ip.inc on line 72.

Weird. I can't reproduce this exact symptom in git, but i do get similar errors in Jenkins:

[127.0.0.1:2200] out: Duplicate entry '0' for key 'PRIMARY'              [warning]
[127.0.0.1:2200] out: query: INSERT INTO hosting_ip_addresses (nid, ip_address) VALUES (4,
[127.0.0.1:2200] out: '127.0.0.1') database.mysqli.inc:134

http://ci.aegirproject.org/job/D%20aegir%206.x-2.x%20install/466/console...

I'll look into this...

Reproduced in a manual install... raaah:

drupal-6.28 downloaded.                                                                                                                                                                                                             [ok]
hostmaster cloned from http://git.drupal.org/project/hostmaster.git.                                                                                                                                                                [ok]
Checked out tag 6.x-2.0-alpha1.                                                                                                                                                                                                     [ok]
Found makefile: hostmaster.make                                                                                                                                                                                                     [ok]
hosting_platform_pathauto-6.x-2.0-beta1 downloaded.                                                                                                                                                                                 [ok]
jquery_ui-6.x-1.4 downloaded.                                                                                                                                                                                                       [ok]
>> Project modalframe contains 2 modules: modalframe_example, modalframe.modalframe-6.x-1.6 downloaded.                                                                                                                                                                                                      [ok]
eldir-6.x-2.0-alpha1 downloaded.                                                                                                                                                                                                    [ok]
admin_menu-6.x-1.8 downloaded.                                                                                                                                                                                                      [ok]
install_profile_api-6.x-2.1 downloaded.                                                                                                                                                                                             [ok]
openidadmin-6.x-1.2 downloaded.                                                                                                                                                                                                     [ok]
jquery_ui downloaded from http://jquery-ui.googlecode.com/files/jquery.ui-1.6.zip.                                                                                                                                                  [ok]
Created aegirorangeseeds database                                                                                                                                                                                                   [success]
BLOB/TEXT column 'ip_address' used in key specification without a key length                                                                                                                                              [warning]
query: CREATE TABLE hosting_ip_addresses (
`id` INT unsigned NOT NULL DEFAULT 0,
`nid` INT unsigned NOT NULL DEFAULT 0,
`ip_address` TINYTEXT NOT NULL,
PRIMARY KEY (id),
INDEX nid (nid),
INDEX ip_address (ip_address)
) /*!40100 DEFAULT CHARACTER SET utf8 */ database.mysqli.inc:134
Table 'aegirorangeseeds.hosting_ip_addresses' doesn't exist                                                                                                                                                          [warning]
query: INSERT INTO hosting_ip_addresses (nid, ip_address) VALUES (2, '192.168.0.3') database.mysqli.inc:134
Table 'aegirorangeseeds.hosting_ip_addresses' doesn't exist                                                                                                                                                          [warning]
query: SELECT ip_address FROM hosting_ip_addresses WHERE nid=2 database.mysqli.inc:134
Table 'aegirorangeseeds.hosting_ip_addresses' doesn't exist                                                                                                                                                          [warning]
query: INSERT INTO hosting_ip_addresses (nid, ip_address) VALUES (4, '127.0.0.1') database.mysqli.inc:134
Table 'aegirorangeseeds.hosting_ip_addresses' doesn't exist                                                                                                                                                          [warning]
query: SELECT ip_address FROM hosting_ip_addresses WHERE nid=4 database.mysqli.inc:134

Hum. So this *was* fixed in git properly, which is why Jenkins is not picking it up.

However, I screwed up when laying down the tags - I had moved my local tag to the right commit, but somehow forgot to push this to hostmaster before making the release nodes.

So the original bug reported here actually *is* fixed in 2.x. Get hostmaster from git 6.x-2.x to see the goods.

Commit that fixes this is c402e86. I'll open a separate issue for that other warning.

I can confirm if installing hostmaster from git, this gets rid of the error. I was trying to document how to go about setting up hostmaster from git, as I hadn't successfully accomplished this yet myself. I thought it might be useful for others in the same position. This may be a separate issue, if I should open one, please let me know. I'm running in to the following errors after running drush hostmaster-install.

This command will replace your crontab for this user. continue? (y/n): y
/usr/share/php/drush/drush.php '@hostmaster' hosting-dispatch
sh: /usr/share/php/drush/drush.php: Permission denied
Dispatch command could not be run. Returned: [error]

The command did not complete successfully, please fix the issues and re-run this script [error]

Also, when I log in to aegir now, I cannot create a site as I am getting a "No valid choices" error on both Install Profile and Platform. Can you please take a look at my documentation below and let me know what I am doing wrongly.

Follow Manual install instructions up until 5.2. Install provision

mkdir /var/aegir/.drush
cd /var/aegir/.drush
git clone --recursive --branch 6.x-2.x http://git.drupal.org/project/provision.git

cd /var/aegir
git clone --recursive --branch 6.x-2.x http://git.drupal.org/project/hostmaster.git
mkdir hostmaster-6.x-2.x
cp hostmaster/hostmaster.make hostmaster-6.x-2.x/drupal-6.28.make
cd hostmaster-6.x-2.x

Add projects[] = drupal after the line api = 2 in drupal-6.28.make

drush make drupal-6.28.make
mv ../hostmaster profiles/
drush hostmaster-install

The aegir user is also the owner and group of /usr/share/php/drush and /usr/bin/drush. However, as a side note, from the documentation, I can never install drush as the aegir user, as this requires access to pear, so I have to install drush as root and then change the ownership of drush to that of aegir:aegir.

Thanks.

Quick fix in #6 worked for me.

Any idea when an alpha2 will be released with the official fix?