Hello, I'm wondering why I need different settings than written anywhere in the documentation. For the first time I tried to use bayes via SQL, and read the README and the wiki. They suggest this in local.cf:
bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL
bayes_sql_dsn DBI:driver:database:hostname[:port]
bayes_sql_username dbusername
bayes_sql_password dbpassword
(and optionally:)
bayes_sql_override_username someusername
But that didn't work for me, I had to use:
bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL
bayes_sql_dsn DBI:Pg:dbname=spamass;host=localhost
bayes_sql_username dbusername
bayes_sql_password dbpassword
bayes_sql_override_username vscan
So my DSN had to contain "dbname=" and "host=", separated via semicolon.
That seems to be because of my version of DBD::Pg, which is
perl-DBD-Pg-1.22-199 (rpm by SUSE9.3).
The next itch after this was, that I couldn't start spamd, because user
vscan was not defined. After one
insert into bayes_vars (username) values ('vscan');
everything seems to work now.
But I'm still wondering why the documentation differs from my
experience?
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0660/4156531 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi3.asc | gpg --import"
// Fingerprint: 44A3 C1EC B71E C71A B4C2 9AA6 C818 847C 55CB A4EE
// Keyserver: www.keyserver.net Key-ID: 0x55CBA4EE
pgpx2LdCztyem.pgp
Description: PGP signature
