Multisite - Sharing Users Tables with different databases

Posted by Anthony Pero on March 30, 2008 at 2:03pm

Hey there, got a question, and after 3 months, no love searching this site for the answer...

I have two websites, configured in multisite mode. This part works. They have two separate databases for them, which I think is the best way to have two sites that don't share content. However, I want to share users across this site, as they are related. So, I keep trying to find it here, but I can't seem to find how to share user tables between databases. If there is a book page on this, please link it for me, cause I've had no success. Better yet, if someone has done this, please tell me how you did it!

Thanks again,
Tony

Comments

have you seen

Posted by WorldFallz on March 30, 2008 at 3:16pm

have you seen these:

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}

I've seen them, but...

Posted by Anthony Pero on March 30, 2008 at 10:27pm

Thanks for the reply, but as noted in my message, I'm not using a shared Database. I'm using two separate databases. Any ideas how to accomplish this with two unique databases? I also won't need shared sign on. i don't mind people having to log into the two sites separately, I just want the log-on to be the same.

Thanks anyway!

Anthony Pero
http://limafirstmedia.com
http://anthonypero.com/booking

Anthony Pero
Project Lead
Convergent Creative Web Design
http://www.convergentcreative.com/

Sorry, i should have been

Posted by WorldFallz on March 30, 2008 at 11:35pm

Sorry, i should have been more verbose. Perhaps separate databases is not actually the best way to do what you want to do. If you read the article in the first link, they are setting up pretty much what you want--- shared users, separate nodes (the title is somewhat misleading). But even if you don't want to do it that way, you could use the info in that link to set up database replication between the appropriate tables to share use info.

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}

Thanks

Posted by Anthony Pero on March 31, 2008 at 7:35pm

I skimmed over both of those posts in the past... I'll look a little harder!

Anthony Pero
http://limafirstmedia.com
http://anthonypero.com/booking

Anthony Pero
Project Lead
Convergent Creative Web Design
http://www.convergentcreative.com/

single user signon and multiple databases

Posted by georgelai on March 31, 2008 at 10:04pm

Anthony,

I share your frustration. I have been looking for a single user signon, and selection of the database is based on user selection.

I think I am just going to have to create my own sql tables, login code, and cache the user data in session variables. Then goto the respective Drupal site I have created.

I don't even know if this is possible though; I have to look deep into the Drupal code to see how it looks at user id.

For what I want to do, different databases are almost a must, so I have to keep the data separate.

Anyone have any other ideas?

George

I haven't tried it yet so I

Posted by WorldFallz on March 31, 2008 at 10:40pm

I haven't tried it yet so I don't know-- is there a reason that replicating the appropriate user tables from one separate drupal db to another won't work?

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}

Question on that..

Posted by Anthony Pero on April 1, 2008 at 1:58am

When you replicate the user tables from one database to another... si that an automated process, or do you have to keep running a script to make it happen? Does cron do this, or do you go into your MySQL databases and copy them manually? Obviously to work for my situation, I need it to update each database whenever a new user signs onto either site.

Anthony Pero
http://limafirstmedia.com
http://anthonypero.com/booking

Anthony Pero
Project Lead
Convergent Creative Web Design
http://www.convergentcreative.com/

it's an automated process at

Posted by WorldFallz on April 1, 2008 at 1:37pm

it's an automated process at the db level... if your using mySQL, the following link should be helpful: http://dev.mysql.com/doc/refman/4.1/en/replication.html

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}

Have you found a way to

Posted by Juanzo on December 17, 2008 at 5:00pm

Have you found a way to archive this? Either share some tables across different databases or having a script to replicate each table via cron?
--
Duplika | Web Hosting

--
Duplika | Hosting Argentina

Do you know some similar

Posted by themegarden.org on March 31, 2008 at 11:08am

Do you know some similar solution, but for drupal 6?
---
Drupal Theme Garden

----
Drupal Theme Garden

I don't believe multisite

Posted by WorldFallz on March 31, 2008 at 1:09pm

I don't believe multisite has changed from d5 to d6-- at least nothing that i have been able to detect so far. Any of the d5 multisite posts should still apply.

__{Don't be a Help Vampire - read and abide the forum guidelines.

If you find my assistance useful, please pay it forward to your fellow drupalers.}