[Mimedefang] Re: sql integration of quarentine and others
Danny Kj=?ISO-8859-1?B?5g==?=rgaard
danny at resennet.dk
Tue Apr 17 02:42:28 EDT 2007
Hi,
As this is not in production and we are testing I made the field a longblob,
now that should be large enough. I have discovered that it's something with
the encoding, or I think it is. Most of the mail that doesnt get into the DB
have some ISO encodings. I first put the entire mail into Email::Simple and
then used the as_string, and that help alot, but i still get some mails that
dont get into the DB. Ill try Mime:Tools instead
Cheers
-Danny
On 4/17/07 12:07 AM, in article 4623BB50.1508.724EA2 at mimedefang.nabs.net,
"Jeff Rife" <mimedefang at nabs.net> wrote:
> On 16 Apr 2007 at 10:11, Danny Kjærgaard wrote:
>
>> I got my sql integration working, but i have an odd error. I first do an md5
>> hash of the body, and insert that into mysql, afterwards i insert the body
>> and the header into mysql. The hash works every time. But the entiremail
>> insertion, breaks every now and then, 1 out of 10 i think. I use a prepared
>> statement with the placeholders, but since the md5hash works and the
>> sqlinsertion dont, i might think that i have to escape something in the
>> header or body. Does any one know what this might be?
>
> What's the error message? I got bit by not allocating a big enough
> field in the database to hold some of the things I was grabbing out of
> the e-mail. That seems a lot more likely if you are trying to store
> the entire body.
>
>
> --
> Jeff Rife | Sam: Hey, how's life treating you there, Norm?
> |
> | Norm: Beats me...then it kicks me and leaves me
> | for dead.
>
>
More information about the MIMEDefang
mailing list