Extension talk:PHPBB Auth

/Archive 1 - Up until 28th December 2007

I cleaned up the talk page for the new release. If you need help post on the forums @ http://uber.leetphp.com. --Nick 01:22, 28 December 2007 (UTC)

Is the code for this extension mirrored anywhere? The original download site has gone down and the extension is no longer available. 68.223.244.238 21:02, 7 January 2008 (UTC)
 * The site is up --Nick 08:27, 11 January 2008 (UTC)
 * It is down again. May be it would be good to put this code to some place like Google Code, which is available >99% of time? --89.179.245.37 23:17, 25 January 2008 (UTC)
 * I had it in google code, but the interface was lacking. When I checked the help/FAQ the answer to the problems I had was, "Sorry you can't do whatever. We are adding that later". So someday when Google Code gets better. Anyways my site is normally up. --Nick 23:59, 28 January 2008 (UTC)
 * I'm hosting a small project on Google Code and found that interface actually have everything I need. It's interesting what you were lacking in it? And may be they've added this since then? :) --Ipse 04:38, 29 January 2008 (UTC)
 * One of the main issues I had was being able to change the featured file. So if I set Auth_2.3.zip I can not change it to Auth_2.4.zip --Nick 07:49, 16 February 2008 (UTC)

Does someone has a copy of the extension? The authoprs site is now down for 2 days at least and I want to use this extension. Thanks.--89.18.168.236 13:11, 18 May 2008 (UTC)
 * My site is up. --Nick 08:43, 19 May 2008 (UTC)

Hi!! I cant download de source code... anybody can give me a copy of the extension? Thank you! - mail me: zsuarez@draiz.cat

iauthplugin.php ?
Installed the extension on 1.12.0 PHP5.2.5. I received an including error looking for iAuthPlugin.php. Googled/searched and found no such plug-in. The support site seems to be down and I can't verify what version of the extension I have. I do, however see a note that this was tested on my MediaWiki version. Any ideas? --71.106.200.196 03:50, 3 June 2008 (UTC)

You can download everything you need from Download --Nick 06:14, 3 June 2008 (UTC)

How can anonymous users edit wiki pages?
Only logged in can do this. 84.42.63.97 21:48, 27 December 2008 (UTC)

MediaWiki 1.6.x (aka PHP4 users)
For those of us restricted to PHP4 - phpBB3 works on PHP4 - is there any hope to be had in adapting this script to work with MediaWiki 1.6.x? (It is the last stable version to work on PHP4)?

Multiple wiki groups
We made some changes to allow multiple wiki groups:

Note: This code is based on version 2.6 of this mod.

To configure this you have to add multiple groups in your LocalSettings.php as well: Notice the quotes. It is important to write every group in single quotes. Star 17:24, 6 February 2008 (UTC)


 * NOTE: 3.0.3 now has support for multiple wiki groups. But please leave this code here for those who can not use 3.x line. --Nick 21:58, 3 March 2008 (UTC)

Can we do reverse log in?
I know this used to be a feature, but can we still do it? Like, we log in through MediaWiki and it closes phpBB instead? Or does it do both? Thanks! --74.130.45.110 21:17, 9 February 2008 (UTC)


 * I am not sure what you mean by "we log in through MediaWiki and it closes phpBB instead". --Nick 07:47, 16 February 2008 (UTC)
 * I didn't say that. O_o This is what I meant: "we log in through MediaWiki and it logs us into phpBB" What I'm saying is that, you can't log in through phpBB. You can log in through MediaWiki and it'll log you into phpBB with that account; your extension does the other away around. Is it possible to do it this way? --74.130.45.110 22:22, 18 February 2008 (UTC)
 * To quote the author of this extensions forums, what you are looking for is called Single-sign-on. It can be done, but thus far has not been done.  At least, not in any extension I know of.Zellfaze 20:40, 7 August 2010 (UTC)

Hello! I am also intrested in this method (if we have a account on mediawiki and we can login in the phpbb 3 and wordpress with same account). Actually I am using phpnuke for my main site and i include a plugin in media wiki so that i can login in mediawiki using the username and password of phpnuke. But i could not find such a plugin for phpbb3 and wordpress. So now i want that if i can connect the phpbb3 and wordpress to the phpnuke wia mediawiki it will be good (i think so). so is there any solution regarding this problam.

Ist this extension also working with mediawiki 1.9.3? 77.179.243.255 16:02, 16 March 2008 (UTC)

Security Issue
The Plugin does not test if a phpBB account is active or not, when granting permission to the wiki. So anyone can easily get access, if he just registers to the phpBB. Even if the Admin of the phpBB wants to limit his access by manually activating his phpBB account, the user gets access to the wiki before that. The Plugin should by default check the `user_type` column in the phpBB_user table and report an error, if the type was '1' (deactivated) but grant access if the type is '0' (active account) or '2' (phpBB Board Founder). So, if the phpBB account is inactive, the wiki access should also be restricted.Heinrich krebs 16:44, 15 August 2009 (UTC)
 * I can see why this feature would be needed. I will look into adding it. --Nick 20:52, 11 November 2009 (UTC)

Thanks
Thanks for this extension! It saves us a lot of duplicate user accounts / passwords. :) --Pnagel 09:19, 9 April 2008 (UTC)
 * You are welcome. --Nick 21:05, 11 November 2009 (UTC)

Notice Errors
I followed the installation instructions but I'm getting some errors. I'm using mediawiki version 1.12.0 and phpbb 3.0.1. These are the errors I'm getting:

Notice: Undefined index: MySQL_Database in /home/xxxx/public_html/xxxx/wiki/extensions/Auth_phpBB.php on line 243

Notice: Undefined index: MySQL_Host in /home/xxxx/public_html/xxxx/wiki/extensions/Auth_phpBB.php on line 244

Notice: Undefined index: MySQL_Password in /home/ixxxx/public_html/xxxx/wiki/extensions/Auth_phpBB.php on line 245

Notice: Undefined index: MySQL_Username in /home/xxxx/public_html/xxxx/wiki/extensions/Auth_phpBB.php on line 246

Warning: Cannot modify header information - headers already sent by (output started at /home/xxxx/public_html/xxxx/wiki/extensions/Auth_phpBB.php:243) in /home/xxxx/public_html/xxxx/wiki/includes/WebResponse.php on line 10

Warning: Cannot modify header information - headers already sent by (output started at /home/xxxx/public_html/xxxx/wiki/extensions/Auth_phpBB.php:243) in /home/xxxx/public_html/xxxx/wiki/includes/WebResponse.php on line 10

I'm using the correct host, database user, and password.

75.167.218.31 20:20, 13 May 2008 (UTC)

-> you have some empty lines at the bottom of Auth_phpBB.php. Just delete them, then it should work.

Doesn't work --> Exception Error
After trying to log in, I get immediately this error: exception 'Exception' with message 'Unable to find phpBB installed at (http://www.riev.nl/sint/).' in C:\domains\riev.nl\wwwroot\sint\wiki\extensions\Auth_phpBB.php:650 Stack trace: #0 C:\domains\riev.nl\wwwroot\sint\wiki\extensions\Auth_phpBB.php(917): Auth_phpBB->loadPHPFiles('UTF8') #1 C:\domains\riev.nl\wwwroot\sint\wiki\extensions\Auth_phpBB.php(493): Auth_phpBB->utf8('Rick II') #2 C:\domains\riev.nl\wwwroot\sint\wiki\includes\User.php(567): Auth_phpBB->getCanonicalName('Rick II') #3 C:\domains\riev.nl\wwwroot\sint\wiki\includes\User.php(259): User::getCanonicalName('Rick II', 'valid') #4 C:\domains\riev.nl\wwwroot\sint\wiki\includes\SpecialUserlogin.php(371): User::newFromName('Rick II') #5 C:\domains\riev.nl\wwwroot\sint\wiki\includes\SpecialUserlogin.php(447): LoginForm->authenticateUserData #6 C:\domains\riev.nl\wwwroot\sint\wiki\includes\SpecialUserlogin.php(100): LoginForm->processLogin #7 C:\domains\riev.nl\wwwroot\sint\wiki\includes\SpecialUserlogin.php(17): LoginForm->execute #8 C:\domains\riev.nl\wwwroot\sint\wiki\includes\SpecialPage.php(678): wfSpecialUserlogin(NULL, Object(SpecialPage)) #9 C:\domains\riev.nl\wwwroot\sint\wiki\includes\SpecialPage.php(464): SpecialPage->execute('wfSpecialUserlo...', NULL, Object(SpecialPage)) #10 C:\domains\riev.nl\wwwroot\sint\wiki\includes\Wiki.php(193): SpecialPage::executePath(NULL) #11 C:\domains\riev.nl\wwwroot\sint\wiki\includes\Wiki.php(45): MediaWiki->initializeSpecialCases(Object(Title)) #12 C:\domains\riev.nl\wwwroot\sint\wiki\index.php(90): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(WebRequest)) #13 {main}

How can I fix this?

Edit: Maybe useful: Path to wiki is www.domain.xx/sint/wiki. My php is www.domain.xx/sint. Both are in the same database, with prefix phpbb3_ and wiki_

75.88.81.83 00:42, 7 June 2008 (UTC)


 * Take a look at this post on the forums. php|uber.leet Forums --Nick 06:00, 7 June 2008 (UTC)
 * Took a look. Didn't work out, because it's not the same problem! Someone else? :-( 75.88.81.83 22:27, 7 June 2008 (UTC)


 * You are going to have to look at it again as it has the answer to your problem. You are getting "Unable to find phpBB installed" it's an error I throw when the plug-in can't find phpBB to load some files from it. --Nick 00:10, 8 June 2008 (UTC)
 * Next error ;-)

Warning: require_once(./sint/includes/utf/utf_tools.php) [function.require-once]: failed to open stream: No such file or directory in C:\domains\riev.nl\wwwroot\sint\wiki\LocalSettings.php on line 52

Fatal error: require_once [function.require]: Failed opening required './sint/includes/utf/utf_tools.php' (include_path='C:\domains\riev.nl\wwwroot\sint\wiki;C:\domains\riev.nl\wwwroot\sint\wiki/includes;C:\domains\riev.nl\wwwroot\sint\wiki/languages;.;C:\php5\pear') in C:\domains\riev.nl\wwwroot\sint\wiki\LocalSettings.php on line 52

75.88.81.83 00:48, 8 June 2008 (UTC)
 * Don't know whát I did... But it's working! Thanks for your help! 75.88.81.83 01:14, 8 June 2008 (UTC)

How about an answer?
I posted an error I'm getting at my mediawiki over a month ago. See the Notice Errors post above. How much longer do I need to wait for an answer? 97.115.227.196 21:28, 25 June 2008 (UTC)


 * If you want support you should follow the link for support and post on the forums. I looked at your error you posted above and it has already been asked and answered on the forums. --Nick 06:49, 31 July 2008 (UTC)

Will this work on a 1.6.8 version of Mediawiki?

 * 1)  MediaWiki: 1.6.8
 * 2) PHP: 5.2.4 (apache)
 * 3) MySQL: 5.0.45-community

Will this user integration work on a mediawiki version 1.6.8?

97.115.181.238 00:48, 14 July 2008 (UTC)


 * For 1.6.8 you should use v2.7 of the plug-in. You can download it from the website. This also means you will have to use phpBB2.

Is it working with 1.12.xx and 1.13 version of Mediawiki?
Will this user integration work on a mediawiki version 1.12.xx ?

Hi here i am giving the answere of my own question that this extension is working well with 1.12.xx and 1.13 versions.

How about my old mediawiki user accounts?
If I've understood correctly, this extension makes MediaWiki use phpBB's user database and leaves MediaWiki's own user database completely unused.

I have a website with MediaWiki and phpBB3 already running separately. If I add this extension, what happens to the current user information in my wiki? Is user information in articles and revision histories etc converted or what happens to them?


 * If there are phpBB accounts with the same name then the plug-in assumes they are the same. So have your MW users go make new phpBB accounts to match their MW usernames. --Nick 20:56, 11 November 2009 (UTC)

Single Sign On
This is possible with phpbb3 and mediawiki?


 * If you are asking if it can be done the answer is yes, it can be done. --Nick 20:57, 11 November 2009 (UTC)
 * I've found a solution to this problem. It can be implemented here if the author could:

http://www.phpfreaks.com/forums/index.php/topic,258000.msg1214145.html?PHPSESSID=06jki48j9uge7uq4k6h72ck553#msg1214145 http://www.mwusers.com/forums/showthread.php?11287-Website-Login-with-API-Login-and-curl --Noone 09:40, 11 June 2010 (UTC)
 * These no longer function in version > 1.15.3 as there were changes to require tokens. Has any updated one of these pages to use the new tokens required by the api?

The cURL solution identified in those links should do the trick if combined with THIS to get it to work with the new token system. If someone more knowledgeable in PHP/cURL figures out a single script to do this (and one for logging out), please post back here. Both scripts are short, so it shouldn't be too difficult. I really like the idea of a single sign on working both from a custom external login form and with this awesome extension! --Anonymous 04:20, 11 February 2011 (UTC)
 * Single sign on is supported in the extension Phpbb Single Sign-On

Possible Permissions Problem and solution
After I installed this extension, I was no longer able to edit my Sidebar or anything under the MediaWiki namespace. To solve this, did "view Source" on the page, copied the text, then DELETE the page, then re-create it, then paste the text back and hit save. Now i have editing privs again.


 * Seems odd. I'll have to look into this later. You are the 1st to report it. --Nick 20:58, 11 November 2009 (UTC)

phpBB user id sync with Wiki user id?
Is there an easy way to make it so that when a user logs into the wiki for the first time using their phpBB username/password, that a Wiki account is created with their phpBB id? So that the unique id numbers in phpbb_users and wiki_user are synchronized with one another.


 * Yes, but do not expect this plug-in to support this feature. --Nick 20:50, 11 November 2009 (UTC)

login to both wiki and forum
Has anybody extended this extension so that logging in to the Wiki also logs in to the forum? (and maybe the reverse?) The code includes the hooks for this, but has anybody done it? --GhostInTheMachine 10:00, 13 April 2009 (UTC)


 * Single Sign On (SSO) is currently not supported. --Nick 21:00, 11 November 2009 (UTC)


 * I've found a solution to this problem. It can be implemented here if the author could:

http://www.phpfreaks.com/forums/index.php/topic,258000.msg1214145.html?PHPSESSID=06jki48j9uge7uq4k6h72ck553#msg1214145 http://www.mwusers.com/forums/showthread.php?11287-Website-Login-with-API-Login-and-curl --Noone 09:40, 11 June 2010 (UTC)
 * Has anyone updated this to work with the new 'token' system required by wp > 1.15.3?
 * Single sign on is supported in the extension Phpbb Single Sign-On--Noone 08:38, 10 June 2011 (UTC)

Group mapping
Are there any plans to extend this extension further to include support for group mapping between phpbb and mediawiki? --Ganiman 13:05, 26 June 2009 (UTC)


 * There are not. --Nick 21:01, 11 November 2009 (UTC)

Username case
I notice that you are using ucfirst(username_clean) to determine the canonical username; is there a reason why you're not simply using the username, and preserving the case? That would allow the Wiki username (as displayed) to exactly match the Forum username. --86.145.38.74 23:09, 27 June 2009 (UTC)


 * IIRC the MW 1.4 code base forces all usernames into a ucfirst(strtolower($username)) convention. --Nick 21:03, 11 November 2009 (UTC)

Is there any fix for this then?

Security Warning on MediaWiki version 1.10
After install the extension on 1.10, the page Special:Version will error and shows MySQL IP, password .. example: Chienwen 05:33, 2 September 2009 (UTC)


 * I'm looking into this. --Nick 20:49, 11 November 2009 (UTC)

Password issue
I can't seem to get this to work, I type in the correct password and it says the password is wrong. Any help, suggestions? I also turned off the Wiki group option, so you do not need a group to edit, just an account. Mediawiki 1.15.1 with phpbb3 3.5. Rgoodermote 23:00, 9 September 2009 (UTC)


 * If you want support go to the forums. --Nick 21:04, 11 November 2009 (UTC)


 * Not everyone wants to join another forum. Especially for a one time usage. - Rgood erm ote   07:27, 12 November 2009 (UTC)

Mediawiki 1.15.1 and PHPBB 3.0.6 - Is this project dead?
Using this combo, I tried and failed. Does anyone know if this project is updated as it seemed the original coder hasn't released a new public release in a short while.

Id love to get this working, any ideas/hints?

219.90.139.198 18:22, 24 November 2009 (UTC)

I'm using phpBB 3.0.6 and MW 1.15.1 with no problems.

--216.139.99.243 07:23, 28 November 2009 (UTC)


 * Glad you got it working. The project is not dead. --Nick 17:50, 11 May 2010 (UTC)

Nice work
I was just about to put a messy cross-database trigger into my phpBB mySQL database to achieve the effect of this extension. I just wanted to get a nice layout of the mediawiki to help with that job, and stumbled across this extension. I'm trying to flog the forum/wiki concept to my Parents and Citizens association by using a trial, and duplicate registration processes wouldn't have gone down well with my hesitant audience. I've added group permissions into the wgGroupPermissions array, after the extension object is created, but left the '*' group empty. I'm not sure what effect this has on 'security' yet, but wanted to get a manual permission control of sorts, based on username rather than group. For this small trial that is sufficient, but it probably wouldn't take too much hacking to get a group to group mapping going on later. Maybe the concept of open collaboration will take off in my organisation, and such measures won't be necessary.

Copying existing mediawiki user accounts to phpbb
Any existing scripts/tools to do so? Password handle are different, data base can't be just copy from mediawiki to phpbb --HKairpost 13:13, 30 December 2009 (UTC)


 * I don't know if any tools to do this. --Nick 17:51, 11 May 2010 (UTC)

Patch needed
For passwords with special characters to work properly, in file 'wiki/extensions/Auth_phpBB.php' after while($faryMySQLResult = mysql_fetch_assoc($fresMySQLResult)) {

there must be a line $password = htmlspecialchars( $password, ENT_COMPAT, 'UTF-8' );

Works for me. phpBB ver. 3.0.6, MediaWiki ver. 1.15.1. Alkvivad


 * I haven't had issues with special character passwords. I will have to look into it. I am also not sure htmlspecialchars is the best option for dealing with the issue if there is one. Glad it works for you. --Nick 17:54, 11 May 2010 (UTC)


 * Had this problem as well with passwords using punctuation, it seems with this line modification and the latest PasswordHash.php, we're up and running! note: Mediawiki running DEFAULT CHARSET=binary, phpbb running UTF-8. - Anonymous

Restoring Sysop
Ok, I installed a fresh MediaWiki and immediately, without configuring much on the wiki, installed this extension. Next thing I know, nobody had login access to be sysop. Because that is begging for potential mayhem, I tried to think logically on how this all worked, and figured since my sysop account was Admin, and on my phpBB3 board there actually was nobody named Admin, that it must need that user on the phpbb, as the Admin showed as an administrator when I entered Special:ListUsers on the wiki. So, I created an account named Admin on phpBB3 and put it in the Wiki group. I got my sysop back! Figured this might help some people.
 * How do I login as sysop? --Nick 17:58, 11 May 2010 (UTC)

strange php/headers error
strange php/headers error

Hi I tried to itegrate wiki with phbb and i have this this strange bug http://pastebin.com/q59s6YDP im using latest wiki, integration script and phpbb3 under PHP 5.2.10 ! Please help me!


 * Try getting a fresh copy of the code. If you need more help check out the forms. --Nick 18:03, 11 May 2010 (UTC)

Reverse Mode
Is there a way to do this in reverse? Rather than MediaWiki being the login slave to phpBB, and users must log into phpBB, is it possible to make phpBB the login slave, so that MediaWiki is needed to sign in? --142.167.181.86 16:30, 19 March 2010 (UTC)


 * Yes there is a way to do this and just about anything you want to do. --Nick 18:05, 11 May 2010 (UTC)

Consider this mod in LocalSettings
$wgAuth_Config['PathToPHPBB']   = '/../forum/';         // Path from this file to your phpBB install. Must end with '/'.

require_once(dirname(__FILE__) . '/' . $wgAuth_Config['PathToPHPBB'] . 'config.php'); $wgAuth_Config['MySQL_Host']       = $dbhost;            // phpBB MySQL Host Name. $wgAuth_Config['MySQL_Username']   = $dbuser;            // phpBB MySQL Username. $wgAuth_Config['MySQL_Password']   = $dbpasswd;          // phpBB MySQL Password. $wgAuth_Config['MySQL_Database']   = $dbname;            // phpBB MySQL Database Name. $wgAuth_Config['UserTB']        = $table_prefix. 'users';      // Name of your PHPBB user table. (i.e. phpbb_users) $wgAuth_Config['GroupsTB']      = $table_prefix. 'groups';     // Name of your PHPBB groups table. (i.e. phpbb_groups) $wgAuth_Config['User_GroupTB']  = $table_prefix. 'user_group'; // Name of your PHPBB user_group table. (i.e. phpbb_user_group)

Mod Development
Is this mod still active and being developed? Does it work with PHPBB 3.0.8 and 1.16.0? 87.194.248.222 16:20, 25 December 2010 (UTC) Hi. Yes, I've got it working with MW 1.16.2 and PHPBB 3.0.8. The only thing that doesn't seem to work is password reset. The user gets sent a temporary password, but it doesn't work. I have to reset users manually, which is a pain. Mitchelln 15:40, 7th February 2010 (UTC)

phpBB changes synced on login?
How does the Extension stay in sync with the original phpBB DB? Say if a user changes his or her password on phpBB, will the MediaWiki Extension check that upon a MW login or does the user have to change the PW in MediaWiki manually? 84.73.229.55 17:18, 13 June 2011 (UTC)

Maybe you want to use Extension:Phpbb_Single_Sign-On to keep accounts in sync. It provides true single sign on behaviour. --Noone 08:33, 15 June 2011 (UTC)

What 's the phpBB user's rights in Mediawiki ?
What 's the phpBB user's rights in Mediawiki ?
 * Standard is a simple user. Beware that first login causes user data from phpBB to be copied to MediaWiki - you can put a single user into a specific MW group after his/her first login. 77.59.236.57 12:04, 14 June 2011 (UTC)
 * A suggestion : in the futur version, can you put in the same name phpBB group in MediaWiki ?

Wiki and PHPBB on different servers
I have a scenario where the wiki is on one server, and the forum on an other server. Currently it looks to me that PathToPHPBB has to be on the same filesystem. Has anyone create a patch that would allow the wiki and forum to be on different servers?
 * I managed to get it to work by having an installation of phpBB on the same server as the wiki (originally used as a backup of the forum) and pointing to that installation in the PathtoPHPBB string. Hope this helps. --anon

getCanonicalName function modification proposal
public function getCanonicalName( $username ) {           global $wgContLang;

// Connect to the database. $fresMySQLConnection = $this->connect;

$username = $this->utf8($username); // Convert to UTF8 clean name

// Check Database for username. We will return the correct casing of the name. $fstrMySQLQuery = sprintf("SELECT `username`                              FROM `%s`                               WHERE `username_clean` = '%s'                               LIMIT 1",                               $this->_UserTB,                               mysql_real_escape_string($username, $fresMySQLConnection));

// Query Database. $fresMySQLResult = mysql_query($fstrMySQLQuery, $fresMySQLConnection) or die($this->mySQLError('Unable to view external table'));

while($faryMySQLResult = mysql_fetch_assoc($fresMySQLResult)) {               return $wgContLang->ucfirst($faryMySQLResult['username']); }

// At this point the username is invalid and should return just as it was passed. return $username; } What do you intend to achieve with this change? --Noone, 21 July 2011 (UTC)
 * I just tried it and it seams usernames are used and written into the wiki-database without being converted to lower case. Quite useful, I think - but may there arise any other problems with this code change?? I haven't detect any, but I don't think I understand the whole code well enough to be sure... --79.235.92.229 12:01, 2 August 2011 (UTC)

Restrict for specific group
Wonderful plugin. I have one inquiry though: When users register to my forum, they are being put into the "Newly Registered" Group, which has "Never"-Restrictions, and at the same time into the "Registered" Group. After one post, I assume the "Newly Registered" membership will be deleted, so "Registered" is the user's new (and only) main group. Since I don't want newly registered users to have the right to edit, how can I achieve this? Setting the necessary user group to "REGISTERED" in the plugin settings won't help, since the user is also in "Registered", and I don't assume the plugin works with the same "NEVER"-Settings as phpBB does. Thank you. -- Thomas