On 7/25/11 10:24 AM, Jason Ede wrote:
We’ve 2 reasonably powerful mail servers handling incoming email and
sharing the load. We’ve moved to a single bayes database (to make
training easier) and its stored in mariadb and all of the bayes tables
are innodb
# mysql -V
mysql Ver 14.16 Distrib 5.2.7-MariaDB, for unknown-linux-gnu (x86_64)
using readline 5.1
The bayes settings are…
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn DBI:mysql:bayes:localhost
bayes_sql_username sa_user
bayes_sql_password ********
bayes_sql_override_username root
bayes_expiry_max_db_size 1000000
missing this:
bayes_auto_expire 0
and only run the 'sa-learn –force-expire' late at night, when no one is
doing anything.
--
Michael Scheidell, CTO
o: 561-999-5000
d: 561-948-2259
>*| *SECNAP Network Security Corporation
* Best Mobile Solutions Product of 2011
* Best Intrusion Prevention Product
* Hot Company Finalist 2011
* Best Email Security Product
* Certified SNORT Integrator
______________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.secnap.com/products/spammertrap/
______________________________________________________________________
