• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 706
  • Last Modified:

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
0
DantechIT
Asked:
DantechIT
  • 3
  • 2
1 Solution
 
johanntagleCommented:
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.
0
 
DantechITAuthor 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?
0
 
johanntagleCommented:
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.
0
 
DantechITAuthor Commented:
I'm having someone code the php to share the data and sessions.
0
 
johanntagleCommented:
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.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now