MailWatch Stops logging sascore & sareport

[Anthony Peacock]

Hi,

I originally posted this to the MailWatch users list, and although I 
have had some help I still have the problem.  I am posting this here in 
the hope that someone on this list might have seen this problem before 
and can give some pointers.

I apologise to those people who are on both lists.

-------- Original Message --------
Hi All,

I though a recent upgrade of MailScanner had cured me of this problem,
but 20 minutes ago MailWatch suddenly stopped logging any values of
sascore or sareport.  It still logged details of emails processed but
sascore and sareport are both NULL.  MailScanner is correctly marking
emails still and they are still filtered properly.  It just stops
logging these values in MailWatch.

It has run for about 5 days now without showing this behaviour.  It is
very difficult to track down, as if I leave DBItrace running for 5 days
the file gets huge.  And a restart of MailScanner cures the problem, so
switching DBItrace on when I see the problem occur doesn't help.  :-(

If anybody has seen something similar or can give me some pointers I
would be very grateful.

I may post this to the MailScanner-users list as well to see if I reach
a different audience...

Steve Freegard wrote:
> Hi Anthony,
> 
> On Fri, 2006-04-28 at 07:40 +0100, Anthony Peacock wrote:
>> Every so often, MailWatch stops logging the SpamAssassin score.  All 
>> other details still get logged, except the sascore is always NULL in the 
>> database.  MailScanner and SpamAssassin are correctly scoring, marking 
>> and filtering the emails so the system is working as expected except 
>> that when I check the MailWatch web page none of the emails are marked 
>> as spam.
>>
>> As stop and start of mailscanner clears this problem up and there does 
>> not appear to be any residual problems.
>>
>> As I said I did investigate this earlier this week and couldn't see 
>> anything obvious in the logs or DBItrace.  This appears to be something 
>> that happens after a period of time.  Any ideas would be appreciated.
> 
> Very strange indeed as sascore gets no particular special attention by
> MailWatch.pm.
> 
> The only thing that I know causes NULL to be written to the column is
> when a message has been whitelisted.
> 
> Only thing you could try is to disable the SpamAssassin cache
> temporarily and see if that solves the problem as this is the only thing
> I can think of that changes sascore in the recent versions of
> MailScanner.
> 
> Kind regards,
> Steve.
> 
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Mailwatch-users mailing list
> Mailwatch-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mailwatch-users
> 
> 


-- 
Anthony Peacock
CHIME, Royal Free & University College Medical School
WWW:    http://www.chime.ucl.ac.uk/~rmhiajp/
"The most exciting phrase to hear in science, the one that heralds new
discoveries, is not 'Eureka!' but 'That's funny....'" -- Isaac Asimov


-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job 
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Mailwatch-users mailing list
Mailwatch-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mailwatch-users



-- 
Anthony Peacock
CHIME, Royal Free & University College Medical School
WWW:    http://www.chime.ucl.ac.uk/~rmhiajp/
"The most exciting phrase to hear in science, the one that heralds new 
discoveries, is not 'Eureka!' but 'That's funny....'" -- Isaac Asimov