On Thu, 2004-05-06 at 08:50, Peter Darley wrote:
> Folks,
>       I'm having a hard time find out how to set up smtp-auth with Postfix and
> DBMail.  Anyone got any pointers?
> Thanks,
> Peter Darley
> 
> _______________________________________________
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail

Here's what you need

You need libsasl2

If you're using debian you need:

libsasl2
libsasl2-modules
libsasl2-modules-sql

You then need to put the following in a smtpd.conf file in
/etc/postfix/sasl (debian) or wherever your sasl config files go for
your operating system (other common places are /usr/lib/sasl2 and
/usr/local/lib/sasl2)

mech_list: PLAIN LOGIN ANONYMOUS
pwcheck_method: auxprop
sql_engine: mysql (or pgsql if you're using postgres)
sql_user: someuser
sql_passwd: somepasswd
sql_hostnames: x.x.x.x
sql_database: your_database
sql_select: select passwd from users where userid = '%u'


Then setup postfix to use sasl as is document readily elsewhere.

You may need to modify the sql_select if you aren't using plaintext
passwords, there's documentation with libsasl2 that tells you all the
different options and syntax.  Much easier to setup than the pam stuff.

Anyhow, these instructions are for debian unstable...  Anything else
should be similar, but with subtle differences.

Also, there was a large change between versions 2.1.15 and 2.1.18 of
libsasl2 on debian.  Version 2.1.15 had a libsasl2-modules-mysql and all
the config prefixes were mysql_* instead of sql_*.  They changed it to a
generic engine for 2.1.18 and it broke my setup and reading the
instructions and noticing the changes were what was needed (debian just
uninstalled libsasl2-modules-mysql instead of replacing it with
libsasl2-modules-sql).

Good luck.

Ryan Butler
ADI Internet Solutions
[EMAIL PROTECTED]


Reply via email to