Hello all,
I am runnung a small network of multilanguage Drupal 5.16 sites using a single codebase, separate databases and instead of sharing users across databases I use a seperate user database that is accessed by all websites. The user database contains the following tables (these tables were dropped from the other databases):
- authmap
- buddylist
- buddylist_buddy_group
- buddylist_groups
- buddylist_pending_requests
- facebook_status
- privatmsg
- privatmsg_archive
- privatmsg_block_user
- privatmsg_folder
- sequences
- sessions
- userpoints
- userpoints_txn
- users
I am also using avatar pictures. So right now I see my own picture seven times if I login to all seven sites manually.
What I am looking for is a single signon solution that will only display each user once.
So far most solutions work only if I use table prefixing on a shared database. This of course will not work since I use separate databases.
Does anyone have any advice on how to best enable a single signon?
Regards, Paul
P.S. Another problem I have is sharing the user profiles - I am using the Advanced Profile Kit. But I have already found out that it is not advicable to ahre nodes. So that issue is not important anymore.
Comments
Sort of what you want but not exact
I have similar need and this is what I have achived.
I have seperate databases, but only user, session tables shared. The multiple sites are under different subdomains but same master domain. Huge benefit is I can share the same cookie domain across all sites which preserves login status as users move from one site to another.
But I think it creates differrnt sessions (not sure). One way to get around the problem with to modify query showing avatar picture and show the session associated with the current site the user is. This is just a loud thinking and don't know all gotchas.
For me users seemlessly moving from one site to another (without using any singlesignon module) was more important.