Thanks Marcel, I'll check the Docs.
Best Regards, Leon -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marcel Hartmann Sent: Sunday, August 07, 2005 6:11 PM To: [email protected] Subject: RE: [Web-cyradm] ToDo List/changelog and Buglist etc. 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 _______________________________________________ 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
