Re: Personal Bayes Score
Matthew Yette wrote: Dankos, Put this into your /etc/mail/spamassassin/local.cf: user_scores_sql_custom_querySELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '@GLOBAL' OR username = _DOMAIN_ ORDER BY username ASC That will make per-user preferences priority, and then roll back to the GLOBAL if the user doesn't have a preference specified. If i running spamd with -u [user] option and use your configuration, GLOBAL configuration never used, is that correct ? If no, what is the correct parameter i must use ? Regards, dankos. ___ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com
Re: Personal Bayes Score
Hello Dhanny, Sunday, July 31, 2005, 12:08:51 AM, you wrote: DK> Hi, DK>I installed qmail (only for smtp proxy) + spamassassin (userpref, DK> bayes, awl store in mySQL). I use spamd and spamc to scan every email, DK> but how can spamc scan email with personal configuration after scan DK> with global configuration ? Do you need two scans, global then personal? Or will one scan, global with personal overrides, do? SA is designed to do the latter. You need to have qmail (or the equivalent) identify which user the email is being delivered to, and call spamd/spamc specifying that user's id. Then spamc will automatically grab the system configs, the user's user_prefs, bayes, and awl, and apply that combination to the scan. I don't know to what extent that's possible with qmail, but that's the point at which the userid needs to be identified and passed to spamd. Bob Menschel
RE: Personal Bayes Score
Dankos, Put this into your /etc/mail/spamassassin/local.cf: user_scores_sql_custom_querySELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '@GLOBAL' OR username = _DOMAIN_ ORDER BY username ASC That will make per-user preferences priority, and then roll back to the GLOBAL if the user doesn't have a preference specified. Matt -- Matthew Yette Senior Engineer - NOC/Operations MA Polce Consulting, Inc. [EMAIL PROTECTED] 315-838-1644 (w) 315-356-0597 (f) AIM/Yahoo: MAPolceNOC MSN: [EMAIL PROTECTED] -Original Message- From: Dhanny Kosasih [mailto:[EMAIL PROTECTED] Sent: Sunday, July 31, 2005 3:09 AM To: users@spamassassin.apache.org Subject: Personal Bayes Score Hi, I installed qmail (only for smtp proxy) + spamassassin (userpref, bayes, awl store in mySQL). I use spamd and spamc to scan every email, but how can spamc scan email with personal configuration after scan with global configuration ? I want my user can configure bayesian, userpref, or awl for him self via web base, how can i do this ? This is the architecture : email <--> qmail (proxy) <--> qmail <--> inbox OS : Redhat Fedora Core 3 SpamAssassin 3.0.4 MySQL Regards, Dankos.