Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 07 Apr 2004 08:44:17 +0200
From:      Remko Lodder <remko@elvandar.org>
To:        Brent Wiese <brently@bjwcs.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Postfix - Sasl - mysql
Message-ID:  <4073A341.2040006@elvandar.org>
In-Reply-To: <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA>
References:  <20040407004028.LWYD4805.fed1rmmtao02.cox.net@SAMBA>

next in thread | previous in thread | raw e-mail | index | archive | help
Brent Wiese wrote:
> I (tried) following the instructions at:
> http://high5.net/howto/
> 
> I have postfix virtual users working in MySQL. I have courier imap/pop3
> working w/ virtual users. I wanted to add SMTP auth.
> 
> I added the cyrus-sasl2 port (also chose support for it in postfix port)
> "WITH_MYSQL".
> 
> No go.
> 
> I added the following lines to /usr/local/lib/sasl2/smtpd.conf (found this
> in another faq/tutorial, so it may be incorrect)
> 
> sasl_pwcheck_method: auxprop
> sasl_auxprop_plugin: sql 
   sql_engine: mysql
   mech_list: login plain crammd6 digestmd5
> sql_user: postfix-user
> sql_passwd: thepassword
> sql_database: postfix
> sql_statement: SELECT password FROM mailbox WHERE username = '%u'
> sql_verbose: yes
> 

That works for me..
-- 

Kind regards,

Remko Lodder
Elvandar.org/DSINet.org
www.mostly-harmless.nl A Dutch community for helping newcomers on the 
hackerscene



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4073A341.2040006>