[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