Author Topic: Add-On: amavisd quarantine on postgresql  (Read 3074 times)

nuanda

  • Zen Apprentice
  • *
  • Posts: 17
  • Karma: +0/-0
    • View Profile
Add-On: amavisd quarantine on postgresql
« on: June 06, 2008, 12:20:43 pm »
It could be not so hard to implement a quarantine system Ebox; I use this method:
I create the database on postgresql using the guide on http://www.ijs.si/software/amavisd/README.sql-pg
The tables necessaries for quarantine are: maddr, mailaddr, msgrcpt, msgs, quarantine.
In /etc/amavis/conf.d you must add:

$spam_quarantine_method = 'sql:';
@storage_sql_dsn = (['DBI:Pg:database=spam;host=localhost', 'user', 'pass']);
$policy_bank{'AM.PDP'} = {
   log_level => 3,
   protocol=>'AM.PDP', # Amavis policy delegation protocol (new milter helper)
   inet_acl=>[qw( 127.0.0.1 [::1] 192.168.X.XXX )]
};
$interface_policy{'9998'} = 'AM.PDP';

Then I use MailZu (http://www.mailzu.net/) as a web interface for release.