[Postfixbuch-users] smtpd-auth auf ein neues

Carsten Laun-De Lellis carsten.delellis at delellis.net
Mo Jul 13 16:20:51 CEST 2009


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.

 

 

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

 

-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <https://listi.jpberlin.de/pipermail/postfixbuch-users/attachments/20090713/975c937c/attachment.html>


Mehr Informationen über die Mailingliste Postfixbuch-users