A quick follow up, if I use the same config and setup with 2.5.0 it works. So it has to be something in 2.5.1 that has changed, but I can't figure out what. Any ideas?
Thanks all. Best regards, Martin Martin Svensson wrote: > 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/ ------------------------------------------------------------------------- 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/
