[Postfixbuch-users] smtpd-auth auf ein neues

Patrick Ben Koetter p at state-of-mind.de
Mo Jul 13 16:35:35 CEST 2009


* Carsten Laun-De Lellis <postfixbuch-users at listen.jpberlin.de>:
> Hallo alle zusammen
> 
>  
> 
> Ich hatte vor ca. 2 Wochen schon mal gepostet, da ich Probleme mit
> smptd-auth habe und habe keinen blassen Schimmer, wo ich in meiner Konfig
> hinfassen muss, damit dies richtig funzt. Habe den Rechner nun nochmal neu
> aufgesetzt, aber immer noch die gleichen Probleme.
> 
>  
> 
> Die Daten zu der Installation könnte Ihr dem Auszug aus saslfinger
> entnehmen. Zusätzlich habe ich noch einen Auszug aus dem mysql, dem mail und
> dem messages log angehängt. Das Problem ist, dass beim sql server gar keine
> Anfrage anzukommen scheint. Dies gilt jedoch nur für die Authentifizierung.
> Für andere Abfragen, wie maildirectory, forwardings, usw sehe ich die SQL
> Statements im Log. Habe wirklich keine Idee, wo ich da momentan hinpacken
> muss.

apparmor angeschaltet?

p at rick



> 
>  
> 
>  
> 
> saslfinger - postfix Cyrus sasl configuration Mon Jul 13 14:29:02 CEST 2009
> 
> version: 1.0.2
> 
> mode: server-side SMTP AUTH
> 
>  
> 
> -- basics --
> 
> Postfix: 2.5.5
> 
> System: Welcome to openSUSE 11.1 - Kernel \r (\l).
> 
>  
> 
> -- smtpd is linked to --
> 
>         libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7e7c000)
> 
>  
> 
> -- 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 /etc/sasl2 --
> 
> total 20
> 
> drwxr-xr-x  2 root root  4096 Jul 13 14:23 .
> 
> drwxr-xr-x 99 root root 12288 Jul 13 14:19 ..
> 
> -rw-------  1 root root   283 Jul 13 14:23 smtpd.conf
> 
>  
> 
> -- content of /etc/sasl2/smtpd.conf --
> 
> pwcheck_method: auxprop
> 
> mech_list: plain login
> 
> log_level: 7
> 
> #auxprop parameters
> 
> auxprop_plugin: sql
> 
> sql_engine: mysql
> 
> sql_hostname: localhost
> 
> sql_database: mail
> 
> sql_user: --- replaced ---
> 
> sql_passwd: --- replaced ---
> 
> sql_select: SELECT password FROM virtual_users where username = '%u'
> 
> 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 PLAIN LOGIN
> 
> 250-AUTH=PLAIN LOGIN
> 
>  
> 
> -- end of saslfinger output --
> 
>  
> 
>  
> 
>  
> 
> /var/log/mail
> 
> Jul 13 16:05:38 S000010 postfix/smtpd[4708]: warning: dict_nis_init: NIS
> domain name not set - NIS lookups disabled
> 
> Jul 13 16:05:38 S000010 postfix/smtpd[4708]: connect from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:39 S000010 postfix/smtpd[4708]: warning: unknown[10.242.2.6]:
> SASL LOGIN authentication failed: authentication failure
> 
> Jul 13 16:05:39 S000010 postfix/smtpd[4708]: lost connection after AUTH from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:39 S000010 postfix/smtpd[4708]: disconnect from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:40 S000010 postfix/smtpd[4708]: connect from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:41 S000010 postfix/smtpd[4708]: warning: unknown[10.242.2.6]:
> SASL LOGIN authentication failed: authentication failure
> 
> Jul 13 16:05:41 S000010 postfix/smtpd[4708]: lost connection after AUTH from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:41 S000010 postfix/smtpd[4708]: disconnect from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:47 S000010 imapd: Connection, ip=[::ffff:10.242.2.6]
> 
> Jul 13 16:05:47 S000010 postfix/smtpd[4708]: connect from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:48 S000010 postfix/smtpd[4708]: warning: unknown[10.242.2.6]:
> SASL LOGIN authentication failed: authentication failure
> 
> Jul 13 16:05:48 S000010 postfix/smtpd[4708]: lost connection after AUTH from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:48 S000010 postfix/smtpd[4708]: disconnect from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: connect from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: warning: unknown[10.242.2.6]:
> SASL LOGIN authentication failed: authentication failure
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: lost connection after AUTH from
> unknown[10.242.2.6]
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: disconnect from
> unknown[10.242.2.6]
> 
>  
> 
>  
> 
> /var/log/mysqld.log
> 
> 090713 15:09:20      20 Quit
> 
> 090713 15:12:55      21 Quit
> 
> 090713 15:26:22      22 Connect     root at localhost on mail
> 
>                      22 Query       select domain from
> virtual_mailbox_domains where domain = 'delellis.net'
> 
>                      23 Connect     root at localhost on mail
> 
>                      23 Query       select virtual_mailbox from
> virtual_users where username = 'carsten.delellis at delellis.net' and
> active='1'
> 
>                      24 Connect     root at localhost on mail
> 
>                      24 Query       select virtual_uid from virtual_users
> where username = 'carsten.delellis at delellis.net' and active = '1'
> 
>                      25 Connect     root at localhost on mail
> 
>                      25 Query       select virtual_gid from virtual_users
> where username = 'carsten.delellis at delellis.net' and active = '1'
> 
> 090713 15:27:22      23 Quit
> 
>                      24 Quit
> 
>                      25 Quit
> 
> 090713 16:05:38      26 Connect     root at localhost on
> 
>                      26 Init DB     mail
> 
>                      26 Query       SELECT username, "", password,
> virtual_uid, virtual_gid, virtual_mailbox_base, virtual_mailbox, "",
> username, "" FROM virtual_users WHERE username =
> 'carsten.delellis at delellis.net'
> 
> 090713 16:05:47      27 Connect     root at localhost on
> 
>                      27 Init DB     mail
> 
>                      27 Query       SELECT username, "", password,
> virtual_uid, virtual_gid, virtual_mailbox_base, virtual_mailbox, "",
> username, "" FROM virtual_users WHERE username =
> 'carsten.delellis at delellis.net'
> 
> 090713 16:10:38      26 Quit
> 
> 090713 16:10:47      27 Quit
> 
>  
> 
> /var/log/messages
> 
> Jul 13 16:05:48 S000010 postfix/smtpd[4708]: sql plugin couldn't connect to
> any host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin Parse the username
> carsten.delellis at delellis.net
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin try and connect to a
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin trying to open db
> 'mail' on host ''
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin could not connect to
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin couldn't connect to
> any host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin Parse the username
> carsten.delellis at delellis.net
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin try and connect to a
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin trying to open db
> 'mail' on host ''
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin could not connect to
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin couldn't connect to
> any host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin Parse the username
> carsten.delellis at delellis.net
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin try and connect to a
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin trying to open db
> 'mail' on host ''
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin could not connect to
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin couldn't connect to
> any host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin Parse the username
> carsten.delellis at delellis.net
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin try and connect to a
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin trying to open db
> 'mail' on host ''
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin could not connect to
> host
> 
> Jul 13 16:05:49 S000010 postfix/smtpd[4708]: sql plugin couldn't connect to
> any host
> 
>  
> 
> Carsten Laun-De Lellis 
> Dipl.-Ing. Elektrotechnik 
> Certified Information Systems Auditor (CISA) 
> 
> Hauptstrasse 13 
> D-67705 Trippstadt 
> 
> Phone: +49 (6306) 992140 
> Mobile: +49 (1520) 9889178 
> email:   carsten.delellis at delellis.net
> 
>  
> 

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