You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Helmut Schneider <ju...@gmx.de> on 2009/04/22 17:07:53 UTC
move bayes-db to mysql, unable to initialize database for amavis user, aborting!
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...
Thanks, Helmut
--
No Swen today, my love has gone away
My mailbox stands for lorn, a symbol of the dawn
Re: move bayes-db to mysql, unable to initialize database for amavis user, aborting!
Posted by Helmut Schneider <ju...@gmx.de>.
Micke Andersson <mi...@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
Re: move bayes-db to mysql, unable to initialize database for amavis
user, aborting!
Posted by Micke Andersson <mi...@swemic.net>.
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...
>
> Thanks, Helmut
>
Have you tried to connect to your MySQL database with user amavis and
password amavis?
My quick guess is that you have forgotten to grant all needed ACL's to
MySQL user amavis.
/Micke