Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By davidjmcq on
I have 6.3 working correctly with domain1, database1
I am trying to set up sites/domain2/settings.php with database2
$db_url = 'mysql://user:pass@localhost/database2';
$db_prefix = '';
When I go to www.domain2.com I get a whole lot of mysql errors such as.....
etc....
I expected to get a setup page.
How do I set up my multi domain with multiple databases? I've been hunting through the forums for hours and can't seem to see what i'm doing wrong.
thanks
Comments
I don't see the error
I don't see the error messages.
By the way, the settings directory must be named sites/domain2.com/, not sites/domain2/
multi site multi database fails
You are right about name of the settings directory, but that was a mistake in my post, not in the configuration. I was pretty tired by the time I posted.
error messages:
Warning: Table 'drupal.access' doesn't exist query: SELECT 1 FROM access WHERE type = 'host' AND LOWER('xxx.xxx.xxx.xxx') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in /var/www/html/drupal/includes/database.mysql.inc on line 128
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /var/www/html/drupal/includes/database.mysql.inc:128) in /var/www/html/drupal/includes/bootstrap.inc on line 1031
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/html/drupal/includes/database.mysql.inc:128) in /var/www/html/drupal/includes/bootstrap.inc on line 1031
Warning: Table 'drupal.cache' doesn't exist query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /var/www/html/drupal/includes/database.mysql.inc on line 128
Warning: Table 'drupal.variable' doesn't exist query: SELECT * FROM variable in /var/www/html/drupal/includes/database.mysql.inc on line 128
Warning: Table 'drupal.cache' doesn't exist query: UPDATE cache SET data = '', created = 1249914995, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in /var/www/html/drupal/includes/database.mysql.inc on line 128
Warning: Table 'drupal.system' doesn't exist query: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /var/www/html/drupal/includes/database.mysql.inc on line 128
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/drupal/includes/database.mysql.inc:128) in /var/www/html/drupal/includes/bootstrap.inc on line 630
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/drupal/includes/database.mysql.inc:128) in /var/www/html/drupal/includes/bootstrap.inc on line 631
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/drupal/includes/database.mysql.inc:128) in /var/www/html/drupal/includes/bootstrap.inc on line 632
Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/drupal/includes/database.mysql.inc:128) in /var/www/html/drupal/includes/bootstrap.inc on line 633
Warning: Table 'drupal.url_alias' doesn't exist query: SELECT COUNT(pid) FROM url_alias in /var/www/html/drupal/includes/database.mysql.inc on line 128
problem solved
.... so easy when you know how.....
I had to login via http:// domain2.com/install.php
The errors were because I had already edited sites/domain2.com/settings.php with the new database details.
Apparently if I didn't edit the settings.php file first, it would have worked as expected.