SA 3.0.2 and MySQL

[Steen, Glenn]

> -----Original Message-----
> From: MailScanner mailing list 
> [mailto:MAILSCANNER at JISCMAIL.AC.UK] On Behalf Of Pete Russell
> Sent: den 6 april 2005 12:16
> To: MAILSCANNER at JISCMAIL.AC.UK
> Subject: Re: SA 3.0.2 and MySQL
> 
> 
> ?
Well... I would've done it myself if I had the time... But Real
Work(tm) is limiting that resource for me ATM...
Aparantly Dahwal would've too, but failed somehow (can't imagine
how, seeing as it is so simple:-).

Cheers
-- Glenn

> 
> I will add this to the wiki on his behalf.
> 
> Kind regards and thanks for providing this doco. I am going 
> to try it on
> a new test machine i am building next week.
> 
> Thanks again
> Pete
> 
> Steen, Glenn wrote:
> > Will you take this Peter?
> > Or perhaps better... Dahwal, driop Ugo a line and join in 
> the fun...:-).
> >
> > -- Glenn
> >
> >     -----Original Message-----
> >     *From:* MailScanner mailing list 
> [mailto:MAILSCANNER at JISCMAIL.AC.UK]
> >     *On Behalf Of *Dhawal Doshy
> >     *Sent:* den 5 april 2005 18:41
> >     *To:* MAILSCANNER at JISCMAIL.AC.UK
> >     *Subject:* Re: SA 3.0.2 and MySQL
> >
> >     Pete Russell wrote:
> >
> >>     Mmm that sounds like a treat. Would make a great 
> addition to the new
> >>     wiki documentation project.
> >>
> >>     Care to write a guide and post it up?
> >
> >     okay, here goes, apologies for the HTML:
> >
> >     You'll need the perl-DBI and perl-DBD-MySQL modules 
> installed before
> >     you try this.
> >
> >     _Assumptions and Variables:_
> >     SpamAssassin Bayes Database Name: *sa_bayes*
> >     SpamAssassin Bayes Database UserName: *sa_user*
> >     SpamAssassin Bayes Database Password: *sa_password*
> >     Your database server's real name: *local_fqdn*
> >     Every other server that'll connect to and use this 
> database, this
> >     name should be resolvable by the DNS or /etc/hosts: 
> *remote_fqdn*
> >
> >     First of all, create a database where you intend on storing the
> >     bayesian information
> >     /# mysql -u root -p/ #(some distros like redhat and 
> clones have no
> >     password set by default.)
> >     /mysql> create database sa_bayes;
> >     mysql> GRANT ALL ON *sa_bayes*.* TO *sa_user*@localhost 
> IDENTIFIED
> >     BY '*sa_password*';
> >     mysql> GRANT ALL ON *sa_bayes*.* TO *sa_user*@*local_fqdn*
> >     IDENTIFIED BY '*sa_password*';
> >     mysql> GRANT ALL ON *sa_bayes*.* TO *sa_user*@*remote_fqdn*
> >     IDENTIFIED BY '*sa_password*';
> >     /
> >     Locate the bayes_mysql.sql file
> >     For RedHat(like) systems:
> >     /usr/share/doc/spamassassin-%version%/sql/bayes_mysql.sql
> >
> >     /# mysql -u sa_user -p sa_bayes < /path/to/bayes_mysql.sql/
> >
> >     Now backup your current bayes database:
> >     /sa-learn -p /path/to/spam.assassin.prefs.conf --backup >
> >     sa_bayes_backup.txt
> >     sa-learn -p /path/to/spam.assassin.prefs.conf --clear 
> #(optional,
> >     incase you want to rollback)
> >     /
> >     Make some changes to your spam.assassin.prefs.conf, on 
> remote (MS
> >     Front-end) servers replace '*localhost*' with the value of
> >     '*local-fqdn*'
> >
> >     bayes_store_module      Mail::SpamAssassin::BayesStore::SQL
> >     bayes_sql_dsn           DBI:mysql:*sa_bayes:localhost*
> >     bayes_sql_username      *sa_user*
> >     bayes_sql_password      *sa_password*
> >     *
> >     *and comment out the following lines
> >     bayes_path /etc/MailScanner/bayes/bayes
> >     bayes_file_mode 0660
> >
> >     Now for recovering the bayes_dbm to bayes_sql
> >     /# sa-learn -p /path/to/spam.assassin.prefs.conf --restore
> >     sa_bayes_backup.txt/
> >
> >     And finally the acid test
> >     /# spamassassin -x -D -p 
> /path/to/spam.assassin.prefs.conf --lint/
> >
> >     Check for lines like
> >     debug: bayes: Database connection established
> >     debug: bayes: found bayes db version 3
> >     debug: bayes: Using userid: 2
> >     and some more like
> >     debug: bayes: tok_get_all: Token Count: 20
> >     debug: bayes token 'somewhat' => 0.978
> >     debug: bayes: score = 0.845189622547555
> >
> >     Make sure you stop and start MailScanner..
> >
> >     Futther reading / discussion can be taken up here:
> >     /usr/share/doc/spamassassin-%version%/sql/README.bayes OR on the
> >     sa-users / sa-dev lists
> >
> >     cheers,
> >     - dhawal
> >
> >     PS: Any mistakes are entirely mine (any yours if you follow this
> >     blindly), please test thoroughly before you go production.
> >     Also i couldn't find any way to post this to the new wiki, can
> >     someone guide me?
> >     ------------------------ MailScanner list 
> ------------------------
> >     To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
> >     'leave mailscanner' in the body of the email.
> >     Before posting, read the MAQ (http://www.mailscanner.biz/maq/)
> >     and the archives 
> (http://www.jiscmail.ac.uk/lists/mailscanner.h> tml).
> >
> >     
> *Support MailScanner development - buy the 
> book off the website!*
> >
> > ------------------------ MailScanner list ------------------------
> > To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
> > 'leave mailscanner' in the body of the email.
> > Before posting, read the MAQ (http://www.mailscanner.biz/maq/)
> > and the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
> >
> > *Support MailScanner development - buy the book off the website!*
> 
> ------------------------ MailScanner list ------------------------
> To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
> 'leave mailscanner' in the body of the email.
> Before posting, read the MAQ (http://www.mailscanner.biz/maq/) and
> the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
> 
> Support MailScanner development - buy the book off the website!
> 

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the MAQ (http://www.mailscanner.biz/maq/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!