Postfix / smtpd : sql_select option missing auxpropfunc error no mechanism available error and solution

by on June 11, 2007 · 5 comments· LAST UPDATED November 20, 2007

in , ,

Q. I’m running Redhat Enterprise Linux 4.5 server along with Postfix and Cyrus mail server. However I’m getting following error in my log files:

Jun 10 18:00:04 server postfix/smtpd[7280]: sql_select option missing
Jun 10 18:00:04 server postfix/smtpd[7280]: auxpropfunc error no mechanism available

How do I fix this error? I’m not using mysql for postfix.

A. The cyrus software comes with various plugin. The cyrus-sasl-sql package contains the Cyrus SASL plugin which supports using a RDBMS for storing shared secrets.

If you are not using MySQL, just remove the plugin using rpm command:

# rpm -ev cyrus-sasl-sql

Note if you are using Debian or Ubuntu remove libsasl2-modules-sql package:
# apt-get remove libsasl2-modules-sql

Also on RHEL 3 / 4, make sure that file /etc/openldap/slapd.conf is owned by the user ldap:
# chown ldap.ldap /etc/openldap/slapd.conf

Other option is to configure the sql module. Now there should not be any sort of error in /var/log/messages or /var/log/maillog file.

Tweet itFacebook itG+ itDownload PDF versionFound an error/typo on this page?

{ 5 comments… read them below or add one }

1 satish May 9, 2008 at 9:58 am

this solved my problem. Thanx


2 York December 2, 2008 at 3:58 pm

seems this put out those ugly lines from my server logs. thank you.


3 Giancarlo December 8, 2008 at 5:53 am



4 Andre August 15, 2009 at 5:01 pm

I am getting somehow a similar problem. The difference is that I am using mysql with
cyrus-sasl-2.1.19-14 and cyrus-sasl-sql-2.1.19-14 with rhel 4

postfix/smtpd[5425]: sql_select option missing
postfix/smtpd[5425]: auxpropfunc error no mechanism available


5 Thomas Webb May 5, 2013 at 3:45 pm

and what if i’m using mysql plugin?


Leave a Comment

Tagged as: , , , , , , , ,

Previous Faq:

Next Faq: