-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 27/01/2010 12:34, Stevan Baji? wrote: > 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
dspam --version DSPAM Anti-Spam Suite 3.9.0 (agent/library) Copyright (c) 2002-2009 DSPAM Project http://dspam.sourceforge.net. DSPAM may be copied only under the terms of the GNU General Public License, a copy of which can be found with the DSPAM distribution kit. Configuration parameters: '--prefix=/usr' '--disable-dependency-tracking' '--includedir=/usr/include' '--with-logdir=/var/log/dspam/' '--with-dspam-home=/var/amavis/dspam' '--sysconfdir=/etc/' '--enable-domain-scale' '--enable-signature-headers' '--without-delivery-agent' '--with-mysql-includes=/usr/include/mysql' '--with-storage-driver=mysql_drv' '--enable-virtual-users' '--enable-preferences-extension' '--enable-daemon' '--enable-debug' dspam.conf: Home /var/amavis/dspam StorageDriver /usr/lib/dspam/libmysql_drv.so TrustedDeliveryAgent "no" OnFail error Trust root Trust dspam Trust apache Trust mail Trust mailnull Trust smmsp Trust daemon Trust amavis TrainingMode teft TestConditionalTraining on Feature noise Feature whitelist Feature tb=5 Algorithm graham burton Tokenizer osb PValue bcr WebStats off ImprobabilityDrive on Preference "trainingMode=TEFT" # { TOE | TUM | TEFT | NOTRAIN } -> default:teft Preference "spamAction=tag" # { quarantine | tag | deliver } -> default:quarantine Preference "spamSubject=[SPAM]" # { string } -> default:[SPAM] Preference "statisticalSedation=6" # { 0 - 10 } -> default:0 Preference "enableBNR=on" # { on | off } -> default:off Preference "enableWhitelist=on" # { on | off } -> default:on Preference "signatureLocation=message" # { message | headers } -> default:message Preference "tagSpam=off" # { on | off } Preference "tagNonspam=off" # { on | off } Preference "showFactors=off" # { on | off } -> default:off Preference "optIn=off" # { on | off } Preference "optOut=off" # { on | off } Preference "whitelistThreshold=10" # { Integer } -> default:10 Preference "makeCorpus=off" # { on | off } -> default:off Preference "storeFragments=off" # { on | off } -> default:off Preference "localStore=" # { on | off } -> default:username Preference "processorBias=on" # { on | off } -> default:on Preference "fallbackDomain=off" # { on | off } -> default:off Preference "trainPristine=off" # { on | off } -> default:off Preference "optOutClamAV=off" # { on | off } -> default:off Preference "ignoreRBLLookups=off" # { on | off } -> default:off Preference "RBLInoculate=off" # { on | off } -> default:off AllowOverride enableBNR AllowOverride enableWhitelist AllowOverride fallbackDomain AllowOverride ignoreGroups AllowOverride ignoreRBLLookups AllowOverride localStore AllowOverride makeCorpus AllowOverride optIn AllowOverride optOut AllowOverride optOutClamAV AllowOverride processorBias AllowOverride RBLInoculate AllowOverride showFactors AllowOverride signatureLocation AllowOverride spamAction AllowOverride spamSubject AllowOverride statisticalSedation AllowOverride storeFragments AllowOverride tagNonspam AllowOverride tagSpam AllowOverride trainPristine AllowOverride trainingMode AllowOverride whitelistThreshold AllowOverride dailyQuarantineSummary MySQLServer /var/run/mysqld/mysqld.sock MySQLUser dspam MySQLPass ****** MySQLDb dspam MySQLConnectionCache 10 HashRecMax 98317 HashAutoExtend on HashMaxExtents 0 HashExtentSize 49157 HashPctIncrease 10 HashMaxSeek 10 HashConnectionCache 10 Notifications off PurgeSignatures 14 # Stale signatures PurgeNeutral 90 # Tokens with neutralish probabilities PurgeUnused 90 # Unused tokens PurgeHapaxes 30 # Tokens with less than 5 hits (hapaxes) PurgeHits1S 15 # Tokens with only 1 spam hit PurgeHits1I 15 # Tokens with only 1 innocent hit LocalMX 127.0.0.1 SystemLog on UserLog on Opt in Broken case Broken lineStripping MaxMessageSize 4194304 ServerPass.Relay1 "secret" ServerDomainSocketPath "/tmp/dspam.sock" ClientHost /tmp/dspam.sock ClientIdent "sec...@relay1" ProcessorURLContext on ProcessorBias on StripRcptDomain off defaukt preference in mysql: |dspam_admin change preference default "dailyQuarantineSummary" "off" dspam_admin change preference default "enableBNR" "on" dspam_admin change preference default "enableWhitelist" "on" dspam_admin change preference default "fallbackDomain" "off" dspam_admin change preference default "ignoreGroups" "off" dspam_admin change preference default "ignoreRBLLookups" "off" dspam_admin change preference default "makeCorpus" "off" dspam_admin change preference default "optIn" "on" dspam_admin change preference default "optOut" "off" dspam_admin change preference default "optOutClamAV" "on" dspam_admin change preference default "processorBias" "on" dspam_admin change preference default "showFactors" "off" dspam_admin change preference default "signatureLocation" "headers" dspam_admin change preference default "spamAction" "tag" dspam_admin change preference default "spamSubject" "[SPAM]" dspam_admin change preference default "statisticalSedation" "6" dspam_admin change preference default "storeFragments" "off" dspam_admin change preference default "tagNonspam" "off" dspam_admin change preference default "tagSpam" "off" dspam_admin change preference default "trainingMode" "TOE" dspam_admin change preference default "trainPristine" "off" dspam_admin change preference default "whitelistThreshold" "10"| mysql --version mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAktgMD8ACgkQ8FtMlUNHQIOkTACeK4KAYBM4tmOryQENPFlofDUv BKoAoKmuW2p7X3pHym4K7GHec8cbWSOb =byVO -----END PGP SIGNATURE----- ------------------------------------------------------------------------------ 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
