Not logged in. · Lost password · Register
Forum: General Help and Support Installation and Configuration RSS
AuthPDO & Simple Machines Forum - SOLVED
It works, but it doesn't.
NFG #1
User title: Distracted.
Member since Oct 2010 · 18 posts · Location: Australia
Group memberships: Members
Show profile · Link to this post
Subject: AuthPDO & Simple Machines Forum - SOLVED
UPDATE:  AuthPDO doesn't work against SMF's clever password encryption strategies, but I found this AuthSMF20 plugin which seems to work fine.

Original post follows:

So I finally sat down and worked out how the AuthPDO module worked and went from a dead wiki, to the wrong columns being returned, to no errors in a short time.  But it doesn't work.  Verified user/pass credentials are refused every time.

Sorry, username or password was wrong.

If I make any changes to the SQL code, an error is generated (debug is on) and I get an SQL statement which, when corrected, returns the right results.  So the simple answer is the user/pass just doesn't match.  So...  ¯\_(ツ)_/¯

Here's my SQL:

SELECT `id_member` AS `uid`, `member_name` as `user`, `real_name` as `name`, `passwd` as `hash`, `email_address` as `mail` FROM smf_members WHERE `member_name` = :user

And that generates these results:

123, NFG, NFG, <hash>, <email>

But it fails.  I'm guessing it's the salt, but while I know where the salt is in the db, I can't find any code that deals with mysql and bcrypt so I don't know how to sort out the 'check pass' component of the authpdo module.  Every example I can find is MD5 or SHA1 and that != bcrypt and I'm just way out of my depth here.

If anyone has some mysql to apply to the DB and match against the wiki user's password, or can point out where I've gone wrong in my thinking, I'd love to see it.
This post was edited on 2019-12-09, 23:31 by NFG.
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum
This board is powered by the Unclassified NewsBoard software, 20150713-dev, © 2003-2015 by Yves Goergen
Current time: 2020-04-06, 04:25:48 (UTC +02:00)