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