Extension talk:PHPBB Auth

From mediawiki.org

/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)Reply

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)Reply

The site is up --Nick 08:27, 11 January 2008 (UTC)Reply
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)Reply
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)Reply
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)Reply
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)Reply

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)Reply

My site is up. --Nick 08:43, 19 May 2008 (UTC)Reply

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 ?[edit]

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)Reply

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

How can anonymous users edit wiki pages?[edit]

Only logged in can do this. 84.42.63.97 21:48, 27 December 2008 (UTC)Reply

MediaWiki 1.6.x (aka PHP4 users)[edit]

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[edit]

We made some changes to allow multiple wiki groups:

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

//-- mod : Multi-Group-Auth ------------------------------------------------------
//-- del
//            // Get WikiId
//            mysql_query('SELECT @wikiId := `group_id` FROM `' . $GLOBALS['wgPHPBB_GroupsTB'] . //<-
//                        '` WHERE `group_name` = \'' . $GLOBALS['wgPHPBB_WikiGroupName'] . '\';', $fresMySQLConnection) //<-
//                        or die($this->mySQLError('Unable to get wikiID.'));
//
//            // Check UserId and WikiId
//            mysql_query('SELECT @isThere := COUNT( * ) FROM `' . $GLOBALS['wgPHPBB_User_GroupTB'] . //<-
//                        '` WHERE `user_id` = @userId AND `group_id` = @wikiId;', $fresMySQLConnection) //<-
//                        or die($this->mySQLError('Unable to get validate user group.'));
//-- add
            // Check UserId and WikiId
            mysql_query('SELECT @isThere := COUNT( * ) FROM `' . $GLOBALS['wgPHPBB_User_GroupTB'] . //<-
                        '` WHERE `user_id` = @userId AND `group_id` in
                                (SELECT `group_id` FROM `' . $GLOBALS['wgPHPBB_GroupsTB'] . //<-
                                '` WHERE `group_name` in (' . $GLOBALS['wgPHPBB_WikiGroupName'] . '));', $fresMySQLConnection) //<-
                        or die($this->mySQLError('Unable to get validate user group.'));
//-- fin mod : Multi-Group-Auth --------------------------------------------------

To configure this you have to add multiple groups in your LocalSettings.php as well:

$wgPHPBB_WikiGroupName  = "'wiki group 1', 'wiki group 2'";           // Name of your PHPBB group
                                                // users need to be a member 
                                                // of to use the wiki. (i.e. wiki)

Notice the quotes. It is important to write every group in single quotes. Star 17:24, 6 February 2008 (UTC)Reply

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)Reply

Can we do reverse log in?[edit]

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)Reply

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)Reply
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)Reply
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)Reply

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)Reply

Security Issue[edit]

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)Reply

I can see why this feature would be needed. I will look into adding it. --Nick 20:52, 11 November 2009 (UTC)Reply

Thanks[edit]

Thanks for this extension! It saves us a lot of duplicate user accounts / passwords. :) --Pnagel 09:19, 9 April 2008 (UTC)Reply

You are welcome. --Nick 21:05, 11 November 2009 (UTC)Reply

Notice Errors[edit]

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)Reply

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

Doesn't work --> Exception Error[edit]

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)Reply

Take a look at this post on the forums. php|uber.leet Forums --Nick 06:00, 7 June 2008 (UTC)Reply
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)Reply
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)Reply
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)Reply

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)Reply

How about an answer?[edit]

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)Reply

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)Reply

Will this work on a 1.6.8 version of Mediawiki?[edit]

  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)Reply

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?[edit]

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?[edit]

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)Reply

Single Sign On[edit]

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)Reply
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)Reply

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[edit]

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)Reply

phpBB user id sync with Wiki user id?[edit]

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)Reply

login to both wiki and forum[edit]

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)Reply

Single Sign On (SSO) is currently not supported. --Nick 21:00, 11 November 2009 (UTC)Reply
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)Reply

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[edit]

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)Reply

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

Username case[edit]

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)Reply

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

Is there any fix for this then?

Security Warning on MediaWiki version 1.10[edit]

After install the extension on 1.10, the page Special:Version will error and shows MySQL IP, password .. example:

Auth_phpBB Object
(
    [_DB_Collation:private] => 
    [_debug:private] => 
    [_GroupsTB:private] => phpbb_groups
    [_LoginMessage:private] => You need a phpBB account to login.
Click here to create an account.
    [_MySQL_Database:private] => wiki
    [_MySQL_Host:private] => localhost
    [_MySQL_Password:private] => 1111
    [_MySQL_Username:private] => root
    [_MySQL_Version:private] => 
    [_NoWikiError:private] => You are not a member of the required phpBB group.
    [_PathToPHPBB:private] => ../phpbb/
    [_SessionTB:private] => 
    [_UseExtDatabase:private] => 1
    [_User_GroupTB:private] => phpbb_user_group
    [_UserID:private] => 
    [_UserTB:private] => phpbb_users
    [_UseWikiGroup:private] => 
    [_WikiGroupName:private] => Wiki
)


Catchable fatal error: Method Auth_phpBB::__toString() must return a string value in C:\AppServ\www\wiki\includes\SpecialVersion.php on line 233

Chienwen 05:33, 2 September 2009 (UTC)Reply


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

Password issue[edit]

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)Reply

If you want support go to the forums. --Nick 21:04, 11 November 2009 (UTC)Reply
Not everyone wants to join another forum. Especially for a one time usage. - Rgoodermote  07:27, 12 November 2009 (UTC)Reply
I have the same problem, if in the password the sign " or the & then wiki say, password wrong. Any idea why?

Mediawiki 1.15.1 and PHPBB 3.0.6 - Is this project dead?[edit]

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)Reply

    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)Reply

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

Nice work[edit]

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[edit]

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)Reply

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

Patch needed[edit]

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)Reply
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[edit]

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)Reply

strange php/headers error[edit]

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)Reply

Reverse Mode[edit]

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)Reply

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

Consider this mod in LocalSettings[edit]

$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)

This is a good option! Eliminates the need to put these vars in the config file. --Frug (talk) 19:05, 21 June 2012 (UTC)Reply

Mod Development[edit]

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)Reply
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?[edit]

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)Reply

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 ?[edit]

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)Reply
A suggestion : in the futur version, can you put in the same name phpBB group in MediaWiki ?

Wiki and PHPBB on different servers[edit]

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[edit]

        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)Reply

Restrict for specific group[edit]

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

Throwing an error with PHP 5.3[edit]

Hi. This extension works fine with PHP 5.2, but with 5.3 it throws an error:

Notice: Undefined variable: wgRequest in /var/www/webapps/wiki/index.php on line 51 
Fatal error: Call to a member function getVal() on a non-object in /var/www/webapps/wiki/index.php on line 51 

If I disable the extension the wiki runs fine, so it is definitely a problem with this extension. Any ideas what might be wrong?
Thanks
--Mitchelln 11:11, 15 December 2011 (UTC)Reply

I found out what it is. For some reason when using PHP 5.3, apc caching causes this extension to totally die. On PHP 5.2 it is fine, even with the same version of apc. Very odd.
Mitchelln 10:11, 21 December 2011 (UTC)Reply

Make PHPBB/Users Integration better[edit]

I install MediaWiki 1.18.1 and phpBB 3.0.10. Extension:PHPBB/Users_Integration does not suit me.

I need the following functionality:

  1. when user input login and password script first checks its presence in the database wiki
  2. if user not present in wiki userbase, script must access to phpBB3 user table (with ban-check), and if user present in phpBB3-usertable user login into wiki
  3. phpBB3-user must have full wiki-capabilities and script must map phpBB3 usergroups into the wiki-groups

I know about ExternalAuth and class ExternalUser in wiki-engine, but I do not know what to do next

P.S. Sorry my bad english

ExternalAuth and method getGroups()[edit]

  • how I can set permissions to phpBB3 groups?

or

  • how I can map phpBB3 groups to mediawiki groups?


Well, i needed map phpBB3 groups to mediawiki urgently, so, although I'm newbie y does a litle temporaly patch :)
Only add section "-- mod : Update-Group-Auth"
CAUTION: this mod doesn't work with $wgSharedTables, if u use $wgSharedTables change manually the name of $table_user and $table_group to right ones.
    	public function authenticate($username, $password)
    	{
            // Connect to the database.
    		$fresMySQLConnection = $this->connect();

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

    		// Check Database for username and password.
    		$fstrMySQLQuery = sprintf("SELECT `user_id`, `username_clean`, `user_password`
    		                   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))
            {
                //-- mod : Update-Group-Auth by trollderiu ------------------------------------
                $id_auth = $faryMySQLResult['user_id'];
                $user_auth = ucwords($faryMySQLResult['username_clean']);
                
                $groupNames = mysql_query('SELECT `group_name` FROM `' . $this->_GroupsTB . '` WHERE `group_id` in 
                                (SELECT `group_id` FROM `' . $this->_UserTB . '` WHERE `user_id` = ' . $id_auth . ')', $fresMySQLConnection)
                        or die($this->mySQLError('auth: select group_name error'));
                        
                while($groupName = mysql_fetch_array($groupNames))
                {                 
                    $db_selected = mysql_select_db($GLOBALS['wgDBname']);
                    $group = $groupName['group_name'];                    
                    $table_user = $GLOBALS['wgDBprefix'] . 'user';
                    $table_group = $GLOBALS['wgDBprefix'] . 'user_groups';
                    
                    $exist_groups = mysql_query('SELECT * FROM ' . $table_group . ' WHERE `ug_user` in 
                        (SELECT `user_id` FROM ' . $table_user . ' WHERE `user_name` = "' . $user_auth . '")', $fresMySQLConnection)
                            or die ($this->mySQLError('auth: select group error')); 
                    
                    if (mysql_num_rows($exist_groups) == 0){
                        $user_ids = mysql_query('SELECT user_id FROM ' . $table_user . ' WHERE `user_name` = "' . $user_auth . '"', $fresMySQLConnection)
                                or die($this->mySQLError('auth: insert group error'));
                        
                        while($user_id = mysql_fetch_array($user_ids)){                        
                            mysql_query('INSERT INTO ' . $table_group . ' (ug_user, ug_group) VALUES (' . $user_id['user_id'] . ' , "' . $group . '" );') 
                                or die($this->mySQLError('auth: insert group error'));                            
                        }
                    }else{
                        while($exist_group = mysql_fetch_array($exist_groups)){
                           if($exist_group['ug_group'] != $group){
                              mysql_query('UPDATE ' . $table_group . ' SET ug_group = "' . $group . '" WHERE `ug_user` = ' . $exist_group['ug_user'])
                                 or die($this->mySQLError('auth: update group error'));
                           }   
                        }                        
                    }
                    $db_selected = mysql_select_db($this->_MySQL_Database, $fresMySQLConnection);                    
                }
                //-- fin mod : Update-Group-Auth by trollderiu ------------------------------------

feel free to improve it.

manual invalidate user session[edit]

So, I install Extension:PHPBB/Users_Integration. On every user login extension check user password and groups from phpBB base. When I ban user on phpBB, user adds to specified group, which not allowed for login to mediawiki. How I can invalidate mediawiki sessions and cookies of specified user (which now has been banned)

work with mediawiki 1.19.2?[edit]

I used to have this working, then I had to upgrade my wiki, and now it doesn't work...

I use phpbb3 version: 3.0.9 MediaWiki 1.19.2 PHP 5.2.17 (cgi-fcgi) MySQL 5.1.66-community-log

Any suggestions?

--Cadosuperum (talk) 04:13, 13 November 2012 (UTC)Reply

Invalid username caused by cyrillic names[edit]

There's a little fix for it: when validating username in User.php $name != $wgContLang->ucfirst( $name ) is used, but when Auth_phpbb in getCanonicalName function there's ordinal ucfirst: return ucfirst($faryMySQLResult['username_clean']); so changing to the following fixxed the problem: return $GLOBALS["wgContLang"]->ucfirst($faryMySQLResult['username_clean']);


Sorry for inproper post - it's the first time I'm posting anything in duscuss threads...

Underline in username[edit]

Hello i have a problem, if in the username a underline (_) then the user cant login in the medaiwiki. Give it any patch for it? I use the German language pack from phpbb and mediawiki.

i Have found any one. I have edited the auth_phpbb.php to this: http://svn.m0tah.com/88Flak/Misc/Auth_phpBB.php found over google.

Sorry 4 bad english but i hope i can help any users

What happens to currently registered Wiki accounts if they match (or are similar to) phpBB accounts?[edit]

What happens if I try to install this on a Mediawiki install after phpBB forum users have already registered on the wiki using Mediawiki's default registration process (Special:UserLogin&type=signup page)? Users have been registering normally on Mediawiki for about a year now. Will the usernames overlap? Overwrite? --GregariousJB (talk) 01:00, 14 April 2016 (UTC)Reply

EDIT: I found this similar question above, so I guess that's my answer unless that has changed. We simply make sure people use the same registration name for Wiki and phpBB. --GregariousJB (talk) 01:05, 14 April 2016 (UTC)Reply

Fix your Mediawiki versions in the infobox[edit]

http://i.imgur.com/U9Sfcmn.png

This implies that it only supports Mediawiki 1.12.x and 1.17.x and no other versions. It should say something like "1.11+", as it is in your description's first paragraph. — Preceding unsigned comment added by GregariousJB (talkcontribs) 02:25, 14 April 2016‎

Done C4K3 (talk) 17:08, 1 July 2016 (UTC)Reply

Automatic account creation is not allowed[edit]

After setting up the extension with MediaWiki 1.27, create the Wiki group on phpBB board, and then log on MediaWiki, I've got this error :

Auto-creation of a local account failed: Automatic account creation is not allowed.

I think this is link to 1.27 version and the introduction of AuthManager replacing AuthPlugin. --Andonier (talk) 21:00, 5 July 2016 (UTC)Reply

It's caused by the new permission autocreateaccount added in mediawiki 1.27, see https://github.com/Digitalroot/MediaWiki_PHPBB_Auth/pull/13 -Cake~talk 19:55, 18 July 2016 (UTC)Reply

strange problem Call to a member function bind_param() on boolean[edit]

Hi

I installed as per instructions (mediawiki 1.27) and now when I press login says: Fatal error: Call to a member function bind_param() on boolean in /home/max/newforum2/mediawiki-1.27.1/extensions/Auth_phpbb.php on line 507 I have copied in LocalSettings.php what is needed, double checked the database info required there.

Please somebody could help? — Preceding unsigned comment added by Edrimon (talkcontribs) 22:44, 4 October 2016

That error is because it's not connecting to the database properly. It ought to have better error messages than that, but 1.27 has mostly broken the way it previously showed error messages, but I digress. I assume you've got useExtDatabase set to false. Try setting it to true and manually enter the database info into your LocalSettings. The only other cause I can think of is you're using some weird phpbb version that this extension doesn't understand. In either case, if you want faster help, post an issue at https://github.com/Digitalroot/MediaWiki_PHPBB_Auth/issues you'll get a faster response then. -Cake~talk 23:25, 14 December 2016 (UTC)Reply

Doesn't work with 1.33 (and probably anything after 1.27)[edit]

Version Info says it works with 1.27+, however it actually doesn't. AuthPlugin was deprecated in MW 1.27, so it's looking for an old file that no longer exists. More info here: https://www.mediawiki.org/wiki/AuthPlugin

BradLeeBH (talk) 04:52, 25 July 2019 (UTC)Reply