Posted by grawat on March 12, 2009 at 1:05pm
I have a drupal multisite installation using drupal 6.10. At the moment each site has a separate database and some tables (those related to users) are shared. I would like to move all sites to a single database. For this I added a site specific prefix to all tables and moved them to the single database. And then made the necessary changes in settings.php . Things seem to be working but I read this comment http://drupal.org/node/147828#comment-826478 and it mentions something about Table 'sequences' and I can't find any such table. Could someone please explain what else needs to be done in order for all the sites to work properly.
Comments
From what I have read,
From what I have read, sequences is no longer used in Drupal 6. I think it used to deal with incrementing the user ID's properly but that it now handled by an auto increment in the actual users table.
You're correct. This is why
You're correct. This is why D5 / D6 sites can't play nicely together for user sharing unless you share D5 user base with a D6 site and the D6 site doesn't generate users on it's own because of that table :)
"Plaguing the world with Drupal; One Plone, Moodle, Wordpress, Joomla user at a time since 2005." ~ btopro
http://elearning.psu.edu/
http://elearning.psu.edu/projects/
http://elearning.psu.edu/drupalineducation/
Ex Uno Plures
http://elmsln.org/
http://btopro.com/
http://drupal.psu.edu/
ok so I'm already sharing
ok so I'm already sharing the users table so I shouldn't have any problems right ?
Infact, I'm sharing the following table:
authmap
openid_association
page_title
permission
profile_fields
profile_values
role
sessions
users
users_roles
views_display
views_object_cache
views_view
I'm
I'm sharing:
users
sessions
role
authmap
profile_fields
profile_values
user_roles
I think at a minimum you just have to share users and authmap, everything else is optional. Please correct me if I'm wrong on this!!
roles and users_roles are
roles and users_roles are both good for creating "single-sign-on"-ish system.
profile_fields and profile_values are also nice to share. If you have different domains sharing user base I don't think you can share sessions
"Plaguing the world with Drupal; One Plone, Moodle, Wordpress, Joomla user at a time since 2005." ~ btopro
http://elearning.psu.edu/
http://elearning.psu.edu/projects/
http://elearning.psu.edu/drupalineducation/
Ex Uno Plures
http://elmsln.org/
http://btopro.com/
http://drupal.psu.edu/
ok so what happens when
ok so what happens when sessions is shared ? I was following this guide http://drupal.org/node/291373 and it mentions u need to share sessions.... and I didn't find any problems with it.... so everytime a user logs into one site he is shown as logged in on all sites and I don't mind that ... are there any other issues with sharing sessions ?