On that same note,
I was playing around with BAYES on a MS SQL Server...
(I followed the directions in the readme files and tweaked the mysql.sql
code to work for MS SQL in creation of the tables.)
The import worked fine (no errors that I could see).
sa-learn --D --backup >bayes-backup.txt)
Mod the CF files
sa-learn -D --restore bayes-backup.txt)
But no bayes tests seem to hit since modifying the local.cf for the new
bayes store..
I can see the SQL traffic hitting the database, but nothing seems to be
hitting BAYES_** at all.
Any ideas?
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:ODBC:driver={SQL
Server};server=servername;database=database
bayes_sql_username login
bayes_sql_password password
bayes_sql_override_username username
I did the import from another box, but all seemed fine after I added the
preceding lines to the prod server and I was getting SQL activity (same
lines on the local.cf on the box I imported from).
As well, deleting the newly added local.cf lines returned Bayes to
normal operation (albeit file based).
Any help would be appreciated.
Thanks,
Steven
-----Original Message-----
From: Michael Parker [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 12, 2005 10:11 AM
To: users@spamassassin.apache.org
Subject: Re: SQL Question
On Thu, May 12, 2005 at 05:47:26PM +0100, Alan Munday wrote:
>
> Thanks, though I can't seem to find the Docs that cover bayes/AWL
setup on
> the Wiki or apache site.
>
> Are there any docs that are considered definitive around?
>
sql/README.bayes
sql/README.awl
is the definitive documentation.
You can also find things on the wiki and the SQL presentation here:
http://people.apache.org/~parker/presentations/
Michael
