Hello Everyone,
I am trying to get Dokuwiki integrated with SMF and am having great difficulties so far.
I am trying to use the settings from
https://www.dokuwiki.org/auth:mysql_smf
When looking at the documentation for the mysql auth plugin it says:
checkPass
This statement is used to grant or deny access to the wiki. The result should be a table with exact one line containing at least the password of the user. If the result table is empty or contains more than one row, access will be denied.
I turned the debugging on and ran the select statement against my mysql database and it finds the user and returns the password, yet still getting
Sorry, username or password was wrong.
The code for the query is
$conf['plugin']['authmysql']['checkPass'] = "SELECT passwd as pass
FROM smf_members
WHERE member_Name = '%{user}'
AND passwd = SHA1(concat(LOWER(member_Name), '%{pass}'))";
And the select statement from the debug that works is
SELECT passwd as pass FROM smf_members WHERE member_Name = 'xxxxxxxxx' AND passwd = SHA1(concat(LOWER(member_Name), 'xxxxxxxxxxxxxx')) [auth.php:799]
Would really appreciate any ideaS?