Author: Matt Bernstein Date: To: colin CC: exim-users Subject: Re: [Exim] Newbie question - Roaming Users, SMTP Auth and MySQL
Here is a naïve and completely untested solution which will require
tweaking.. (you've got 1œ days left :)
Early in your RCPT ACL say "accept authenticated = *"
Your authenticators should look a little like this:
cram_md5:
driver = cram_md5
public_name = CRAM-MD5
server_secret = ${lookup mysql{select password from bigtable where username='${quote_mysql{$1}}'}{$value}fail}
server_set_id = $1
(I may have my syntax wrong.)
On May 1 colin@??? wrote:
>To the question, I have a 100 or so roaming users, their usernames and
>plain text passwords are stored in a mysql table in the format
>"select uname,pass from usertable" I have no control over this table
>or the encoding of the password. The requirement is that these users
>be able to send emails from anywhere in the world, via various mail
>clients using SMTP AUTH verified against the username and password in
>the MySQL table. There is to be absolutely no local delivery on this
>server and any mail for the local domain should be delivered to a
>separate SMTP Server I run.
>
>I'm running Exim V4.04 and I've have built and configured it with
>MySQL lookups and all the SMTP AUTH modules.
>
>Can anyone point me in the right direction, or does anyone have any
>sample run-time config scripts to do the same sort of thing?
