We help IT Professionals succeed at work.

Consolidating databases - opencart/phpbb3/mediaWiki (MySQL)

I am building a site that uses opencart as the main site with links to the wiki (MediaWiki) and the forum (phpbb3). I would like to consolidate everything so the user only has to log in once.

mySQL db.

How can I do this? I will be working with a clean db so no need for user migrations.




thanks
Comment
Watch Question

Top Expert 2012

Commented:
What you need to do is implement a single sign-on solution such as openid, CAS or oauth.  Check which one is supported by all 3 (they are usually supported via add-on modules).  Hopefully, there's one openid/cas/oauth implementation that can read from opencart's database.  If not, you need to construct a separate signup solution.

Author

Commented:
So there is no way I can tell it to use the same db  and share the user tables? Like use a different prefix except for the user stuff. Or edit the program to use the same content?
Top Expert 2012
Commented:
It should be possible, but that will likely mean the user still has to log on when he moves from opencart to the other site.  Unless, you also share the session database.  Using a single sign-on solution is really the way most people would handle such a requirement.

Author

Commented:
I'm having someone code the php to share the data and sessions.
Top Expert 2012

Commented:
Well, I hope it works out for you.  Just try to make it so that you don't have to recode the solution if and when you upgrade on or more of the components.  Thanks.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.