For the longest time, my damn auth.log file kept getting spammed with the following errors:
Dec 3 12:18:58 postfix postfix/smtpd[53444]: sql_select option missing Dec 3 12:18:58 postfix postfix/smtpd[53444]: auxpropfunc error no mechanism available Dec 3 12:24:32 postfix postfix/smtpd[53490]: sql_select option missing Dec 3 12:24:32 postfix postfix/smtpd[53490]: auxpropfunc error no mechanism available Dec 3 12:28:06 postfix postfix/smtpd[53506]: sql_select option missing Dec 3 12:28:06 postfix postfix/smtpd[53506]: auxpropfunc error no mechanism available Dec 3 12:30:17 postfix postfix/smtpd[53529]: sql_select option missing Dec 3 12:30:17 postfix postfix/smtpd[53529]: auxpropfunc error no mechanism available Dec 3 12:33:12 postfix postfix/smtpd[53544]: sql_select option missing Dec 3 12:33:12 postfix postfix/smtpd[53544]: auxpropfunc error no mechanism available
Needless to say, quite annoying. I am using authdaemond as my pwcheck_method in my smtpd.conf so it was rather odd to me that the sasl library was complaining about a missing sql_select option since it shouldn't have been loading the sql plugin at all. I searched the tubes quite a few times with no real results until I finally found the following fix.
The workaround for the above problem is actually quite simple, really. You simply remove all the libsql* files in /usr/local/lib/sasl2. That's it. Personally, I moved them all into a folder I created in that directory on the off chance that I may need them in the future. Obviously, this is going to wreak havoc if you are using libsasl for more than one app's authentication and the other one uses sql. But, if you are using it as I am, where I'm only using sasl for smtp auth through an alternate mechanism (authdaemond in my case), then this will end the spamming of your log file.