Re: [Exim] exim and Mysql

On Fri, 14 Mar 2003, tlabs wrote:

> #server_condition = "${if and {{!eq{$1}{}}{!eq{$2}{}}{crypteq{$2}{${lookup mysql {MYSQL_AUTH_PLAIN}
> {$value}fail}}}}{1}{0}}"

unneccessarily overcomplicated. if you carefully craft the lookup, you
don't need to check for the emptyness of the credentials supplied by
the client. also you can make mysql return the "1" or "0" (depending
on whether the authentication succeeded or not), you don't need to
scramble this into exim.

select if(count(*), '1', '0') from ...


--
[-]
... and the rest is silence.