Re: [Exim] SMTP Authentication via MySQL

Top Page
Delete this message
Reply to this message
Author: Jens Kutilek
Date:  
To: exim-users
Subject: Re: [Exim] SMTP Authentication via MySQL
Thanks to everyone who replied. With your help, I figured it out.
In case anybody's interested, my authenticator via mysql now looks
like
this:

fixed_login:
  driver = plaintext
  public_name = LOGIN
  server_prompts = "Username:: : Password::"
  server_condition = "${if crypteq{$2} \
     {${lookup mysql{SELECT password_hash \
                     FROM popbox \
                     WHERE local_part='${local_part:$1}' \
                     AND domain_name='${domain:$1}'}}} \
     {yes}{no}}"
  server_set_id = $1


This works with the vmail-sql setup
(http://www.ex-parrot.com/~chris/vmail-sql/).

bye,
Jens.


--
Jens Kutilek
Web-Design
----------------------------------------------------
ISITRAIN Schulung und Systemlösungen GmbH
Telefon: (05303) 941014, Telefax: (05303) 941016
E-Mail: jk@???, Internet: www.isitrain.de