Date: Wed, 7 Apr 2004 12:32:21 -0700 From: "Brent Wiese" <brently@bjwcs.com> To: <freebsd-questions@freebsd.org> Subject: RE: Postfix - Sasl - mysql Message-ID: <20040407193232.BHDM6191.fed1rmmtao09.cox.net@SAMBA> In-Reply-To: <4073A341.2040006@elvandar.org>
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.. No go. Still getting "no user in db" in /var/log/maillog. I get: postfix/smtpd[23761]: sql_select option missing postfix/smtpd[23761]: auxpropfunc error no mechanism available In /var/log/messages I turned on logging in mysql and it didn't log any queries. Any other suggestions?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040407193232.BHDM6191.fed1rmmtao09.cox.net>