Dspam User skrev, on 01-08-2007 00:10:
I compiled and installed Dspam as outlined in its docs using
MySQL 5.0.45 as a backend.
Unfortunately, I can't deploy Dspam as a spam filter for our mail server
having this crap 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
Well, it would seem to be complaining about the dspam_virtual_uids table.
What do you get with 'mysql -> SELECT * FROM `dspam_virtual_uids` WHERE
1;'? Do you see two columns, one called uid and the other username?
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
Nothing is being entered into dspam_signature_data table
My 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
Default Dspam tables:
dspam_preferences
dspam_signature_data
dspam_stats
dspam_token_data
dspam_virtual_uids
Virtual users are enabled.
Did you build with '--enable-virtual-users'?
Debugging is enabled.
You might have built with '--enable-debug', but you haven't turned it on
in dspam.conf:
Debug *
#Debug bob bill
I have this in 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:
These fields are (supposed to be) in dspam_signature_data. What do you
get with "mysql -> SELECT UID FROM dspam_signature_data WHERE uid = '3';"?
¢ÛÚ(^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]>
You need the debug log, not this one - it's $DSPAMHOME/log/dspam.debug.
If you don't have this, turn debugging on in dspam.conf.
Could you please make any sense out of this data?
The ball's now in your court; at least you've provided most of the info
that helps in analyzing your problem. If I can't help, someone else
surely can ;)
Best,
--Tonni
--
Tony Earnshaw
Email: tonni at hetnet dot nl
