[Mimedefang] Off Topic - Mail Message and MySQL

[Phil Eschallier]

Benjamin;

If you are storing the mail message as it is delivered (as you wrote,
"raw"), it is MIME encoded.  MIME is the mechanism that facilitates
transporting binary data in mail messages and is a textual representation of
binary data (and yes, text is technically binary too, but I don't have
better terms at the moment to describe this).

I've been thinking about logging such messages to an RDBMS as well, though
it's not been a high priority yet.  After some preliminary hacking and
knowing what kind of load MD + SA put on high volume servers, I'm thinking
that the better route is to use the quarantine functions with the filter
akin to the samples in the distribution, and have a separate task (cron
driven) that loads data from the quarantine directories.  I don't like the
potential impact of DB connection overhead or down DB servers to the filter
and mail throughput.  Just my $.02 ...

... Phil
 
 

-----Original Message-----
From: mimedefang-admin at lists.roaringpenguin.com
[mailto:mimedefang-admin at lists.roaringpenguin.com] On Behalf Of schmaus
Sent: Wednesday, June 18, 2003 10:57 AM
To: mimedefang at lists.roaringpenguin.com
Subject: RE: [Mimedefang] Off Topic - Mail Message and MySQL


>
> Take a look at DBI's quote() method.  It will handle on
> the escaping for you.
>
> ... Phil
>


Phil,

What about the possibility of binary data being in the
message?  I read that the quote() method may not be able to
handle that.

Benjamin Schmaus
_______________________________________________
MIMEDefang mailing list
MIMEDefang at lists.roaringpenguin.com
http://lists.roaringpenguin.com/mailman/listinfo/mimedefang