≡ Menu

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

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 itGoogle+ itPDF itFound an error/typo on this page?

{ 5 comments… add one }

  • satish May 9, 2008, 9:58 am

    this solved my problem. Thanx

  • York December 2, 2008, 3:58 pm

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

  • Giancarlo December 8, 2008, 5:53 am

    Thanks.

  • Andre August 15, 2009, 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

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

    and what if i’m using mysql plugin?

Leave a Comment