Hi all,
i've a question concerning the MySQLConnectionCache setting et daemon mode.
I use dspam in daemon mode with amavisd and i've have several amavisd
processes running ($max_servers setting in amavisd)
i'm calling dspam like this:
@spam_scanners = (
['SpamAssassin', 'Amavis::SpamControl::SpamAssassin'],
['DSPAM', 'Amavis::SpamControl::ExtProg', $dspam,
[ qw(--client --stdout --process --deliver=innocent,spam
--user), $daemon_user ],
score_factor => 1,
],
);
if i leave MySQLConnectionCache by default, (2 connections i suppose
from what i see in mysql process list), i see very often some problem in
my log and mail are not scanned by dpsam:
for each mail:
Jan 25 13:03:10 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
Jan 25 13:03:10 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
Jan 25 13:11:51 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
Jan 25 13:11:51 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
Jan 25 13:11:51 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
Jan 25 13:17:07 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
Jan 25 13:17:07 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
Jan 25 13:17:07 mx2 dspam[32398]: _ds_pref_load: unable to initialize
tools context
and sometimes:
Jan 25 13:17:07 mx2 dspam[32398]: Error getting exit status of delivery
agent: : Broken pipe
So i've increase MySQLConnectionCache to the same value as my amavisd
processes and it's doing fine, no problem appears in log and mail are
correctly scanned by dspam
I can see in mysql process list the exact number of processes according
to this setting.
But after some times, the mysql processes are closed (wait timeout
setting in mysql, value 28800) and dspam doesnt open them again.
And of course, the problem reappear in logs and mail are not scanned.
The only way to restore mysql connection cache is to restart dspam daemon.
Is this a known problem or i've made some mistakes in my settings ?
Thx for your help
Regards
Tonio
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user
