Re: [AMaViS-user] error in virus quarantine at SQL db bytea type

[Nikolay B. <ano...@gm...>]

Thanks for the fast answer Mark :)
Yes i have readed that there is a bug in DBD:Pg, and i upgraded to
version 1.49 but the problem is still there. I'll upgrade amavis now and
i will tell the result.

Regards,
Niki

Mark Martinec wrote:
> 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=<us...@do...>, 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
> AMa...@li...
> https://lists.sourceforge.net/lists/listinfo/amavis-user
> AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
> AMaViS-HowTos:http://www.amavis.org/howto/
> 


-- 
Cyberly yours,
Nikolay Balov

mail: ano...@gm...
Linux Registered User #382280
http://keyserver.linux.it/
Key fingerprint = D80E A05B 5727 B40C 7431  2CC0 0845 E79E 428A 1109