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...
pgpFjZZETzcyA.pgp
Description: PGP signature