[Vmail-discuss] vmail smtp auth

Donovan Craig donovan at snapfrozen.com
Tue, 22 Jul 2003 15:42:32 +1000


Hi,

I got SMTP auth working using MySQL in vmail-sql.

Due to the way the passwords are encrypted, I found that I couldn't
use the existing password field so I added one to the domain table
which seems to work ok.

---
alter table domain add smtp_auth varchar(20) default null;
---

I know it's not the most secure way of doing it but it works for what
I need.

-------%<--------------

begin authenticators
 cram:
  driver = cram_md5
  public_name = CRAM-MD5
  server_secret = ${lookup mysql{select smtp_auth from domain \
                   where domain_name = '$1' and smtp_auth !=
''}{$value}fail}  server_set_id = $1

-------%<--------------

Regards,

Donovan