[Mimedefang] MySQL Greylisting issue - server gone away
Guy FELTIN
Guy.Feltin at ciril.fr
Thu Aug 26 05:17:20 EDT 2004
Dans son message, "Paul Murphy" ecrivait :
----------------------------------------------
> 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"4, minflt457, 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?
Hello
you use embedded perl .
I run also /~jpk/md-greylist and it works fine when I run mimefang whithout -E argument (embedded
perl).
But I have the same error ,: MySQL server has gone away , when I run mimedefang whith -E argument.
I haven't find any reason for this . If you have any ideas .
I run MD 2.44, mysql Ver 12.22 Distrib 4.0.17, on hpux11.11
--
Guy Feltin - 03 83 68 24 30
More information about the MIMEDefang
mailing list