[Mimedefang] Re: sql integration of quarentine and others

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

Hi,

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?

Cheers.
-Danny


On 4/3/07 2:41 PM, in article euti19$tv8$1 at sea.gmane.org, "Danny Kjærgaard"
<danny at resennet.dk> wrote:

> Hi
> 
> I'm trying to make an sql integration with mimedefang. I would like to store
> alle spam and virus mails i mysql, but what would be the best way to do this
> ? and where i the filter, begin, end or some other place?
> 
> I read someone talking about make a runner that emptyed the qurantine dires
> in the spool directory and that approache i like. This way i can make an
> check to see if the sql server is up and then empty the spool. But how do i
> make spamassassin deliver all spam to a qurantine dir?
> 
> I know i missed something, but any suggestion on how to make this work the
> best is appreciated.
> 
> Cheers.
> Danny 
> 
> 
>