> -----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