From owner-freebsd-questions@FreeBSD.ORG Thu Jun 17 23:44:56 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 30C5216A4CE for ; Thu, 17 Jun 2004 23:44:56 +0000 (GMT) Received: from adsl-68-76-19-75.dsl.klmzmi.ameritech.net (adsl-68-76-19-75.dsl.klmzmi.ameritech.net [68.76.19.75]) by mx1.FreeBSD.org (Postfix) with ESMTP id B655A43D39 for ; Thu, 17 Jun 2004 23:44:51 +0000 (GMT) (envelope-from luke@foolishgames.com) Received: from [192.168.2.49] (adsl-65-42-187-207.dsl.klmzmi.ameritech.net [65.42.187.207]) (authenticated bits=0)ESMTP id i5HNiAAv005541; Thu, 17 Jun 2004 19:44:15 -0400 (EDT) (envelope-from luke@foolishgames.com) In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v618) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <342EAC58-C0B8-11D8-AA13-000A95EFF4CA@foolishgames.com> Content-Transfer-Encoding: 7bit From: Lucas Holt Date: Thu, 17 Jun 2004 19:43:58 -0400 To: "Lonnie Santella" X-Mailer: Apple Mail (2.618) X-Virus-Scanned: clamd / ClamAV version 0.72, clamav-milter version 0.72 on adsl-68-76-19-75.dsl.klmzmi.ameritech.net X-Virus-Status: Clean cc: freebsd-questions@freebsd.org Subject: Re: Logging the message body from an MTA X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 Jun 2004 23:44:56 -0000 Maybe you can use procmail. I had a procmail script that backed up messages in another mbox file while you were testing new rules. You could do something similar to backup all incoming messages and then write a program that could read the file or use a pop3 interface to read the messages and then store them in mysql or whatever. On Jun 17, 2004, at 7:22 PM, 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 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 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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > > Lucas Holt Luke@FoolishGames.com ________________________________________________________ FoolishGames.com (Jewel Fan Site) JustJournal.com (Free blogging)