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
holmgren@???
