Two Databases, One Login

LBJerryH

I need some help on this. I need to have it where when someone logs into my main site, one database, that login passes to the second database. One login for two databases. Can this be done??? I am a total newb at this so forgive my stupidity. :o

mjax

Could you please elaborate on the specific setup of these two databases? Are you running two sites, both on their own URL, running their own PHP script and their own databases and would you like to apply a "single-sign-on" technique to this?

LBJerryH

mjax wrote:
Could you please elaborate on the specific setup of these two databases? Are you running two sites, both on their own URL, running their own PHP script and their own databases and would you like to apply a "single-sign-on" technique to this?

That is almost correct. The way the site is set up is the main site is www.fuelmyfaith.com and the secondary site is set up like this: www.fuelmyfaith.com/pligg. They are on 2 seperate databases running their own PHP scripts and yes I want one login for both. Thanks.

mjax

I'm still missing a lot of essential details about the authentication mechanismes used in both sites, but I'm going to make some general suggestions.

I assume that you are using some kind of session based authentication mechanisme, that sets some session variables when a user is succesfully authenticated. I also assume that both databases contain the same user/password data and you have some way to keep these synchronized.

This is what you could do:

When somebody logs in succesfully on site A, you redirect them to a script running on site B, supplying the login credentials. E.g http://www.siteb.com/login_from_site_a.php?username=yourusername&password=secret
In the script login_from_site_a.php you proces the supplied credentials to login the user on site B. After processing you redirect the user back to site A.
Apply the same system to allow users to login on site A from site B.

You could make it more fancy by using a POST instead of a GET call to the login_from_site_a.php script to avoid passing credentials in the URL location bar. Please note that this login_from_site_a.php script does not produce any output, it should always end in a redirect to site A.

LBJerryH

mjax wrote:
I'm still missing a lot of essential details about the authentication mechanismes used in both sites, but I'm going to make some general suggestions.

I assume that you are using some kind of session based authentication mechanisme, that sets some session variables when a user is succesfully authenticated. I also assume that both databases contain the same user/password data and you have some way to keep these synchronized.

This is what you could do:

When somebody logs in succesfully on site A, you redirect them to a script running on site B, supplying the login credentials. E.g http://www.siteb.com/login_from_site_a.php?username=yourusername&password=secret

In the script login_from_site_a.php you proces the supplied credentials to login the user on site B. After processing you redirect the user back to site A.

Apply the same system to allow users to login on site A from site B.

You could make it more fancy by using a POST instead of a GET call to the login_from_site_a.php script to avoid passing credentials in the URL location bar. Please note that this login_from_site_a.php script does not produce any output, it should always end in a redirect to site A.

Thanks for the help, but that is a little over my head when it comes to databases and PHP. I understand exactly what you are saying, I just don't know exactly how to execute it. :o