[postfix-users] smtpd-auth

Patrick Ben Koetter p at state-of-mind.de
Fr Jun 19 16:02:27 CEST 2009


* Carsten Laun-De Lellis <postfix-users at de.postfix.org>:
> 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

Es muss sql_passwd und nicht sql_password in smtpd.conf heissen.

p at rick




>
> Habe keine Idee, wo ich drehen muss, damit dies funktioniert. Momentan  
> lasse ich nur relaying aus meinem LAN zu.
>
> Wäre super, wenn jemand unterstützen kann.
>
> Mit freundlichem Gruß
> Carsten Laun-De Lellis
>
>
>
>
>
> Anbei ein Auszug aus dem Ergebnis von saslfinger:
>
> saslfinger - postfix Cyrus sasl configuration Fr 19. Jun 12:38:03 CEST 2009
> version: 1.0.4
> mode: server-side SMTP AUTH
>
> -- basics --
> Postfix: 2.5.5
> System: Ubuntu 9.04 \n \l
>
> -- smtpd is linked to --
>        libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7d1f000)
>
> -- 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 63 root root 20480 2009-06-15 17:09 ..
> -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 11:57 .
> drwxr-xr-x 4 root root 4096 2009-06-18 17:50 ..
> -rw-r--r-- 1 root root  458 2009-06-19 11:57 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:localhost
> sql_database:mail
> sql_user: --- replaced ---
> sql_password: strenggeheim
> # sql_select: SELECT '%p' from virtual_users where username = '%u' and  
> userrealm = '%r' and auth = '1'
> sql_select: SELECT password from virtual_users where username = '%u' and  
> auth = '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:localhost
> sql_database:mail
> sql_user: --- replaced ---
> sql_password: strenggeheim
> # sql_select: SELECT '%p' from virtual_users where username = '%u' and  
> auth = '1'
> sql_select: SELECT password from virtual_users where username = '%u' and  
> auth = '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 --
>
> _______________________________________________
> postfix-users mailing list
> postfix-users at de.postfix.org
> http://de.postfix.org/cgi-bin/mailman/listinfo/postfix-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 postfix-users