--nextPart1637401.75fMDoZHvo
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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:hamish@travellingkiwi.com]
> >>>
> >>> 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 local@email.es|ip=3Dxx.xx
> >>> [438288] dbg: auto-whitelist: sql-based fvarela@iberia.es|ip=3D195.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 local@email.es|ip=3Dxx.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 ju=
st=20
don't seem to say it's connected to a DB, (like the AWL logs do)... In fact=
I=20
can't find anything (Apart from the loading of the plugin) to say that SQL =
is=20
anywhere near the Bayes...

The connections also seem to be too short to show up on mysql administrator=
=2E..=20

It took sa-learn --dump all to convince me it was using it.

--nextPart1637401.75fMDoZHvo
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBGek0i/3QXwQQkZYwRAmsRAJ0QFITLYXh4E5TVv5DpwrU7AtnzCQCgmC3 5
m9sA9JhiEnTmNZ3XGVL/wEk=
=oLwG
-----END PGP SIGNATURE-----

--nextPart1637401.75fMDoZHvo--