<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-15">
<META content="MSHTML 6.00.2900.3562" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Segoe UI">
<DIV>Julian,</DIV>
<DIV>&nbsp;</DIV>
<DIV>Better.&nbsp;&nbsp;The spam report field&nbsp;is populated now but I don't think it is completely fixed.&nbsp; See below:</DIV>
<DIV>&nbsp;</DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>Spam:</TD><TD class=detail><SPAN class=YES>&nbsp;Y&nbsp;</SPAN>&nbsp;&nbsp;Action(s): store, deliver, header, "X-Spam-Status:, Yes"</TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>High Scoring Spam:</TD><TD class=detail><SPAN class=NO>&nbsp;N&nbsp;</SPAN></TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>SpamAssassin Spam:</TD><TD class=detail><SPAN class=NO>&nbsp;N&nbsp;</SPAN></TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>Listed in RBL:</TD><TD class=detail><SPAN class=NO>&nbsp;Y&nbsp;</SPAN></TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>Spam Whitelisted:</TD><TD class=detail><SPAN class=NO>&nbsp;N&nbsp;</SPAN></TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>Spam Blacklisted:</TD><TD class=detail><SPAN class=NO>&nbsp;N&nbsp;</SPAN></TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>SpamAssassin Autolearn:</TD><TD class=detail><SPAN class=NO>&nbsp;N&nbsp;</SPAN></TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>SpamAssassin Score: </TD><TD class=detail>3.09</TD></TR> </FONT></DIV>
<DIV><TR><TD class=heading align="right" width="175" valign="top"><FONT color=#0000ff>Spam Report: </TD><TD class=detail>spam, SBL+XBL</FONT></DIV>
<DIV><FONT color=#0000ff></FONT>&nbsp;</DIV>
<DIV>I confirmed that the database shows <FONT color=#0000ff>spam, SBL+XBL </FONT><FONT color=#000000>only.&nbsp;&nbsp;Problem that I see is that there is nothing in the spamreport field to explain the 3.09 SpamAssassin score.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#000000>Gary</TD></TR></FONT></DIV>
<DIV><BR><BR>&gt;&gt;&gt; Julian Field &lt;MailScanner@ecs.soton.ac.uk&gt; 6/26/2009 4:41 AM &gt;&gt;&gt;<BR>Aha, well done for tracking down that case, I've been looking for that <BR>bug for ages.<BR>Due to your diagnostics I now have what should fix it.<BR><BR>Please try the attached patch to <BR>/usr/lib/MailScanner/MailScanner/Message.pm and then restart MailScanner.<BR><BR>Thanks for helping!<BR>Jules.<BR><BR>On 26/06/2009 05:08, Gary Faith wrote:<BR>&gt; Follow Up!&nbsp; After doing more digging, I believe that I have found the <BR>&gt; common thread when the problem occurs.&nbsp; The spamreport field only <BR>&gt; seems to be blank when isspam &amp; isrblspam flags are set.&nbsp; If issaspam <BR>&gt; and/or ishighspam are set then spamreport has data.<BR>&gt; isspam&nbsp;&nbsp;&nbsp; tinyint(1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =1<BR>&gt; ishighspam&nbsp; tinyint(1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =0<BR>&gt; issaspam&nbsp; tinyint(1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =0<BR>&gt; isrblspam&nbsp; tinyint(1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =1<BR>&gt; spamwhitelisted&nbsp; tinyint(1)&nbsp;&nbsp;&nbsp; =0<BR>&gt; spamblacklisted&nbsp; tinyint(1)&nbsp;&nbsp;&nbsp; =0<BR>&gt; sascore&nbsp; decimal(7,2)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; some value<BR>&gt; spamreport&nbsp; text&nbsp;&nbsp; {Empty}<BR>&gt; I hope this helps shine light on my problem.&nbsp; Any ideas why this is <BR>&gt; happening?<BR>&gt; Thanks,<BR>&gt;<BR>&gt; Gary<BR>&gt;<BR>&gt; &gt;&gt;&gt; "Gary Faith" &lt;gafaith@asdm.net&gt; 6/25/2009 11:14 PM &gt;&gt;&gt;<BR>&gt; Running MailScanner 4.75.11 on SLES 10 SP2 X86_64.&nbsp; When viewing the <BR>&gt; information via MailWatch, I see the following on the details page:<BR>&gt; SpamAssassin Spam: Y&nbsp;&nbsp; Action(s): store, deliver, header, <BR>&gt; "X-Spam-Status:, Yes"<BR>&gt; High Scoring Spam: N<BR>&gt; SpamAssassin Spam: N<BR>&gt; Listed in RBL: N<BR>&gt; Spam Whitelisted: N<BR>&gt; Spam Blacklisted: N<BR>&gt; SpamAssassin Autolearn: N<BR>&gt; SpamAssassin Score:1.66<BR>&gt; The problem is Spam Report is blank.&nbsp; This happens on a few seemingly <BR>&gt; random messages while most have something in the spamreport field.&nbsp; I <BR>&gt; have verified this in the database that it definitely null.&nbsp; Any <BR>&gt; reason why all the data except the spam report would be logged to <BR>&gt; mysql?&nbsp; Could this be a spamassassin timeout problem?<BR>&gt; Thanks,<BR>&gt;<BR>&gt; Gary Faith<BR><BR>Jules<BR><BR>-- <BR>Julian Field MEng CITP CEng<BR>www.MailScanner.info<BR>Buy the MailScanner book at www.MailScanner.info/store<BR><BR>Need help customising MailScanner?<BR>Contact me!<BR>Need help fixing or optimising your systems?<BR>Contact me!<BR>Need help getting you started solving new requirements from your boss?<BR>Contact me!<BR><BR>PGP footprint: EE81 D763 3DB0 0BFD E1DC 7222 11F6 5947 1415 B654<BR>Follow me at twitter.com/JulesFM and twitter.com/MailScanner<BR><BR><BR>-- <BR>This message has been scanned for viruses and<BR>dangerous content by MailScanner, and is<BR>believed to be clean.<BR><BR></DIV></BODY></HTML>