Merging 2 Bayes Databases

[Paul Houselander]

Hi

Thanks for the advice on this, ive now set it up so ive only used the
largest of the 2 bayes databases.

The mysql server this sits on is actually seperate from the 2 MailScanner
machines, my next question is what I should do with regards to expiry?

At the moment I have the following set in spam.assassin.prefs.conf on both
MailScanner machines

bayes_auto_expire 0

and the following in MailScanner.conf

Rebuild Bayes Every = 86400
Wait During Bayes Rebuild = yes

Im guessing I need to disable this on both MailScanner machines and set a
cron job a daily cronjob on the machine the mysql is on?

0 23 * * * /usr/bin/sa-learn --force-expire --sync -p
/etc/MailScanner/spam.assassin.prefs.conf

Is this correct?

Cheers

Paul

-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info
[mailto:mailscanner-bounces at lists.mailscanner.info]On Behalf Of Daniel
Maher
Sent: 27 June 2006 13:56
To: MailScanner discussion
Subject: RE: Merging 2 Bayes Databases


Hello,

Merging Bayes databases is not considered good form, and is difficult (or
impossible) for a very good reason, which is stated here:

http://article.gmane.org/gmane.mail.spam.spamassassin.general/60376

In summary, you'll end up duplicating large amounts of tokens, thus throwing
the integrity of the database into question.

  _
 °v°  Daniel Maher
/(_)\ Administrateur Système Unix
 ^ ^  Unix System Administrator

Sentio aliquos togatos contra me conspirare.


-----Original Message-----
From: mailscanner-bounces at lists.mailscanner.info
[mailto:mailscanner-bounces at lists.mailscanner.info] On Behalf Of Paul
Houselander
Sent: June 27, 2006 7:50 AM
To: MailScanner Mailing List
Subject: Merging 2 Bayes Databases

Hi

Ive got 2 front end Mailscanner machines and was looking at getting them to
share a bayes database.

Ive set up a mysql bayes and tested with both machines and it works fine.

What I want to do is dump both the existing Bayes DB's into it, is it as
simple as doing

sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --backup > host1.txt
sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --backup > host2.txt

Add the entries to spam.assassin.prefs.conf to use the mysql bayes and then
run

sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --restore host1.txt
sa-learn -p /etc/MailScanner/spam.assassin.prefs.conf --restore host2.txt

I dont know if merging 2 bayes databases from 2 different machines would
cause any problems?

Cheers

Paul



--
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website!
--
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read http://wiki.mailscanner.info/posting

Support MailScanner development - buy the book off the website!


This message has been scanned by VSL AVS 'Enterprise'