From owner-freebsd-questions@FreeBSD.ORG Fri Jun 18 20:20:58 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 23CD116A4CE for ; Fri, 18 Jun 2004 20:20:58 +0000 (GMT) Received: from outfbmx009.isp.belgacom.be (outfbmx009.isp.belgacom.be [195.238.2.198]) by mx1.FreeBSD.org (Postfix) with ESMTP id 87D6343D58 for ; Fri, 18 Jun 2004 20:20:57 +0000 (GMT) (envelope-from geert@lori.mine.nu) Received: from outmx019.isp.belgacom.be (outmx019.isp.belgacom.be [195.238.2.200]) (8.12.11/8.12.11/Skynet-OUT-FALLBACK-2.22) with ESMTP id i5I7ptRQ004631 for ; Fri, 18 Jun 2004 09:51:55 +0200 (envelope-from ) Received: from outmx019.isp.belgacom.be (localhost [127.0.0.1]) with ESMTP id i5I7pd35025871 for ; Fri, 18 Jun 2004 09:51:39 +0200 (envelope-from ) Received: from lori.mine.nu (23-16.244.81.adsl.skynet.be [81.244.16.23]) with ESMTP id i5I7paW7025840; Fri, 18 Jun 2004 09:51:36 +0200 (envelope-from ) Received: by lori.mine.nu (Postfix, from userid 1000) id 1CA5F625; Fri, 18 Jun 2004 09:51:35 +0200 (CEST) Date: Fri, 18 Jun 2004 09:51:34 +0200 From: Geert Hendrickx To: Lonnie Santella Message-ID: <20040618075134.GB13723@lori.mine.nu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2i X-GPG-Key: http://www.win.ua.ac.be/~s005085/gnupgkey.txt X-GPG-Key-ID: 1024D/766C1E92 X-Accept-Language: nl,en 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: Fri, 18 Jun 2004 20:20:58 -0000 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 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"