Posted by gadams on July 11, 2010 at 8:44pm
I'm building a brochure website with users that can edit their own publicly displayed profiles however they want a private intranet site using OA/
I am currently running Content profile module on the brochure site but want to link the user accounts with the OA site.
I found the following on a Drupal doc about shared/multi-site
$db_prefix = array(
'users' => 'shared_',
'sessions' => 'shared_',
'role' => 'shared_',
'authmap' => 'shared_',
'sequences' => 'shared_',
'profile_fields' => 'shared_',
'profile_values' => 'shared_',
'users_roles' => 'shared_',
);
Has anyone tried this before and accomplished it?
Does this look appropriate for the tables to use for a shared database?
Thanks
~Captain
Comments
I'm responsible for a couple
I'm responsible for a couple of sites using a shared login system like this, we just share access, sessions and users.
Depending on your situation, be careful sharing roles across sites - if you can see a situation where someone will need to be an administrator on one site but not the other, or if you will need different roles on each site then keep roles separate.
authmap is for third party login systems, so if you're not using any of those no need to share it.
Also, if you're using Content Profile (rather than the built-in Profile module) then the profile_fields and profile_values tables aren't required. I don't think there would be a way to share Content Profiles across sites without sharing the node table, and if you're doing that then there are better ways to handle sharing content across multiple sites (Domain module).
Orlando, FL Web Developer | http://www.garethsprice.com/
Cookies?
Will I have to worry about the cookies configuration the settings.php file?
~Gaelan
G
"Just as diamonds are forever, Google Cache is too"
Do you need remembered login
Do you need remembered login sessions to continue across sites? If so, looks like you'll need to set them to use the same cookie domain. Just checked our site configs and we don't set this. Don't think continuous sessions was a requirement for us, though.
Orlando, FL Web Developer | http://www.garethsprice.com/