Corrupt attachment

Moderator: crythias

Locked
JLindberg
Znuny newbie
Posts: 12
Joined: 18 Jan 2011, 00:32
Znuny Version: 3.05

Corrupt attachment

Post by JLindberg »

Hi

I have installed OTRS 3.05 and everything works perfect except that the attached files in the tickets are corrupt, pdf, doc, docx, xls,xlsx etc... Also files in the FAQ och the PDF-files to download in packages area are corrupt. Ihave tried StorageDB and StorageFS, but the result is the same. If i opened the file from the filesystem it is working (StorageFS).

If i send the attachments to the customer with otrs, the customer can open the files without any problems.

The charset is UTF-8 in OTRS and the database.

Anyone have any idea??, i have read som topics and it seems that it was a problem in 3.04 but that it should be solved in 3.05.

/Jonas
Production site 1
OTRS 3.06 Hosted
W2008 R2 64-Bit
IIS 7.5
Activestate Perl 64-Bit
MySQL enterprise edition 5.5.8
Production site 2
OTRS 3.06
W2008 32-Bit Hosted
Apache 2.2
StrawberryPerl
MySQL enterprise edition 5.5.8
Devsite
OTRS 3.06 ITSM RC1 Hosted
W2008 R2 32-Bit
Apache 2.2
StrawberryPerl
MySQL enterprise edition 5.5.8
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Corrupt attachment

Post by jojo »

it seems that this is a bug, which is IIS related. Please use forums search
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
shailesh
Znuny newbie
Posts: 29
Joined: 11 Feb 2011, 14:03
Znuny Version: 3.5

Re: Corrupt attachment

Post by shailesh »

I am also facing same problem , did you get any solution ?

Thanks & Regards
JLindberg
Znuny newbie
Posts: 12
Joined: 18 Jan 2011, 00:32
Znuny Version: 3.05

Re: Corrupt attachment

Post by JLindberg »

Yes i found a solution in a topic in another forum, however i am not with my home computer so i cant find the link. But it is the same fix as for 3.04. You have yo edit som files, change from utf8 to iso-xxxx-xx.

I will post the link when i am get home, in a week, am in india right now.
Production site 1
OTRS 3.06 Hosted
W2008 R2 64-Bit
IIS 7.5
Activestate Perl 64-Bit
MySQL enterprise edition 5.5.8
Production site 2
OTRS 3.06
W2008 32-Bit Hosted
Apache 2.2
StrawberryPerl
MySQL enterprise edition 5.5.8
Devsite
OTRS 3.06 ITSM RC1 Hosted
W2008 R2 32-Bit
Apache 2.2
StrawberryPerl
MySQL enterprise edition 5.5.8
ictzug
Znuny newbie
Posts: 4
Joined: 12 May 2011, 15:40
Znuny Version: 3.0.7
Real Name: Reto Brand
Company: MIBAG Property + Facility Management AG

Re: Corrupt attachment

Post by ictzug »

Hi

I've exactly the same problem with the charset.

By using UTF-8:
- OTRS delivers the attachment in a wrong way, they're corrupt
- By old tickets which were created by charset iso-8859-1 and
for new tickets which were created by charset utf-8 also
- If I browse to the folder, the attachment is allright
- I use File Storage

By using iso-8859-1, OTRS delivers the attachment without problem.

My environment:

- OTRS 3.0.7 (started with OTRS 2.3 and done the updates for every new release)
- IIS 6 on Win 2003
- MS SQL 2008 R2 on Win 2008 R2

I've looked a long time in several forums, but I didn't find a solution. Does anyone know how to resolve this behavior?

Thanks a lot!

ictzug
ictzug
Znuny newbie
Posts: 4
Joined: 12 May 2011, 15:40
Znuny Version: 3.0.7
Real Name: Reto Brand
Company: MIBAG Property + Facility Management AG

Re: Corrupt attachment

Post by ictzug »

Hi

Ifound the solution. I use ActivePerl 5.10.1 Build 1006. By start with OTRS 2.3 there was a problem
with incomplete http headers. The solution was to map .pl files with <perl.exe "%s" %s> in IIS 6.
That works, but it's slowly.

Everything was working until I've changed OTRS 3.0.x to utf-8. After a lot of try and error, I changed
the mapping of .pl to <PerlEx30.dll> in IIS 6. That was it, the problem with incomplete http header
from OTRS 2.3 seems to solved and the download of the attachments is working now. And OTRS is faster.

ictzug
Locked