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

[Patrick Ben Koetter]

* Andreas Delleske <delleske at gmail.com>:
> 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)

Cyrus-SASL.2.x.

> -- 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/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

Du willst MySQL nutzen, aber die dafür notwendigen libraries "libsql..." hast
Du nicht installiert. Es muß praktisch auf die Schnauze fallen...

> -- 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

Das %u Makro muß bei Dir aus einer Ziffernfolge bestehen und sonst nichts.
Sonst müßtest Du noch das Makro für den REALM anhängen, wenn Du z.B.
12345678@$myhostname hättest, ja?

> -- 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

Gut. smtpd ist nicht chrooted. Laß ihn so solange Du SMTP AUTH noch nicht am
Laufen hast. Später kannst Du dann ein chroot setup angehen.

-- 
SMTP AUTH
Howto: <http://postfix.state-of-mind.de/patrick.koetter/smtpauth/>
Debug: <http://postfix.state-of-mind.de/patrick.koetter/saslfinger/>