1

Topic: Spamassassin user settings in MySql

==== Required information ====
- iRedMail version: 0.8.4
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian Linux
- Related log if you're reporting an issue:
====

Hi,
I want to store per user settings of Spamassassin in mysql db, so I configured this in local.cf:

user_scores_dsn                 DBI:mysql:sa_bayes:localhost
user_scores_sql_username        sa_user
user_scores_sql_password        PaSsWoRd
user_scores_sql_custom_query    SELECT preference, value FROM _TABLE_ WHERE username = _USERNAME_ OR username = '$GLOBAL' OR username = CONCAT('%',_DOMAIN_) ORDER BY username ASC

I have some "whitelist_from" entries in table userpref, but these user settings do not seem to be used.
After some googling I found that this seems to be not possible if spamassassin is invoked by amavis directly and spamd is not running.
Is this correct?
If yes, how can I change the amavis config to use spamd instead?
(I know how to run spamd, just not what I have to change in amavis config to use it)

Best regards,
Oliver