> -----Original Message-----
> From: Adam Denenberg [mailto:[EMAIL PROTECTED] 
> Sent: Monday, July 28, 2003 4:10 PM
> To: Dallas L. Engelken
> Cc: SA-Talk
> Subject: RE: [SAtalk] custom rules with mysql
> 
> 
> dallas,
> 
>  in order to make a rule like 
> 
> Header   L_s_casino      Subject =~ /[EMAIL PROTECTED]/i
> describe L_s_casino      Subject mentions a casino (RM)
> score    L_s_casino      1.1
> 
> work, do you need to turn on allow_user_rules?
> 
>  having some difficulty getting this to work with mysql per user.
> 
> adam
> 
> 

allow_user_rules must be 1 in local.cf for this to work..... 

[EMAIL PROTECTED] NEW_INSTALL]# cat /etc/mail/spamassassin/local.cf
allow_user_rules 1

body TEST_SQL               /TEST_SQL/i
describe TEST_SQL            Test to see if spamd can pull SQL-based
body rules
score TEST_SQL  -10



mysql> select * from sa_rules where preference LIKE "%TEST_SQL%";
+-----+------------------+-------------------+------------------------+-
---------+---------------------+----------------+
| id  | username         | preference        | value                  |
descript | added               | modified       |
+-----+------------------+-------------------+------------------------+-
---------+---------------------+----------------+
| 127 | [EMAIL PROTECTED] | score TEST_SQL    | -0.1                   |
NULL     | 2003-07-28 16:18:11 | 20030728161824 |
| 128 | [EMAIL PROTECTED] | describe TEST_SQL | This is just a Test... |
NULL     | 2003-07-28 16:18:24 | 20030728161835 |
| 126 | [EMAIL PROTECTED] | body TEST_SQL     | /TEST_SQL/i            |
NULL     | 2003-07-28 16:07:58 | 20030728161811 |
+-----+------------------+-------------------+------------------------+-
---------+---------------------+----------------+
3 rows in set (0.01 sec)




[EMAIL PROTECTED] NEW_INSTALL]# echo -e "From: dallase\n\nTEST_SQL\n" | spamc
-u "[EMAIL PROTECTED]"
X-Spam-Report:   0.30 points, 4 required;
  * -0.1 -- BODY: This is just a Test...


notice how the local.cf score and the describe values for the rule
TEST_SQL was overridden via the SQL-prefs for [EMAIL PROTECTED]

dallas





-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk

Reply via email to