On Mar 25 Dan Egli wrote:
>a sample user would look like:
>-------------------------------------
>| bitwize | Y | 25M | jk76asd523 |
>--------------------------------------
>
>the passwd is encrypted using the Encrypt() function in MySql. But I am
>unable to get Exim to accept the password. When I try testing the SMTP AUTH
>exim always returns authentication failure. Here is what I am trying to use
>as my auth lookup line:
>
>server_condition = "${if crypteq{$2} \
> {${lookup mysql{SELECT passwd \
> FROM users \
> WHERE AuthMail = "Y" and
>userID='${local_part:$1}'}}}{1}{0}}"
1. Does MySQL Encrypt() do the same as crypteq{} ? If you were to store
the passwords in plaintext (and implement good security on that table)
you could also use AUTH CRAM-MD5, as well as trivialising the others.
2. Presumably you mean AuthMail = 'Y'
