Problems with attachment

Hi,

We are having problems with xls-attachments, using rt 3.0.6 with Apache 1.3.29, mod_perl 1.29, perl 5.8.1 (with the IO::Stringy-hack from Jesse) on SuSE-Linux SLES8.
(I know, we better should use rt 3.0.8, but we just upgraded from rt 1.0 two months ago.)

Some attachments (excel-sheets) are utf8-encoded in the database, which shouldn’t be like that.
Therefore I put into Ticket/Attachment/dhandler something like:

$m->clear_buffer();
  • my $d = Encode::decode_utf8($data);
  • if ($d) {
  •  $data=$d;
    
  • }
    $m->out($data);

The decode_utf8 is working as expected (I have checked that by doing an
additional $data=MIME::Base64::encode_base64($d) in the example above and/or
writing the result into a tmp-file). However, the m->out($data) is doing an utf8-encoding
again and the result looks the same as before.

Is there a way, to prevent this utf8-encoding on the way out and get the data in binary-form?

We are having tickets with similar xls-attachments, which are stored in “binary”-form in the
database.
These ones can be opened in the browser correctly and everything is fine.
The “Content-Type” is set to “application/vnd.ms-excel” in both cases.

Does anybody have some ideas or hints, what one can be done, so that the data is sent in binary form
with $m-out() ??

Thanks in advance!

Christian Mittag

Christian Mittag
Siemens Business Services
D-81739 Muenchen, Otto-Hahn-Ring 6
mailto:Christian.Mittag@siemens.com

Hi,

We are having problems with xls-attachments, using rt 3.0.6 with Apache 1.3.29, mod_perl 1.29, perl 5.8.1 (with the IO::Stringy-hack from Jesse) on SuSE-Linux SLES8.
(I know, we better should use rt 3.0.8, but we just upgraded from rt 1.0 two months ago.)

Some attachments (excel-sheets) are utf8-encoded in the database, which shouldn’t be like that.

I’d be sort of surprised if non-text files are being encoded. But I’d
also really like to hear if this is still a problem with RT 3.0.8, as
we’ve done a lot of work on making sure that binary attachments are
handled right.

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

I’m afraid it’s still a problem in 3.0.8. I just got a corrupted xls
file from a user.

Running: RT 3.0.8, Apache 1.3.29, perl 5.8.2, mod_perl 1.29, and the
latest perl modules according to CPAN.

-=Kevin=-From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Thursday, January 15, 2004 6:59 AM
To: Mittag Christian
Cc: ‘rt-users@fsck.com’
Subject: Re: [rt-users] Problems with attachment

Hi,

We are having problems with xls-attachments, using rt 3.0.6 with
Apache 1.3.29, mod_perl 1.29, perl 5.8.1 (with the IO::Stringy-hack from
Jesse) on SuSE-Linux SLES8.
(I know, we better should use rt 3.0.8, but we just upgraded from rt
1.0 two months ago.)

Some attachments (excel-sheets) are utf8-encoded in the database,
which shouldn’t be like that.

I’d be sort of surprised if non-text files are being encoded. But I’d
also really like to hear if this is still a problem with RT 3.0.8, as
we’ve done a lot of work on making sure that binary attachments are
handled right.

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Have you tried
http://download.bestpractical.com/pub/rt/devel/IO-stringy-Hacked-For-UTF8-2.
109-BestPractical-Hack-20040107.tar.gz ? It solved the problems with
corrupted attachments for me.

A.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of O’Brien,
Kevin
Sent: Friday, January 16, 2004 11:06 PM
To: rt-users@fsck.com
Subject: RE: [rt-users] Problems with attachment

I’m afraid it’s still a problem in 3.0.8. I just got a corrupted xls
file from a user.

Running: RT 3.0.8, Apache 1.3.29, perl 5.8.2, mod_perl 1.29, and the
latest perl modules according to CPAN.

-=Kevin=-

From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Thursday, January 15, 2004 6:59 AM
To: Mittag Christian
Cc: ‘rt-users@fsck.com’
Subject: Re: [rt-users] Problems with attachment

Hi,

We are having problems with xls-attachments, using rt 3.0.6 with
Apache 1.3.29, mod_perl 1.29, perl 5.8.1 (with the IO::Stringy-hack from
Jesse) on SuSE-Linux SLES8.
(I know, we better should use rt 3.0.8, but we just upgraded from rt
1.0 two months ago.)

Some attachments (excel-sheets) are utf8-encoded in the database,
which shouldn’t be like that.

I’d be sort of surprised if non-text files are being encoded. But I’d
also really like to hear if this is still a problem with RT 3.0.8, as
we’ve done a lot of work on making sure that binary attachments are
handled right.

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

rt-users mailing list
rt-users@lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

That seems to have done it! Thanks!

-=Kevin=-From: Aleš Sušnik [mailto:alesh@sportina.si]
Sent: Friday, January 16, 2004 2:50 PM
To: O’Brien, Kevin; rt-users@fsck.com
Subject: RE: [rt-users] Problems with attachment

Have you tried
http://download.bestpractical.com/pub/rt/devel/IO-stringy-Hacked-For-UTF8-2.
109-BestPractical-Hack-20040107.tar.gz ? It solved the problems with
corrupted attachments for me.

A.

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of O’Brien,
Kevin
Sent: Friday, January 16, 2004 11:06 PM
To: rt-users@fsck.com
Subject: RE: [rt-users] Problems with attachment

I’m afraid it’s still a problem in 3.0.8. I just got a corrupted xls
file from a user.

Running: RT 3.0.8, Apache 1.3.29, perl 5.8.2, mod_perl 1.29, and the
latest perl modules according to CPAN.

-=Kevin=-

From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Thursday, January 15, 2004 6:59 AM
To: Mittag Christian
Cc: ‘rt-users@fsck.com’
Subject: Re: [rt-users] Problems with attachment

Hi,

We are having problems with xls-attachments, using rt 3.0.6 with
Apache 1.3.29, mod_perl 1.29, perl 5.8.1 (with the IO::Stringy-hack from
Jesse) on SuSE-Linux SLES8.
(I know, we better should use rt 3.0.8, but we just upgraded from rt
1.0 two months ago.)

Some attachments (excel-sheets) are utf8-encoded in the database,
which shouldn’t be like that.

I’d be sort of surprised if non-text files are being encoded. But I’d
also really like to hear if this is still a problem with RT 3.0.8, as
we’ve done a lot of work on making sure that binary attachments are
handled right.

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.
rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

rt-users mailing list
rt-users@lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm