[Mimedefang] how do I train bayes MySQL when relayed

[Steffen Kaiser]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 26 Jun 2014, Justin Edmands wrote:

> Seems like lots of spam is slipping past. In turn, I would like to
> train/retrain my bayes database for the defang user. This is certainly
> just a relay so the mail is in and out without being stored. How do I
> train the database when it's MySQL. Do I need to go to my MDA and pull
> the .msg files and feed them to the sa-learn program?

See 
http://wiki.apache.org/spamassassin/BayesFaq?highlight=%28train%29|%28bayes%29

"Will I overtrain Spamassassin if I feed it all my hams and all my spams?

Answer: No. As long as you ensure that everything fed to Bayes is 
accurately classified, manually verified, then you can only improve Bayes' 
accuracy by training it on everything."

Esp. "accurately classified, manually verified"
I let users move SPAMs into a special IMAP folder, which content is learnt 
via sa-learn or spamd demon on a regular basis.

> Also, in the actual database I wanted to see the spam and ham count.
> Seems like so much ham and not much spam collected. Any reason this is
> incorrect?:
>
> mysql> select id,username,spam_count,ham_count,token_count from
> spamassassin.bayes_vars;
> +----+----------+------------+-----------+-------------+
> | id | username | spam_count | ham_count | token_count |
> +----+----------+------------+-----------+-------------+
> |  1 | defang   |        404 |     15794 |      203108 |
> +----+----------+------------+-----------+-------------+

If you did not trained the Bayes DB, it will not contain much.

> These might be dumb questions...sorry if RTFM is the only solution and
> I missed it somehow.

- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQEVAwUBU60SClGgR0+MU/4GAQLeawf8CG1SKjLj+kyLQqcigPbSM01FK7oX83Ct
uqANQRf/htFrfZBkLfPd1nCLDN2MDEy8TWtxMf8thD0TtWSN9kn91chS3ZtTVo2C
LoBIMuKtWqISn0gxtnoNESbnO2o7yhTSorCeJXWprV2PzwlWlSKzcBryjI9WJm2K
ShQCi+/vzBQGC3P6m0Jb19yadDSjfc2JvQuz+rO+fRkUaOfsvImCjhBkVHhC6Gqh
1lRC02jhKz+N07awpRTSi+DB+YmmYP16PgezAYBK/CDcH1xCgm3r7KtRPSYToH1l
2uI/z4Tmugpt6+t71RAoXfAPfnDstkGis4iRV8t9yDw+6V5QapcJ1g==
=NuIp
-----END PGP SIGNATURE-----