On Wed, 20 Jun 2007, Hamie wrote:
On Wednesday 20 June 2007 18:09, Rosenbaum, Larry M. wrote:
From: Hamie [mailto:[EMAIL PROTECTED]
Small problem with SA 3.2.1... I'm using a mysql database. The DB
works
fine for amavisd-new, and SA AWL. e.g.
[438288] dbg: auto-whitelist: sql-based connected to
DBI:mysql:sadb:ixxxxxx:
[438288] dbg: auto-whitelist: sql-based using username: vscan01
[438288] dbg: auto-whitelist: sql-based get_addr_entry: found existing
entry for [EMAIL PROTECTED]|ip=xx.xx
[438288] dbg: auto-whitelist: sql-based [EMAIL PROTECTED]|ip=195.53
scores 21/8.128
[438288] dbg: auto-whitelist: AWL active, pre-score: -1.498, autolearn
score: -1.498, mean: 0.387047619047619, IP: xx.xx.xx.xx
[438288] dbg: auto-whitelist: sql-based add_score: new count: 22, new
totscore: 6.63 for [EMAIL PROTECTED]|ip=xx.xx
[438288] dbg: auto-whitelist: sql-based finish: disconnected from
DBI:mysql:sadb:xxxxxxxx
but the SA bayes SQL spits out the error
[463326] dbg: plugin: loading Mail::SpamAssassin::BayesStore::SQL from
@INC
[463326] dbg: bayes: invalid config, must set bayes_sql_dsn config
variable
plugin: failed to create instance of plugin
Mail::SpamAssassin::BayesStore::SQL:
Which would be fine... Except my local.cf file (Which also defines the
config for AWL) says
bayes_sql_dsn DBI:mysql:sadb:xxxxxxx:
bayes_sql_username spamassassin
bayes_sql_password fred
bayes_sql_override_username vscan01
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
I think you want this:
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
Tried that too. It complains about bayes_sql_dns not being set as well. The
only way I can get it to STOP complaining is to set the bayes_sql_dsn BEFORE
the loadmodule (i.e. move loadmodule form init.pre to local.cf), but then it
loads, and proceeds to ignore using the SQL for bayes & uses local disk
still.
Sigh...
This is how mine is set and it has worked flawless since the initial set
up on v3.1.8 (now running v3.2.1):
bayes_store_module Mail::SpamAssassin::BayesStore::MySQL
bayes_sql_dsn DBI:mysql:db_name:mysql_server:3306
bayes_sql_username username
bayes_sql_password password
Everything here is set up on a per account basis.
