SpamAssassin with MySQL user preferences
 

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://spamassassin.apache.org/full/...ist/sql/README

I have in /etc/sysconfig now SPAMDOPTIONS="-d -c -q -m5 -u vmail H".
( 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!

Have you checked the sql logs from the server?

The mysql logs don't show anything (I don't think the request is getting to the MySQL server).

I also used this URL for the setup of AntiSpam and AntiVirus solutions:
http://www.howtoforge.com/fedora_vir...ota_courier_p3
(if this help).

Thanks!