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 On Mon, 2003-07-28 at 15:38, Adam Denenberg wrote: > cool. Does that mean that we could define "header" and "describe" > paramters in the DB as well ? > > as well in the tables for each user or domain? > > thanks > adam > > On Mon, 2003-07-28 at 14:41, Dallas L. Engelken wrote: > > > -----Original Message----- > > > From: Adam Denenberg [mailto:[EMAIL PROTECTED] > > > Sent: Monday, July 28, 2003 1:28 PM > > > To: Dallas L. Engelken > > > Cc: SA-Talk > > > Subject: RE: [SAtalk] custom rules with mysql > > > > > > > > > I am actually using prefs perfectly with the DB. > > > > > > My question is if i can use the DB to create "rules" for > > > users. Like putting something like > > > > > > > ah, well you're last message said "per-domain/user", so i was answering > > based on your requirement. > > > > > header BAD_SUBJECT Subject =~ test > > > score BAD_SUBJECT 3.0 > > > > > > stuff like that in the DB > > > > > > > yes you can. i use score to override the default whitelist_from and > > blacklist_from scores... i guess i've never wrote a custom rule via > > sql, but it should work also. > > > > mysql> select * from sa_rules where username = "[EMAIL PROTECTED]"; > > +-----+------------------+-------------------------+----------------+--- > > -------+---------------------+----------------+ > > | id | username | preference | value | > > descript | added | modified | > > +-----+------------------+-------------------------+----------------+--- > > -------+---------------------+----------------+ > > | 14 | [EMAIL PROTECTED] | whitelist_from | [EMAIL PROTECTED] | > > test | 2003-05-23 16:11:38 | 20030523161138 | > > | 86 | [EMAIL PROTECTED] | report_safe | 0 | > > NULL | 2003-05-30 16:29:46 | 20030530162946 | > > | 85 | [EMAIL PROTECTED] | subject_tag | [SPAM-_HITS_]- | > > NULL | 2003-05-30 16:29:46 | 20030530162946 | > > | 84 | [EMAIL PROTECTED] | rewrite_subject | 1 | > > NULL | 2003-05-30 16:29:46 | 20030530162946 | > > | 82 | [EMAIL PROTECTED] | required_hits | 4 | > > NULL | 2003-05-30 16:29:46 | 20030530162946 | > > | 83 | [EMAIL PROTECTED] | delete_hits | 9 | > > NULL | 2003-05-30 16:29:46 | 20030530162946 | > > | 120 | [EMAIL PROTECTED] | score USER_IN_WHITELIST | -10 | > > NULL | 2003-07-28 13:39:18 | 20030728133923 | > > | 121 | [EMAIL PROTECTED] | score USER_IN_BLACKLIST | 10 | > > NULL | 2003-07-28 13:39:18 | 20030728133923 | > > +-----+------------------+-------------------------+----------------+--- > > -------+---------------------+----------------+ > > 8 rows in set (0.00 sec) > > > > > > 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 > > > > > > ------------------------------------------------------- > 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 > ------------------------------------------------------- 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
