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 > > > > ----- Original Message ----- > From: "Adam Denenberg" <[EMAIL PROTECTED]> > To: "Terry Milnes" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, November 27, 2003 5:50 AM > Subject: Re: [SAtalk] mysql user rules (no local.cf definition) > > > > no preferences work fine.. i mean rules as in > > > > header TEST_RULE Subject =~ /testsubject/ > > score TEST_RULE 100 > > description TEST_RULE 100 > > > > as of now, you need to define these in local.cf, then override them in > > the DB to make them work. If they only exist in the DB but not in > > local.cf, they never get analyzed. > > > > anyone have similar issues? > > > > thanks > > adam > > > > On Nov 26, 2003, at 3:31 PM, Terry Milnes wrote: > > > > > What do you mean by "user rules"? .... if you mean user preferences I > > > have preferences in mysql that are not in the local.cf and they do > > > work. > > > > > > Terry > > > > > > Adam Denenberg wrote: > > >> I believe Dallas touched on this some time ago when 2.55 was released > > >> but not sure of the status. It appears still that in order to have > > >> user > > >> rules work in a mysql database, they need to exist in the local.cf > > >> file > > >> still. I have been testing this all day and the only time i can get it > > >> to work was when i had defined all 3 (header, describe, score) in > > >> local.cf and then simply overrode the score preference in mysql. > > >> Can anybody offer assistance as to how to fix this so that actual > > >> rules > > >> can be placed in mysql? > > >> thanks > > >> adam > > >> ------------------------------------------------------- > > >> 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 > > > > > > > > > > > > ------------------------------------------------------- > > > 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 > > > > > > > > > > > ------------------------------------------------------- > > 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 > > > > > > > ------------------------------------------------------- > 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 > > ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ ------------------------------------------------------- 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
