I’ve been trying to move to RT3 for a few weeks now. One last obstacle
stands in my way, but I fear it’s going to be the worst one yet!
I took heed of the predictions of doom and upgraded to perl 5.8.3 a few
weeks ago (many full stop/start cycles in the past now), but I’m still
seeing broken binary attachments. Text and HTML seem to attach and decode
fine, but when I try
to attach a 127k PDF to a ticket, either by email or using the web
interface, I get a 5.7k attachment.
The only errors I see in the apache log are:
[Sun Mar 7 20:32:22 2004] [error] [client 18.104.22.168] FastCGI: server
"/usr/local/rt3/bin/mason_handler.fcgi" stderr: Use of uninitialized value
in length at /usr/lib/perl5/site_perl/5.8.3/Text/Quoted.pm line 228,
which although worrying, don’t seem related to the binary attachment issue.
Poking into this from the Oracle side of things, I see the following
SQL> select DBMS_LOB.GETLENGTH(CONTENT) from “RT3_IFAX”.“ATTACHMENTS” WHERE
"ID" = 22747;
That size (176541) looks about reasonable for an encoded 127k binary file,
if you ask me! And yet here’s what the web interface reports on the lower
right-hand corner of the transaction:
Download webinar.pdf 5.7k
That’s also the size of the attachment the requestor received by email,
I attached another larger (400k) PDF to the ticket. The length of the CLOB
was about right, and yet again, the web interface showed:
Download passport.pdf 5.7k
This just has to be a bug with the Oracle port. I hope!? Anyone running
3.0.9 with Oracle?