Nikolay, > based on: gentoo with postfix-2.2.10, amavisd-new-2.4.1, > PostgreSQL-8.0.9-r1, clamav-0.90, spamassassin-3.1.3 and > courieri-imap-4.0.4. I have a db amavis where all the spam and virus > messages are saved, BUT only the spam goes there. When i receive virus > message the following error is received: > > Feb 26 13:29:36 dexter postfix/lmtp[11136]: BBB7D8DBD9: > to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1], delay=2, > status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in > processing, id=11138-01, quar+notif FAILED: temporarily unable to > quarantine: 451 4.5.0 Storing to sql db as mail_id M+ECNSAIM2Mb failed: > writing mail text to SQL failed: Error closing, flush: sql inserting > text failed, sql exec: err=7, 22P02, DBD::Pg::st execute failed:
> ERROR: invalid input syntax for type bytea > http://www.ijs.si/software/amavisd/README.sql.txt > as is described there the quarantine.mail_text field type is bytea, > and from the beginning it was in this type. Which version of Perl module DBD::Pg ? You should be using the latest (1.49). It is probably due to a CPAN bug #18264. Also the following may be related, fixed with amavisd-new-2.4.4 (or 2.4.5): amavisd-new-2.4.4 release notes - PostgreSQL: when storing mail text to a quarantine use pg_type=PG_BYTEA attribute with a field 'quarantine.mail_text'; - SQL logging: cleanly chop an UTF-8 octet sequence according to RFC 3629 (avoid truncating character octet sequence tail) when Subject, From or Message-Id header field is longer than 255 characters; - SQL: explicitly call DBI::bind_param to be able to specify data types of values passed in @args to Amavis::Out::SQL::Connection::execute; Mark ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ 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/