[Mimedefang] Re: sql integration of quarentine and others

[Danny Kj=?ISO-8859-1?B?5g==?=rgaard]

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.
> 
>