By sharique on

How to configure Drupal 5 for multisite with single Drupal & Mysql installation?
I have subdomains and I want use single sign-on for all sub-domain and main site, rest of things are different.
How I can do this?

⋅ Categories: Drupal 5.x

Comments

marafa’s picture

marafa commented

i am interested to know too.
i m there fore subscribing to the thread.
hope u dont mind

http://namima.in-egypt.net

__________
http://namima.in-egypt.net اجدد اخبار ممثلين

http://www.echognumix.com

billmurphy’s picture

billmurphy commented

I´m also subscribing, I was looking into multisite, and found a solution symlinking and found this thread:
http://drupal.org/node/39807
I´ll give it a try, but would like to know about other possible solutions.

marafa’s picture

marafa commented

hi
the answer to sharing the mysql installation is in settings.php in sites/default
or site/domain1
the thing is to enable that array 

*   $db_prefix = array(
 *     'default'   => 'main_',
 *     'users'     => 'shared_',
 *     'sessions'  => 'shared_',
 *     'role'      => 'shared_',
 *     'authmap'   => 'shared_',
 *     'sequences' => 'shared_',
 *   );

i have shared the following tables:
role (moderator group automatically created)
locales_source (locale module)
locales_target (locale module)

the main reason i wanted to do this was for the locale module (and users - but i havent gotten round to that yet) coz each drupal installation requires that i import the po file for my language and that definetly times out in the middle. so i have to refresh the browser repeatedly and i never know if i finished importing the entire file.
and the second reason is that these 2 tables each take up half a meg of space in the db. thats 1 mb per installation.

nuff said .. its done
__________
http://namima.in-egypt.net اجدد اخبار ممثلين

__________
http://namima.in-egypt.net اجدد اخبار ممثلين

http://www.echognumix.com

Mojah’s picture

Mojah commented

When sharing one database accross many subdomains, any ideas which tables to make unique so as not to cause any problems with caching and seperate themes for each subdomain?

I temporarily did this in my .htaccess file to overcome the time outs when importing .po files...

<IfModule mod_php4.c>
  php_value magic_quotes_gpc          0
  php_value register_globals              0
  php_value session.auto_start          0
  php_value max_execution_time	     600
  php_value memory_limit		40M
</IfModule>

If you have access to .htaccess give it a try or just temporarily adjust the settings in php.ini ;)

marafa’s picture

marafa commented

no idea .. i guess its trial and error
__________
http://namima.in-egypt.net اجدد اخبار ممثلين

__________
http://namima.in-egypt.net اجدد اخبار ممثلين

http://www.echognumix.com