[Postfixbuch-users] Kann via SMTP keine Mails Verschicken

[Oliver Stephan]

Halloo nochmal,




> 
> Das sieht gut aus (wenn der Postfix smtpd-Dämon chrooted läuft)
> 
> 
>>Habe Postfix mal wieder ins chroot genommen, das hatte mal funktiert..
> 
> 
> gut.

Postfix läuft wieder im chroot, soweit scheints zu laufen

>>
>>Was kann ich bei nem Vermurksten Pam machen?
> 
> 
> Debuggen? Was kommt denn beim MySQL-Server an? Was sagt dessen log?
> 
> p at rick
> 
Via Smtp und Tls hab ich eine Email verschickt, bei der Passwortabfrage
habe ich das ENCRYPT Psswort aus der Mysql Tabelle genommen.
Dannach war die Mail durch (s.u.) aber gleich dannach kam wieder die
Passwortabfrage.. Jetzt muss nurnoch das Passwort korrekt im Klartext am
hiesigen Thunderbird eingebbar sein und erst am Server in ENCRYPT' eder
Form abgeglichen werden. (Weil es so in der DB steht)

Anbei die Mail.log und die Mysql.log

Habe nun die mail.log (auszugsweise)

Jan  3 17:21:40 m34s26 postfix/smtpd[24204]: connect from
localhost[127.0.0.1]
Jan  3 17:21:40 m34s26 postfix/smtpd[24204]: CA05513A70:
client=localhost[127.0.0.1]
Jan  3 17:21:40 m34s26 postfix/cleanup[24186]: CA05513A70:
message-id=<43BAA49F.5080609 at asmodeuz.dyndns.org>
Jan  3 17:21:40 m34s26 postfix/smtpd[24204]: disconnect from
localhost[127.0.0.1]
Jan  3 17:21:40 m34s26 amavis[19540]: (19540-02) Passed,
<postmaster at asmodeuz.dyndns.org> -> <thorac at gmx.de>, Message-ID:
<43BAA49F.5080609 at asmodeuz.dyndns.org>, Hits: -
Jan  3 17:21:40 m34s26 postfix/smtp[24193]: E2C6413A6F:
to=<thorac at gmx.de>, relay=127.0.0.1[127.0.0.1], delay=3, status=sent
(250 2.6.0 Ok, id=19540-02, from MTA: 250 Ok: queued as CA05513A70)
Jan  3 17:21:41 m34s26 postfix/qmgr[26658]: CA05513A70:
from=<postmaster at asmodeuz.dyndns.org>, size=1030, nrcpt=1 (queue active)
Jan  3 17:21:41 m34s26 postfix/qmgr[26658]: E2C6413A6F: removed
Jan  3 17:21:41 m34s26 imapd-ssl: LOGIN: DEBUG:
ip=[::ffff:213.7.132.80], command=AUTHENTICATE
Jan  3 17:21:41 m34s26 imapd-ssl: authdaemon: starting client module
Jan  3 17:21:41 m34s26 postfix/smtp[24209]: CA05513A70:
to=<thorac at gmx.de>, relay=mx0.gmx.de[213.165.64.100], delay=1,
status=sent (250 2.6.0 {mx066} Message accepted)
Jan  3 17:21:41 m34s26 postfix/qmgr[26658]: CA05513A70: removed




Mysql log (auszugsweise) beim SMTP Vorgang:

060103 17:20:07     575 Connect     provider_admin at localhost on provider
060103 17:20:08     575 Init DB     provider
                    575 Query       SELECT password FROM users WHERE
email='postmaster at asmodeuz.dyndns.org'
                    575 Quit
060103 17:20:09     576 Connect     provider_admin at localhost on provider
                    576 Query       select destination from forwardings
where source = 'asmodeuz.dyndns.org'
060103 17:20:10     577 Connect     provider_admin at localhost on provider
                    577 Query       select email from users where email
= 'asmodeuz.dyndns.org'
                    578 Connect     provider_admin at localhost on provider
                    578 Query       select 'virtual' from domains where
domain = 'asmodeuz.dyndns.org'
                    576 Query       select destination from forwardings
where source = 'gmx.de'
                    577 Query       select email from users where email
= 'gmx.de'
                    578 Query       select 'virtual' from domains where
domain = 'gmx.de'
060103 17:20:11     579 Connect     provider_admin at localhost on provider
                    579 Query       select destination from forwardings
where source = 'thorac at gmx.de'
                    580 Connect     provider_admin at localhost on provider
                    580 Query       select email from users where email
= 'thorac at gmx.de'
                    579 Query       select destination from forwardings
where source = '@gmx.de'
                    580 Query       select email from users where email
= '@gmx.de'
060103 17:20:13     447 Query       SELECT "Y" as local FROM domains
WHERE CONCAT("@",domain) IN ('thorac at gmx.de','@gmx.de','@.')
060103 17:20:16     576 Query       select destination from forwardings
where source = 'asmodeuz.dyndns.org'
                    577 Query       select email from users where email
= 'asmodeuz.dyndns.org'
                    578 Query       select 'virtual' from domains where
domain = 'asmodeuz.dyndns.org'
                    576 Query       select destination from forwardings
where source = 'gmx.de'
                    577 Query       select email from users where email
= 'gmx.de'
                    578 Query       select 'virtual' from domains where
domain = 'gmx.de'
                    581 Connect     provider_admin at localhost on provider
                    581 Query       select destination from forwardings
where source = 'thorac at gmx.de'
                    582 Connect     provider_admin at localhost on provider
                    582 Query       select email from users where email
= 'thorac at gmx.de'
                    581 Query       select destination from forwardings
where source = '@gmx.de'
                    582 Query       select email from users where email
= '@gmx.de'
                    576 Query       select destination from forwardings
where source = 'gmx.de'
                    577 Query       select email from users where email
= 'gmx.de'
                    578 Query       select 'virtual' from domains where
domain = 'gmx.de'



Wie mach ich am Einfachsten den Debug bei Mysql?

Danke
Oliver