[Mimedefang] Potential SA Problem for load_scoreonly_sql
Kevin A. McGrail
kmcgrail at pccc.com
Sat Jun 2 10:35:20 EDT 2007
> 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
More information about the MIMEDefang
mailing list