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/