From: John Doe <[email protected]>
> 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
--
## List details at http://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/
