CREATE TABLE `policy` ( `id` int(10) unsigned NOT NULL auto_increment, `domain` varchar(32) default NULL, `virus_lover` char(1) default NULL, `spam_lover` char(1) default NULL, `banned_files_lover` char(1) default NULL, `bad_header_lover` char(1) default NULL, `bypass_virus_checks` char(1) default NULL, `bypass_spam_checks` char(1) default NULL, `bypass_banned_checks` char(1) default NULL, `bypass_header_checks` char(1) default NULL, `spam_modifies_subj` char(1) default NULL, `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, `spam_tag2_level` float default NULL, `spam_kill_level` float default NULL, `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, `warnbannedrecip` char(1) default NULL, `warnbadhrecip` char(1) default NULL, `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` int(11) default NULL, `banned_rulenames` varchar(64) default NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Policy Table' AUTO_INCREMENT=1 ;
-- -- Dumping data for table `policy` -- INSERT INTO `policy` VALUES (1, 'Default', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', NULL, NULL, NULL, NULL, -30, 5, 7, 5, NULL, NULL, NULL, NULL, 'Y', 'N', 'N', NULL, NULL, NULL, NULL, NULL, '*** SPAM ***', '*** SPAM ***', NULL, NULL); i am lost in this one, since i don't know how to realy make this sql table work from amavisd :( whitelist/blacklist is static in amavisd.conf, so i just need to have the policy sql conf working, one last thing is that i have searched for sql loging, but not found a howto on that :/ ------------------------------------------------------- This SF.Net email is sponsored by the JBoss Inc. Get Certified Today Register for a JBoss Training Course. Free Certification Exam for All Training Attendees Through End of 2005. For more info visit: http://ads.osdn.com/?ad_idv28&alloc_id845&op=click _______________________________________________ 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/
