Why email was deferred?

From MyWiki

Revision as of 22:38, 25 September 2014

Was trying to get my head around how to dig out the reason why we have so many emails in deferred queue

Getting the reason why each email was deferred. Format of the output <email> %% <reason why deferred>

# for d in `find /opt/pmx6/postfix/var/spool/mqueue/defer ! -type d -print`; do awk -F= '/recipient/{ rec = $2} /reason/{reason = $2 } END {print rec" %% "reason}' $d; done| sort | uniq
5856b200-6e15-427a-8760-d9f43542fd69@test.com %% connect to test.com[208.64.121.161]:25: Connection timed out
6c6f1bae-ee74-4f94-bc24-dbd39534d9e2@test.com %% connect to test.com[208.64.121.161]:25: Connection timed out

Digging out where the connection came from:

# for d in `find /opt/pmx6/postfix/var/spool/mqueue/defer ! -type d -print`; do grep `basename ${d}` /var/log/mail.log.1 | grep client | awk -F= '{print $2}'; done | sort | uniq -c
     36 localhost[127.0.0.1]

Which server sent the email to the upstream SMTP gateway (/tmp/def.txt has list of email addresses email to which were deferred on the upstream DMZ based SMTP gateway, one email address per line):

$ while read line; do for e in `grep $line /var/log/mail.log | awk '{print $6}' | sed -e 's/://'`; do grep $e /var/log/mail.log | grep client | awk -F= '{print $2}'; done ; done < /tmp/def.txt | sort | uniq -c
      1 www-02.production[192.168.114.11]
      5 svn-01.production[192.168.0.173]
      4 web-02.production[192.168.48.12]
      1 web-03.production[192.168.48.13]
     10 webx-01.production[192.168.107.20]
     10 webx-02.production[192.168.107.21]
      8 webx-03.production[192.168.107.22]