There is a pop3 user authentication program called vmail-sql, I've never
been able to get it to work on my system but it's supposedly excellent. It's
got sample config files for exim, however I'm not sure if it shows you how
to do what you're asking, but you could download it anyway and give it a go.
I can't actually remember the url, i think it's something like
http://www.ex-parrot.com/~chris/vmail-sql/ but if you just slp 'vmail-sql'
into google i'm sure it'll come up strait away.
Hope this is of some use,
Gareth
gjd@???
----- Original Message -----
> From: Matt Bernstein <mb@???>
> To: Dan Egli <dmegli@???>
> Cc: <exim-users@???>
> Sent: Tuesday, March 26, 2002 8:37 AM
> Subject: Re: [Exim] MySQL Authentication
>
>
> > On Mar 25 Dan Egli wrote:
> >
> > >a sample user would look like:
> > >-------------------------------------
> > >| bitwize | Y | 25M | jk76asd523 |
> > >--------------------------------------
> > >
> > >the passwd is encrypted using the Encrypt() function in MySql. But I am
> > >unable to get Exim to accept the password. When I try testing the SMTP
> AUTH
> > >exim always returns authentication failure. Here is what I am trying to
> use
> > >as my auth lookup line:
> > >
> > >server_condition = "${if crypteq{$2} \
> > > {${lookup mysql{SELECT passwd \
> > > FROM users \
> > > WHERE AuthMail = "Y" and
> > >userID='${local_part:$1}'}}}{1}{0}}"
> >
> > 1. Does MySQL Encrypt() do the same as crypteq{} ? If you were to store
> > the passwords in plaintext (and implement good security on that
table)
> > you could also use AUTH CRAM-MD5, as well as trivialising the others.
> >
> > 2. Presumably you mean AuthMail = 'Y'
> >
> >
> >
>
