un.codiert.org

Silvio said to me that he gets tons of spam. I couldn’t imagine that only he gets the spam and all of my addresses and domain mail users didn’t get spam. But today I saw the bug in the amavisd.conf. The variable “@local_domains_maps” in the configuration only has my domain. This brings the failure that amavis checks the mail but doesn’t write the result or doesn’t act as described in the configuration. The bad thing is that the maillog doesn’t show this behaviour, the log shows that the mail is detected as SPAM and will be blocked. The first solution to protect Silvio against SPAM is to at his domain to the local_domains_maps. But this doesn’t help all the other hosted domain users. Amavis provides a MySql interface to query a database for the domains. The following lines have to be configured:

@lookup_sql_dsn = ( ['DBI:mysql:database=database;host=127.0.0.1;
                    port=3306', 'user', 'secret'] );
$sql_select_policy = 'SELECT "Y" as local FROM alias WHERE address IN (%k)';

This instruct amavis to lookup the domain for each mail which is hosted and should be checked. Happy Mailing…

This entry was posted on Tuesday, October 28th, 2008 at 10:57 and is filed under Linux.You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.