Am Montag, 22. Oktober 2007 schrieb Andreas Winkelmann: > On Montag, 22. Oktober 2007, Florian Lindner wrote: > > Hello, > > I try to use cyrus-sasl with postfix on a Debian etch (stable) system. I > > want SASL to authenticate against a MySQL database (without saslauthd). I > > have installed the libsasl2-2 [1] and the SQL modules. > > The output from saslpluginviewer is below. There is no SQL plugin listed. > > My /etc/postfix/sasl/smtpd.conf looks like that: > > > > osiris:~# cat /etc/postfix/sasl/smtpd.conf > > log_level: 3 > > In the case of Postfix log_level is senseless. > > > pwcheck_method: auxprop > > auxprop_plugin: sql > > > > allowanonymouslogin: no > > allowplaintext: yes > > These both are no cyrus-sasl Options. Ok, I'll remove them but they shouldn't have done any harm. > > sql_engine: mysql > > sql_hostnames: localhost > > sql_user: system > > sql_passwd: pwd > > sql_database: system > > sql_select: SELECT password FROM mailboxes WHERE login = '%u@%r' > > > > What is wrong here? > > > > Thanks, > > > > Florian > > > > [1] http://packages.debian.org/etch/libsasl2-2 > > [2] http://packages.debian.org/etch/libsasl2-modules-sql > > [...] > > Ok, show the contents of "/usr/lib/sasl2/". osiris:~# ls /usr/lib/sasl2/ libanonymous.a libanonymous.so.2 libcrammd5.la libcrammd5.so.2.0.22 libdigestmd5.so liblogin.a liblogin.so.2 libntlm.la libntlm.so.2.0.22 libplain.so libsasldb.a libsasldb.so.2 libsql.la libsql.so.2.0.22 libanonymous.la libanonymous.so.2.0.22 libcrammd5.so libdigestmd5.a libdigestmd5.so.2 liblogin.la liblogin.so.2.0.22 libntlm.so libplain.a libplain.so.2 libsasldb.la libsasldb.so.2.0.22 libsql.so libanonymous.so libcrammd5.a libcrammd5.so.2 libdigestmd5.la libdigestmd5.so.2.0.22 liblogin.so libntlm.a libntlm.so.2 libplain.la libplain.so.2.0.22 libsasldb.so libsql.a libsql.so.2 [...] > What does your mail-log say? Turn on verbose-logging in Postfix (smtpd > -vvv) in master.cf then everything sasl-related should be logged. The line in master.cf: smtp unix - - n - - smtp -vvv and also relay unix - - n - - smtp -vvv but that doesn't really reveals much information: postfix/smtpd[29842]: connect from host185.natpool.mwn.de[138.246.7.185] postfix/smtpd[29842]: warning: host185.natpool.mwn.de[138.246.7.185]: SASL LOGIN authentication failed: authentication failure postfix/smtpd[29842]: lost connection after AUTH from host185.natpool.mwn.de[138.246.7.185] postfix/smtpd[29842]: disconnect from host185.natpool.mwn.de[138.246.7.185] Thanks a lot, Florian
