Martin, > Only when enabling penpal i am not really sure whether i have to set: > # %sql_clause = ( > # 'sel_penpals' => > # "SELECT msgs.time_num, msgs.mail_id, subject". > # " FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id". > # " WHERE sid=? AND rid=? AND ds='P' AND content!='V'". > # " ORDER BY time_num DESC LIMIT 1", > # ); > or if the above is the default and will be used if i do not specify any sql > clause.
It is a default, no need to set it explicitly. See amavisd.conf-default. > Logging to sql is working and i am using the default tables > mentioned in readme.sql with the proposed change for mysql: time_iso > TIMESTAMP NOT NULL DEFAULT 0. Good. Mark ------------------------------------------------------------------------- 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 AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/