Dankos, Put this into your /etc/mail/spamassassin/local.cf:
user_scores_sql_custom_query SELECT 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.
