[Postfixbuch-users] Postfix 2.1.5 - SASL - Problem mit MySQL auf Debain sarge

Andreas Delleske delleske at gmail.com
Mo Mär 7 01:06:02 CET 2005


> Bitte lade Dir saslfinger runter. Laß es mit "saslfinger -s" laufen und sende
> den output an die Liste.

Großartig, vielen Dank!

Hier der Output:
-------
eins:~# tar xvfz saslfinger-0.9.9.1.tar.gz
saslfinger-0.9.9.1/
saslfinger-0.9.9.1/TODO
saslfinger-0.9.9.1/man/
saslfinger-0.9.9.1/man/saslfinger.1
saslfinger-0.9.9.1/HISTORY
saslfinger-0.9.9.1/install.sh
saslfinger-0.9.9.1/ChangeLog
saslfinger-0.9.9.1/INSTALL
saslfinger-0.9.9.1/script/
saslfinger-0.9.9.1/script/saslfinger
eins:~# cd saslfinger-0.9.9.1
eins:~/saslfinger-0.9.9.1# ls -l
total 28
-rw-r--r--  1 root root 1896 Jan 11 00:37 ChangeLog
-rw-r--r--  1 root root  617 Jan 11 00:37 HISTORY
-rw-r--r--  1 root root  129 Jan 11 00:37 INSTALL
-rw-r--r--  1 root root  168 Jan 11 00:37 TODO
-rwx------  1 root root 1113 Jan 11 00:37 install.sh
drwxr-xr-x  2 root root 4096 Jan 11 00:37 man
drwxr-xr-x  2 root root 4096 Jan 11 00:37 script
eins:~/saslfinger-0.9.9.1# ./install.sh
Installing saslfinger...
Installing man page...
eins:~/saslfinger-0.9.9.1# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Mon Mar  7 01:03:29 CET 2005
version: 0.9.9.1
mode: server-side SMTP AUTH

-- basics --
Postfix: 2.1.5
System: Debian GNU/Linux 3.1 \n \l

-- smtpd is linked to --
        libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x401a1000)

-- active SMTP AUTH and TLS parameters for smtpd --
broken_sasl_auth_clients = yes
smtpd_sasl_auth_enable = yes
smtpd_sasl_local_domain = $myhostname
smtpd_sasl_security_options = noanonymous


-- listing of /usr/lib/sasl --
total 268
drwxr-xr-x   2 root root  4096 Nov  8 22:17 .
drwxr-xr-x  45 root root 12288 Mar  6 15:45 ..
-rw-r--r--   1 root root  5912 Oct 16 23:37 libanonymous.so
-rw-r--r--   1 root root  5912 Oct 16 23:37 libanonymous.so.1
-rw-r--r--   1 root root  5912 Oct 16 23:37 libanonymous.so.1.0.17
-rw-r--r--   1 root root 10864 Oct 16 23:37 libcrammd5.so
-rw-r--r--   1 root root 10864 Oct 16 23:37 libcrammd5.so.1
-rw-r--r--   1 root root 10864 Oct 16 23:37 libcrammd5.so.1.0.19
-rw-r--r--   1 root root 30608 Oct 16 23:37 libdigestmd5.so
-rw-r--r--   1 root root 30608 Oct 16 23:37 libdigestmd5.so.0
-rw-r--r--   1 root root 30608 Oct 16 23:37 libdigestmd5.so.0.0.20
-rw-r--r--   1 root root 12900 Feb 17  2004 libgssapiv2.so
-rw-r--r--   1 root root 12900 Feb 17  2004 libgssapiv2.so.1
-rw-r--r--   1 root root 12900 Feb 17  2004 libgssapiv2.so.1.0.18
-rw-r--r--   1 root root  8132 Oct 16 23:37 liblogin.so
-rw-r--r--   1 root root  8132 Oct 16 23:37 liblogin.so.0
-rw-r--r--   1 root root  8132 Oct 16 23:37 liblogin.so.0.0.7
-rw-r--r--   1 root root  7848 Oct 16 23:37 libplain.so
-rw-r--r--   1 root root  7848 Oct 16 23:37 libplain.so.1
-rw-r--r--   1 root root  7848 Oct 16 23:37 libplain.so.1.0.16

-- listing of /usr/lib/sasl2 --
total 848
drwxr-xr-x   2 root root  4096 Mar  6 22:32 .
drwxr-xr-x  45 root root 12288 Mar  6 15:45 ..
-rw-r--r--   1 root root 13488 Oct 16 23:02 libanonymous.a
-rw-r--r--   1 root root   851 Oct 16 23:02 libanonymous.la
-rw-r--r--   1 root root 13824 Oct 16 23:02 libanonymous.so
-rw-r--r--   1 root root 13824 Oct 16 23:02 libanonymous.so.2
-rw-r--r--   1 root root 13824 Oct 16 23:02 libanonymous.so.2.0.19
-rw-r--r--   1 root root 16298 Oct 16 23:02 libcrammd5.a
-rw-r--r--   1 root root   837 Oct 16 23:02 libcrammd5.la
-rw-r--r--   1 root root 16180 Oct 16 23:02 libcrammd5.so
-rw-r--r--   1 root root 16180 Oct 16 23:02 libcrammd5.so.2
-rw-r--r--   1 root root 16180 Oct 16 23:02 libcrammd5.so.2.0.19
-rw-r--r--   1 root root 47516 Oct 16 23:02 libdigestmd5.a
-rw-r--r--   1 root root   860 Oct 16 23:02 libdigestmd5.la
-rw-r--r--   1 root root 43944 Oct 16 23:02 libdigestmd5.so
-rw-r--r--   1 root root 43944 Oct 16 23:02 libdigestmd5.so.2
-rw-r--r--   1 root root 43944 Oct 16 23:02 libdigestmd5.so.2.0.19
-rw-r--r--   1 root root 13726 Oct 16 23:02 liblogin.a
-rw-r--r--   1 root root   831 Oct 16 23:02 liblogin.la
-rw-r--r--   1 root root 14028 Oct 16 23:02 liblogin.so
-rw-r--r--   1 root root 14028 Oct 16 23:02 liblogin.so.2
-rw-r--r--   1 root root 14028 Oct 16 23:02 liblogin.so.2.0.19
-rw-r--r--   1 root root 31248 Oct 16 23:02 libntlm.a
-rw-r--r--   1 root root   825 Oct 16 23:02 libntlm.la
-rw-r--r--   1 root root 30660 Oct 16 23:02 libntlm.so
-rw-r--r--   1 root root 30660 Oct 16 23:02 libntlm.so.2
-rw-r--r--   1 root root 30660 Oct 16 23:02 libntlm.so.2.0.19
-rw-r--r--   1 root root 20142 Oct 16 23:02 libotp.a
-rw-r--r--   1 root root   825 Oct 16 23:02 libotp.la
-rw-r--r--   1 root root 43184 Oct 16 23:02 libotp.so
-rw-r--r--   1 root root 43184 Oct 16 23:02 libotp.so.2
-rw-r--r--   1 root root 43184 Oct 16 23:02 libotp.so.2.0.19
-rw-r--r--   1 root root 13886 Oct 16 23:02 libplain.a
-rw-r--r--   1 root root   831 Oct 16 23:02 libplain.la
-rw-r--r--   1 root root 14096 Oct 16 23:02 libplain.so
-rw-r--r--   1 root root 14096 Oct 16 23:02 libplain.so.2
-rw-r--r--   1 root root 14096 Oct 16 23:02 libplain.so.2.0.19
-rw-r--r--   1 root root 21798 Oct 16 23:02 libsasldb.a
-rw-r--r--   1 root root   852 Oct 16 23:02 libsasldb.la
-rw-r--r--   1 root root 18692 Oct 16 23:02 libsasldb.so
-rw-r--r--   1 root root 18692 Oct 16 23:02 libsasldb.so.2
-rw-r--r--   1 root root 18692 Oct 16 23:02 libsasldb.so.2.0.19

-- content of /etc/postfix/sasl/smtpd.conf --
pwcheck_method: auxprop
auxprop_plugin: sql
mech_list: plain login cram-md5 digest-md5
sql_engine: mysql
sql_hostnames: localhost
sql_user: --- replaced ---
sql_passwd: --- replaced ---
sql_database: postfix
sql_select: select clearpwd from users where email='%u'
log_level: 7


-- active services in /etc/postfix/master.cf --
# service type  private unpriv  chroot  wakeup  maxproc command + args
#               (yes)   (yes)   (yes)   (never) (50)
smtp      inet  n       -       n       -       10      smtpd
pickup    fifo  n       -       -       60      1       pickup
cleanup   unix  n       -       -       -       0       cleanup
qmgr      fifo  n       -       -       300     1       qmgr
rewrite   unix  -       -       -       -       -       trivial-rewrite
bounce    unix  -       -       -       -       0       bounce
defer     unix  -       -       -       -       0       bounce
flush     unix  n       -       -       1000?   0       flush
smtp      unix  -       -       n       -       10      smtp
showq     unix  n       -       -       -       -       showq
error     unix  -       -       -       -       -       error
local     unix  -       n       n       -       -       local
virtual   unix  -       n       n       -       -       virtual
lmtp      unix  -       -       n       -       -       lmtp
cyrus     unix  -       n       n       -       -       pipe
  flags=R user=cyrus argv=/usr/sbin/cyrdeliver -e -m ${extension} ${user}
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 -d -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}

proxymap          unix  -       -       n       -       -       proxymap
trace     unix  -       -       -       -       0       bounce
verify    unix  -       -       -       -       1       verify
relay     unix  -       -       n       -       -       smtp

-- mechanisms on localhost --
250-AUTH LOGIN PLAIN DIGEST-MD5 CRAM-MD5
250-AUTH=LOGIN PLAIN DIGEST-MD5 CRAM-MD5

-- end of saslfinger output --

eins:~/saslfinger-0.9.9.1#                            


-- 
Gruß
Andreas Delleske



Mehr Informationen über die Mailingliste Postfixbuch-users