-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 27/01/2010 14:44, Stevan Baji? wrote:
> On Wed, 27 Jan 2010 13:23:27 +0100 "[email protected]"
> <[email protected]> wrote:
>
> 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
>>
>>
-
------------------------------------------------------------------------------
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
of course ! it was obvious, sorry for the noise
thank you.
Regards
Tonio
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAktgVIwACgkQ8FtMlUNHQINHFgCfcU+QeKTjgL9C6MRMUsz2U1MN
4KcAn1hzimDLYiOgiwv3GiDmoWUO5lun
=J8eQ
-----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
