>I have setup exim to handle SMTP AUTH and read user info from a MySQL
>database. I am configured for both methods (LOGIN and PLAIN). The Login
>method seems to work correctly (so program like Outlook Express work fine),
>but PLAIN seems to not be working. I have setup plain as follows:
>
>plain:
> driver=plaintext
> public_name=PLAIN
> server_condition = "${if eq{$2} \
> {${lookup mysql{SELECT pwd FROM mail \
> WHERE uname='${local_part:$1}'}}}{1}{0}}"
> server_prompts= "Login::"
> server_set_id=$1
>
>
These work for me...
plain_login:
driver = plaintext
public_name = PLAIN
server_condition = \
${lookup mysql{SELECT if(count(*), "1", "0") \
FROM passwd WHERE id = '${quote_mysql:$2}' and \
clear = '${quote_mysql:$3}'}}
server_set_id = $2
fixed_login:
driver = plaintext
public_name = LOGIN
server_prompts = "Username:: : Password::"
server_condition = \
${lookup mysql{SELECT if(count(*), "1", "0") \
FROM passwd WHERE id = '${quote_mysql:$1}' and \
clear = '${quote_mysql:$2}'}}
server_set_id = $1
