Merging 2 Bayes Databases

[Dhawal Doshy]

Daniel Maher wrote:
> That would certainly work, yes. :)

Paul,

You might want to read this..
http://wiki.mailscanner.info/doku.php?id=documentation:anti_spam:spamassassin:bayes:sql

- dhawal

> -----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 12:03 PM
> To: MailScanner discussion
> Subject: RE: Merging 2 Bayes Databases
> 
> 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'
> 
>