On Wed, 27 Jan 2010 13:23:27 +0100 "[email protected]" <[email protected]> wrote:
> -----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 > Add here this: MySQLReconnect true > 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 > ------------------------------------------------------------------------------ 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
