Hi,
> Subject: RE: [Web-cyradm] ToDo List/changelog and Buglist etc.
>
>
> QUOTE:
>
> "If you are interested, i can show you my config files for that.
> But in the amavis README Files there is a HowTo to get i working.
> .
> .
> Regards
> Marcel"
>
> Hello Marcel,
>
> I'm interested in seeing your configs for virus/spam
> enable/disable feature.
>
> Regards,
> Leon
>
Did you read the manuals from amavisd-new?
There is a README.sql in whitch you can read all you need for
Setting up amavisd with postfix.
1. Set up a Database User with read (also select is enough if you
Wan't save quarantine to MySQL .
2. Set up the amavisd.conf and put the Database User in the DSN:
@lookup_sql_dsn =
( ['DBI:mysql:database=mail;host=127.0.0.1;port=3306', 'user1',
'passwd1'],
['DBI:mysql:database=mail;host=host2', 'username2', 'password2'],
['DBI:Pg:host=host1;dbname=mail'],
["DBI:SQLite:dbname=$MYHOME/sql/mail_prefs.sqlite", '', ''] );
Increase the debuglevel in amavisd.conf and restart it.
3. create the database structures for mysql:
-- local users
CREATE TABLE users (
id SERIAL PRIMARY KEY,
priority integer NOT NULL DEFAULT '7', -- 0 is low priority
policy_id integer unsigned NOT NULL DEFAULT '1',
email varchar(255) NOT NULL,
fullname varchar(255) DEFAULT NULL, -- not used by amavisd-new
local char(1), -- Y/N (optional field, see note further down)
KEY email (email)
);
CREATE UNIQUE INDEX users_idx_email ON users (email);
-- any e-mail address, external or local, used as senders in wblist
CREATE TABLE mailaddr (
id SERIAL PRIMARY KEY,
priority integer NOT NULL DEFAULT '7', -- 0 is low priority
email varchar(255) NOT NULL,
KEY email (email)
);
CREATE TABLE wblist (
rid integer unsigned NOT NULL, -- recipient: users.id
sid integer unsigned NOT NULL, -- sender: mailaddr.id
wb varchar(10) NOT NULL, -- W or Y / B or N / space=neutral /
score
PRIMARY KEY (rid,sid)
);
CREATE TABLE policy (
id SERIAL PRIMARY KEY, -- this is the _only_ required field
policy_name varchar(32), -- not used by amavisd-new
virus_lover char(1), -- Y/N
spam_lover char(1), -- Y/N
banned_files_lover char(1), -- Y/N
bad_header_lover char(1), -- Y/N
bypass_virus_checks char(1), -- Y/N
bypass_spam_checks char(1), -- Y/N
bypass_banned_checks char(1), -- Y/N
bypass_header_checks char(1), -- Y/N
spam_modifies_subj char(1), -- Y/N
virus_quarantine_to varchar(64) default NULL,
spam_quarantine_to varchar(64) default NULL,
banned_quarantine_to varchar(64) default NULL,
bad_header_quarantine_to varchar(64) default NULL,
spam_tag_level float default NULL, -- higher score inserts spam info
headers
spam_tag2_level float default NULL, -- inserts 'declared spam' header
fields
spam_kill_level float default NULL, -- higher score activates evasive
actions
, e.g.
-- reject/drop, quarantine, ...
-- (subject to final_spam_destiny
setting)
spam_dsn_cutoff_level float default NULL,
addr_extension_virus varchar(64) default NULL,
addr_extension_spam varchar(64) default NULL,
addr_extension_banned varchar(64) default NULL,
addr_extension_bad_header varchar(64) default NULL,
warnvirusrecip char(1) default NULL, -- Y/N
warnbannedrecip char(1) default NULL, -- Y/N
warnbadhrecip char(1) default NULL, -- Y/N
newvirus_admin varchar(64) default NULL,
virus_admin varchar(64) default NULL,
banned_admin varchar(64) default NULL,
bad_header_admin varchar(64) default NULL,
spam_admin varchar(64) default NULL,
spam_subject_tag varchar(64) default NULL,
spam_subject_tag2 varchar(64) default NULL,
message_size_limit integer default NULL, -- size in bytes
banned_rulenames varchar(64) default NULL -- comma-separated list of
...
-- names mapped through %banned_rules to actual banned_filename
tables
);
>From now on you only must set up the emailadress you will to configure
In the policy table. Thats all. Finetuning is you think. Ans if you have
more
Questions, please read the README Files in Amavisd-new Doc's.
Greets
Marcel Hartmann
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
