[support] multi-site question

[Greg Holsclaw]

I have seen this a few times. Go straight to the install.php file in
your broswers, instead of relying on Drupal to know to find it.

Greg

-----Original Message-----
From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Miles Fidelman
Sent: Thursday, January 25, 2007 10:06 AM
To: support at drupal.org
Subject: [support] multi-site question

Hi Folks,

Just tried to install a 2nd site on a Drupal 5 installation, using a 
common codebase, but a separate database:

- running on a separate IP address
- created a separate mysql database
- setup the Apache information
- created a sites/secondhost directory
- copied sites/default/settings.php into the new directory
- edited settings.php to point to the new database
- restarted apache

When I try to access the site, I get a screen full of errors, starting
with:
*Warning*: Table 'gd.access' doesn't exist query: SELECT CASE WHEN 
status=1 THEN 0 ELSE 1 END FROM access WHERE type = 'host' AND 
LOWER('24.60.167.199') LIKE LOWER(mask) ORDER BY status DESC LIMIT 0, 1 
in */var/drupal/includes/database.mysql.inc* on line *167*

It looks like Apache is going to the common codebase, and Drupal is 
finding the proper settings file, but.... Drupal doesn't seem to realize

this is a new installation, and doesn't try to run the initialization 
routines to create and populate tables.

If I delete settings.php, it tries to log into my default site.

So... how do I get Drupal to initialize the new site?

Thanks much,

Miles Fidelman
-- 
[ Drupal support list | http://lists.drupal.org/ ]