[Mimedefang] Greylist DB addition fails silently?

[Paul Murphy]

> I've had endless problems with Berkeley DB and Perl.  Our greylisting
> implementation uses PostgreSQL; I'm sure it wouldn't be too hard to
> write a DBI version that can use MySQL or PostgreSQL.

Hmm, I was afraid that would be the answer...  The database fell over at 9212
keys, and when I created a new version, is OK.  MySQL would be relatively
simple, but the hassle of having to work out the connection details with the
multiplexor is something I had hoped to avoid.

Presumably if making the DBI connection and all of the SQL prepare statements
are done in filter_initialize, and the database is closed in filter_cleanup,
then it should all work OK using DBI execute statements in the main filter code?

Best Wishes,

Paul.
__________________________________________________
Paul Murphy
Head of Informatics
Ionix Pharmaceuticals Ltd
418 Science Park, Cambridge, CB4 0PA

Tel. 01223 433741
Fax. 01223 433788


_______________________________________________________________________
DISCLAIMER:
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to which they
are addressed.  If you have received this email in error please contact
the sender or the Ionix IT Helpdesk on +44 (0) 1223 433741
_______________________________________________________________________