Just Gags wrote:

> I am showing the following log entries every ten to twenty minutes.
> What are causing these? [quote="/var/log/messages"] Sep 27 09:10:12
> www postfix/smtpd[23525]: sql_select option missing Sep 27 09:10:12
> www postfix/smtpd[23525]: auxpropfunc error no mechanism available 
> Sep 27 09:10:12 www lmtpunix[23532]: sql_select option missing Sep 27
> 09:10:12 www lmtpunix[23532]: auxpropfunc error no mechanism 
> available [/quote]

A very late reply but I ran into this problem just a few days ago. I
solved it by adding the following to my /etc/postfix/sasl/smtpd.conf:

pwcheck_method: saslauthd
mech_list: PLAIN LOGIN
saslauthd_version: 2
sql_engine: mysql
sql_verbose: no
sql_user: mail
sql_passwd: PASSWORDHERE
password_format: crypt
sql_hostnames: localhost
sql_database: mail
sql_select: SELECT password FROM accountuser WHERE username = '[EMAIL 
PROTECTED]'
log_level: 3

In /etc/imapd.conf I have:
sasl_mech_list: PLAIN LOGIN
sasl_pwcheck_method: saslauthd
sasl_sql_engine: mysql
sasl_sql_verbose: no
sasl_log_level: 3
sasl_sql_user: mail
sasl_sql_passwd: PASSWORDHERE
sasl_password_format: crypt
sasl_sql_hostnames: localhost
sasl_sql_database: mail
sasl_sql_select: SELECT password FROM accountuser WHERE username = '[EMAIL 
PROTECTED]'
sasl_auto_transition: yes



Now the only sasl messages in /var/log/auth.log look like
Nov  9 08:31:13 darkside cyrus/lmtpunix[6409]: sql auxprop plugin using
mysql engine
Nov  9 08:31:59 darkside postfix/smtpd[6427]: sql auxprop plugin using
mysql engine


While I don't know if my configs are correct, the annoying 'errors' are
gone.

Hopefully this helps someone else out.

-- 

Ed
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch

_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm

Reply via email to