Micke Andersson <m...@swemic.net> wrote:
Helmut Schneider wrote:
Hi,
I tried to move a global (not per user) bayes-db to mysql5.0 to use it
with 3 different machines.
From local.cf:
use_bayes 1
bayes_store_module Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn DBI:mysql:SpamAssassin
bayes_sql_username amavis
bayes_sql_password amavis
bayes_sql_override_username amavis
auto_whitelist_factory Mail::SpamAssassin::SQLBasedAddrList
user_awl_dsn DBI:mysql:SpamAssassin
user_awl_sql_username amavis
user_awl_sql_password amavis
spamassassin --lint -D
[12722] dbg: bayes: using username: amavis
[12722] dbg: bayes: database connection established
[12722] dbg: bayes: found bayes db version 3
[12722] dbg: bayes: unable to initialize database for amavis user,
aborting!
[12722] dbg: bayes: database connection established
[12722] dbg: bayes: found bayes db version 3
[12722] dbg: bayes: unable to initialize database for amavis user,
aborting!
What did I miss? I read README.bayes carefully, but...
Have you tried to connect to your MySQL database with user amavis and
password amavis?
Forgot to initialize the database:
http://wiki.apache.org/spamassassin/BetterDocumentation/SqlReadmeBayes,
bottom.
Thanks, Helmut
--
No Swen today, my love has gone away
My mailbox stands for lorn, a symbol of the dawn