Re: [dspam-users] Which version of Dspam should be used?

Dspam User Sat, 28 Jul 2007 14:59:12 -0700

All right Tony, 
I might misunderstood you.

Here are *exact* answers to your points


dspam.conf:

Home /var/dspam
TrustedDeliveryAgent       "/usr/sbin/sendmail"
OnFail error
Trust root
Trust mail
Trust maildrop
Trust mailfilter
Trust postfix
Trust daemon
TrainingMode teft
TestConditionalTraining on
Feature whitelist
Algorithm graham burton
Tokenizer chain
PValue bcr
WebStats on
Preference "signatureLocation=headers"
Preference "showFactors=on"
Preference "spamSubject=[SPAM]"
AllowOverride localStore
MySQLServer             /tmp/mysql.sock
MySQLPort
MySQLUser               user
MySQLPass               pass
MySQLDb                 mail
MySQLCompress           true
MySQLConnectionCache    10
MySQLUIDInSignature    on
HashRecMax              98317
HashAutoExtend          on
HashMaxExtents          0
HashExtentSize          49157
HashPctIncrease 10
HashMaxSeek             10
HashConnectionCache     10
Notifications   off
PurgeSignature  off # Specified in purge.sql
PurgeNeutral   90
PurgeUnused    off # Specified in purge.sql
PurgeHapaxes   off # Specified in purge.sql
PurgeHits1S    off # Specified in purge.sql
PurgeHits1I    off # Specified in purge.sql
SystemLog on
UserLog   on
ParseToHeaders on
ChangeModeOnParse on
ChangeUserOnParse off
ServerQueueSize 32
ServerPID              /var/run/dspam.pid
ServerMode auto
ServerIdent             "mail.mailswamp.com"
ServerDomainSocketPath  "/tmp/dspam.sock"
ProcessorURLContext on
ProcessorBias on

Dspam tables:

dspam_preferences    
dspam_signature_data 
dspam_stats          
dspam_token_data     
dspam_virtual_uids   

Virtual users are enabled.

Debugging is enabled. 

I have this in: 

dspam.log

27570: [07/27/2007 16:44:19] query error: Unknown 
column '3,46aa8353275701619110565' in 'where clause': see sql
.errors for more details
27570: [07/27/2007 16:44:19] query error: You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL server version for 
the right syntax to use near '¿\nQ:
¢ÛÚ(^A\0\0\0y<95>À^Uª<99>«ñ^A\0\0\0ìfÙ^EÆd-Ä^B\0\0\0oßÝBmÖ°À^A\0\0\0PÎ<85>þ<86>^P©Ø^A\0\0\0^R^FU¨'
 
at line 1: see sql.errors for more details
27570: [07/27/2007 16:44:19] _ds_set_signature() failed with error -5


sql.errors

[07/27/2007 16:13:00] 27266: Unknown column '3,46aa7bfc272665954492529' 
in 'where clause': select signature from dspam_signature_data where uid = 3 
and signature = "3,46aa7bfc272665954492529"
[07/27/2007 16:13:00] 27266: You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right syntax to 
use near '¿\nQ:
¢ÛÚ(^A\0\0\0y<95>À^Uª<99>«ñ^A\0\0\0<98>§\'¦¸<8c>¡û^A\0\0\0ìfÙ^EÆd-Ä^B\0\0\0oßÝBmÖ°À^A\0\0\0PÎ<85>'
 
at line 1: insert into dspam_signature_data(uid, signature, length, 
created_on, data) values(3, "3,46aa7bfc272665954492529", 1500, 
current_date(), "¿\nQ:
¢ÛÚ(^A\0\0\0y<95>À^Uª<99>«ñ^A\0\0\0<98>§\'¦¸<8c>¡û^A\0\0\0ìfÙ^EÆd-Ä^B\0\0\0oßÝBmÖ°À^A\0\0\0PÎ<85>þ<86>^P©Ø^A\0\0\0^R^FU¨òôB<8b>^A\0\0\0^QÊ^]^WÇ<9b>T<8a>^A\0\0\0Ç;ªr|}<]^A\0\0\0uÑ·^OßoY<8b>^A\0\0\0<9e>é<9d><9c>ÛìÇô^A\0\0\0ö4<9d>&n[¹^F^A\0\0\0,×àÞÝ
©Î^A\0\0\0^QÊ^]^WÇ;
\'¬^A\0\0\0mö4<9d>&~Þ^S^A\0\0\0¤b<99>[EMAIL PROTECTED]<9d>&®|
æÍµ^A\0\0\0Ú<9b>7½Ø^R^Få^A\0\0\0³ÓB½ÆÔpý^B\0\0\07½<88><8c>xÝ½â^A\0\0\0P¼^N;#M»Ç^A\0\0\0ayù^A¿äëÛ^A\0\0\0&¾<8f>Gç¥÷<94>^A\0\0\0Î^[çÔCLô<90>^A\0\0\0ÓðGÀ<=\r<92>^A\0\0\0ö4<9d>&[EMAIL
 PROTECTED]<9b>7½Hú/^A\0\0\0½<98>    
rR¨â\0^A\0\0\0Ê^]^WÇ+¥ëk^A\0\0\0ÀÚ<9b>7½X>)^A\0\0\0mö4<9d>&^N~f^B\0\0\0ö4<9d>&n<9d>ø^R^A\0\0\0<87>^FèÁeÔÂâ^A\0\0\0y<92>°^Uª<99>«ñ^A\0\0\0<80><83>1
 
H<90><87>ç^A\0\0\0=<9a>^N^W´ÿP^\^A\0\0\0üoß]Ô;
×^A\0\0\0Hú^?mÌõôÒ^A\0\0\0mö4<9d>&®;v^A\0\0\0Àá³<88>^[!ÝL^A\0\0\0r|}<^]I±²^A\0\0\0¯Ò<85>Þ\\Ä^_á^A\0\0\0&n[¹ö^Eåà^A\0\0\0,sß<^FÅ(l^A\0\0\0/Þ¿\"á<80><97>Ó^A\0\0\0^QÊ^]^WÇË=³^A\0\0\04<9d>&nm^YSÌ^A\0\0\0DlnYvçéÄ^A\0\0\0½<83>ýp
ãt4^A\0\0\0íÒ^?^AÐ¤À ^A\0\0\0Á\Z{1ÞsÏ,^A\0\0\0^A¥=> ÿIÌ^A\0\0\07
[<92>Ò<96>^Q³\n^A\0\0\0E¤^Qä<91>>R¡^A\0\0\0<82>ç|5r
^VA^A\0\0\0^QÊ^]^WÇ[ÓÍ^A\0\0\0X.-i<88>UU×^A\0\0\0^L Ý\Z/è
´5^A\0\0\07½<88>L~^]^Kã^A\0\0\0Å(|Ä¦pAR^A\0\0\0^QÊ^]^WÇëÕ¦^A\0\0\0`|
ÇSk<86>[EMAIL 
PROTECTED];^B\0\0\0ÛóÁ^Tâ~ãµ^A\0\0\0\0\0À^A»µa)^B\0\0\0=<9a>^ÉÁgv`^A\0\0\0ôàu^L^HsÐL^A\0\0\0Ç3ù^R^D·1ã^A\0\0\0JÔü-å<80>+Ó^A\0\0\0j<80>G%Fk<90><9d>^A\0\0\0<9f>^WL<83>¯þà¶^A\0\0\0Ê#<^X<86>Ô<8e>.^A\0\0\06^NG<9a>&ñ<9f><84>^A\0\0\0<86>káiW<8a>^D<81>^A\0\0\0¢*£d,2ù·^A\0\0\0ÇË=S³¡»n^A\0\0\0m^YS\\<92>
´<9f>^U^A\0\0\0l<88>¬\ZnV¸>^A\0\0\0éNV-ü`<85>¡^A\0\0\0L£®\"<89>×^Op^A\0\0\0mö4<9d>&þÄg^A\0\0\0^W
      
RËC#<9d>I^A\0\0\0=<9a><8e>ëiÂ#t^A\0\0\04<9d>&Þ\']
7Ë^A\0\0\0<9b>7½X.-i<88>^A\0\0\0&®l²)NÝ<98>^A\0\0\0^PFÐ^WY^H^Rz^A\0\0\0ö4<9d>&¾<8f>G^W^A\0\0\0<8f>f÷^]B<95>6P^A\0\0\0Ýr|
<88>f^]Kx^A\0\0\0Î!<83>¬<80>ê<9a>ç^A\0\0\0<86>Ô<8e><9e>[EMAIL PROTECTED]
M¥^A\0\0\0Ø<9a>ÑÞ;a\rÄ^B\0\0\0k^V!=<9a>Î!<83>^A\0\0\0^WÇ;`|
ÇS+^A\0\0\0øâ%Mr2^?<85>^A\0\0\0®|
æÍ%Rå^[^A\0\0\0^QÊ^]^WÇë¢Ê^A\0\0\0Ç+¥ëÛ³^[t^A\0\0\04<9d>&N^Y^V|
Û^A\0\0\0!=<9a>Î1×¨4^A\0\0\0½X>y<8d>ãÚx^A\0\0\0ÉÁgvÀ<9e>ÓV^A\0\0\0^Q^E^RÁ¤2îR^A\0\0\0<9d>&<8e>ÄÐÑ<81>g^A\0\0\08ÔÞ^Y<99><88>»ô^A\0\0\0Ú<9b>7½<98>
   
râ^A\0\0\0mö4<9d>&®l^R^A\0\0\0ád£m<84>½X2^B\0\0\0N^Y^V|
K\"En^A\0\0\0ÀÚ<9b>7½<88><8c>(^A\0\0\0ó<85>EîPJ/?^B\0\0\0ÛOê7^V«¥y^A\0\0\0<9d>&¾éNV-\\^A\0\0\0=<9a>îèiÂ8t^A\0\0\0ÀÚ<9b>7½<88>L.^A\0\0\0<9b>7½8=)y<8c>^A\0\0\0hÂK<Á:q°^A\0\0\0\ZnV¸.<88>ü¨^A\0\0\0d-Ô<90>$^N+ö^A\0\0\0PNMW<97><8b>øÑ^A\0\0\0¥ä±PÎ<85>þ¦^A\0\0\0")


system.log

1185580667      I       Dspam User <[EMAIL PROTECTED]>  
3,46aa867b276321332919328       [dspam-users] Is this Dspam bug??? 
_ds_set_signature() failed with error -5     0.050010        alex    
Delivered       <[EMAIL PROTECTED]>
1185605402      I       Tony Earnshaw <[EMAIL PROTECTED]> 
3,46aae71a283741497319589       Re: [dspam-users] Which version of Dspam 
should be used?        0.080017        alex    Delivered       
<[EMAIL PROTECTED]>
1185605816      I       Tony Earnshaw <[EMAIL PROTECTED]> 
3,46aae8b8284441336712104       Re: [dspam-users] Which version of Dspam 
should be used?        0.060013        alex    Delivered       
<[EMAIL PROTECTED]>
1185646207      I       Dspam User <[EMAIL PROTECTED]>  
3,46ab867f295287785049143       Re: [dspam-users] Which version of Dspam 
should be used?        0.100022        alex    Delivered       
<[EMAIL PROTECTED]>
1185647981      I       Tony Earnshaw <[EMAIL PROTECTED]> 
3,46ab8d6d295861619110565       Re: [dspam-users] Which version of Dspam 
should be used?        0.070015        alex    Delivered       
<[EMAIL PROTECTED]>
1185652494      I       "Ranbir Sanasam" <[EMAIL PROTECTED]> 
3,46ab9f0e297073451617763       [dspam-users] pop3filter and dspam 
integration problem  0.070015        alex    Delivered       
<[EMAIL PROTECTED]>


Could you please make any sense out of this data?

Thanks in advance,

Alex


On Saturday 28 July 2007 11:39:09 Tony Earnshaw wrote:
> Dspam User skrev, on 28-07-2007 20:09:
> > Thanks for you reply.
>
> I can't do anything until you've answered *exactly* the points that I
> asked you to answer.
>
> You haven't, you've made up your own reply, according to what you
> consider to be relevant.
>
> Most of it isn't relevant at all.
>
> As I said, I have dspam 3.8.0 working perfectly on a number of machines.
> You don't, it's up to you.
>
> --Tonni

Re: [dspam-users] Which version of Dspam should be used?

Reply via email to