SpamAssassin with MySQL issues

Discussion in 'Server Operation' started by silviap, Jul 21, 2009.

  1. silviap

    silviap New Member

    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!
     
  2. falko

    falko Super Moderator ISPConfig Developer

  3. silviap

    silviap New Member

Share This Page