On Sun, 10 Sep 2006 20:30:03 -0600 Gary V <[EMAIL PROTECTED]> wrote: > No, the SQL field spam_quarantine_to needs to be NULL in the policy > table. > > mysql> use amavisd; > (or whatever your amavis database is called) > > Before, list current spam_quarantine_to data in the policy table, and note it: > mysql> SELECT id,spam_quarantine_to FROM policy; > +----+--------------------+ > | id | spam_quarantine_to | > +----+--------------------+ > | 5 | NULL | > | 1 | | > | 2 | | > | 3 | | > | 4 | | > | 6 | | > | 7 | | > | 8 | | > | 9 | | > | 10 | | > | 11 | | > +----+--------------------+ > 11 rows in set (0.01 sec) > > You may possibly need to change the data type of spam_quarantine_to: > mysql> ALTER TABLE `policy` CHANGE `spam_quarantine_to` `spam_quarantine_to` > VARCHAR( 64 ) NULL DEFAULT NULL; > > Then update all policies to NULL: > mysql> UPDATE `policy` SET `spam_quarantine_to` = NULL; > > mysql> SELECT id,spam_quarantine_to FROM policy; > +----+--------------------+ > | id | spam_quarantine_to | > +----+--------------------+ > | 5 | NULL | > | 1 | NULL | > | 2 | NULL | > | 3 | NULL | > | 4 | NULL | > | 6 | NULL | > | 7 | NULL | > | 8 | NULL | > | 9 | NULL | > | 10 | NULL | > | 11 | NULL | > +----+--------------------+ > 11 rows in set (0.01 sec) > > Gary V >
Bingo!!!!! Changing this worked. The value in the database was spam-quarantine with that as the 'default' value. mysql> select id,spam_quarantine_to from policy; +----+--------------------+ | id | spam_quarantine_to | +----+--------------------+ | 7 | spam-quarantine | | 3 | spam-quarantine | | 1 | spam-quarantine | | 2 | spam-quarantine | | 6 | spam-quarantine | | 5 | spam-quarantine | | 4 | spam-quarantine | +----+--------------------+ 7 rows in set (0.00 sec) It's strange that this works on the other server. Once I changed values to NULL.. I'm seeing quarantined items. Now, to touch on the question earlier about bad-headers...is there a way to pass those completely without quarantining them? Thanks for everything. hanji -- Key ID: 68CE3C73 Fingerprint: 815A 5232 BEF5 3DEF 7640 E5DA 7570 027F 68CD 3C73 ------------------------------------------------------------------------- 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/
