[Postfixbuch-users] Sasl ... wie immer

Jan Scholten Jammer at gmx.de
Mi Apr 25 12:41:31 CEST 2007


Wie peinlich.. Problem selber gelöst.
 sql_hostnames: localhost
durch
 sql_hostnames: 127.0.0.1
ersetzt und es geht.

*schäm*

 


> Guten Tag Postfixbuch-users,

> Ich hänge ein bischen zwischen den Seilen.

> 1. es geht wenn postfix nicht im chroot läuft
> 2. sasl geht nicht wenn postfix im chroot läuft, aber ich weiß nicht warum.
> 3. userdaten stehen im mysql (nach workaround.org)
> 4. Es handelt sich um ein Debian Etch
> 5. Ich dachte wenn ich mysql über tcp anspreche muß ich keine Sockets in das chroot legen.
> 6. courier-pop/imap über courier-authdaemon geht

> Meine Config:
> saslfinger -s

> saslfinger - postfix Cyrus sasl configuration Wed Apr 25 12:21:01 CEST 2007
> version: 1.0.1
> mode: server-side SMTP AUTH

> -- basics --
> Postfix: 2.3.8
> System: Debian GNU/Linux 4.0 \n \l

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

> -- active SMTP AUTH and TLS parameters for smtpd --
> broken_sasl_auth_clients = yes
> smtpd_sasl_auth_enable = yes
> smtpd_sasl_security_options = noanonymous
> 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 924
> drwxr-xr-x  2 root root  4096 2007-04-24 15:08 .
> drwxr-xr-x 39 root root  8192 2007-04-24 15:08 ..
> -rw-r--r--  1 root root 18868 2006-12-13 22:52 libanonymous.a
> -rw-r--r--  1 root root   855 2006-12-13 22:52 libanonymous.la
> -rw-r--r--  1 root root 15792 2006-12-13 22:52 libanonymous.so
> -rw-r--r--  1 root root 15792 2006-12-13 22:52 libanonymous.so.2
> -rw-r--r--  1 root root 15792 2006-12-13 22:52 libanonymous.so.2.0.22
> -rw-r--r--  1 root root 21754 2006-12-13 22:52 libcrammd5.a
> -rw-r--r--  1 root root   841 2006-12-13 22:52 libcrammd5.la
> -rw-r--r--  1 root root 19184 2006-12-13 22:52 libcrammd5.so
> -rw-r--r--  1 root root 19184 2006-12-13 22:52 libcrammd5.so.2
> -rw-r--r--  1 root root 19184 2006-12-13 22:52 libcrammd5.so.2.0.22
> -rw-r--r--  1 root root 60216 2006-12-13 22:52 libdigestmd5.a
> -rw-r--r--  1 root root   864 2006-12-13 22:52 libdigestmd5.la
> -rw-r--r--  1 root root 48504 2006-12-13 22:52 libdigestmd5.so
> -rw-r--r--  1 root root 48504 2006-12-13 22:52 libdigestmd5.so.2
> -rw-r--r--  1 root root 48504 2006-12-13 22:52 libdigestmd5.so.2.0.22
> -rw-r--r--  1 root root 19094 2006-12-13 22:52 liblogin.a
> -rw-r--r--  1 root root   835 2006-12-13 22:52 liblogin.la
> -rw-r--r--  1 root root 16424 2006-12-13 22:52 liblogin.so
> -rw-r--r--  1 root root 16424 2006-12-13 22:52 liblogin.so.2
> -rw-r--r--  1 root root 16424 2006-12-13 22:52 liblogin.so.2.0.22
> -rw-r--r--  1 root root 38700 2006-12-13 22:52 libntlm.a
> -rw-r--r--  1 root root   829 2006-12-13 22:52 libntlm.la
> -rw-r--r--  1 root root 32520 2006-12-13 22:52 libntlm.so
> -rw-r--r--  1 root root 32520 2006-12-13 22:52 libntlm.so.2
> -rw-r--r--  1 root root 32520 2006-12-13 22:52 libntlm.so.2.0.22
> -rw-r--r--  1 root root 19134 2006-12-13 22:52 libplain.a
> -rw-r--r--  1 root root   835 2006-12-13 22:52 libplain.la
> -rw-r--r--  1 root root 16392 2006-12-13 22:52 libplain.so
> -rw-r--r--  1 root root 16392 2006-12-13 22:52 libplain.so.2
> -rw-r--r--  1 root root 16392 2006-12-13 22:52 libplain.so.2.0.22
> -rw-r--r--  1 root root 29100 2007-02-07 16:32 libsasldb.a
> -rw-r--r--  1 root root   856 2007-02-07 16:32 libsasldb.la
> -rw-r--r--  1 root root 21456 2007-02-07 16:32 libsasldb.so
> -rw-r--r--  1 root root 21456 2007-02-07 16:32 libsasldb.so.2
> -rw-r--r--  1 root root 21456 2007-02-07 16:32 libsasldb.so.2.0.22
> -rw-r--r--  1 root root 33056 2006-12-13 22:52 libsql.a
> -rw-r--r--  1 root root   964 2006-12-13 22:52 libsql.la
> -rw-r--r--  1 root root 27872 2006-12-13 22:52 libsql.so
> -rw-r--r--  1 root root 27872 2006-12-13 22:52 libsql.so.2
> -rw-r--r--  1 root root 27872 2006-12-13 22:52 libsql.so.2.0.22




> -- content of /etc/postfix/sasl/smtpd.conf --
> log_level: 7
> 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: mail
> sql_select: select password from users where email='%u@%r'


> -- active services in /etc/postfix/master.cf --
> # service type  private unpriv  chroot  wakeup  maxproc command + args
> #               (yes)   (yes)   (yes)   (never) (100)
> smtp      inet  n       -       -       -       -       smtpd
> pickup    fifo  n       -       -       60      1       pickup
> cleanup   unix  n       -       -       -       0       cleanup
> qmgr      fifo  n       -       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/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       n       -       -       pipe
>   flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
>   ${nexthop} ${user}

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


> -- end of saslfinger output --



> Warum gibt es probleme mit dem chroot, sollte das mittel 127.0.0.1 nicht automatisch (über das an
> localhost lauschende) mysql gehen?

> Logs sagen:
> Apr 25 12:23:27 localhost postfix/smtpd[1627]: sql auxprop plugin using mysql engine
> Apr 25 12:23:27 localhost postfix/smtpd[1627]: sql plugin Parse the username
> test at testserver.server.mine
> Apr 25 12:23:27 localhost postfix/smtpd[1627]: sql plugin try and connect to a host
> Apr 25 12:23:27 localhost postfix/smtpd[1627]: sql plugin trying to open db 'mail' on host 'localhost'
> Apr 25 12:23:27 localhost postfix/smtpd[1627]: sql plugin could not connect to host localhost
> Apr 25 12:23:27 localhost postfix/smtpd[1627]: sql plugin couldn't connect to any host


> mysql.log hat garnichts von auxprop.

> Wo/was fehlt mir im chroot.. und warum?

> Über Tipps bin ich dankbar.

> Jan


> -- 
> "Das Ganze ist mehr als die Summe seiner Teile." 
> (Aristoteles)

> Mit freundlichen Grüßen
> Jan Scholten
> mailto:Jammer at gmx.de




-- 
Law: In any sufficiently large group of people most are idiots

Mit freundlichen Grüßen
Jan Scholten
mailto:Jammer at gmx.de







Mehr Informationen über die Mailingliste Postfixbuch-users