[Postfixbuch-users] smtpd-auth
Patrick Ben Koetter
p at state-of-mind.de
Mi Jun 24 12:32:56 CEST 2009
* carsten.delellis at delellis.net <postfixbuch-users at listen.jpberlin.de>:
>
> Hallo alle zusammen
>
> Ich habe ein Problem mit der Authtentifizierung über mysql und weiß
> nicht so recht, wie ich es lösen kann.
>
> Meldung in der log-Datei:
>
> S000003 postfix/smtpd[10591]: warning: unknown[10.242.2.6]: SASL LOGIN
> authentication failed: authentication failure
Dein smtpd läuft chrooted und kann keine Verbindung zum Socket des MySQL
Server aufbauen.
alternativen:
1. smtpd Raus aus dem Chroot oder
2. MySQL über TCP ansprechen.
p at rick
>
>
> Auszug aus saslfinger
>
> -- basics --
> Postfix: 2.5.5
> System: Ubuntu 9.04 \n \l
>
> -- smtpd is linked to --
> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7e01000)
>
> -- active SMTP AUTH and TLS parameters for smtpd --
> broken_sasl_auth_clients = yes
> smtpd_sasl_auth_enable = yes
> smtpd_sasl_authenticated_header = yes
> smtpd_sasl_local_domain =
> smtpd_sasl_security_options = noanonymous
>
>
> -- listing of /usr/lib/sasl2 --
> insgesamt 944
> drwxr-xr-x 2 root root 4096 2009-06-15 09:55 .
> drwxr-xr-x 65 root root 20480 2009-06-22 14:46 ..
> -rw-r--r-- 1 root root 13868 2009-03-06 17:05 libanonymous.a
> -rw-r--r-- 1 root root 989 2009-03-06 17:05 libanonymous.la
> -rw-r--r-- 1 root root 13752 2009-03-06 17:05 libanonymous.so
> -rw-r--r-- 1 root root 13752 2009-03-06 17:05 libanonymous.so.2
> -rw-r--r-- 1 root root 13752 2009-03-06 17:05 libanonymous.so.2.0.22
> -rw-r--r-- 1 root root 16390 2009-03-06 17:05 libcrammd5.a
> -rw-r--r-- 1 root root 975 2009-03-06 17:05 libcrammd5.la
> -rw-r--r-- 1 root root 17848 2009-03-06 17:05 libcrammd5.so
> -rw-r--r-- 1 root root 17848 2009-03-06 17:05 libcrammd5.so.2
> -rw-r--r-- 1 root root 17848 2009-03-06 17:05 libcrammd5.so.2.0.22
> -rw-r--r-- 1 root root 47760 2009-03-06 17:05 libdigestmd5.a
> -rw-r--r-- 1 root root 998 2009-03-06 17:05 libdigestmd5.la
> -rw-r--r-- 1 root root 46828 2009-03-06 17:05 libdigestmd5.so
> -rw-r--r-- 1 root root 46828 2009-03-06 17:05 libdigestmd5.so.2
> -rw-r--r-- 1 root root 46828 2009-03-06 17:05 libdigestmd5.so.2.0.22
> -rw-r--r-- 1 root root 14160 2009-03-06 17:05 libldapdb.a
> -rw-r--r-- 1 root root 982 2009-03-06 17:05 libldapdb.la
> -rw-r--r-- 1 root root 17780 2009-03-06 17:05 libldapdb.so
> -rw-r--r-- 1 root root 17780 2009-03-06 17:05 libldapdb.so.2
> -rw-r--r-- 1 root root 17780 2009-03-06 17:05 libldapdb.so.2.0.22
> -rw-r--r-- 1 root root 13906 2009-03-06 17:05 liblogin.a
> -rw-r--r-- 1 root root 969 2009-03-06 17:05 liblogin.la
> -rw-r--r-- 1 root root 13748 2009-03-06 17:05 liblogin.so
> -rw-r--r-- 1 root root 13748 2009-03-06 17:05 liblogin.so.2
> -rw-r--r-- 1 root root 13748 2009-03-06 17:05 liblogin.so.2.0.22
> -rw-r--r-- 1 root root 30324 2009-03-06 17:05 libntlm.a
> -rw-r--r-- 1 root root 963 2009-03-06 17:05 libntlm.la
> -rw-r--r-- 1 root root 30196 2009-03-06 17:05 libntlm.so
> -rw-r--r-- 1 root root 30196 2009-03-06 17:05 libntlm.so.2
> -rw-r--r-- 1 root root 30196 2009-03-06 17:05 libntlm.so.2.0.22
> -rw-r--r-- 1 root root 14226 2009-03-06 17:05 libplain.a
> -rw-r--r-- 1 root root 969 2009-03-06 17:05 libplain.la
> -rw-r--r-- 1 root root 17844 2009-03-06 17:05 libplain.so
> -rw-r--r-- 1 root root 17844 2009-03-06 17:05 libplain.so.2
> -rw-r--r-- 1 root root 17844 2009-03-06 17:05 libplain.so.2.0.22
> -rw-r--r-- 1 root root 22402 2009-03-06 17:05 libsasldb.a
> -rw-r--r-- 1 root root 1000 2009-03-06 17:05 libsasldb.la
> -rw-r--r-- 1 root root 21804 2009-03-06 17:05 libsasldb.so
> -rw-r--r-- 1 root root 21804 2009-03-06 17:05 libsasldb.so.2
> -rw-r--r-- 1 root root 21804 2009-03-06 17:05 libsasldb.so.2.0.22
> -rw-r--r-- 1 root root 24164 2009-03-06 17:05 libsql.a
> -rw-r--r-- 1 root root 1098 2009-03-06 17:05 libsql.la
> -rw-r--r-- 1 root root 26064 2009-03-06 17:05 libsql.so
> -rw-r--r-- 1 root root 26064 2009-03-06 17:05 libsql.so.2
> -rw-r--r-- 1 root root 26064 2009-03-06 17:05 libsql.so.2.0.22
>
> -- listing of /etc/postfix/sasl --
> insgesamt 12
> drwxr-xr-x 2 root root 4096 2009-06-19 21:29 .
> drwxr-xr-x 4 root root 4096 2009-06-22 10:22 ..
> -rw-r--r-- 1 root root 460 2009-06-19 21:29 smtpd.conf
>
>
>
>
> -- content of /etc/postfix/sasl/smtpd.conf --
> #Global parameters
> log_level: 5
> pwcheck_method: auxprop
> mech_list: plain login
> # cram-md5 digest-md5
> #auxiliary plugin parameters
> auxprop_plugin:sql
> sql_engine:mysql
> sql_hostnames:127.0.0.1
> sql_database:mail
> sql_user: --- replaced ---
> sql_passwd: --- replaced ---
> # sql_select: SELECT '%p' from virtual_users where username = '%u' and
> userrealm
> = '%r' and auth = '1'
> sql_select: SELECT userPassword from virtual_users where username = '%u'
> and aut
> h = '1'
> sql_usessl: no
>
>
> -- content of /etc/postfix/sasl/smtpd.conf --
> #Global parameters
> log_level: 5
> pwcheck_method: auxprop
> mech_list: plain login
> # cram-md5 digest-md5
> #auxiliary plugin parameters
> auxprop_plugin:sql
> sql_engine:mysql
> sql_hostnames:127.0.0.1
> sql_database:mail
> sql_user: --- replaced ---
> sql_passwd: --- replaced ---
> # sql_select: SELECT '%p' from virtual_users where username = '%u' and
> userrealm
> = '%r' and auth = '1'
> sql_select: SELECT userPassword from virtual_users where username = '%u'
> and aut
> h = '1'
> sql_usessl: no
>
>
>
> -- 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
> proxywrite unix - - n - 1 proxymap
> smtp unix - - - - - smtp
> relay unix - - - - - smtp
> -o smtp_fallback_relay=
> showq unix n - - - - showq
> error unix - - - - - error
> retry 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}
>
> amavisd-new unix - - n - 2 smtp
> -o smtp_data_done_timeout=1200s
> -o disable_dns_lookups=yes
>
> 127.0.0.1:10025 inet n - n - - smtpd
> -o content_filter=
> -o local_recipient_maps=
> -o relay_recipient_maps=
> -o smtpd_restriction_classes=
> -o smtpd_client_restrictions=
> -o smtpd_helo_restrictions=
> -o smtpd_sender_restrictions=
> -o smtpd_recipient_restrictions=permit_mynetworks,reject
> -o mynetworks=127.0.0.0/8
>
> -- mechanisms on localhost --
> 250-AUTH LOGIN PLAIN
> 250-AUTH=LOGIN PLAIN
>
>
> -- end of saslfinger output --
>
> --
> _______________________________________________
> Postfixbuch-users -- http://www.postfixbuch.de
> Heinlein Professional Linux Support GmbH
>
> Postfixbuch-users at listen.jpberlin.de
> https://listi.jpberlin.de/mailman/listinfo/postfixbuch-users
--
state of mind
Digitale Kommunikation
http://www.state-of-mind.de
Franziskanerstraße 15 Telefon +49 89 3090 4664
81669 München Telefax +49 89 3090 4666
Amtsgericht München Partnerschaftsregister PR 563
Mehr Informationen über die Mailingliste Postfixbuch-users