Mark Martinec wrote:
> 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
Great, many thanks for the quick help Mark. It seems to do the trick.
Have a nice weekend list-members!
/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
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/
