RE: [Mimedefang] Greylisting code with SQLite Backend

John Kirkland Thu, 24 Jun 2004 21:44:19 -0700

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:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 11:41 AM
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
http://lists.roaringpenguin.com/mailman/listinfo/mimedefang


------------------------------

_______________________________________________
MIMEDefang mailing list
[EMAIL PROTECTED]
http://lists.roaringpenguin.com/mailman/listinfo/mimedefang


End of MIMEDefang Digest, Vol 9, Issue 52
*****************************************

_______________________________________________
Visit http://www.mimedefang.org and http://www.canit.ca
MIMEDefang mailing list
[EMAIL PROTECTED]
http://lists.roaringpenguin.com/mailman/listinfo/mimedefang

RE: [Mimedefang] Greylisting code with SQLite Backend

Reply via email to