Benny Pedersen skrev:
On Tue, August 29, 2006 08:16, Anders Norrbring wrote:
[6204] dbg: bayes: unable to initialize database for vscan user, aborting!
from a new sql database this is default error, means that there is no data to
work with so far
Well, there actually IS one post in the DB.. When I run spamassassin -D
--lint it connects as root, and both reads and writes to the database.
Shouldn't SA try to contact MySQL as "username" and not as "vscan"? The
processes runs as the user vscan.
in next life of spamassassin :-)
But what's the bayes_sql_username config parameter good for then?
I also tried to set bayes_sql_override_username = username, no luck
there either.
[7997] dbg: bayes: database connection established
[7997] dbg: bayes: found bayes db version 3
[7997] dbg: bayes: unable to initialize database for vscan user, aborting!
[7997] dbg: bayes: not scoring message, returning undef
[7997] dbg: bayes: opportunistic call attempt failed, DB not readable
so if you want pr user sa configs make users as unix users not virtual users,
i know it can be done with non unix users aswell, but not in 5 mins setup
guide :(
Nope, I'm looking at setting up a site wide BayesDB, stored in MySQL.
The database exists, the access username and password are listed in
local.cf like I described.
Now when using bayes_sql_override_username with the username set as the
MySQL database user, it still complains "dbg: bayes: unable to
initialize database for sadb user, aborting!"
Same username and password are used for the whitelisting MySQL database,
and there it seems to work just fine.
--
Anders Norrbring
Norrbring Consulting
