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

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.

------------------------------------------------------------------------------
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