Re: [Exim] SMTP Authentication with mysql database..

Top Page
Delete this message
Reply to this message
Author: Tobias
Date:  
To: pradeep sethi
CC: exim-users
Subject: Re: [Exim] SMTP Authentication with mysql database..
Hi,

I had kinda same problem. Try this:

----------------------------------------------------------------------------------------------------------------

login:
  driver = plaintext
  public_name = LOGIN
  server_prompts = "Username:: : Password::"
  server_condition = "${if and { \
                        {!eq{$1}{}} \
                        {!eq{$2}{}} \
                        {crypteq{$2}{\{md5\\}${lookup mysql{SELECT
<column> FROM \
                                                             <Table>
WHERE <column>='$1'}{$value}fail}}} \
                         } {yes}{no}}"
  server_set_id = $1


-----------------------------------------------------------------------------------------------------------------

The clue is the \{md5\\} Part

You can find more on this at

http://www.exim.org/exim-html-4.00/doc/html/spec_11.html#IX582

Regards

-tobias

pradeep sethi wrote:

>login:
>  driver = plaintext
>  public_name = LOGIN
>  server_prompts = "Username:: : Password::"
>  server_condition = "${if and { \
>                        {!eq{$1}{}} \
>                        {!eq{$2}{}} \
>                        {crypteq{$2}{${lookup mysql{SELECT password FROM mailbox WHERE mailbox_name='$1'}{$value}fail}}} \
>                        } {yes}{no}}"
>  server_set_id = $1

>
># End of Exim configuration file
>
>--
>
>--
>
>## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
>