On Wednesday 20 June 2007 18:39, Duane Hill wrote: > 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
Sorry... It's working... Possibly has been all the time. The damned logs just don't seem to say it's connected to a DB, (like the AWL logs do)... In fact I can't find anything (Apart from the loading of the plugin) to say that SQL is anywhere near the Bayes... The connections also seem to be too short to show up on mysql administrator... It took sa-learn --dump all to convince me it was using it.
pgpXHUEEHpdHD.pgp
Description: PGP signature
