By Cactii1 on

I wanted to make a 100% multi-language web site and I tried i18n but found out quickly that this was not the way to go.

I have a D6 install on example.com and another install on es.example.com

When these were both installed and had a whole bunch of information in them I decided that I wanted my users from one site to be able to get into the other as well. Sounded pretty easy since I did some research and found out that Drupal allows for table prefixing.

So here's my config:

Spanish installation of D6 on es.example.com using common_database with tables prefixed with es_ and the following config in my settings.php

$db_url = 'mysqli://user:pass@localhost/common_database';
$db_prefix = array(
     'default' => 'es_',
     'users' => 'en_',
     'users_roles' => 'en_',
     'sessions' => 'en_',
     'permission' => 'en_',
     'role' => 'en_',
     'authmap' => 'en_',
   );
$cookie_domain = 'example.com';

Default installation of D6 on example.com using common_database with tables prefixed with en_ and the following config in my settings.php

$db_url = 'mysqli://user:pass@localhost/common_database';
$db_prefix = 'es_';
$cookie_domain = 'example.com';

So everything looks good right?

Well... it's not. I'm able to pull up both sites no problem and for sure the database prefixing is working good because the language of the site changes between the es.example.com and example.com.

However, when I try to log in Drupal never lets me and always fails to authenticate my user/pass combo. If anything the english site should work without fail since ALL the tables would be prefixed with en_.

I've emptied all my cache and sessions tables and cleared my browser cache as well but nothing seems to allow me to authenticate.

I think I have read every post about different multisite configs but nothing seems to indicate that I am doing anything wrong.

If you think you can help please let me know!

⋅ Categories: Drupal 6.x