Bram de Jong - MTG wrote:
Hello Peter,
I asked the same question here a couple of days ago, no answer thoguh. I wanted to join the PHPBB and MediaWiki together with one login just as you. I found a quite ugly lite fix that did it though.
First I joined the together the usertables for phpbb and mediawiki. I used the one for phpbb as I already have all my users there, and merged in all the columns for mediawiki user-table.
Then I changed all the table and columns references in mediawiki to match phpbb usertable and username and password column.
Half way there. Users from phpbb can now log in with the same details in my wiki. New registrations will be directed to phpbb registration form. Luckily mediawiki and phpb encrypt passwords the same way.
Okay, that's all very neat! How do you generate the "missing bits" for mediawiki? I'm not sure I like the hacking the mysql DB though - for future compatibility that seems a bit... scary. I guess it would be possible using database triggers, but... those don't exist yet in MySQL.
Actually I havn't really added in the missing bits or mediawiki yet.. I guess I will add some custom fields into the registration for phpbb and edit the registratino scripts. Now when you mention it hanv't even investigated which the "missing bits" really are.. if any.. so I feel kind of stupid now.
When you start hacking these things future upgrades are not possible. I would run an update on my phpbb.. or actually I did work... at all. So my though it now that if I do this now.. I'm pretty much stuck with the releases I got installed. But of course, upgrades can be done manually with a little bit of diff and patience... phpbb is pretty much ruined if you install any mods och extensions..
Here comes the ugly part.
Users login to the wiki, mediawiki valides the password, if correct the information will be posted into the php-loginscript. Not good, not secure, not stable, but it works. A lot of things could go wrong there.. and I wouldn't recommend it.
Not sure I get this? What isn't secure about this? Do their passwords get posted or something? I guess I don't know -yet- how the wiki login works...
I took an easy turn here and just posted the details along via GET, I did encrypt the password first though and removed the encryption in the phpbb login-script. That should be secure enough. Don't feel very confident about this though, but it seems to work.
I would prefer to figure out the login-function in mediawiki and just include that and run it in the phpbb-script, I hanv't quite figured it out though and with all the path and includes it kind of confusing..
I though I should try and make something better, but I hanv't yet. So I made a fast easy hack.
Well, I for one would love to help you with this - or at least do something so I can use the same system. I mainly asked here because I didn't want to re-invent the wheel.
Let me know if you find something clever.
/peter