No SQL module found

[Jorge Bastos]

I have the same problem and related it to the list and nobody answered me.
I have to move to sasldb to keep things working, and not using MySQL.

Jorge



-----Original Message-----
From: cyrus-sasl-bounces at lists.andrew.cmu.edu [mailto:cyrus-sasl-bounces at lists.andrew.cmu.edu] On Behalf Of Florian Lindner
Sent: segunda-feira, 22 de Outubro de 2007 13:26
To: cyrus-sasl at lists.andrew.cmu.edu
Subject: No SQL module found

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

pwcheck_method: auxprop
auxprop_plugin: sql

allowanonymouslogin: no
allowplaintext: yes

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

osiris:~# saslpluginviewer
Installed SASL (server side) mechanisms are:
PLAIN NTLM LOGIN DIGEST-MD5 CRAM-MD5 ANONYMOUS EXTERNAL
List of server plugins follows
Plugin "plain" [loaded],        API version: 4
        SASL mechanism: PLAIN, best SSF: 0, supports setpass: no
        security flags: NO_ANONYMOUS
        features: WANT_CLIENT_FIRST|PROXY_AUTHENTICATION
Plugin "ntlm" [loaded],         API version: 4
        SASL mechanism: NTLM, best SSF: 0, supports setpass: no
        security flags: NO_ANONYMOUS|NO_PLAINTEXT
        features: WANT_CLIENT_FIRST
Plugin "login" [loaded],        API version: 4
        SASL mechanism: LOGIN, best SSF: 0, supports setpass: no
        security flags: NO_ANONYMOUS
        features:
Plugin "digestmd5" [loaded],    API version: 4
        SASL mechanism: DIGEST-MD5, best SSF: 128, supports setpass: no
        security flags: NO_ANONYMOUS|NO_PLAINTEXT|MUTUAL_AUTH
        features: PROXY_AUTHENTICATION
Plugin "crammd5" [loaded],      API version: 4
        SASL mechanism: CRAM-MD5, best SSF: 0, supports setpass: no
        security flags: NO_ANONYMOUS|NO_PLAINTEXT
        features: SERVER_FIRST
Plugin "anonymous" [loaded],    API version: 4
        SASL mechanism: ANONYMOUS, best SSF: 0, supports setpass: no
        security flags: NO_PLAINTEXT
        features: WANT_CLIENT_FIRST
Installed auxprop mechanisms are:
sasldb
List of auxprop plugins follows
Plugin "sasldb" ,       API version: 4
        supports store: yes

Installed SASL (client side) mechanisms are:
PLAIN NTLM LOGIN DIGEST-MD5 CRAM-MD5 ANONYMOUS EXTERNAL
List of client plugins follows
Plugin "plain" [loaded],        API version: 4
        SASL mechanism: PLAIN, best SSF: 0
        security flags: NO_ANONYMOUS
        features: WANT_CLIENT_FIRST|PROXY_AUTHENTICATION
Plugin "ntlm" [loaded],         API version: 4
        SASL mechanism: NTLM, best SSF: 0
        security flags: NO_ANONYMOUS|NO_PLAINTEXT
        features: WANT_CLIENT_FIRST
Plugin "login" [loaded],        API version: 4
        SASL mechanism: LOGIN, best SSF: 0
        security flags: NO_ANONYMOUS
        features: SERVER_FIRST
Plugin "digestmd5" [loaded],    API version: 4
        SASL mechanism: DIGEST-MD5, best SSF: 128
        security flags: NO_ANONYMOUS|NO_PLAINTEXT|MUTUAL_AUTH
        features: PROXY_AUTHENTICATION|NEED_SERVER_FQDN
Plugin "crammd5" [loaded],      API version: 4
        SASL mechanism: CRAM-MD5, best SSF: 0
        security flags: NO_ANONYMOUS|NO_PLAINTEXT
        features: SERVER_FIRST
Plugin "anonymous" [loaded],    API version: 4
        SASL mechanism: ANONYMOUS, best SSF: 0
        security flags: NO_PLAINTEXT
        features: WANT_CLIENT_FIRST
Plugin "EXTERNAL" [loaded],     API version: 4
        SASL mechanism: EXTERNAL, best SSF: 0
        security flags: NO_ANONYMOUS|NO_PLAINTEXT|NO_DICTIONARY
        features: WANT_CLIENT_FIRST|PROXY_AUTHENTICATION