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.
Subscribe to our free e-mail newsletter or RSS feed to get all updates.
You can Email this page to a friend.
Related Linux / UNIX FAQ:
- Postfix setup catch-all email accounts using /etc/postfix/virtual
- Postfix limit incoming or receiving email rate
- Postfix block PDF or ZIP files attachments
- Postfix blacklist or reject an email address
- Linux: Find out which network card or NIC server is bind or running on
Discussion on This FAQ
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Please do not use the comment form to ask for help / question. Ask your question on the excellent Linux tech support forum. Thank you very much for stopping by our site!
Tags: apt-get_command, cyrus_sasl, enterprise_linux, log_files, mail_server, postfix, redhat, rpm_command, sql_package ~ Last updated on: November 20, 2007
May 9th, 2008 (6 days ago) at 9:58 am
this solved my problem. Thanx