phpBB3Auth - Migrate phpBB3 user/password to VB4

[MoreLinux]

For all the phpBB3 administrators who want to migrate their phpBB3 to VB4 and hate the idea that the users have to use the "Forgotten your password?" method to logon to the new VB4 board.

The idea heavily borrowed from the ipbAuth (https://vborg.vbsupport.ru/showthread.php?t=236012) mod created by viarun.

The solution I implemented is that I first hash the password the phpBB3 way and check the hashed password against the entry in phpbb3.users table. When the hashes are the same I use the normal VB4 method to store the password in the VB4 database.

Because I don't like to destroy the original phpBB3.users table I added an extra field "PWD_Synced" to the table and use that field to remember that a password was already synced.

We are running this mod on our brand new VB4 forum http://www.astroforum.nl and it work perfect. 330+ phpBB3 users already migrated their password to the new board.

Many thanks to viarun and malcolmx in his LDAP Auth Plugin. THANKS guys!

Installation instructions:
Add the field "PWD_Synced" in the phpBB3 table phpbb_users. You can use the following statement.
"ALTER TABLE `phpbb_users` ADD `PWD_Synced` BOOL NOT NULL DEFAULT '0';"
copy phpBB3Auth directory to your vb forum installation directory
change the path to controller.php directory in phpBB3-plugin.xml
copy the hooks_phpBB3.xml to FORUM_ROOT/inclucdes/xml directory
in login.php do:
search for:
if ($vbulletin->GPC['vb_login_username'] == '')
{
eval(standard_error(fetch_error('badlogin', $vbulletin->options['bburl'], ....
}

insert below:
($hook = vBulletinHook::fetch_hook('phpBB3_login_hook')) ? eval($hook) : false;

activate plugin system (if not done already) in admincp
in admin cp import the product file "phpBB3-plugin.xml" at "Download / Upload" Plugins
re-check if the include for controller.php is right
in includes/class_bootstrap.php search for:
$show['nopasswordempty']
change: defined('DISABLE_PASSWORD_CLEARING') ? 1 : 0;
to: defined('DISABLE_PASSWORD_CLEARING') ? 0 : 1;
test the product

Important information

In my documentation I forgot too mention that it is best to install the plug-in after you migrated the data from phpBB3 to VB4. You can leave the phpBB3 database on-line and when you go live the users start to login on VB4 and automagically the password gets migrated to VB4.

Detailed installation instructions and all files needed are in the zip file.

Have fun with it,
MoreLinux

[Kolektor]

must be included in the impex.

[funmasti]

it solved a big prob

[MoreLinux]

@Kolektor and Funmasti, Thanks

Funmasti, I would love to hear about your experience with phpBB3Auth.

[MoreLinux]

I updated the docu a bit. The following was added.

Important information

In my docu I forgot to mention that it is best to install the plug-in after you migrated the data from phpBB3 to VB4. You can leave the phpBB3 database on-line and when you go live the users start to login on VB4 and auto-magically the password gets migrated to VB4.

[CRDeveloper]

I need help with this.

Can i have this path include('phpBB3Auth/controller.php'); if the folder is in public_html/forum/ ???

Do i have to set the config file?

[CRDeveloper]

Now its working, thanks for the mod!

[sarangan]

It's not working for me.. I have succesfully imported all those 33.000 users I had in my phpbb3 installation and moved all to vb latest version succesfully.. I also have installed everything correct.. But login doesn't works..

Please help need.. :(

[charl13dontsurf]

Nevermind!

You rock!

[Vcize]

Is there anything like this for going from phpbb3 to vb3?

[Lestat_]

this is heaven ! thank you so much mate, you saved me lots and lots of troubles - works excellent, this was the final step I needed to make the transition from phpbb to vbulletin - thank you, you saved my day :D

[Tracyf]

Ok so I installed this and i cannot get it to work.

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host '<host>' (1) in [path]/phpBB3Auth/controller.php on line 99
Unable to connect to DB: Unknown MySQL server host '' (1)

What does this mean and how do I fix it?

EDIT: Nevermind I got it right after this post :)

[thetgc]

+1 for being added to impex... this would have helped me when i migrated 2 years ago!

[Alright_Guys!]

Thanks for your code.
I just picked out some lines to help me coding a password updater. Works great!

[CPTA]

it this working?

[Thomasmp]

amazing

[Mr GRiM]

I wish I knew about this mod a couple of months ago, Impex sucks and I have lots so many many members because this wasn't included

[kisanjong]

excellant - thankyou :)


I just picked out some lines to help me coding a password updater. Works great!

sounds interesting please explain this more :D

[VictoriaS]

Hi, sorry if I'm being a bit dim but I don't understand this:

'copy phpBB3Auth directory to your vb forum installation directory
change the path to controller.php directory in phpBB3-plugin.xml'

Is the phpBB3Auth directory the folder called 'auth' that sits within the includes directory on phpbb? If so do I copy across the whole of that folder to my vBulletin installation inside the 'install' folder or somewhere else?

Where then do I need to put:

phpBB3_functions.php
phpBB3config.inc.php
controller.php

I'm fine with the rest of it. Any help anyone can give would be much appreciated!

Thanks,

Victoria

[VictoriaS]

Bump!

Can anyone shed any light on this please?

[MoreLinux]

@VictoriaS, the directory is called phpBB3Auth and it is put into the forum root directory.

[volantis]

I cannot get this to work. When my path to controller.php is anything other than /phpBB3Auth/controller.php it tells me cannot connect to database. When i have it set to /phpBB3Auth/controller.php it doesn't seem to work, but does let you try to login and tell you the password is incorrect.

I see others had this problem and then figured it out, but didn't post the solution in this thread.

Thoughts?

[kh99]

Did you copy the phpBB3auth directory to your forum directory (the same one with forum.php)?

[volantis]

Did you copy the phpBB3auth directory to your forum directory (the same one with forum.php)?

Yes, I did. I have the modified phpBB3-plugin.xml file in there as well.

My guess is something is up with the path to controller.php, but that's just a guess. Thanks for your input.

[kh99]

OK, I looked at the code a little and it looks like you need to edit the phpBB3config.inc.php file to set the database information for the db that has the old passwords (seems to be missing from the installation instructions).

I'd put the path back the way you had it when you were getting the db error - I think you had it right.

[volantis]

OK, I looked at the code a little and it looks like you need to edit the phpBB3config.inc.php file to set the database information for the db that has the old passwords (seems to be missing from the installation instructions).

I'd put the path back the way you had it when you were getting the db error - I think you had it right.

That's embarrassing that I didn't even think about where the data would be coming from. I may have it connecting to the DB...I'll get some people to test it and report back here either way for future reference.

[volantis]

I'm still getting unable to connect to DB. It doesn't show any error message after the message, which seems odd.

I reset the include path to be ./phpBB3Auth/controller.php which is what came out of the box.

config file info:
$phpBB3DbHost='<localhost>';
$phpBB3DbName='<dbname>';
$phpBB3DbUser='<dbuser>';
$phpBB3DbPass='<dbpwd>';
$phpBB3DbPrefix='phpbb_';

I feel like it's really close to working....anyone have an idea?

[kh99]

I'm pretty sure you need to change all those entires like <dbname> to be an actual value, for instance <dbname> would be the user name that you use to connect to the database. If it's the same database server that you're using for vbulletin, then I guess they would be the same values that you have in your config.php.

ETA: oh, I just looked at the "out of the box" values and I see that you did change them...so where did you get those values? They look kind of strange with <> aoround them.

[volantis]

I'm pretty sure you need to change all those entires like <dbname> to be an actual value, for instance <dbname> would be the user name that you use to connect to the database. If it's the same database server that you're using for vbulletin, then I guess they would be the same values that you have in your config.php.

ETA: oh, I just looked at the "out of the box" values and I see that you did change them...so where did you get those values? They look kind of strange with <> aoround them.

It was operator error typing in the db passwords. I wasn't thinking and left the <>.

So for others having problems:
- You must set the DB settings for the phpBB server in the config file
- The correct path for controller.php is likely ./phpBB3Auth/controller.php

[zag2me]

Thanks for this, saved me a lot of effort!

[rgreene1971]

I am so jealous right now. I am moving from smf to vb4 at the end of the month and would kill for a mod like this one.

[PikkonMG]

Does this still work with 4.2.0 patch level 2? I know i had used it some time ago but im unable to get ti to work on anymore, you try to login and tell you the password is incorrect.

[yakiclub]

Please be an example ?

[arsalan660]

I also had problem converting my phpbb forum. Some password got converted but Some user complain about incorrect password.

[peterska2]

Has anyone had any success getting this to work with vB3? It would really save my bacon if it has already been done by someone else.

[spinferno]

Hey gang, I have issues in running this cool phpbbauth system.
After the install, i get this error:
Warning: include(./vbulletin/phpBB3Auth/controller.php): failed to open stream: No such file or directory in [path]\login.php(114) : eval()'d code on line 1

Warning: include(): Failed opening './migration/phpBB3Auth/controller.php' for inclusion (include_path='.;C:\php\pear') in [path]\login.php(114) : eval()'d code on line 1
Has anyone else had similar issues and can point me towards whether the fix is to try different paths or to hack the include files?
Thanks guys!
Bill

[Wickex]

Worked fine for me on 4.2.0! :)

Thanks a lot, you saved me so much time!

[acalero]

Totally awesome! Just worked perfectly! Wondering if this could be managed at VB5 too, because it's the next step I've to take

Thank you very much

[dartho]

What would be the chances of doing the same with WordPress to VB4?

Thanks!

[edit: working on it myself, almost there]

[kemraj]

when can i un install it? will it transfer everything right away or only when a person logs in

[dartho]

It only updates on log in, so you do not uninstall it until ALL users have logged in, or until you are willing to put them through the VB lost password procedure

[superj707]

GREAT MOD! is there an SMF version of this also?

[gullbird]

i suggest update it like

we copy phpbb_user table to vb database so we need to have only one table instead of whole phpbb database.

once field "PWD_syn" is filled it notifies to admin with instruction to remove those added lines into login.php and bootstrap.php and removing phpbb3auth directory.