Solved, though the solution was not exactly what you suggested. I tried that and had no luck; but a little more googling got me checking /var/log/auth.log, where I found the following:<br><br>May 21 00:05:56 g4 postfix/smtpd[3295]: sql_select option missing
<br>May 21 00:05:56 g4 postfix/smtpd[3295]: auxpropfunc error no mechanism available<br>May 21 00:05:56 g4 postfix/smtpd[3295]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql<br><br>A little more googling turned up a solution. The correct parameter is:
<br><br>
smtpd_sasl_path = smtpd
<br><br>Found the answer here: <a href="http://archives.neohapsis.com/archives/postfix/2007-04/1445.html">http://archives.neohapsis.com/archives/postfix/2007-04/1445.html</a><br><br><div><span class="gmail_quote">On 5/19/07,
<b class="gmail_sendername">Josh Paetzel</b> <<a href="mailto:josh@tcbug.org">josh@tcbug.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Thomas Johnson wrote:<br>> I am in the process of migrating my mail server from Ubuntu Dapper to Debian<br>> Etch (Ubuntu dropped PPC support and I just got a G4 to play with, so<br>> switching architectures too). For the most part everything has been as
<br>> painless as copying the appropriate configuration files and installing the<br>> requisite packages. One thing I'm having trouble with is getting postfix to<br>> authenticate users using sasl reading from a mysql backend when they send
<br>> mail (using squirrelmail to send).<br>><br>> When I try to send from squirrelmail I get the following error:<br>> Authentication failed<br>> Server replied: 535 5.7.0 Error: authentication failed: authentication
<br>> failure<br>><br>> Checking the log files says the same thing:<br>> May 17 17:33:48 g4 postfix/smtpd[3286]: warning: SASL authentication<br>> problem: unable to open Berkeley db /etc/sasldb2: No such file or directory
<br>> May 17 17:33:48 g4 postfix/smtpd[3286]: warning: SASL authentication<br>> problem: unable to open Berkeley db /etc/sasldb2: No such file or directory<br>><br>> I've been digging around the Internet looking for an answer all afternoon
<br>> and comparing the configuration between the two systems. The configuration<br>> for the pieces of the mail system is almost identical (by virtue of having<br>> copied the files directly w/ minimal modification). The configuration works
<br>> flawlessly on the old system; Squirrelmail authenticates with postfix, which<br>> uses sasl to query mysql. Judging from the error messages that show up in<br>> the mail logs, it makes me think that sasl is trying to authenticate against
<br>> its own (non-existent) user database rather than sql. The sasl bits of the<br>> /etc/postfix/main.cf are as follows:<br>><br>> # sasl stuff (per the howto)<br>> smtpd_sasl_auth_enable = yes<br>> broken_sasl_auth_clients = yes
<br>> # below line was previous working config, changed to see if there is any<br>> effect.<br>> #smtpd_sasl_path = /etc/postfix/sasl:/usr/lib/sasl2<br>> smtpd_sasl_path = /etc/postfix/sasl<br>> smtpd_sasl_security_options = noanonymous
<br>> smtpd_sasl_local_domain =<br>><br>> /etc/postfix/sasl/smtpd.conf is the file that should be referenced by the<br>> smtpd_sasl_path in <a href="http://main.cf">main.cf</a>. It's contents are as follows:
<br>><br>> pwcheck_method: auxprop<br>> auxprop_plugin: sql<br>> mech_list: plain login cram-md5 digest-md5<br>> sql_engine: mysql<br>> sql_hostnames: <a href="http://127.0.0.1">127.0.0.1</a><br>> sql_user: xyzuser
<br>> sql_passwd: xyzpass<br>> sql_database: maildb<br>> sql_select: select clear from users where id='%u@%r' and enabled = 1<br>><br>> FWIW, Squirrelmail is attempting to authenticate with DIGEST-MD5. I believe
<br>> I have the required packages installed on the new system, the relevant<br>> version numbers are:<br>><br>> new: libsasl2-2 2.1.22<br>> old: libsasl2 2.1.19<br>><br>> new: libsasl2-modules-sql 2.1.22
<br>> old: libsasl2-modules-sql 2.1.19<br>><br>> new: postfix 2.3.8<br>> old: postfix 2.2.10<br>><br>> If anyone has any thoughts on this, i would really love to hear them as I'd<br>> really like to be able to send mail again.
<br>><br>> Cheers,<br>><br>> Tom Johnson<br>><br>><br><br>The name of the parameter is a bit misleading, but if you set it to<br>/etc/postfix/sasl/smtpd.conf it will be much happier.<br><br>--<br>Thanks,
<br><br>Josh Paetzel<br></blockquote></div><br>