Gary V-2 wrote:
>
>>I'm running amavisd-new with spamassassin and setup bayes and mysql
earlier
>>today. It seems to connect to the db fine with user vscan when running
>>spamassassin -d. I ran sa-learn --spam/ham < spam.txt (full email
headers
>>too) a few times and those are the only entires in the db, the ones that
I
>>added, all other email is untouched. What's the deal? Here is my
local.cf
>>file... awl seems to work fine, but it scores mail funky sometimes.
>>
>># Enable the Bayes system
>>use_bayes 1
>>bayes_store_module Mail::SpamAssassin::BayesStore::SQL
>>bayes_sql_dsn DBI:mysql:bayes
>>bayes_sql_username vscan
>>bayes_sql_password vscan
>>bayes_sql_override_username vscan
>>
>># Enable awl
>>auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
>>user_awl_dsn DBI:mysql:bayes
>>user_awl_sql_username vscan
>>user_awl_sql_password vscan
>>
>>--
>
> You probably ran the commands as root, so you are only looking at root's
> data. Add this in local.cf:
>
> bayes_sql_override_username vscan
>
> That way everyone will see the same data (site wide configuration). You
> want
> to always run spamassassin and sa-learn commands as the vscan user but
> adding this seting means that even if you learn spam or ham as root,
> vscan's
> data will be updated.
>
> su vscan -c 'sa-learn --spam < spam.txt'
>
> Gary V
The command was run as user vscan (amavisd-new user and spamassassin user).
If you look closer you will see that my config already has that directive.
Indeed, I missed it.
Not related, but if running MySQL 4.1 or newer, change:
Mail::SpamAssassin::BayesStore::SQL
to
Mail::SpamAssassin::BayesStore::MySQL
I would run
amavisd stop
amavisd -d bayes debug-sa
then send a message containing the gtube string through it. Send the message
from the outside world (smtp), not from the local machine. See what
amavisd-new thinks of Bayes.
Gary V
_________________________________________________________________
Get a preview of Live Earth, the hottest event this summer - only on MSN
http://liveearth.msn.com?source=msntaglineliveearthhm
