dokiwiki 2018-04-22b "Greebo"
nginx 1.16.1
PHP 7.3.13
MariaDB 10.4.11
table
users - id, login, pass, name, mail
groups - id, name
usergroup - uid, gid
adds a user to the users table - everything is OK
$conf['plugin']['authpdo']['insert-user'] = 'INSERT INTO users (login, pass, name, mail)
VALUES (:user, :hash, :name, :mail)';
for example
login - test
pass (:hash) - $1$faeXB3YP$Fy2Ed6YSG.16cGZ3CMp/2.
:clear - 'tiihivkab46#'
and when I check the check-pass at the entrance-the passwords do not match
pass
<> MD5(CONCAT(MD5(:user), MD5(:clear)))
$conf['plugin']['authpdo']['check-pass'] = 'SELECT id AS "uid"
FROM users
WHERE login = :user
AND pass = MD5(CONCAT(MD5(:user), MD5(:clear)))';
what the error is?
...
SELECT id AS "uid",
pass,
MD5('tiihivkab46#')
FROM users
WHERE login = 'test'
/* AND pass = MD5(CONCAT(MD5('test'), MD5('tiihivkab46#')))*/
pass= $1$faeXB3YP$Fy2Ed6YSG.16cGZ3CMp/2.
MD5('tiihivkab46#') = 56335c62603eceb64e68ab6422d531a0
how dokuwiki generates :hash from :clear= 'tiihivkab46#' for correct comparison in ['authpdo'] ['checkpass'] ?