Hi, I changed to use the MySQL version of greylisting from http://www.bl.org/~jpk/md-greylist/ after issues with Berkeley DB surfaced while using Jonas' original code. It has been working well for several weeks, but I now get problems with slaves dying occasionally with the mail log showing:
Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Slave 2 died prematurely -- check your filter rul es Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Slave 2 stderr: DBD::mysql::st execute failed: My SQL server has gone away at /etc/mail/greylist-msql/mimedefang-filter-greylist line 246. DBD::mysql::st execute failed: MySQL server has gone away at /etc/mail/greylist-msql/mimedefang-filter-greylist line 246. Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Reap: Idle slave 2 (pid 10176) exited normally wi th status 32 (SLAVE DIED UNEXPECTEDLY) Aug 26 09:45:49 adelie mimedefang-multiplexor[30954]: Slave 2 resource usage: req=8, scans=2, user=3.12 0, sys=0.150, nswap=0, majflt=224, minflt=10457, maxrss=0, bi=0, bo=0 Aug 26 09:45:49 adelie mimedefang[26637]: Error from multiplexor: ERR No response from slave Line 246 of the mimedefang-filter-greylist file is in the greylist_check routine, and is the execute call to search the database: $select_sth->execute($ip, $sender, $recipient); As this works normally, and the other slaves are still OK (MySQL is still running), I'm wondering whether there's something strange happening with the Perl session. I'm using MD 2.43, embedded Perl 5.8.3, and MySQL 12.22/4.0.18 on Debian Linux. Any ideas what might be causing this? 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 _______________________________________________________________________
_______________________________________________ Visit http://www.mimedefang.org and http://www.canit.ca MIMEDefang mailing list [EMAIL PROTECTED] http://lists.roaringpenguin.com/mailman/listinfo/mimedefang
