bayes SQL database remote server (Roland de Lepper)

[George Elgin]

your error message indicates a root mysql login issue. access rights on the DB you created ?. 

have you checked to make sure it's not something like port 3306 not open on the remote host ?

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

/var/spool/amavisd/.spamassassin to 
    /etc/MailScanner/bayes/

what is this
bayes_path /etc/MailScanner/bayes/bayes

set to in .conf ?






George

http://nomenware.net/Admin.htm
  

--- On Mon, 5/2/11, mailscanner-request at lists.mailscanner.info <mailscanner-request at lists.mailscanner.info> wrote:

From: mailscanner-request at lists.mailscanner.info <mailscanner-request at lists.mailscanner.info>
Subject: MailScanner Digest, Vol 65, Issue 2
To: mailscanner at lists.mailscanner.info
Date: Monday, May 2, 2011, 7:01 AM

Send MailScanner mailing list submissions to
    mailscanner at lists.mailscanner.info

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.mailscanner.info/mailman/listinfo/mailscanner
or, via email, send a message with subject or body 'help' to
    mailscanner-request at lists.mailscanner.info

You can reach the person managing the list at
    mailscanner-owner at lists.mailscanner.info

When replying, please edit your Subject line so it is more specific
than "Re: Contents of MailScanner digest..."


Today's Topics:

   1. bayes SQL database remote server (Roland de Lepper)


----------------------------------------------------------------------

Message: 1
Date: Mon, 2 May 2011 10:11:53 +0200
From: Roland de Lepper <roland.de.lepper at cvis.nl>
Subject: bayes SQL database remote server
To: mailscanner at lists.mailscanner.info
Message-ID: <BANLkTimJ6Vxk2u5vKV2fhFseB6eM1tOAQQ at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

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-0001.html

------------------------------

-- 
MailScanner mailing list
mailscanner at lists.mailscanner.info
http://lists.mailscanner.info/mailman/listinfo/mailscanner

Before posting, read the Wiki (http://wiki.mailscanner.info/).

Support MailScanner development - buy the book off the website! 


End of MailScanner Digest, Vol 65, Issue 2
******************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20110502/d324616d/attachment.html