On Wed, 27 Jan 2010 08:29:57 +0100 "[email protected]" <[email protected]> wrote:
> 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 ? > Please post the output of "dspam --version" Please post your dspam.conf What version of MySQL? > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspam-user > ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
