[Mimedefang] Potential SA Problem for load_scoreonly_sql

[Kevin A. McGrail]

> Right now, I've added logging for the actual SQL queries by modifying SA's 
> SQL.pm and I'll report back more on that.

I've added the logging by enabling the dbg messages in Conf/SQL.pm on the 
load_with_dbi routine.

And I'm clearing seeing the problem occurring.  Below are two emails to the 
same person.  One worked, one didn't.  The first is an email that did work. 
It loaded the preferences (note required=6.5):

Jun 2 09:09:08 intel1 mimedefang-multiplexor[26976]: Slave 3 stderr: 
config-dbi: Conf::SQL: executing SQL: select preference, value from userpref 
where username = 'olgcva-global' or username = '@GLOBAL' order by username 
asc at /usr/local/lib/perl5/site_perl/5.8.0/Mail/SpamAssassin/Conf/SQL.pm 
line 147.
Jun 2 09:09:08 intel1 mimedefang-multiplexor[26976]: Slave 3 stderr: 
config-dbi: retrieving prefs for olgcva-global from SQL server at 
/usr/local/lib/perl5/site_perl/5.8.0/Mail/SpamAssassin/Conf/SQL.pm line 152.

Jun 2 09:09:08 intel1 mimedefang-multiplexor[26976]: Slave 3 stderr: 
config-dbi: SQL prefs retrieved for olgcva-global - rewrite_header^ISubject 
*****SPAM***** required_hits^I6.5

Jun 2 09:09:08 intel1 mimedefang.pl[10851]: Enabling SPAM Filter from MD 
because of <dravia at domain4.org>

Jun 2 09:09:17 intel1 mimedefang.pl[10851]: SA-DEBUG: <dravia at domain4.org> - 
Yes, hits=38.4 required=6.5 
^Itests=BODY_ENHANCEMENT2,DK_POLICY_SIGNSOME,FB_HARD_ERECTION, ^I 
FM_NO_STYLE,HTML_FONT_BIG,HTML_MESSAGE,IMPOTENCE, ^I 
KAM_RPTR_MISSING,KAM_RR_60_79,LG_4C_2V_3C, ^I 
RAZOR2_CF_RANGE_51_100,RAZOR2_CF_RANGE_E4_51_100, ^I 
RAZOR2_CF_RANGE_E8_51_100,RAZOR2_CHECK,RCVD_IN_NJABL_DUL, ^I 
RCVD_IN_XBL,RM_rb_ANCHOR,RM_rb_FONT,RM_rb_HTML,RM_rb_PARA, ^I 
UNRESOLVED_TEMPLATE,URIBL_BLACK,URIBL_JP_SURBL, ^I 
URIBL_OB_SURBL,URIBL_SBL,URIBL_SC_SURBL,URIBL_WS_SURBL ^Iversion=3.1.4


And here's one shortly later that DID NOT work.  Note that there are no 
warnings from the SA Conf/SQL load_with_dbi routine and the required is 6.4. 
This means the database was not queried for the sql-based user preferences.
Jun 2 09:09:41 intel1 mimedefang.pl[14031]: Enabling SPAM Filter from MD 
because of <dravia at domain4.org>

Jun 2 09:09:48 intel1 mimedefang.pl[14031]: SA-DEBUG: <dravia at domain4.org> - 
Yes, hits=42.8 required=6.4 
^Itests=CUSTOM_RCVD_IN_MANY,DK_POLICY_SIGNSOME,FM_NO_STYLE, ^I 
HTML_FONT_BIG,HTML_MESSAGE,KAM_RR_80_99,KAM_TIME, ^I 
RAZOR2_CF_RANGE_51_100,RAZOR2_CF_RANGE_E4_51_100, ^I 
RAZOR2_CF_RANGE_E8_51_100,RAZOR2_CHECK, ^I 
RCVD_IN_BL_SPAMCOP_NET,RCVD_IN_DSBL,RCVD_IN_XBL, ^I 
REPLICA_WATCH,RM_rb_ANCHOR,RM_rb_FONT,RM_rb_HTML, ^I 
SARE_SPEC_ROLEX,SARE_SPEC_ROLEX_REP,UNRESOLVED_TEMPLATE, ^I 
UOLCC_ROLEX_BODY1,UOLCC_ROLEX_BODY3,UOLCC_WATCH_REPL, ^I 
URIBL_BLACK,URIBL_JP_SURBL,URIBL_OB_SURBL,URIBL_SBL, ^I 
URIBL_SC_SURBL,URIBL_WS_SURBL ^Iversion=3.1.4



Anyone have any ideas on a plan of attack?



Regards,
KAM