[Exim] SMTP auth via MySQL Databse

Top Page
Delete this message
Reply to this message
Author: Franz Georg Köhler
Date:  
To: exim-users
Subject: [Exim] SMTP auth via MySQL Databse
Hi,
I do have a slightly changed setup of vmail-sql by Chris Lightfoot
(http://www.ex-parrot.com/~chris/vmail-sql/), which works quite good.

Now I want to implent smtp auth, which i did by creating a plain text
passwort and the following configuration directive:

fixed_plain:
driver = plaintext
public_name = PLAIN
server_condition = "\
# $2 = Username | $3 = password
${if and {{!eq{$2}{}}{!eq{$3}{}} \
{eq{$3}{${extract{1}{:} \
{${lookup{$2}lsearch{/usr/local/exim/passwd}{$value}{*:*}}}}}}}{1}{0}}"
server_set_id = $2

login_plain:
driver = plaintext
public_name = LOGIN
server_prompts = "Username:: : Password::"
server_condition = "\
# $1 = Username | $2 = password
${if and {{!eq{$1}{}}{!eq{$2}{}} \
{eq{$2}{${extract{1}{:} \
{${lookup{$1}lsearch{/usr/local/exim/passwd}{$value}{*:*}}}}}}}{1}{0}}"
server_set_id = $1



Know I want to use the same data for smtp validation as for pop3
authorization.

I do have a database named 'exim' which has tables named 'domain',
'forwarders' and 'popbox',

'popbox' consists of 4 fields, first comes the domain_name, second
local_part , third password_hash, and finally mbox_name, which is the
name of the unix mailbox.

How can I set up Exim using this database for smtp authentification?


BTW:
I currectly do have log file entrys like this in my logs:

2001-06-21 13:57:13 15D35E-0007w2-00 <= PLazou@??? H=www.radiolink.net (nf1.netforward.com) [206.96.221.125] P=esmtp S=299342 id=7B2EBAD19005D4118D220090275172B201A38698@???
2001-06-21 13:57:14 15D35E-0007w2-00 => dpejko <dpejko@???> D=virtual_localuser T=virtual_localdelivery                                                   



It does log the username of the recipient (in this case: dpejko),
however, this user doesn't realyy exist on this system and some user do
seem to exist at lease double (e.a. webmaster...).
Is it possible to log the entire recipient instead of just the local
part (like it is done when forwarding a message...)?