<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">your error message indicates a root mysql login issue. access rights on the DB you created ?. <br><br>have you checked to make sure it's not something like port 3306 not open on the remote host ?<br><br>let me add i am not clear on the advantage of putting `bayes` into mysql. by default spamassassin uses flat files and when i wanted to retain all my sa-learn stuff from an amavisd install i copied these files over<br><br>/var/spool/amavisd/.spamassassin to <br> /etc/MailScanner/bayes/<br><br>what is this<br>bayes_path /etc/MailScanner/bayes/bayes<br><br>set to in .conf ?<br><br><br><br><br><br><br><div class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"></span></font></div><div><div class="MsoNormal"><em><i><font face="Times New Roman" size="3"><span style="font-size: 12pt;">George<span style="text-decoration:
underline;"><br><br></span></span></font></i></em><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><a rel="nofollow" target="_blank" href="http://www.linkedin.com/in/gelgin"></a>http://nomenware.net/Admin.htm<br> </span></font></div><div class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><a rel="nofollow" target="_blank" href="http://www.nomenware.net/demo.html/"> </a></span></font></div><font face="Times New Roman" size="3"></font></div><br><br>--- On <b>Mon, 5/2/11, mailscanner-request@lists.mailscanner.info <i><mailscanner-request@lists.mailscanner.info></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: mailscanner-request@lists.mailscanner.info <mailscanner-request@lists.mailscanner.info><br>Subject: MailScanner Digest, Vol 65, Issue 2<br>To: mailscanner@lists.mailscanner.info<br>Date: Monday, May
2, 2011, 7:01 AM<br><br><div class="plainMail">Send MailScanner mailing list submissions to<br> <a ymailto="mailto:mailscanner@lists.mailscanner.info" href="/mc/compose?to=mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br>or, via email, send a message with subject or body 'help' to<br> <a ymailto="mailto:mailscanner-request@lists.mailscanner.info" href="/mc/compose?to=mailscanner-request@lists.mailscanner.info">mailscanner-request@lists.mailscanner.info</a><br><br>You can reach the person managing the list at<br> <a ymailto="mailto:mailscanner-owner@lists.mailscanner.info"
href="/mc/compose?to=mailscanner-owner@lists.mailscanner.info">mailscanner-owner@lists.mailscanner.info</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of MailScanner digest..."<br><br><br>Today's Topics:<br><br> 1. bayes SQL database remote server (Roland de Lepper)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 2 May 2011 10:11:53 +0200<br>From: Roland de Lepper <<a ymailto="mailto:roland.de.lepper@cvis.nl" href="/mc/compose?to=roland.de.lepper@cvis.nl">roland.de.lepper@cvis.nl</a>><br>Subject: bayes SQL database remote server<br>To: <a ymailto="mailto:mailscanner@lists.mailscanner.info" href="/mc/compose?to=mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br>Message-ID: <<a ymailto="mailto:BANLkTimJ6Vxk2u5vKV2fhFseB6eM1tOAQQ@mail.gmail.com"
href="/mc/compose?to=BANLkTimJ6Vxk2u5vKV2fhFseB6eM1tOAQQ@mail.gmail.com">BANLkTimJ6Vxk2u5vKV2fhFseB6eM1tOAQQ@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Hi,<br><br>I'm trying to get the bayes to be stored on a remote MySQL server.<br><br>My mailscanner server is mta1.host.com<br>My MySQL database server is sql.host.com<br><br>in spam.assassin.prefs.conf i've added:<br><br>bayes_store_module Mail::SpamAssassin::BayesStore::SQL<br>bayes_sql_dsn DBI:mysql:sa_bayes;sql.host.com<br>bayes_sql_username root<br>bayes_sql_password xxxx<br>bayes_sql_override_username root<br><br>on sql.host.com i've created a mysql database called: sa_bayes<br><br>For some reason it keeps looking at localhost when i'm executing:<br><br>spamassassin
2>&1 -x -D -p /path/to/spam.assassin.prefs.conf --lint | grep<br>bayes<br>May 2 11:00:00.625 [13939] dbg: config: fixed relative path:<br>/var/lib/spamassassin/3.003001/saupdates_openprotect_com/<br>70_sare_bayes_poison_nxm.cf<br>May 2 11:00:00.625 [13939] dbg: config: using<br>"/var/lib/spamassassin/3.003001/saupdates_openprotect_com/<br>70_sare_bayes_poison_nxm.cf" for included file<br>May 2 11:00:00.626 [13939] dbg: config: read file<br>/var/lib/spamassassin/3.003001/saupdates_openprotect_com/<br>70_sare_bayes_poison_nxm.cf<br>May 2 11:00:01.015 [13939] dbg: config: fixed relative path:<br>/var/lib/spamassassin/3.003001/updates_spamassassin_org/23_bayes.cf<br>May 2 11:00:01.015 [13939] dbg: config: using<br>"/var/lib/spamassassin/3.003001/updates_spamassassin_org/23_bayes.cf" for<br>included file<br>May 2 11:00:01.015 [13939] dbg: config: read
file<br>/var/lib/spamassassin/3.003001/updates_spamassassin_org/23_bayes.cf<br>May 2 11:00:01.690 [13939] dbg: bayes: learner_new<br>self=Mail::SpamAssassin::Plugin::Bayes=HASH(0xc8d37a0),<br>bayes_store_module=Mail::SpamAssassin::BayesStore::SQL<br>May 2 11:00:01.698 [13939] dbg: bayes: using username: root<br>May 2 11:00:01.698 [13939] dbg: bayes: learner_new: got<br>store=Mail::SpamAssassin::BayesStore::SQL=HASH(0xcd185d0)<br>May 2 11:00:01.795 [13939] dbg: bayes: unable to connect to database:<br>Access denied for user 'root'@'mta1.host.com' (using password: YES)<br>May 2 11:00:01.852 [13939] dbg: bayes: unable to connect to database:<br>Access denied for user 'root'@'mta1.host.com' (using password: YES)<br><br>Why it keeps looking at the MailScanner host, even if I say<br>"bayes_sql_dsn DBI:mysql:sa_bayes;sql.host.com ??<br><br>Thanks in advanced for any help.<br><br>Kind regards,<br><br>Roland<br>-------------- next
part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.mailscanner.info/pipermail/mailscanner/attachments/20110502/b833ae52/attachment-0001.html" target="_blank">http://lists.mailscanner.info/pipermail/mailscanner/attachments/20110502/b833ae52/attachment-0001.html</a><br><br>------------------------------<br><br>-- <br>MailScanner mailing list<br><a ymailto="mailto:mailscanner@lists.mailscanner.info" href="/mc/compose?to=mailscanner@lists.mailscanner.info">mailscanner@lists.mailscanner.info</a><br><a href="http://lists.mailscanner.info/mailman/listinfo/mailscanner" target="_blank">http://lists.mailscanner.info/mailman/listinfo/mailscanner</a><br><br>Before posting, read the Wiki (<a href="http://wiki.mailscanner.info/" target="_blank">http://wiki.mailscanner.info/</a>).<br><br>Support MailScanner development - buy the book off the website! <br><br><br>End of MailScanner Digest, Vol 65, Issue
2<br>******************************************<br></div></blockquote></td></tr></table>