Share Users Across Multiple Sites
ALT83 - May 4, 2006 - 15:38
I know this topic has been talked about extensively in many different places around the drupal site, but I was wondering if anyone has actually managed to share usernames/passwords and sessions etc. across multiple sites/domains and/or databases and what they found was the most efficient way of doing this without making future upgrades a real chore.
Is anyone working on some kind of plug in architecture or will this kind of functionality ever make it to the core? I would have thought there was enough demand for it.
Cheers,
Alex
sql_auth module ?
I am interested in doing the same thing, and thought I'd found the answer when I found the SQL Authentication module ( http://drupal.org/node/50946 ).
It doesn't seem to be an official contributed module though and it doesn't seem to work under 4.7 ( gives form errors on the settings page).
Is this ever likely to be added to the module downloads page or updated to run under 4.7?
It can be done with the singlesignon module
For 4.6, we used the singlesignon module to achieve this on www.kasahorow.com, www.kasahorow.org and www.dictionary.kasahorow.com.
Suuch Solutions supports The GhanaThink Foundation
I'm sharing
I'm sharing usernames/profiles/roles across different domains which are using the same database.
The only thing to do, is prefixing the tables for every setup and defining the shared tables and the prefix in your settings.php.
Updating is as simple as for a single site.
vg
Can login one time for multisites?
If it's possible for the shared users of your multisites to browse the different sites but only need login one time? Also when the users logout from one site and then they will logout all other sites automatically? Thanks
As I understand it, through
As I understand it, through the use of shared tables, sessions are included, so yes login once, logout once.
Correct me if I'm wrong.
Regards,
Alex
Ask "login once" again
For testing the features of multisites I created some sites which can share users.
"login once" works well only for those sites hosted on the same domain. But when swich to another site under a diffrent subdomain I must login again.
Do you experience this or know how to configure multisites under different subdomains for "loginning once"? Thanks!
I'm not 100% sure, but I
I'm not 100% sure, but I believe that you should configure your subdomains as directories in your main Drupal installation.
For example. In my web hosts control panel (I use Dreamhost) I set up my main domain as www.mydomain.com. With my web hosts this makes a folder mydomain.com in the root of my hosted web server. If I was to create subdomain.mydomain.com, this would create a folder subdomain.mydomain.com also in the root of my server. Instead, however I should configure the subdomain to point to mydomain.com, and configure relevant settings in the Drupal sites folder i.e. www.mydomain.com/sites/subdomain.mydomain.com . Hopefully Drupal should handle the rest...
I'm not completely sure if that will be enough, I'm going to be looking into it myself over the next day or two, so if you still have problems we can try and figure it out. The above method, I believe, is also used for sharing a code base, so that you do not require multiple installations.
Very clear. I'll follow your
Very clear. I'll follow your guidance to have a try. But could you tell me how to
with cPanel?
By the way, my multisites are sharing a code base with separated DBs, and with shared users by sharing some tables. This moment every site looks working well except the issue "login once" for browsing different subdomain's sites.
I'm afraid I don't use
I'm afraid I don't use cPanel so I don't know. With Dreamhost (my hosts) I simply make subdomain.mydomain.com = the same folder as www.mydomain.com . I haven't had the opportunity yet to try any of this out, but will try a little later tonight (took a while for my subdomain to become active).
I believe you can use seperate DBs in general, but I think the whole login problem your having is that information about a login session is also stored in the DB and therefore all the sites need to share the same DB. I know this is not ideal, as I personally would feel better with a seperate DB just for user logins etc. and I believe their may be some dirty hacks to do this, but as standard I think all sites need to be the same database, with each site having its own table prefixes, e.g. site1_tables, site2_tables etc. and then the user tables are shared, e.g. shared_users etc.
Maybe have a look at http://drupal.org/node/2622
Single Sign On For 4.7?
Great to hear it working for 4.6, anyone using it for 4.7 successfully?
Ultimately it would be great to see some kind of module where different sites can have different databases. Does anyone know how many tables, and users etc. a MySQL database can realistically handle?
Great to hear it working for
I just made some fixes to the singlesignon module for 4.7 and HEAD. You can get the latest copy from CVS.
--Dan
Use website 1 user list on website 2 ?
Hi,
I have a user list on "Website 1" and would like to create the same user list for "Website 2" then send and email to all "Website 1" users to tell them that they can log on "Website 2" with the same username.
Can I just save the user list from "Website 1" database and upload it to "Website 2" database?
"Website 2" is a brand new one so it has no user yet.
Thanks for help.