Solved

Track Postfix Bounced Email

Posted on 2004-09-21
3
1,206 Views
Last Modified: 2013-12-16
I have a Postfix mail server sending out a large qty of emails generated from a CRM database of my current customers.  I would like to be able to take all of the bounced emails, parse out the bad email addresses and flag the customers record in my CRM database. This will allow me to know when I talk to my customer to get a new email address.

Is it possible to configure Postfix to take these bounced email addresses and put them in a specific file which I can then import?
0
Comment
Question by:jmh1971
3 Comments
 
LVL 40

Accepted Solution

by:
jlevie earned 250 total points
ID: 12114758
If you configure the application that is sending the emails to specify a particular user as the sender bounces will go back to that user rather than root or the user that ran the application. Typically that would be done via something like:

sendmail -f sender-name@dom.tld recipient@other-dom.tld <message

By having a special account used just for this purpose all bounces will be in one mailbox.
0
 
LVL 9

Expert Comment

by:_GeG_
ID: 12114873
I tried once to make a script that checks an account periodically for bounces, so that my newsletter addresses would stay up to date.
But I couldn't come up with a way how to check for bounces that works for all bounces. The problem is that not all bounces are generated by your postfix (that would be easy). If you send a lot of emails, you will also receive a lot of virus bounces. My script could qualify around 60% of the bounces, but needed always updates, because the mailservers change the bounces all the time. If you find a good solution, please post it here.
0
 

Author Comment

by:jmh1971
ID: 12145429
I actually solved this by using procmail and some shell scripts to parse out the bad email address from all returned mail.

The email addresses are collected in a file, then I use a MS SQL DTS Script to go read the file and update the customer records to show a bad email address.  

It worked pretty well I sent out 12K emails to customers received 1800 bad addresses back into SQL and 30 customers sent back and opt out request.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Daily system administration tasks often require administrators to connect remote systems. But allowing these remote systems to accept passwords makes these systems vulnerable to the risk of brute-force password guessing attacks. Furthermore there ar…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question