Anope IRC Services

Anope Support => 2.0.x/1.9.x Support => Topic started by: Craig Fairhurst on December 20, 2014, 11:55:44 PM

Title: Anope with phpBB (MySQL and enc_bcrypt)
Post by: Craig Fairhurst on December 20, 2014, 11:55:44 PM

Hey guys

I got a good one for you guys, I wish to use enc_bcrypt to retrieve/authenticate passwords in a phpbb forum database.

My MySQL configuration is up and running so I'm now stuck using query from m_sql_authentication to get at the password data but I'm not sure how to get it to use enc_bcrypt.

Code: [Select]

query = "SELECT `user_email` AS `email` FROM `phpbb_users` WHERE `username` = @a@ AND `user_password` = ??????@p@"
How would I enable bcrypt in the SQL command???

Kind regards

Title: Re: Anope with phpBB (MySQL and enc_bcrypt)
Post by: LEthaLity on December 21, 2014, 06:06:48 PM

you can't, unless someone changes what can be done with the provided password, eg. using one of the enc_* modules, like Inspircd's sqlauth does, iirc.

Title: Re: Anope with phpBB (MySQL and enc_bcrypt)
Post by: Craig Fairhurst on December 21, 2014, 08:00:33 PM

OK

FYI I ended up modifying phpBB, php/auth/provider/db.php and phpbb/passwords/driver/bcrypt.php were the files I needed to modify in order to negate the crypt algorithm.

Kind regards