[Maia-users] Some rules not loading

[Robert Fitzpatrick]

I had a message picked up as spam on our production server (amavisd-new,
not maia) this morning and came to test the same message against our
test server we have up with Maia. I cannot find one of the rules,
CTYPE_001C_A, in the database. I ran load-sa-rules.pl to find no new
rules. Then, I explicity set the folders in maia.conf and ran it again,
but still not there, however it did find one new rule after changing my
updates dir from 'undef'. Where else can I look to find why this rule,
and perhaps others are not loading? Is my SQL query correct below to
find the rule?

$local_cf_dir = "/etc/mail/spamassassin";
$system_rules_dir = "/var/db/spamassassin/%%VERSION%%";  # sa-update

mx1# /etc/periodic/daily/822.webtent-sa-update
2007-08-21 09:21:31 Maia: [load-sa-rules] Adding new rule: TVD_PDF_FINGER01 (Mail matches standard pdf spam fingerprint)
2007-08-21 09:22:55 Maia: [load-sa-rules] 1 new rules added (1463 rules total), all scores updated.

mx1# grep
CTYPE_001C_A /var/db/spamassassin/3.002001/updates_spamassassin_org/72_active.cf
##{ CTYPE_001C_A
header CTYPE_001C_A Content-Type =~ /multipart.{0,200}boundary=
\"----=_NextPart_000_0001_01C[0-9A-F]{5}\.[0-9A-F]{7}0\"/
##} CTYPE_001C_A

mx1# /etc/periodic/daily/822.webtent-sa-update
2007-08-21 09:21:31 Maia: [load-sa-rules] Adding new rule:
TVD_PDF_FINGER01 (Mail matches standard pdf spam fingerprint)
2007-08-21 09:22:55 Maia: [load-sa-rules] 1 new rules added (1463 rules
total), all scores updated.
No Update:       MSRBL-Images.hdb  Available Tue Aug 21 09:22:57 EDT
2007
No Update:       MSRBL-SPAM.ndb  Available Tue Aug 21 09:22:57 EDT 2007
No Update:       phish.ndb  Available Tue Aug 21 09:22:59 EDT 2007
No Update:       scam.ndb  Available Tue Aug 21 09:22:59 EDT 2007
Stopping amavisd.
Waiting for PIDS: 21214.
Starting amavisd.

maia=> select * from maia_sa_rules where rule_name = 'CTYPE_001C_A';
 id | rule_name | rule_description | rule_score_0 | rule_score_1 |
rule_score_2 | rule_score_3 | rule_count 
----+-----------+------------------+--------------+--------------+--------------+--------------+------------
(0 rows)


-- 
Robert