Hi,<div><br></div><div>I'm trying to get the bayes to be stored on a remote MySQL server.</div><div><br></div><div>My mailscanner server is <a href="http://mta1.host.com">mta1.host.com</a></div><div>My MySQL database server is <a href="http://sql.host.com">sql.host.com</a></div>
<div><br></div><div>in spam.assassin.prefs.conf i've added:</div><div><br></div><div><div>bayes_store_module Mail::SpamAssassin::BayesStore::SQL</div><div>bayes_sql_dsn DBI:mysql:sa_bayes;<a href="http://sql.host.com">sql.host.com</a></div>
<div>bayes_sql_username root</div><div>bayes_sql_password xxxx</div><div>bayes_sql_override_username root</div></div><div><br></div><div>on <a href="http://sql.host.com">sql.host.com</a> i've created a mysql database called: sa_bayes</div>
<div><br></div><div>For some reason it keeps looking at localhost when i'm executing:</div><div><br></div><div><div>spamassassin 2>&1 -x -D -p /path/to/spam.assassin.prefs.conf --lint | grep bayes</div><div>May 2 11:00:00.625 [13939] dbg: config: fixed relative path: /var/lib/spamassassin/3.003001/saupdates_openprotect_com/<a href="http://70_sare_bayes_poison_nxm.cf">70_sare_bayes_poison_nxm.cf</a></div>
<div>May 2 11:00:00.625 [13939] dbg: config: using "/var/lib/spamassassin/3.003001/saupdates_openprotect_com/<a href="http://70_sare_bayes_poison_nxm.cf">70_sare_bayes_poison_nxm.cf</a>" for included file</div>
<div>May 2 11:00:00.626 [13939] dbg: config: read file /var/lib/spamassassin/3.003001/saupdates_openprotect_com/<a href="http://70_sare_bayes_poison_nxm.cf">70_sare_bayes_poison_nxm.cf</a></div><div>May 2 11:00:01.015 [13939] dbg: config: fixed relative path: /var/lib/spamassassin/3.003001/updates_spamassassin_org/<a href="http://23_bayes.cf">23_bayes.cf</a></div>
<div>May 2 11:00:01.015 [13939] dbg: config: using "/var/lib/spamassassin/3.003001/updates_spamassassin_org/<a href="http://23_bayes.cf">23_bayes.cf</a>" for included file</div><div>May 2 11:00:01.015 [13939] dbg: config: read file /var/lib/spamassassin/3.003001/updates_spamassassin_org/<a href="http://23_bayes.cf">23_bayes.cf</a></div>
<div>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</div><div>May 2 11:00:01.698 [13939] dbg: bayes: using username: root</div>
<div>May 2 11:00:01.698 [13939] dbg: bayes: learner_new: got store=Mail::SpamAssassin::BayesStore::SQL=HASH(0xcd185d0)</div><div>May 2 11:00:01.795 [13939] dbg: bayes: unable to connect to database: Access denied for user 'root'@'<a href="http://mta1.host.com">mta1.host.com</a>' (using password: YES)</div>
<div>May 2 11:00:01.852 [13939] dbg: bayes: unable to connect to database: Access denied for user 'root'@'<a href="http://mta1.host.com">mta1.host.com</a>' (using password: YES)</div></div><div><br></div>
<div>Why it keeps looking at the MailScanner host, even if I say "bayes_sql_dsn DBI:mysql:sa_bayes;<a href="http://sql.host.com">sql.host.com</a> ??</div><div><br></div><div>Thanks in advanced for any help.</div><div>
<br></div><div>Kind regards,</div><div><br></div><div>Roland</div><meta http-equiv="content-type" content="text/html; charset=utf-8"><div><br></div>