nikss, > I found in amavisd source that a code responsible for sql logging is > located in array? %sql_clause > What is the best option to modify logging SQL queries to fit to my > database schema?? > for example i had already table users with fields email,domain and i > dont want to create another table maddr with duplicate data for amavisd > logging
Indeed the %sql_clause holds all SQL clauses in use, and may be modified in amavisd.conf. The file amavisd.conf-default shows default settings (or see file amavisd). The relevant keys for logging are sel_adr, ins_adr, ins_msg, upd_msg, ins_rcp. If a change you want can not be covered by modifying SQL clause alone, you may need to modify the list of supplied arguments to SQL call. The relevant subroutines are: find_or_save_addr save_info_preliminary save_info_final where arguments to >execute may need to be modified. The basic idea about storing email addresses (regardless of being recipient or sender address) is: because a sizable proportion of mail addresses occurs repeatedly, it makes sense to store full addresses into a separate table, and only store a shorter uniqe id with each msgs and msgrcpt record. Mrak ------------------------------------------------------------------------- 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/