On Sonntag, 18. Juni 2006 01:37 Michael Monnerie wrote: > 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
Sorry, forgot to post the errors from spamd:
[21920] dbg: bayes: unable to connect to database: missing "=" after
"zmi_sa_bayes:localhost" in connection info string
[21920] dbg: bayes: unable to connect to database: missing "=" after
"zmi_sa_bayes:localhost" in connection info string
> 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.
Errors here:
[2322] dbg: bayes: using username: vscan
[2322] dbg: bayes: database connection established
[2322] dbg: bayes: found bayes db version 3
[2322] dbg: bayes: unable to initialize READONLY database for vscan
user, aborting!
[2322] dbg: bayes: database connection established
[2322] dbg: bayes: found bayes db version 3
[2322] dbg: bayes: unable to initialize READONLY database for vscan
user, aborting!
Note that the word "READONLY" was set by me in
lib/Mail/SpamAssassin/BayesStore/SQL.pm line 141, because it was the
same message than in the function where the DB was NOT readonly. I just
wanted to know where the code was jumping around...
Ah yes, it's SA 3.1.3.
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
pgpvkqB7Zo6SF.pgp
Description: PGP signature
