Hi, My have try adam's setting but can't work,SA can't load the custom rule form mysql, can anyone help ?
----- Original Message ----- From: "Marcello Lupo" <[EMAIL PROTECTED]> Newsgroups: gmane.mail.spam.spamassassin.general Sent: Friday, December 12, 2003 1:39 AM Subject: Re: mysql user rules (no local.cf definition) > Hi to all, > i write to know if some one have thinked a solution for the problem of the > definition of the tests inside the mysql database, becouse i have the same > problem. I have to define the rules in the local.cf too and after i can > override the score in the database. > > Thanks to all, > Bye, > MArecello > > > > >Hello Adam, > >There is a work-around but not good at all. > >As Spamassassin will be looking at all the files under > >you can just made a user.cf file and conditionally restart spamd (I use RPM > >version). > >Quite a bad idea, though. > >Best Regards > >Patrick Tsang > > > > > > > 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 mail sent through IMP: http://horde.org/imp/ > > > > > > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. > Become an expert in LINUX or just sharpen your skills. Sign up for IBM's > Free Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
