You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by ca...@nc.rr.com on 2007/06/21 21:22:49 UTC
Setup SA to use mysql DB
OK, i have gotten a little further after searching some other email.
This is what i get when i run spamassassin --lint
[3069] warn: config: failed to parse line, skipping: bayes_store_dsn
DBI:mysql:sadb:Spamassassin
Can't locate Mail/Spamassassin/BayesStore/MySQL.pm in @INC (@INC
contains: lib /usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/5.8.3/i586-linux-thread-multi /usr/lib/perl5/5.8.3
/usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl) at (eval 2266) line 2.
This is what my local.cf looks like:
bayes_store_dsn DBI:mysql:sadb:Spamassassin*what does this
signify? Can someone break this line down?
bayes_sql_username <name>is this the user of the mysql DB?
bayes_sql_password >password>is this the password for the user
of the mysql DB?
bayes_sql_override_username vscan*is this suppose to be here?
bayes_store_module Mail::Spamassassin::BayesStore::MySQL
RE: Setup SA to use mysql DB
Posted by Bret Miller <br...@wcg.org>.
OK, I don't use MySQL, but I do use SQL for Bayes and AWL. Here are my
settings (which are working currently in 3.2.1):
# auto_whitelist settings
auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn DBI:ODBC:Driver={SQL
Server};Server=MAIL;Database=sql-database
user_awl_sql_username sql-user-name
user_awl_sql_password sql-password
user_awl_sql_override_username global
# Bayes settings
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:ODBC:Driver={SQL
Server};Server=MAIL;Database=sql-database
bayes_sql_username sql-user-name
bayes_sql_password sql-password
bayes_sql_override_username global
HTH,
Bret
>
> -----Original Message-----
> From: carnold5@nc.rr.com [mailto:carnold5@nc.rr.com]
> Sent: Thursday, June 21, 2007 2:23 PM
> To: users@spamassassin.apache.org
> Subject: Setup SA to use mysql DB
>
> OK, i have gotten a little further after searching some other email.
> This is what i get when i run spamassassin --lint
> [3069] warn: config: failed to parse line, skipping:
> bayes_store_dsn
> DBI:mysql:sadb:Spamassassin
> Can't locate Mail/Spamassassin/BayesStore/MySQL.pm in @INC (@INC
> contains: lib /usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.3
> /usr/lib/perl5/5.8.3/i586-linux-thread-multi /usr/lib/perl5/5.8.3
> /usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl) at (eval 2266) line 2.
> This is what my local.cf looks like:
> bayes_store_dsn DBI:mysql:sadb:Spamassassin*what does this
> signify? Can someone break this line down?
> bayes_sql_username <name>is this the user of the mysql DB?
> bayes_sql_password >password>is this the password for the user
> of the mysql DB?
> bayes_sql_override_username vscan*is this suppose to be here?
> bayes_store_module Mail::Spamassassin::BayesStore::MySQL
>
>
>
>
RE: Setup SA to use mysql DB
Posted by Jonn R Taylor <jo...@taylortelephone.com>.
This is what I use and it has been working for the last 3 years.
# MySQL Setup
use_razor2 1
use_bayes_rules 1
allow_user_rules 1
use_auto_whitelist 1
user_scores_dsn DBI:mysql:spamassassin:127.0.0.1
user_scores_sql_username xxxxx
user_scores_sql_password xxxxx
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn DBI:mysql:spamassassin:127.0.0.1
bayes_sql_username xxxxx
bayes_sql_password xxxxx
bayes_sql_override_username @GLOBAL
auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn DBI:mysql:spamassassin:127.0.0.1
user_awl_sql_username xxxxx
user_awl_sql_password xxxxx
Jonn
-----Original Message-----
From: carnold5@nc.rr.com [mailto:carnold5@nc.rr.com]
Sent: Thursday, June 21, 2007 2:23 PM
To: users@spamassassin.apache.org
Subject: Setup SA to use mysql DB
OK, i have gotten a little further after searching some other email.
This is what i get when i run spamassassin --lint
[3069] warn: config: failed to parse line, skipping: bayes_store_dsn
DBI:mysql:sadb:Spamassassin
Can't locate Mail/Spamassassin/BayesStore/MySQL.pm in @INC (@INC
contains: lib /usr/lib/perl5/vendor_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.3
/usr/lib/perl5/5.8.3/i586-linux-thread-multi /usr/lib/perl5/5.8.3
/usr/lib/perl5/site_perl/5.8.3/i586-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl) at (eval 2266) line 2.
This is what my local.cf looks like:
bayes_store_dsn DBI:mysql:sadb:Spamassassin*what does this
signify? Can someone break this line down?
bayes_sql_username <name>is this the user of the mysql DB?
bayes_sql_password >password>is this the password for the user
of the mysql DB?
bayes_sql_override_username vscan*is this suppose to be here?
bayes_store_module Mail::Spamassassin::BayesStore::MySQL