[Maia-users] Extracting message for testing

[Robert Fitzpatrick]

On Mon, 2007-08-20 at 01:58 -0700, Robert LeBlanc wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Robert Fitzpatrick wrote:
> 
> > Had a question about how we
> > will be able to restest messages after applying updates. We do this
> > quite a bit now by archiving all messages for up to 15 days, but now all
> > the content is in maia, correct? How can I re-run a clean message
> > through SA from maia?
> 
> If by a "clean message" you mean a message whose headers have not been
> modified, then you'll need to get it from the maia_mail table directly.
>  As long as you haven't enabled the encryption features, the
> maia_mail.contents column should get you the unaltered mail contents,
> complete with all headers.  Encryption will garble this of course, so
> you'd need to decrypt the output using your Blowfish key if you're using
> encryption.
> 

Actually, it seems in our postgresql install, the messages are being
altered a bit....

psql -h esmtp.ky -U vscan -t -c "select contents from maia_mail where
contents like '%ESMTP id E797D1D1C6A%';" maia >> tmp1.msg

Then in my resulting file, I find the first few headers lines these
strange \x09 entries and all lines in the file have a space preceeding
them....

 Received: from ureach.com (unknown [74.94.11.194])
 \x09by mx1.webtent.net (WebTent ESMTP Postfix Internet Mail Gateway) with ESMTP id A2FEA1D1C54
 \x09for <sales at webtent.com>; Thu, 23 Aug 2007 18:12:25 -0400 (EDT)
 From: "EmailZipCode" emailzip at ureach.com
 To: sales at webtent.com
 Subject: Local Email & Postal Leads
 Date: 23 Aug 2007 18:11:41 -0400
 Message-ID: <20070823181141.4C383957F36F64F7 at ureach.com>
 MIME-Version: 1.0
 Content-Type: text/plain
 Content-Transfer-Encoding: 8bit

 <snip>

-- 
Robert