On 29/06/2011 4:58 PM, JKL wrote:
select count(spam_count) from bayes_vars
Run this query
SELECT username,spam_count,ham_count FROM bayes_vars
This will give a list of usernames that have been used to learn ham and
spam into SpamAssassin's Bayes MySQL DB. For a site-wide installation,
this should only return one result.
To answer your previous question, I meant to simply add the
bayes_sql_override_username setting to your local.cf and restart
spamassassin
If you are using Postfix with the postfix username, set it as
bayes_sql_override_username postfix
This ensures that all future e-mails are labeled as being learned from
the postfix user, regardless of whether you did it manually using
sa-learn via ssh or another interface, or auto-learning is used. For one
site-wide Bayes installation, this is what you want.
Regards,
Lawrence
