Peter Huetmannsberger wrote:

> I am running sendmail with Petr Rehor's amavisd-milter and on this new
> machine I am storing spam and the rest in a mysql database.
> If I add the following to amavisd.conf:
> $policy_bank{'SMTP_AUTH'} = {
>   originating => 1,
>   bypass_banned_checks_maps => [1],
>   bypass_spam_checks_maps => [1],
>   os_fingerprint_method => undef,
> };
> I get the following result.
>
> policy "MYNETS", which is basically the same works fine. Or do I need to
> change something in the mysql table setup in order to make it work.

How do you load this policy bank? Through a "policy_bank=..." attribute
in AM.PDP request?

> Jan  7 22:21:54 george3.eliot.priv.at /usr/sbin/amavisd[5503]: (05503)
> (!)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
> (`mail/msgrcpt`, CONSTRAINT `msgrcpt_ibfk_2` FOREIGN KEY (`mail_id`)
> REFERENCES `msgs` (`mail_id`) ON DELETE CASCADE) at (eval 77) line 169.

This is a side effect of a previous error.

> Jan  7 23:12:07 george3.eliot.priv.at /usr/sbin/amavisd[6313]: (06313)
> (!)WARN save_info_preliminary: sql exec: err=, , Insecure dependency in
> parameter 2 of DBI::st=HASH(0xad9e7b0)->bind_param method call while running
> with -T switch at (eval 77) line 167, <GEN11> line 13.   

I see. This is the root of a problem.

Which version of Perl is that?

  Mark

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
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/

Reply via email to