On Fri, Dec 10, 2004 at 11:11:43PM -0000, Aaron Stone wrote:
> Drew Morris <[EMAIL PROTECTED]> said:
>
> > Are their any plans to add support for SMTP-AUTH to dbmail instead of
> > just POP before SMTP and IMAP before SMTP. SMTP-AUTH would seem like a
> > very logical thing to have on a system like this.
>
> You can't have SMTP AUTH without an SMTP server ;-) DBMail is only an
> MDA, Mail Delivery Agent, which receives mail from the MTA, such as
> Postfix or Sendmail, Exim, and others. Those are the SMTP servers which
> you would want to configure for SMTP AUTH.
>
> In order to share a user base with DBMail, you would need to configure
> your SMTP AUTH to use DBMail's database. While that information is beyond
> the scope of DBMail, if you do create a working config, please post it
> back to the mailing list so that we can include some helpful hints in the
> DBMail documentation.
Exim configuration for SMTP AUTH against dbmail database is pretty straight
forward.
begin authenticators
plain:
driver = plaintext
public_name = PLAIN
server_condition = ${lookup mysql{SELECT user_idnr FROM users WHERE userid =
'${quote_mysql:$2}' AND passwd = '${quote_mysql:$3}'}{1}fail}
server_set_id = $2
server_advertise_condition = ${if eq{$tls_cipher}{}{no}{yes}}
login:
driver = plaintext
public_name = LOGIN
server_prompts = "Username:: : Password::"
server_condition = ${lookup mysql{SELECT user_idnr FROM users WHERE userid =
'${quote_mysql:$1}' AND passwd = '${quote_mysql:$2}'}{1}fail}
server_set_id = $1
server_advertise_condition = ${if eq{$tls_cipher}{}{no}{yes}}
cram_md5:
driver = cram_md5
public_name = CRAM-MD5
server_secret = ${lookup mysql{SELECT passwd FROM users WHERE userid =
'${quote_mysql:$1}'}{$value}fail}
server_set_id = $1
spa:
driver = spa
public_name = NTLM
server_password = ${lookup mysql{SELECT passwd FROM users WHERE userid =
'${quote_mysql:$1}'}{$value}fail}
