Üllar,

> I can't make amavisd-new to log into mysql table. Followed
> http://www.ijs.si/software/amavisd/README.sql.txt but no luck. Table maddr
> is ok but nothing gets into msgrcpt, msgs or quarantine.
> mail.log is at http://pastebin.com/703932

> Jun 12 10:02:54 localhost amavis[17367]: (17367-01)
>   (!) WARN save_info_preliminary: sql exec: err=, ,
>   Insecure dependency in parameter 10 of DBI::st=HASH(0xb5f5ce8)->execute
>   method call while running with -T switch at (eval 40) line 138

Please try 2.4.1, it added some more workarounds for Perl taint bugs.

amavisd-new-2.4.1 release notes:
- add another round of local($1) declarations as a workaround for already
  familiar Perl taint bugs, popping up again on some Perl installations;

> Jun 12 10:03:30 localhost amavis[17367]: (17367-01)
>   (!) WARN save_info_final: sql exec: err=1452, S1000, DBD::mysql::st
>   execute failed: Cannot add or update a child row: a foreign
>  key constraint fails
>   (`provider/msgrcpt`, CONSTRAINT `msgrcpt_ibfk_2`
>   FOREIGN KEY (`mail_id`) REFERENCES `msgs` (`mail_id`)
>   ON DELETE CASCADE) at (eval 40) line 138

Not sure, but is likely a consequence of the above.

  Mark


_______________________________________________
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