[SAtalk] SQL Integration
What per-user preferences are supported by the mysql integration? Just the basics like required_hits and white/blacklisting, or is it possible to support more? Thanks. --- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html ___ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
Re: [SAtalk] SQL Integration
Hi, strange, it's ignoring pretty much anything else I ask it to do via mysql. Is there anything would override mysql preferences? Carl R. Friend said: On Sat, 10 Jan 2004, Andrew Cranson wrote: What per-user preferences are supported by the mysql integration? Just the basics like required_hits and white/blacklisting, or is it possible to support more? Thanks. The per-user configurability capabilities of the MySQL interface go well beyond white/black-list and required hits. Whilst those are sufficient for average users, it's also possible to override scores on a per-user basis and either raise/lower per-rule scores or even disable specific tests. The latter is important for people who routinely communicate with sites that, for whatever reason, are listed in a DNS-blacklists, and if a site is implementing hightly-custom rules. Cheers. ++-+ | Carl Richard Friend (UNIX Sysadmin)| West Boylston | | Minicomputer Collector / Enthusiast| Massachusetts, USA | | mailto:[EMAIL PROTECTED]+-+ | http://users.rcn.com/crfriend/museum | ICBM: 42:22N 71:47W | ++-+ --- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html ___ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
Re: [SAtalk] SQL Integration
On Sat, 10 Jan 2004, Andrew Cranson wrote: What per-user preferences are supported by the mysql integration? Just the basics like required_hits and white/blacklisting, or is it possible to support more? Thanks. The per-user configurability capabilities of the MySQL interface go well beyond white/black-list and required hits. Whilst those are sufficient for average users, it's also possible to override scores on a per-user basis and either raise/lower per-rule scores or even disable specific tests. The latter is important for people who routinely communicate with sites that, for whatever reason, are listed in a DNS-blacklists, and if a site is implementing hightly-custom rules. Cheers. ++-+ | Carl Richard Friend (UNIX Sysadmin)| West Boylston | | Minicomputer Collector / Enthusiast| Massachusetts, USA | | mailto:[EMAIL PROTECTED]+-+ | http://users.rcn.com/crfriend/museum | ICBM: 42:22N 71:47W | ++-+ --- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html ___ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
Re: [SAtalk] SQL Integration
Hi, See http://www.mail-archive.com/[EMAIL PROTECTED]/msg03016.html * http://nyx.ilk.com/qsspam/ There is a mention of a delete_mail_threshold. I have been trying to implement that via mySQL but it doesn't appear to be doing anything. Is there a component require that includes this function, or should it be included by default? (SA 2.61) Thanks Carl R. Friend said: On Sat, 10 Jan 2004, Andrew Cranson wrote: Hi, strange, it's ignoring pretty much anything else I ask it to do via mysql. Is there anything would override mysql preferences? What do your per-user SQL preferences look like? In order to override a stock score one must specify score RULE_NAME for the preference column and the desired score in the value column. To wit, one of my pet peeves is invisible HTML text, so I over-rode the default with a SQL sequence of: insert into userpref (username,preference,value) values ('crfriend','score HTML_FONT_INVISIBLE','3.0'); If you're missing the score component, it will not work properly (been there, done that). In general, the syntax in the MySQL database is identical to that in the various *.cf files. Cheers. ++-+ | Carl Richard Friend (UNIX Sysadmin)| West Boylston | | Minicomputer Collector / Enthusiast| Massachusetts, USA | | mailto:[EMAIL PROTECTED]+-+ | http://users.rcn.com/crfriend/museum | ICBM: 42:22N 71:47W | ++-+ --- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html ___ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
Re: [SAtalk] SQL Integration
On Sat, 10 Jan 2004, Andrew Cranson wrote: See http://www.mail-archive.com/[EMAIL PROTECTED]/msg03016.html * http://nyx.ilk.com/qsspam/ There is a mention of a delete_mail_threshold. I have been trying to implement that via mySQL but it doesn't appear to be doing anything. Is there a component require that includes this function, or should it be included by default? (SA 2.61) Any notion of a delete_mail threshold must reside within your qmail setup and not within SpamAssassin. SpamAssassin *only* tags e-mail as *possible* spam; it *never* deletes it. Any deletion of tagged messages (note that I did not say, spam) is up to the delivery agent that follows SA in the delivery pipe. As delivered, SA *cannot* delete e-mail. Nor, in my humble opinion, should it. Sooner or later you *will* get a false-positive, and if your system is designed to delete tagged-mail then you *will* lose that message, irretrievably, forever. Cheers. ++-+ | Carl Richard Friend (UNIX Sysadmin)| West Boylston | | Minicomputer Collector / Enthusiast| Massachusetts, USA | | mailto:[EMAIL PROTECTED]+-+ | http://users.rcn.com/crfriend/museum | ICBM: 42:22N 71:47W | ++-+ --- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html ___ Spamassassin-talk mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/spamassassin-talk