On Fri, 8 Sep 2006, Anders Norrbring wrote:

> I'm about to set up a spam quarantine in MySQL and let users manage
> their accounts via MailZu or similar utility.
> But I'm a bit confused over the README.sql... I ONLY want to do the spam

This is my changes to amavisd.conf

$inet_socket_port = [10024, 9998]; # accept SMTP on this local TCP port
# (default is undef, i.e. disabled)

$spam_quarantine_method = 'sql:';

$sa_quarantine_cutoff_level = 20; # dflt: undef, which disables this 
feature

@storage_sql_dsn = ( 
['DBI:mysql:database=mail;host=127.0.0.1;port=3306', 'user', 'password']);


$policy_bank{'AM.PDP'} = {
log_level => 3,
inet_acl => [ qw ( 127.0.0.1 [::1] MailZu-host ) ],
protocol=>'AM.PDP', # Amavis policy delegation protocol (new milter 
helper)
   };


$interface_policy{'9998'} = 'AM.PDP';

> quarantine in SQL, so I suppose I don't need everything from the readme,

I just copied all the sample SQL from readme.SQL, and executed the SQL. 
That is it.

> but I'm not sure about amavis way of working with the DB, so can someone
> please advice on what tables I need for my goal?
> -- 
>
> Anders Norrbring
> Norrbring Consulting
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> AMaViS-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/amavis-user
> AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
> AMaViS-HowTos:http://www.amavis.org/howto/
>

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/

Reply via email to