On 6/14/2011 1:23 PM, Marc Perkel wrote:
On 6/14/2011 10:19 AM, Morgan Bishop wrote:
On 6/14/2011 1:03 PM, Marc Perkel wrote:
I must be blind but I can seem to find the files or instructions for
creating the mysql databases to set up bayes.
Thanks in advance
I'm not sure, but I believe you are looking for bayes_mysql.sql in
the spamassassin documentation directory. Depending on your
install/distribution it may be in /usr/share/doc/spamassassin/sql/
You can also find the readme for sql support there, or check out:
http://svn.apache.org/repos/asf/spamassassin/branches/3.3/sql/README.bayes
It's quite easy to setup and get running.
I can't seem to find the bayes_mysql.sql file anywhere.
Depending on your distribution it could be in a number of places. You
could try a:
find / -name bayes_mysql.sql
If you have svn installed you can download it via svn. You can also
download it with wget (or view in browser) directry via:
http://svn.apache.org/repos/asf/spamassassin/branches/3.3/sql/bayes_mysql.sql
From there it's as easy an configuring your local.cf to use Bayes SQL
and creating the tables in mysql. Don't forget to backup your existing
bayes tokens and such before doing any changes. You can later restore
that backup to Mysql so you don't lose any training.