Hi all, I've just reinstalled our staging area with the latest amavis release etc on RHEL5. I've created the mysql-db according to README.sql-mysql to be used with the SQL Logging features (not quarantine).
I keep getting the error below, any ideas why am_id is null? The setup is the classic amavis-milter<->sendmail (AM.CL protocol, and it's changed in amavis.conf from am.pdp->am.cl). The error is: Jun 12 15:09:57 xxx.yyy /usr/local/sbin/amavisd[16668]: sql begin transaction Jun 12 15:09:57 xxx.yyy /usr/local/sbin/amavisd[16668]: sql: preparing and executing: INSERT INTO msgs (mail_id, secret_id, am_id, time_num, time_iso, sid, policy, client_addr, size, host) VALUES (?,?,?,?,?,?,?,?,?,?) Jun 12 15:09:57 xxx.yyy /usr/local/sbin/amavisd[16668]: sql rollback Jun 12 15:09:57 xxx.yyy/usr/local/sbin/amavisd[16668]: save_info_preliminary: rollback done Jun 12 15:09:57 xxx.yyy /usr/local/sbin/amavisd[16668]: (!)WARN save_info_preliminary: sql exec: err=1048, 23000, DBD::mysql::st execute failed: Column 'am_id' cannot be null at (eval 52) line 169, <GEN9> line 4. After that a couple of other errors occurs on the msgrcpt field, I suppose it has something to do with the above. Jun 12 15:10:09 xxx.yyy /usr/local/sbin/amavisd[16668]: sql: preparing and executing: INSERT INTO msgrcpt (mail_id, rid, ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?) Jun 12 15:10:09 xxx.yyy /usr/local/sbin/amavisd[16668]: sql rollback Jun 12 15:10:09 xxx.yyy /usr/local/sbin/amavisd[16668]: save_info_final: rollback done Jun 12 15:10:09 xxx.yyy /usr/local/sbin/amavisd[16668]: (!)WARN save_info_final: sql exec: err=1452, 23000, DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`amavis/msgrcpt`, CONSTRAINT `msgrcpt_ibfk_2` FOREIGN KEY (`mail_id`) REFERENCES `msgs` (`mail_id`) ON DELETE CASCADE) at (eval 52) line 169, <GEN9> line 18. Any ideas are welcome! Thanks. /Martin ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ 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/
