On Fri, Jul 09, 2004 at 03:26:02PM -0500, Dallas L. Engelken wrote: > mysql> select username,preference,value from sa_rules where preference > like 'score%' limit 2; > +-----------+-------------------------+-------+ > | username | preference | value | > +-----------+-------------------------+-------+ > | %nmgi.com | score USER_IN_BLACKLIST | 10 | > | $GLOBAL | score USER_IN_BLACKLIST | 10 | > +-----------+-------------------------+-------+ > > Works fine as you can see here... > > [EMAIL PROTECTED] Conf]# echo -e "From: [EMAIL PROTECTED]" | spamc -u > '[EMAIL PROTECTED]' | grep USER_IN_BLACKLIST > * 10 USER_IN_BLACKLIST From: address is in the user's > black-list
I'm not sure why I didn't think of that. I'd put "score" in preference and "USER_IN_BLACKLIST 10" in value. What you've done makes more sense I think. > And I know I've tested "describe RULE" as the preference in the past > and it works just fine also. > > Give it a shot... I don't think there is a need to change this code. > > The only thing that doesn't work with SQL prefs is defining new rules.. > > Body, header, full, etc. You can change the describe and score via SQL, > but for some reason, new rules cannot be read in from SQL due to the > timing of the call I believe. I haven't dug much deaper than that. Certainly the way I was doing it allowed definition of new rules. Given the way the code works I don't see why it wouldn't work the way you describe. Tim. -- Tim Bishop http://www.bishnet.net/tim PGP Key: 0x5AE7D984
