Re: web interface and command line dspam apparently failing to reclassify emails

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 21-11-14 00:00, Sparr wrote:
> On Thu, Nov 20, 2014 at 4:32 PM, Sparr <[email protected]> wrote:
>> On Thu, Nov 20, 2014 at 3:48 PM, [email protected] <[email protected]>
>> wrote:
>>>> 5398: [11/20/2014 13:34:09] saving signature as
>>>> 546e423153989760964788
>>> 
>>> Well, it looks like the signature is saved. Can you try a
>>> manual select of the signature from your DB. Also, what process
>>> do you have for cleaning the signature DB, otherwise it grows
>>> without bound? Maybe the signature was removed by that cleanup
>>> process before you had a chance to use it. That timing is alway
>>> a space vs. time retained trade-off.
>> 
>> A manual select of the signature from my DB is the only way I
>> know to check:
>> 
>> SELECT * from dspam_signature_data where signature =
>> "546e423153989760964788";
>> 
>> I ran dspam_maintenance and dspam_clean once yesterday, but
>> haven't since, and probably never before.
>> 
>> To be clear, *none* of the emails I am seeing in my dspam.debug
>> log are showing up in the dspam_signature_data table.
> 
> Additional info: At about the same time as dspam.debug says
> "saving signature as xxx", my mysql general query log shows this
> query:
> 
> SELECT signature FROM dspam_signature_data WHERE uid=nnn AND
> signature="xxx"
> 
> That query has zero results, as near as I can tell. There is no
> INSERT query.
> 
> I am seeing INSERT queries from another dspam server that's
> working correctly, so this must be a configuration problem.
> 

Or are you using train on error / TOE ?

Tom

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCAAGBQJUbndxAAoJEJPfMZ19VO/1voEQAIluvpWXtBficVemF82YuowF
TpbJ0NfWICD3ZZvQULw9Nl7DlNHEgqFcrK4cEP9xWmk5I6cgHSmIZibRhh24FUuR
Ofh9tPXW/aF8724j1vPxWo2G+lNnARJ2fjHrXbpAyMCqMfekWndx+wLkJeJ2rjR6
VtJxbMprsDbva2dJDsphbR5hqLIL/NC2uTbShHTYtxg2nK6DKQ26ioVTZF0K1xxH
LVcxZIgABSoYxkVrHxUF6r+pAm4Yo5PPka+GFMO4ft2bHoFWOPo8fYjiaQsRRUr0
p8tTbIPtVEeQHoq5Llk/SS9DdUm0Edd+F8j0zJ7SQOgfS3xsuevQ32j6pAcEh/cw
e3Xacdotp3H7BvJUNLDPO/v0CDNxmYFEugk80hTh7oHKYpqpiyK2Y/PlCTcFFr4q
nNsVZjw/fc67IPBuf/39GPEEqUFptfI0vACwAEjz07CHlBwgZMSnyGT1bbSnvGe4
Mx5ECTN3MI0HVLPzBYPbQ1t2P3Y09BA7OXvgQEZjfPwJJkW6e5L1nnAaFsAt2nrZ
p9k6MWaKJmjvjehmGzzMX8cdyH0sVDfvDSu8z3HTxdH+byAjacab3EzpVSprjeBe
JGtlOrgbcLCf9+FoVkQfDxe1Hr53n8CdGOZtw7uVnt8rO5JOmaqdvzZYOUpGu96y
tBI9rHR1QL1X1a56uuDt
=sB/G
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk