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@xxxxxxxxxxxxxxxxxxxx [mailto:cyrus-sasl-bounces@xxxxxxxxxxxxxxxxxxxx] On Behalf Of Florian Lindner Sent: segunda-feira, 22 de Outubro de 2007 13:26 To: cyrus-sasl@xxxxxxxxxxxxxxxxxxxx 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
