<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>Follow Up! After doing more digging, I believe that I have found the common thread when the problem occurs. The spamreport field only seems to be blank when isspam & isrblspam flags are set. If issaspam and/or ishighspam are set then spamreport has data.</DIV>
<DIV> </DIV>
<DIV>isspam tinyint(1) =1<BR>ishighspam tinyint(1) =0<BR>issaspam tinyint(1) =0<BR>isrblspam tinyint(1) =1<BR>spamwhitelisted tinyint(1) =0<BR>spamblacklisted tinyint(1) =0<BR>sascore decimal(7,2) some value<BR>spamreport text {Empty}<BR></DIV>
<DIV>I hope this helps shine light on my problem. Any ideas why this is happening?</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV><BR>Gary</DIV>
<DIV><BR>>>> "Gary Faith" <gafaith@asdm.net> 6/25/2009 11:14 PM >>><BR></DIV>
<DIV>Running MailScanner 4.75.11 on SLES 10 SP2 X86_64. When viewing the information via MailWatch, I see the following on the details page:</DIV>
<DIV> </DIV>
<DIV><TR><TD class=heading colspan="2" align="center" valign="top">SpamAssassin</TD></TR> <TR><TD class=heading align="right" valign="top" width="175">Spam:</TD><TD class=detail><SPAN class=YES> Y </SPAN> Action(s): store, deliver, header, "X-Spam-Status:, Yes"</TD></TR> </DIV>
<DIV><TR><TD class=heading align="right" valign="top" width="175">High Scoring Spam:</TD><TD class=detail><SPAN class=NO> N </SPAN></TD></TR> </DIV>
<DIV><TR><TD class=heading align="right" valign="top" width="175">SpamAssassin Spam:</TD><TD class=detail><SPAN class=NO> N </SPAN></TD></TR> </DIV>
<DIV><TR><TD class=heading align="right" valign="top" width="175">Listed in RBL:</TD><TD class=detail><SPAN class=NO> N </SPAN></TD></TR> </DIV>
<DIV><TR><TD class=heading align="right" valign="top" width="175">Spam Whitelisted:</TD><TD class=detail><SPAN class=NO> N </SPAN></TD></TR> </DIV>
<DIV><TR><TD class=heading align="right" valign="top" width="175">Spam Blacklisted:</TD><TD class=detail><SPAN class=NO> N </SPAN></TD></TR> </DIV>
<DIV><TR><TD class=heading align="right" valign="top" width="175">SpamAssassin Autolearn:</TD><TD class=detail><SPAN class=NO> N </SPAN></TD></TR> </DIV>
<DIV><TR><TD class=heading align="right" valign="top" width="175">SpamAssassin Score:</TD><TD class=detail>1.66</DIV>
<DIV> </DIV>
<DIV>The problem is Spam Report is blank. This happens on a few seemingly random messages while most have something in the spamreport field. I have verified this in the database that it definitely null. Any reason why all the data except the spam report would be logged to mysql? Could this be a spamassassin timeout problem?</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV><BR>Gary Faith</TD></TR></DIV></BODY></HTML>