Dear Adam, Thanks. It is working fine.
As same as your problem, my user-defined rules are still duplicated in local.cf. However I don't think modification on local.cf for user is a good idea. We have to wait for bug fix. Anyone have the work around? Best Regards Patrick Tsang ----- Original Message ----- From: "Adam Denenberg" <[EMAIL PROTECTED]> To: "Patrick T. Tsang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 12:27 PM Subject: Re: [SAtalk] mysql user rules (no local.cf definition) > Yes i have "allow_user_rules" set to 1 in the local.cf. It doesnt seem to > help though, i still need to define the entire rule however in the local.cf > file. I define the rule in the DB as follows: > > mysql> select * from userpref where username='[EMAIL PROTECTED]' and preference > like "%ADAM%"; > +----------------+---------------------+-------------------------+--------+- --- > ---+ > | username | preference | value | prefid | > valid | > +----------------+---------------------+-------------------------+--------+- --- > ---+ > | [EMAIL PROTECTED] | score ADAM_RULE1 | 40 | 555 | > NULL | > | [EMAIL PROTECTED] | header ADAM_RULE1 | Subject =~ /adamtest99/ | 554 | > NULL | > | [EMAIL PROTECTED] | describe ADAM_RULE1 | TEST RULE FOR ADAM | 556 | > NULL | > +----------------+---------------------+-------------------------+--------+- --- > ---+ > > hope that answers your question. Now if someone can just solve mine :-) > > thanks > adam > > > Quoting "Patrick T. Tsang" <[EMAIL PROTECTED]>: > > > Dear Adam, > > > > I am using Webuserprefs such that each user will use his/her rules > > but it cannot support Header and Body test. > > > > > > so I am very interested in your works. > > > > 1. How can I include the user-defined Header test in Mysql? > > 2. What about Body test? > > > > In the Mysql db schema, I can't see any enough fields to do these. > > Totally confused... > > > > In your question, I don't know "allow_user_rules 1" should help you or not. > > It doesn't make sense if the rules should be in local.cf file. > > > > > > Best Regards > > Patrick Tsang > > ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
