Hello, i tried to set up my exim with authentication over mysql db.
I configured this in exim.conf
MYSQL_USER_CLEARPW1 = SELECT u.clear_pw FROM users AS u WHERE u.username
= '${quote_mysql:$1}' LIMIT 0,1;
MYSQL_USER_CLEARPW2 = SELECT u.clear_pw FROM users AS u WHERE u.username
= '${quote_mysql:$2}' LIMIT 0,1;
....
....
begin authenticators
fixed_login:
driver = plaintext
public_name = LOGIN
server_prompts = Username:: : Password::
server_condition = ${if and
{{!eq{$1}{}}{!eq{$2}{}}{crypteq{$2}{\\{md5\\}${lookup
mysql{MYSQL_USER_CLEARPW1}{$value}fail}}} } {yes}{no}}
server_set_id = $1
fixed_plain:
driver = plaintext
public_name = PLAIN
server_prompts = :
server_condition = ${if and
{{!eq{$2}{}}{!eq{$3}{}}{crypteq{$3}{\\{md5\\}${lookup
mysql{MYSQL_USER_CLEARPW2}{$value}fail}}} } {yes}{no}}
server_set_id = $2
When i try to auth via plain or login i get the following error in my
log messages.
Sep 13 21:20:02 gera124 exim[25348]: 2006-09-13 21:20:02 fixed_login
authenticator failed for dslb-084-057-142-099.pools.arcor-ip.net
([192.168.99.21]) [84.57
.142.99]: 435 Unable to authenticate at present
([EMAIL PROTECTED]): missing } at end of condition inside
"and" group
I understand the error message, but i think (and hope i´m not wrong with
that) i had done this right, and placed the curly braces correctly.
Can someone give me a hint where my problem is?
My second question is about using $auth(n) or $(n) in the
server_condition. When i use $auth(n) i get
Sep 13 20:27:16 gera124 exim[24110]: 2006-09-13 20:27:16 fixed_login
authenticator failed for dslb-084-057-142-099.pools.arcor-ip.net
(morlix.de) [84.57.142.9
9]: 435 Unable to authenticate at present: unknown variable name "auth1"
inside "and{...}" condition
Best regards,
Timo
signature.asc
Description: OpenPGP digital signature
-- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
