Hank wrote: > On Sun, 10 Sep 2006 18:59:40 -0600 > Gary V <[EMAIL PROTECTED]> wrote: >> >> Looks like policy.spam_quarantine_to should be set to NULL instead of >> empty, You show: >> >> lookup_sql_field(spam_quarantine_to) "[EMAIL PROTECTED]" result= >> >> and for you it should be >> >> lookup_sql_field(spam_quarantine_to) "[EMAIL PROTECTED]" result=undef >> >> Gary V >>
> Again.. thanks for helping on this. I added $spam_quarantine_to = > undef; to the conf. Adding NULL returned a Bareword error (not allowed > while 'strict subs'). A re-ran my test with logging at 5 again. It's > still returning result= for spam_quarantine_to. What I don't get is this > is the exact same conf as the working server minus 3 values ($mydomain, > $myhostname and @local_domain_maps()). > Thanks much. > hanji 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 ------------------------------------------------------------------------- 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/
