bayes SQL database remote server

[Roland de Lepper]

Hi,

I'm trying to get the bayes to be stored on a remote MySQL server.

My mailscanner server is mta1.host.com
My MySQL database server is sql.host.com

in spam.assassin.prefs.conf i've added:

bayes_store_module           Mail::SpamAssassin::BayesStore::SQL
bayes_sql_dsn                DBI:mysql:sa_bayes;sql.host.com
bayes_sql_username           root
bayes_sql_password           xxxx
bayes_sql_override_username  root

on sql.host.com i've created a mysql database called: sa_bayes

For some reason it keeps looking at localhost when i'm executing:

spamassassin 2>&1 -x -D -p /path/to/spam.assassin.prefs.conf --lint | grep
bayes
May  2 11:00:00.625 [13939] dbg: config: fixed relative path:
/var/lib/spamassassin/3.003001/saupdates_openprotect_com/
70_sare_bayes_poison_nxm.cf
May  2 11:00:00.625 [13939] dbg: config: using
"/var/lib/spamassassin/3.003001/saupdates_openprotect_com/
70_sare_bayes_poison_nxm.cf" for included file
May  2 11:00:00.626 [13939] dbg: config: read file
/var/lib/spamassassin/3.003001/saupdates_openprotect_com/
70_sare_bayes_poison_nxm.cf
May  2 11:00:01.015 [13939] dbg: config: fixed relative path:
/var/lib/spamassassin/3.003001/updates_spamassassin_org/23_bayes.cf
May  2 11:00:01.015 [13939] dbg: config: using
"/var/lib/spamassassin/3.003001/updates_spamassassin_org/23_bayes.cf" for
included file
May  2 11:00:01.015 [13939] dbg: config: read file
/var/lib/spamassassin/3.003001/updates_spamassassin_org/23_bayes.cf
May  2 11:00:01.690 [13939] dbg: bayes: learner_new
self=Mail::SpamAssassin::Plugin::Bayes=HASH(0xc8d37a0),
bayes_store_module=Mail::SpamAssassin::BayesStore::SQL
May  2 11:00:01.698 [13939] dbg: bayes: using username: root
May  2 11:00:01.698 [13939] dbg: bayes: learner_new: got
store=Mail::SpamAssassin::BayesStore::SQL=HASH(0xcd185d0)
May  2 11:00:01.795 [13939] dbg: bayes: unable to connect to database:
Access denied for user 'root'@'mta1.host.com' (using password: YES)
May  2 11:00:01.852 [13939] dbg: bayes: unable to connect to database:
Access denied for user 'root'@'mta1.host.com' (using password: YES)

Why it keeps looking at the MailScanner host, even if I say
"bayes_sql_dsn DBI:mysql:sa_bayes;sql.host.com ??

Thanks in advanced for any help.

Kind regards,

Roland
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20110502/b833ae52/attachment.html