Hello, I have a CentOS server with Postfix and Dovecot using virtual users (MySQL), I have ClamAV (amavisd) installed and SpamAssassin. The server setup is OK, but I am trying to get SpamAssassin to work with user preferences stored in a MySQL database. I followed the steps from http://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_current_release_3.2.x/sql/README I have in /etc/sysconfig now SPAMDOPTIONS="-d -q -x -m5 -u vmail". ( I tried using only "-d -q -m5 -u nobody -H", I tried with the -Q instead of -q...) The documentation from the apache website says I should see in the logs "retrieving prefs for <username> from SQL server". I can't see that. I also tried to add a plugin to one of the webmail clients I have and I used the same database, I added some rules, but spamd is not processing any data from those MySQL records. Any suggestions? Thank you!
Did you configure SpamAssassin as shown on http://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_current_release_3.2.x/sql/README ? In what file?
Hello Falko, I followed the steps presented in http://svn.apache.org/repos/asf/spamassassin/tags/spamassassin_current_release_3.2.x/sql/README. The database settings are added at the end of local.cf file, located in /etc/mail/spamassassin. For the installation of AntiVirus and AntiSpam solutions, I followed this tutorial: http://www.howtoforge.com/fedora_virtual_postfix_mysql_quota_courier_p3 Thanks for your help!
