[Mimedefang] Mail::SpamAssassin::BayesStore::SQL databasepersistence.

[David F. Skoll]

Matthew.van.Eerde at hbinc.com wrote:

> spamassassin calls through the "spamassassin" command and the
> Mail::SpamAssassin perl modules don't live long enough to hold on to
> a persistent connection.

Yes, they do (in MIMEDefang, anyway).  They live for the lifetime of a
MIMEDefang slave, typically 100 messages or more.

However, looking at the SpamAssassin source code, it looks like it
explicitly "ties" and "unties" the data source.  So even spamd
wouldn't help.  Your best bet would be to derive a class from
Mail::SpamAssassin::BayesStore::SQL and make it use persistent
connections.

> 2. connection pooling

That would work too, but it's somewhat ugly.  There is a pooling
daemon for PostgreSQL: http://pgfoundry.org/projects/pgpool/
I've never used it myself.

Regards,

David.