From: John Doe <jdmls@???>
> USERCHECK_PLAIN_QUERY = ${lookup mysql {SELECT password FROM emails WHERE login
> = '$2'} {$value}fail}}{1}{0}"
> USERCHECK_LOGIN_QUERY = ${lookup mysql {SELECT password FROM emails WHERE login
> = '$1'} {$value}fail}}{1}{0}"
> ...
Fixed it!
End of the week => SELECT password instead of login, plus trailing "...
I also changed a few things:
AUTH_PLAIN_QUERY = SELECT login FROM emails WHERE login = '$2' AND password = MD5('$3')
AUTH_LOGIN_QUERY = SELECT login FROM emails WHERE login = '$1' AND password = MD5('$2')
PLAIN:
driver = plaintext
public_name = PLAIN
server_prompts = :
server_condition = ${lookup mysql{AUTH_PLAIN_QUERY}{1}fail}
server_advertise_condition = ${if def:tls_cipher }
server_set_id = $2
LOGIN:
driver = plaintext
public_name = LOGIN
server_prompts = <| Username: | Password:
server_condition = ${lookup mysql{AUTH_LOGIN_QUERY}{1}fail}
server_advertise_condition = ${if def:tls_cipher }
server_set_id = $1
Anything looks wrong or could be done better?
Thx,
JD
