xoops forums

tvn3015

Just popping in
Posted on: 2008/4/22 5:20
tvn3015
tvn3015 (Show more)
Just popping in
Posts: 53
Since: 2007/4/18
#1

Sharing username and password across multiple XOOPS sites?

Is there anyway that we could share username and password across multiple XOOPS sites (None XOOPS Sites)?
Is it possible at all?
Thanks

TVN
http://www.XoopsViet.com - Xoops for Vietnamese

tvn3015

Just popping in
Posted on: 2008/4/22 5:43
tvn3015
tvn3015 (Show more)
Just popping in
Posts: 53
Since: 2007/4/18
#2

Re: Sharing username and password across multiple XOOPS sites?

Found this on other site!

Share Frontend Users Between Multiple Sites
« on: 08 Apr 2008, 13:08 »

--------------------------------------------------------------------------------

If you want to share frontend users among multiple sites, redirect the registration to the main site (originating). Then set up the following crontab job for each site:

Minute: 1,16,31,46
Hour: *
Day of Month: *
Month : *
Day of Week: *

Command:
/usr/bin/mysqldump -h<originating-hostname> -u<originating-username> -p<originating-password> --quick --add-drop-table --add-locks --lock-tables --tables <originating database name> cms_module_feusers_belongs cms_module_feusers_dropdowns cms_module_feusers_grouppropmap cms_module_feusers_groups cms_module_feusers_groups_seq cms_module_feusers_propdefn cms_module_feusers_properties cms_module_feusers_properties_seq cms_module_feusers_tempcode cms_module_feusers_users cms_module_feusers_users_seq | MySQL -h<destination-hostname> -u<destination-username> -p<destination-password> <destination database name>

This example will run the job every 15 minutes and synch the feusers tables between 2 sites.

Notes:
- This will work between different servers.
- You may need to change the path to mysqldump, depending on your setup.
- Replace the entries in < > with your specific database info.
- Replace the "cms_" table prefixes with your table prefixes.
- The command must be a single line.

Nullig
http://www.XoopsViet.com - Xoops for Vietnamese

jfmoore

Quite a regular
Posted on: 2008/4/22 15:55
jfmoore
jfmoore (Show more)
Quite a regular
Posts: 360
Since: 2004/6/6 5
#3

Re: Sharing username and password across multiple XOOPS sites?

This is great information! There are, however, many usernames and passwords: cPanel username/pw, MySQL username/pw, XOOPS username/pw, etc. I know this should probably be obvious, but it would help if you would clarify as to what goes here:

<originating-hostname> - Is this were my XOOPS site resides? Like mydomain.com/xoops or what?

<originating-username> - ?

<originating-password> - ?

<originating database name> - I take it that this is the name of the d/b that holds the user table that you wish to share.

Thanks,
Jere
...

btesec

Friend of XOOPS
Posted on: 2008/4/22 18:11
btesec
btesec (Show more)
Friend of XOOPS
Posts: 623
Since: 2007/2/20
#4

Re: Sharing username and password across multiple XOOPS sites?

Is there a chance to create a module for this so I can define to which sites my users can connect using the same user and password. Of course one database would be used and then allow users to register and login from any of my sites.

btesec

Dragavan

Just popping in
Posted on: 2008/5/9 7:33
Dragavan
Dragavan (Show more)
Just popping in
Posts: 3
Since: 2006/10/2
#5

Re: Sharing username and password across multiple XOOPS sites?

I was hoping to find out abut the same thing. Is there any chance of someone writing a clear "instruction manual" or "step by step" type post for this (or a module that handled it would be great)? I am not to this point yet, but I can see it's coming and would like to be prepared.

wishcraft

Module Developer
Posted on: 2008/5/9 12:38
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#6

Re: Sharing username and password across multiple XOOPS sites?

Hi guys and gals, I was just stopping by after implementing a new authentication factory for 2.3.1 of XOOPS... Which funny as it seems is all about sharing authentication in a chain sequence amongst XOOPS sites, with soap!!

Have you explored X-Soap at all? you can share your authentication with that, I have just updated the patch from the planning version to a final that will be included with 2.3.1 of XOOPS..

Actually would you like to give it a go?? Goto www.unseen.org.au (server in sydney, aus running 2.0.18.1 and php4) and register an account, then authenticate with the same account you created against http://www.xoops.asia with which is a XOOPS 2.0.18.1 server running php5 in the USA..

You will see how they have different UID's

Have a go!! you can chain this thru many sites point a site at something with x-soap and if you have a username on that site that can access the plug in then you can start authenticating against it, we will be setting up something like that here at https://xoops.org so people can authenticate again XOOPS userbase.
Resized Image
www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/SimonXaies
github.com/Chronolabs-Cooperative
facebook.com/SimonSXaies

sockmonkey

Just popping in
Posted on: 2008/6/4 15:33
sockmonkey
sockmonkey (Show more)
Just popping in
Posts: 21
Since: 2008/6/4 1
#7

Re: Sharing username and password across multiple XOOPS sites?

!!!

This is exactly what I've been looking for! I'm using 2.0.18 for several sites and would like to tie them all to a single login. Can you give more specifics on how to implement this? Are we talking about installing a module? Or a hack? Or both? Any info you can provide is greatly appreciated.