Martin,
> 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).
>
> 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.
> 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?
Here is the patch:
--- amavisd.orig Thu May 31 14:10:01 2007
+++ amavisd Thu Jun 14 18:12:29 2007
@@ -12943,5 +12943,5 @@
# set new amavis message id
new_am_id( ($fname =~ m{amavis-(milter-)?([^/ \t]+)}s ? $2 : undef) )
- if $releasing;
+ if !$releasing;
# file created by amavis helper program or other client, just open it
my(@stat_list) = lstat($fname); my($errn) = @stat_list ? 0 : 0+$!;
@@ -12962,4 +12962,5 @@
}
$msginfo->mail_text($fh); # save file handle to object
+ $msginfo->log_id(am_id());
}
if ($ampdp) {
Sorry for the delay, I was starring at the bug but I couldn't see it.
Thanks for a problem report.
Mark
-------------------------------------------------------------------------
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/
