No SQL module found

[Florian Lindner]

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