Hi there, I followed this tutorial : Virtual Users And Domains With Postfix, Courier And MySQL (Debian Etch). The mail server works, but the spamfilter does not add the **SPAM** tag to spam mails. spamassassin -t /home/vmails/example.com/user/cur/* says Content analysis details: (7.5 points, 5.0 required) Here is my amavis config, i guess amavis is not listening to spamassassin. I hope someone can help me, searching a few days now for a proper sollution. there are a lot of SPAM mails into the QUARANTINEDIR, but i want all the spam mails to my inbox with ***SPAM*** into the Subject. Do i have to edit /etc/spamassassin/local.cf file with amavis?
problem solved! had to add a custom config to 50-user @lookup_sql_dsn = ( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306', 'mail_admin', 'mail_admin_pass']); $sql_select_policy = 'SELECT domain FROM domains WHERE CONCAT("@",domain) IN (%k)';
