From: Aaron P. Martinez (mlproficuous.com)
Date: Sat Apr 10 2004 - 19:25:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

------snip----
> > FreeBsd 4.8
> > All from lasts ports:
> > Cyrus-SASL
> > PORTVERSION= 2.1.18
>
> Hmm, if you use Cyrus-SASL 2.1.18 your smtpd.conf is wrong.
it was, but so is this on.. the following corrections will get you
going.
> It must be something like this:
>
> pwcheck_method: auxprop
correct
> mech_list: plain login cram-md5 digest-md5
correct if you want all these methods...i suspect you only need plain
here
> auxprop_plugin: sql
correct
> sql_engine: mysql
correct
> sql_hostnames: localhost
correct or you can have 127.0.0.1
> sql_user: sasluser
correct
> sql_passwd: secret
correct
> sql_database: sasldb
wrong... you'll want to have this read
sql_database: postfix
> sql_select: select `%p` from users where userName = '%u'
wrong.... you should have for your setup:
sql_statement: select password from mailbox where username='%u%r'

%p is a default value and cyrus_sasl uses UserPassword for it. the other
errors i believe you're getting because you put in the insert and update
statements. TAKE them out unless you absolutely need them.

You don't need the insert or the update statements to simply do password
authentication.
> sql_insert: insert into users (userName,userRealm,`%p`) values ('%u','%r','%v')
> sql_update: update users set `%p` = '%v' where userName = '%u'
>
> And make sure you made the Link /usr/lib/sasl2 => /usr/local/lib/sasl2

I still urge you to adjust your main.cf, you don't need that long file
when most of the thigs you have listed there are the defaults, it would
also make it must easier for us to read.

Aaron

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]