No SQL module found
Jorge Bastos
mysql.jorge at decimal.pt
Thu Oct 25 17:34:21 EDT 2007
Ops sorry,
---
lira:~# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Thu Oct 25 22:33:25 WEST 2007
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.4.6
System: Debian GNU/Linux lenny/sid \n \l
-- smtpd is linked to --
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7cd5000)
-- active SMTP AUTH and TLS parameters for smtpd --
broken_sasl_auth_clients = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = lira
smtpd_tls_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem
smtpd_tls_key_file = /etc/ssl/private/ssl-cert-snakeoil.key
smtpd_tls_session_cache_database = btree:${queue_directory}/smtpd_scache
smtpd_use_tls = yes
-- listing of /usr/lib/sasl2 --
total 786
drwxr-xr-x 2 root root 1424 2007-10-24 13:47 .
drwxr-xr-x 52 root root 17728 2007-10-25 10:09 ..
-rw-r--r-- 1 root root 13312 2007-10-20 21:11 libanonymous.a
-rw-r--r-- 1 root root 855 2007-10-20 21:11 libanonymous.la
-rw-r--r-- 1 root root 12824 2007-10-20 21:11 libanonymous.so
-rw-r--r-- 1 root root 12824 2007-10-20 21:11 libanonymous.so.2
-rw-r--r-- 1 root root 12824 2007-10-20 21:11 libanonymous.so.2.0.22
-rw-r--r-- 1 root root 15482 2007-10-20 21:11 libcrammd5.a
-rw-r--r-- 1 root root 841 2007-10-20 21:11 libcrammd5.la
-rw-r--r-- 1 root root 15000 2007-10-20 21:11 libcrammd5.so
-rw-r--r-- 1 root root 15000 2007-10-20 21:11 libcrammd5.so.2
-rw-r--r-- 1 root root 15000 2007-10-20 21:11 libcrammd5.so.2.0.22
-rw-r--r-- 1 root root 45092 2007-10-20 21:11 libdigestmd5.a
-rw-r--r-- 1 root root 864 2007-10-20 21:11 libdigestmd5.la
-rw-r--r-- 1 root root 41932 2007-10-20 21:11 libdigestmd5.so
-rw-r--r-- 1 root root 41932 2007-10-20 21:11 libdigestmd5.so.2
-rw-r--r-- 1 root root 41932 2007-10-20 21:11 libdigestmd5.so.2.0.22
-rw-r--r-- 1 root root 13462 2007-10-20 21:11 liblogin.a
-rw-r--r-- 1 root root 835 2007-10-20 21:11 liblogin.la
-rw-r--r-- 1 root root 13300 2007-10-20 21:11 liblogin.so
-rw-r--r-- 1 root root 13300 2007-10-20 21:11 liblogin.so.2
-rw-r--r-- 1 root root 13300 2007-10-20 21:11 liblogin.so.2.0.22
-rw-r--r-- 1 root root 28820 2007-10-20 21:11 libntlm.a
-rw-r--r-- 1 root root 829 2007-10-20 21:11 libntlm.la
-rw-r--r-- 1 root root 28276 2007-10-20 21:11 libntlm.so
-rw-r--r-- 1 root root 28276 2007-10-20 21:11 libntlm.so.2
-rw-r--r-- 1 root root 28276 2007-10-20 21:11 libntlm.so.2.0.22
-rw-r--r-- 1 root root 13686 2007-10-20 21:11 libplain.a
-rw-r--r-- 1 root root 835 2007-10-20 21:11 libplain.la
-rw-r--r-- 1 root root 13460 2007-10-20 21:11 libplain.so
-rw-r--r-- 1 root root 13460 2007-10-20 21:11 libplain.so.2
-rw-r--r-- 1 root root 13460 2007-10-20 21:11 libplain.so.2.0.22
-rw-r--r-- 1 root root 21594 2007-10-20 21:11 libsasldb.a
-rw-r--r-- 1 root root 856 2007-10-20 21:11 libsasldb.la
-rw-r--r-- 1 root root 18028 2007-10-20 21:11 libsasldb.so
-rw-r--r-- 1 root root 18028 2007-10-20 21:11 libsasldb.so.2
-rw-r--r-- 1 root root 18028 2007-10-20 21:11 libsasldb.so.2.0.22
-rw-r--r-- 1 root root 23456 2007-10-20 21:11 libsql.a
-rw-r--r-- 1 root root 964 2007-10-20 21:11 libsql.la
-rw-r--r-- 1 root root 22996 2007-10-20 21:11 libsql.so
-rw-r--r-- 1 root root 22996 2007-10-20 21:11 libsql.so.2
-rw-r--r-- 1 root root 22996 2007-10-20 21:11 libsql.so.2.0.22
-rw-r--r-- 1 root root 330 2007-08-25 13:55 smtpd.conf
-- listing of /etc/postfix/sasl --
total 13
drwxr-xr-x 2 root root 160 2007-10-23 23:07 .
drwxr-xr-x 3 root root 688 2007-10-24 13:54 ..
-rw-r--r-- 1 root root 117 2005-11-20 20:02 como_criar_certificado_ssl
-rw-r--r-- 1 root root 381 2007-10-23 23:07 smtpd.conf
-rw-r--r-- 1 root root 349 2007-08-25 19:43 smtpd.conf_ori
-- content of /usr/lib/sasl2/smtpd.conf --
log_level: 7
pwcheck_method: auxprop
#pwcheck_method: pam
auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
sql_engine: mysql
sql_hostnames: 127.0.0.1
sql_user: --- replaced ---
sql_passwd: --- replaced ---
sql_database: postfix
sql_select: select password from smtp_auth_users where username='%u' and status='true'
# @%r
-- content of /etc/postfix/sasl/smtpd.conf --
#saslauthd_path: /var/run/saslauthd/mux
#log_level: 7
pwcheck_method: auxprop
auxprop_plugin: sasldb
#auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
#sql_engine: mysql
#sql_hostnames: 127.0.0.1
sql_user: --- replaced ---
sql_passwd: --- replaced ---
#sql_database: postfix
#sql_select: select password from smtp_auth_users where username='%u' and status='true'
# @%r
-- content of /etc/postfix/sasl/smtpd.conf --
#saslauthd_path: /var/run/saslauthd/mux
#log_level: 7
pwcheck_method: auxprop
auxprop_plugin: sasldb
#auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
#sql_engine: mysql
#sql_hostnames: 127.0.0.1
sql_user: --- replaced ---
sql_passwd: --- replaced ---
#sql_database: postfix
#sql_select: select password from smtp_auth_users where username='%u' and status='true'
# @%r
-- active services in /etc/postfix/master.cf --
# service type private unpriv chroot wakeup maxproc command + args
# (yes) (yes) (yes) (never) (100)
scan unix - - n - 16 smtp -o smtp_send_xforward_command=yes
127.0.0.1:10025 inet n - n - 16 smtpd
-o content_filter=
-o receive_override_options=no_unknown_recipient_checks,no_header_body_checks
-o smtpd_helo_restrictions=
-o smtpd_client_restrictions=
-o smtpd_sender_restrictions=
-o smtpd_recipient_restrictions=permit_mynetworks,reject
-o mynetworks_style=host
-o smtpd_authorized_xforward_hosts=127.0.0.0/8
dbmail-lmtp unix - - n - - lmtp -o disable_dns_lookups=yes
smtp inet n - n - - smtpd -o content_filter=spamfilter:
spamfilter unix - n n - - pipe flags=Rq user=spamfilter argv=/usr/bin/postfixfilter -f ${sender} -- ${recipient}
pickup fifo n - - 60 1 pickup
cleanup unix n - - - 0 cleanup
qmgr fifo n - - 300 1 qmgr
tlsmgr unix - - - 1000? 1 tlsmgr
rewrite unix - - - - - trivial-rewrite
bounce unix - - - - 0 bounce
defer unix - - - - 0 bounce
trace unix - - - - 0 bounce
verify unix - - - - 1 verify
flush unix n - - 1000? 0 flush
proxymap unix - - n - - proxymap
smtp unix - - - - - smtp
relay unix - - - - - smtp
-o fallback_relay=
showq unix n - - - - showq
error unix - - - - - error
discard unix - - - - - discard
local unix - n n - - local
virtual unix - n n - - virtual
lmtp unix - - - - - lmtp
anvil unix - - - - 1 anvil
scache unix - - - - 1 scache
maildrop unix - n n - - pipe
flags=DRhu user=vmail argv=/usr/local/bin/maildrop -d ${recipient}
uucp unix - n n - - pipe
flags=Fqhu user=uucp argv=uux -r -n -z -a$sender - $nexthop!rmail ($recipient)
ifmail unix - n n - - pipe
flags=F user=ftn argv=/usr/lib/ifmail/ifmail -r $nexthop ($recipient)
bsmtp unix - n n - - pipe
flags=Fq. user=bsmtp argv=/usr/lib/bsmtp/bsmtp -t$nexthop -f$sender $recipient
scalemail-backend unix - n n - 2 pipe
flags=R user=scalemail argv=/usr/lib/scalemail/bin/scalemail-store ${nexthop} ${user} ${extension}
mailman unix - - n - - pipe
flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
${nexthop} ${user}
-- mechanisms on localhost --
250-AUTH CRAM-MD5 DIGEST-MD5 LOGIN PLAIN
250-AUTH=CRAM-MD5 DIGEST-MD5 LOGIN PLAIN
-- end of saslfinger output --
---
-----Original Message-----
From: cyrus-sasl-bounces at lists.andrew.cmu.edu [mailto:cyrus-sasl-bounces at lists.andrew.cmu.edu] On Behalf Of Patrick Ben Koetter
Sent: quinta-feira, 25 de Outubro de 2007 22:21
To: cyrus-sasl at lists.andrew.cmu.edu
Subject: Re: No SQL module found
* Jorge Bastos <mysql.jorge at decimal.pt>:
> Check below, what it says in the end that he cannot auth that's not
> completely true, because I can via sasldb.
>
> ---
> lira:~# saslfinger -c
You picked the wrong option. You need to run it like this:
# saslfinger -s
p at rick
--
The Book of Postfix
<http://www.postfix-book.com>
saslfinger (debugging SMTP AUTH):
<http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>
More information about the Cyrus-sasl
mailing list