[Mimedefang] Greylisting code with SQLite Backend

[John Kirkland]

Bummer... I hadn't noticed it before, but I had that in my maillog file, 
too.  It turns out that the perl DBD libraries don't expose the API method 
to set the wait time for locks to expire, so if a lock is encountered an 
error is immediately returned.  There are a couple of bugs logged against 
the DBD Sqlite module at CPAN to this effect.

Potential solutions include using external file locking or switching to 
another database backend.  I made the minor changes to get the thing to 
work under mysql, and I just restarted my mimedefang.  I'll monitor its 
progress overnight, and if it looks good in the morning, I'll post the 
code changes.

Thanks for finding this!  It's a real bummer... there's even a patch on 
CPAN to fix the wait time issue in the DBD module, but it's not yet in the 
distribution.

Best Regards,
John Kirkland

On Thu, 24 Jun 2004, Rob Ade wrote:

> Hi John,
>
> Thanks for the code. I am having some trouble with database locking.
> Have you experienced this? I am running RH 8.0 and Mimedefang 2.43 and
> SpamAssassin 2.63. I am also use DBI-1.42 and DBD-SQLite-0.31. This is
> the error message I am getting:
>
> Jun 24 21:20:36 mail mimedefang-multiplexor[29758]: Slave 0 stderr:
> DBD::SQLite::st execute failed: database is locked at
> /etc/mail/mimedefang-filter-greylist line 247. DBD::SQLite::st execute
> failed: database is locked at /etc/mail/mimedefang-filter-greylist line
> 246.
>
> Any help would be greatly appreciated and thanks for your time!
>
> Rob
>
> -----Original Message-----
> From: John Kirkland [mailto:jpk at bl.org]
> Sent: Thursday, June 24, 2004 11:41 AM
> To: mimedefang at lists.roaringpenguin.com
> Subject: [Mimedefang] Greylisting code with SQLite Backend
>
>
> Hi, all,
>
> I just converted my greylisting implementation to a SQLite backend.  I
> created a web page with the code and basic install instructions:
>
> http://www.bl.org/~jpk/md-greylist/
>
> My code is a derivation of work that was done by others in this mailing
> list... the most significant contribution here is the SQLite backend.
> It
> would be mostly trivial to go from this to a mysql or other DBD
> supported
> backend.
>
> Regards,
> John
> _______________________________________________
> Visit http://www.mimedefang.org and http://www.canit.ca
> MIMEDefang mailing list
> MIMEDefang at lists.roaringpenguin.com
> http://lists.roaringpenguin.com/mailman/listinfo/mimedefang
>
>
> ------------------------------
>
> _______________________________________________
> MIMEDefang mailing list
> MIMEDefang at lists.roaringpenguin.com
> http://lists.roaringpenguin.com/mailman/listinfo/mimedefang
>
>
> End of MIMEDefang Digest, Vol 9, Issue 52
> *****************************************
>