Logging the message body from an MTA

[Geert Hendrickx]

On Thu, Jun 17, 2004 at 11:22:44PM +0000, Lonnie Santella wrote:
> I need to log the message body of incoming and outgoing messages on my 
> FreeBSD 5.2.1 Release server. I'm running Exim right now, but I really 
> don't have a preference of MTA. The main thing is I need to facilitate the 
> logging of message bodies.

I don't know about Exim, but since you don't care switching MTA, Postfix
has an "always_bcc" option.  Every mail processed by Postfix (both
incoming and outgoing) will be forwarded to that address.  You could
then make that address use procmail or some other pipe to store the
e-mail in your database.  

GH

> 
> I don't want to flood you with too many details, but we want to archive 
> messages (including message body) to a MySQL database, so that we can 
> quickly run queries and review messages from months/years ago - no matter 
> who's mailbox it ended up in.
> 
> To accomplish this, we need to <first> log the message body somehow... 
> anyhow... then commit the logs to the MySQL database.
> 
> I'd settle for learning how to do the first step. I've read through Exim 
> docs and Sendmail docs, as well as various newsgroups - plenty of info on 
> logging various data - but nothing on message bodies. I posted a message to 
> the Exim news group - but no luck there.
> 
> I'm not set on Exim - I just want to log message bodies. Any help or a push 
> in the right direction would be GREATLY appreciated.
> 
> Thanks,
> 
> Lonnie
> 
> 
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"