Ian, > I have a small issue with content filtering and cant get my around > it. When I enable @lookup_sql_dsn in the amavisd.conf file postfix > smtp process gives me an error.
> If I disable @lookup_sql_dsn and just use the defaults from the > amavisd conf file everthing is ok. > Feb 13 23:41:31 freebsd. domain.net /usr/local/bin/amavisd[16291]: > (16291-01) sql: preparing and executing: SELECT *,users.id FROM > users,policy WHERE (users.policy_id=policy.id) AND (users.email IN > (?,?,?,?,?)) ORDER BY users.priority DESC > Feb 13 23:41:31 freebsd.domain.net /usr/local/bin/amavisd[16281]: > Net::Server: Starting "1" children Process 16291 crashed, Net::Server started a replacement. As this seem to be related to SQL lookups, the first likely culprit is a C code in a SQL client library or DBD interface code. Try recompiling and reinstalling a DBD perl module (after freshening up ports). Since you are on a FreeBSD, that would be the databases/p5-DBD-mysql or databases/p5-DBD-Pg . If you are interested why it crashed, you may start amavisd through truss: # su vscan $ truss -f amavisd foreground Mark 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 [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/
