Any thoughts based on what I've sent so far? If I can get some time,
I'll hook a debugger up or inject some debug code in the mysql driver
around this area to get more information about what's happening. It is
really annoying having hundreds of spams every couple days get skipped
by dspam...
-J
Jason Axley wrote:
Here's my dspam.conf:
grep -v ^# /etc/dspam/dspam.conf|grep -v '^[ ]*$'
Home /var/spool/dspam
StorageDriver /usr/lib/dspam/libmysql_drv.so
DeliveryHost 127.0.0.1
DeliveryPort 10025
DeliveryIdent localhost
DeliveryProto SMTP
OnFail error
Trust root
Trust dspam
Trust mail
Trust mailnull
Trust smmsp
Trust daemon
DebugOpt process spam fp classify
Debug *
TrainingMode toe
TestConditionalTraining on
Feature whitelist
Algorithm graham burton
Tokenizer chain
PValue bcr
WebStats on
Preference "spamAction=tag"
Preference "signatureLocation=message" # 'message' or 'headers'
Preference "showFactors=off"
Preference "spamSubject=[***SPAM***]"
AllowOverride trainingMode
AllowOverride spamAction spamSubject
AllowOverride statisticalSedation
AllowOverride enableBNR
AllowOverride enableWhitelist
AllowOverride signatureLocation
AllowOverride showFactors
AllowOverride optIn optOut
AllowOverride whitelistThreshold
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 out
TrackSources [EMAIL PROTECTED] [EMAIL PROTECTED]
ServerPID /var/run/dspam/dspam.pid
ServerMode auto
ServerParameters "--deliver=innocent -d %u"
ServerIdent "localhost.localdomain"
ServerDomainSocketPath "/var/spool/postfix/tmp/dspam.sock"
ProcessorURLContext on
ProcessorBias on
Include /etc/dspam/dspam.d/
And in /etc/dspam/dspam.d, I just have my mysql config:
MySQLServer /var/run/mysqld/mysqld.sock
MySQLUser libdspam7-drv-my
MySQLPass REDACTED
MySQLDb libdspam7drvmysql
MySQLVirtualTable dspam_virtual_uids
MySQLVirtualUIDField uid
MySQLVirtualUsernameField username
MySQLUIDInSignature on
MySQLReconnect true
Steve wrote:
-------- Original-Nachricht --------
Datum: Sun, 06 Jan 2008 11:57:40 -0800
Von: Jason Axley <[EMAIL PROTECTED]>
An: Steve <[EMAIL PROTECTED]>
CC: [email protected]
Betreff: Re: [dspam-users] CVS version getting invalid result messages in logs
Steve wrote:
-------- Original-Nachricht --------
Datum: Sat, 05 Jan 2008 15:13:50 -0800
Von: Jason Axley <[EMAIL PROTECTED]>
An: Steve <[EMAIL PROTECTED]>
CC: [email protected]
Betreff: Re: [dspam-users] CVS version getting invalid result messages
in logs
I'm now running a build with --enable-verbose-debug. Here is a
transcript of a single spam addressed to multiple users via my mail
server. I'm not sure if the bug is related to the number of recipients
dspam is handling for the same message? Apologies for the length but
each is interwoven together:
[...]
Is this the transcript of a message which is crashing DSPAM?
Not crashing dspam. Dspam is running in daemon mode and continues to
run. Postfix is passing messages to dspam using LMTP via the UNIX
domain socket so there's only one instance of dspam.
But this is a message that resulted in dspam not tagging it and simply
delivering it without tagging it.
Aha. Okay. Would it be possible to post your dspam.conf?
-Jason
Steve
Steve
Jason Axley wrote:
Nope. Just had the same problem occur with same messages. I'm going
to build a new version with debug options enabled and report back if I
find anything.
-Jason
Jason Axley wrote:
I just enabled the MySQLReconnect option and I'll run with that for a
few days and see if I experience the same issue. If that doesn't
work, I'll create a build with full debug and run it on my system to
try to isolate it. Thanks!!
I've rebuilt my dspam.conf file after 3.8.0 by diffing the two and
changing lines that mattered so I don't think that's related.
-Jason
Steve wrote:
<snip>
For me the significant/important information is that you have Ubuntu
and that you run 32Bit and that you have a similar issue as Tony has.
But
you both have different architectures and differend bit depth and
different
distributions. But the problem you have is similar (to a certain
extend).
I think the fastest and most economic way to solve this issue would
be
to have some one having Ubuntu and/or FC6 to compile DSPAM with all the
debug flags turned on and with debug compile flags and install it and
debug
the issue.
One thing you could try to do is enable the new MySQLReconnect
option
in dspam.conf. We in Gentoo added that feature since MySQL >= 5.0.13
does
not any more reconnect (the older 4.x series did that by default). Just
add
in your dspam.conf this and try if this solves your problem:
MySQLReconnect true
One other thing I remember is that we have one user on Gentoo
claiming
in Bugzilla that his old dspam.conf was responsible for DSPAM crashing:
http://bugs.gentoo.org/show_bug.cgi?id=200481#c28
After changing the dspam.conf his error got away. But I don't know
how
valid his claims are since we in Gentoo can not reproduce this issue
and
he has not any more his old dspam.conf.
// Steve
!DSPAM:4,4781cca3236042127612005!
