"Wietse Venema":
Yaoxing:
True but there got to be some easy way to export that list, otherwise
I'll have to delete the dead mails from our database manually from time
to time. Any ideas how I can get everything work fluently? I mean, for
example, every several days I get all dead mail addresses from postfix
by maybe a windows console program, then delete them from our
subscription database. But where can I get the list firstly? dead mails
seems to have been deleted directly.
Postfix returns undeliverable mail to the envelope sender address.
Postfix logs the envelope sender address as:
Dec 24 08:36:59 spike postfix/qmgr[31619]: 9E33D1F3EA7:
from=<wie...@porcupine.org>, size=X, nrcpt=Y (queue active)
The idea is to to feed the returned mail through a program that
extracts the failed recipient address and unsubscribes the recipient.
Wietse
If searching for 'status=bounced' is a valid way to find the addresses, then
see the attached example.
#!/bin/bash
#
# cleanexample.sh
#
perl -ne 'print "DELETE FROM somedb.sometable WHERE somefield = \"$1\"\ LIMIT 1;\n" if
/to=<(....@.*)>.*status=bounced/' /var/log/mail.log >/root/cleanexample.sql
mysql -u someuser -psomepass -h 10.11.12.13 somedb < /root/cleanexample.sql
