Tuesday 09 May 2006 14:02 skrev alwayssend:
> begin authenticators
>
> #<SMTPAUTH>
> # AUTH LOGIN authentication method with MySQL support used by Outlook
> Express. auth_login:
> driver = plaintext
> public_name = LOGIN
> server_condition = ${if eq{$1}{${lookup mysql{SELECT Account FROM
> UserSession WHERE Account='$1' and Password='$2'}{$value}fail}}{1}{0}}
> server_prompts = "Username:: : Password::"
> server_set_id = $1
>
> auth_plain:
>   driver = plaintext
>    public_name = PLAIN
>    server_condition = ${if eq{$2}{${lookup mysql{SELECT password FROM user
> WHERE username='$1'}{$value}fail}}{1}{0}} #server_prompts = :
>    server_set_id = $1
> #</SMTPAUTH>

For PLAIN, username is $2 and password $3. Change accordingly. Also, the way 
the SQL queries differs can be a little confusing. Moreover, and more 
importantly, you should not accept empty passwords (even if you make sure 
that empty passwords never make it into the database). 

-- 
Magnus Holmgren
[EMAIL PROTECTED]

Attachment: pgpd314pCRiU8.pgp
Description: PGP 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/

Reply via email to