Zimbra7 Bayes Anti Spam

[MobiusNZ]

Hi All,

I'm trying to get bayes going on spamassassin, based off instructions here:

http://www.zimbra.com/docs/ne/latest...rotection.html

So I did

zmlocalconfig -e antispam_mysql_enabled=true
zmmtactl restart && zmamavisdctl restart

I did a test run of zmtrainsa on my mailbox but it gave an error

ERROR: the Bayes learn function returned an error, please re-run with -D for more information at /opt/zimbra/libexec/sa-learn line 493.

So I found where the learn function was being called and added the -D, and I see the following errors:

Jul 13 14:55:41.622 [2960] info: config: SpamAssassin failed to parse line, no value provided for "bayes_sql_password", skipping: bayes_sql_password

//---SNIP

Jul 13 14:55:42.067 [2960] dbg: message: ---- MIME PARSER START ----
Jul 13 14:55:42.067 [2960] dbg: message: parsing normal part
Jul 13 14:55:42.067 [2960] dbg: message: ---- MIME PARSER END ----
Jul 13 14:55:42.067 [2960] dbg: message: decoding other encoding type (8bit), ignoring
Jul 13 14:55:42.069 [2960] dbg: bayes: unable to connect to database: Can't connect to MySQL server on '127.0.0.1' (111)
Jul 13 14:55:42.069 [2960] dbg: bayes: unable to connect to database: Can't connect to MySQL server on '127.0.0.1' (111)

How should I specify the bayes password?

And shouldn't this be mentioned in the docs I linked to above?

[phoenix]

Originally Posted by MobiusNZ

How should I specify the bayes password?

These are the steps to follow: Scalable Anti-Spam Using Spamassassin and MySQL - Zimbra :: Wiki & Bug 53261 – documentation for setting up MySQL database for spamassassin

Originally Posted by MobiusNZ

And shouldn't this be mentioned in the docs I linked to above?

Probably.

[MobiusNZ]

I'm confused. We only have one server, so surely what I've done should be enough?

Also this is what I get when running the following commands:

zimbra@zimbra-1:~$ zmlocalconfig -s antispam_mysql_password
antispam_mysql_password = 
zimbra@zimbra-1:~$ zmlocalconfig -s antispam_mysql_user
antispam_mysql_user = zimbra