<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal>Hello everyone,<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US>I have a problem with our RT installation
here: It is an RT 3.8.7 install with Postgres as database backend. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>When uploading a file through the web
frontend which contains special characters (like “Polizeipräsidium”),
RT silently (!) fails to upload the file. The log message shows, that
appearantly some characterset conversions are missing in this case.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>The basic translation of the error message is
about: “Invalid Byte-Sequence for encoding UTF8. This error can occur
alos, if the byte sequence does not match the encoding expected by the server
and set in the client_encoding.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>I would appreciate any help in how to fix
this.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US> [Fri Apr 30 09:15:21 2010] [crit]:
Apache2::RequestIO::rflush: (103) Software caused connection abort at
/usr/share/perl5/HTML/Mason/ApacheH<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>andler.pm line 1026
(/usr/share/request-tracker3.8/libexec/webmux.pl:168)<o:p></o:p></span></p>
<p class=MsoNormal>[Fri Apr 30 09:15:33 2010] [warning]: DBD::Pg::st execute
failed: FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369<o:p></o:p></p>
<p class=MsoNormal>HINT: Dieser Fehler kann auch auftreten, wenn die
Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet,
welche durch<o:p></o:p></p>
<p class=MsoNormal><span lang=EN-US>»client_encoding« bestimmt wird. at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:5<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>09)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>[Fri Apr 30 09:15:33 2010] [warning]:
RT::Handle=HASH(0x44765d0) couldn't execute the query 'INSERT INTO Attachments
(Subject, Filename, Con<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>tentType, Headers, Creator, MessageId,
Parent, Created, Content, ContentEncoding, TransactionId) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)' a<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>t
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x44765d0)', 'INSERT
INTO Attachments (Subject, Filename, ContentType, Hea<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>d...', 'Polizeipr<E4>sidiums
Mittelfranken.xls', 'Polizeipr<E4>sidiums Mittelfranken.xls',
'application/vnd.ms-excel', 'MIME-Version: 1.0\x{<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>a}Subject: Polizeipr\x{e4}sidiums
Mittelfranken.xl...', 22, '', 185867, ...) called at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 35<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>7<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x44765d0)',
'Attachments', 'Subject', 'Polizeipr<E4>sidiums Mittelfranken.xls'<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>, 'Filename', 'Polizeipr<E4>sidiums
Mittelfranken.xls', 'ContentType', 'application/vnd.ms-excel', 'Headers', ...)
called at /usr/share/perl<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>5/DBIx/SearchBuilder/Handle/Pg.pm line 66<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0x44765d0)',
'Attachments', 'Subject', 'Polizeipr<E4>sidiums Mittelfranken.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>xls', 'ContentType',
'application/vnd.ms-excel', 'Filename', 'Polizeipr<E4>sidiums
Mittelfranken.xls', 'Headers', ...) called at /usr/share/<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>perl5/DBIx/SearchBuilder/Record.pm line
1293<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x5664d40)',
'Subject', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'Filename<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>', 'Polizeipr<E4>sidiums
Mittelfranken.xls', 'ContentType', 'application/vnd.ms-excel', 'Headers',
'MIME-Version: 1.0\x{a}Subject: Polizeipr<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>\x{e4}sidiums Mittelfranken.xl...', ...)
called at /usr/share/request-tracker3.8/lib/RT/Record.pm line 289<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Record::Create('RT::Attachment=HASH(0x5664d40)', 'TransactionId', 252488,
'ContentType', 'application/vnd.ms-excel', 'ContentEnc<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>oding', 'base64', 'Parent', 185867, ...)
called at /usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 178<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Attachment::Create('RT::Attachment=HASH(0x5664d40)', 'TransactionId',
252488, 'Parent', 185867, 'Attachment', 'MIME::Entity=HASH(0x5743be8)') called
at /usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 158<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Attachment::Create('RT::Attachment=HASH(0x54038a0)', 'TransactionId',
252488, 'Attachment', 'MIME::Entity=HASH(0x5041010)') called at
/usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 514<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> RT::Transaction::_Attach('RT::Transaction=HASH(0x54101e8)',
'MIME::Entity=HASH(0x5041010)') called at
/usr/share/request-tracker3.8/lib/RT/Transaction_Overlay.pm line 154<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Transaction::Create('RT::Transaction=HASH(0x54101e8)', 'ObjectId', 13698,
'ObjectType', 'RT::Ticket', 'TimeTaken', '', 'Type', 'Correspond', ...) called
at /usr/share/request-tracker3.8/lib/RT/Record.pm line 1457<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Record::_NewTransaction('RT::Ticket=HASH(0x3f150b8)', 'Type', 'Correspond',
'Data', 'No Subject', 'TimeTaken', '', 'MIMEObj',
'MIME::Entity=HASH(0x5041010)', ...) called at
/usr/share/request-tracker3.8/lib/RT/Ticket_Overlay.pm line 2175<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Ticket::_RecordNote('RT::Ticket=HASH(0x3f150b8)', 'BccMessageTo', '',
'CcMessageTo', '', 'NoteType', 'Correspond', 'TimeTaken', '', ...) called at
/usr/share/request-tracker3.8/lib/RT/Ticket_Overlay.pm line 2087<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Ticket::Correspond('RT::Ticket=HASH(0x3f150b8)', 'BccMessageTo', '',
'CcMessageTo', '', 'MIMEObj', 'MIME::Entity=HASH(0x5041010)', 'TimeTaken', '',
...) called at /usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 1147<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Commands::ProcessUpdateMessage('ARGSRef', 'HASH(0x51fcb78)',
'Actions', 'ARRAY(0x520ac88)', 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)')
called at /usr/local/share/request-tracker3.8/html/Ticket/Display.html line 145<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Commands::__ANON__('TicketObj', 'RT::Ticket=HASH(0x3f150b8)',
'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '',
'QuoteTransaction', ...) called at /usr/share/perl5/HTML/Mason/Component.pm
line 135<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5212f48)',
'TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '', 'SubmitTicket',
'Anfrage Aktualisieren', 'Status', '', ...) called at
/usr/share/perl5/HTML/Mason/Request.pm line 1302<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> eval {...} called at
/usr/share/perl5/HTML/Mason/Request.pm line 1292<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> HTML::Mason::Request::comp(undef,
undef, 'TicketObj', 'RT::Ticket=HASH(0x3f150b8)', 'UpdateCc', '',
'SubmitTicket', 'Anfrage Aktualisieren', 'Status', ...) called at
/usr/share/request-tracker3.8/html/Ticket/Update.html line 261<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Commands::__ANON__('UpdateCc', '', 'SubmitTicket', 'Anfrage
Aktualisieren', 'Status', '', 'QuoteTransaction', '', 'UpdateBcc', ...) called
at /usr/share/perl5/HTML/Mason/Component.pm line 135<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x5054f68)',
'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '',
'QuoteTransaction', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm
line 1302<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> eval {...} called at
/usr/share/perl5/HTML/Mason/Request.pm line 1292<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> HTML::Mason::Request::comp(undef,
undef, undef, 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren',
'Status', '', ...) called at
/usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 320<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Interface::Web::ShowRequestedPage('HASH(0x4f3a358)') called at
/usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 224<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Interface::Web::HandleRequest('HASH(0x4f3a358)') called at
/usr/share/request-tracker3.8/html/autohandler line 53<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> HTML::Mason::Commands::__ANON__('UpdateCc',
'', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction',
'', 'UpdateBcc', ...) called at /usr/share/perl5/HTML/Mason/Component.pm line
135<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x4f3a7f0)',
'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '',
'QuoteTransaction', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm
line 1297<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> eval {...} called at
/usr/share/perl5/HTML/Mason/Request.pm line 1292<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> HTML::Mason::Request::comp(undef,
undef, undef, 'UpdateCc', '', 'SubmitTicket', 'Anfrage Aktualisieren',
'Status', '', ...) called at /usr/share/perl5/HTML/Mason/Request.pm line 481<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> eval {...} called at
/usr/share/perl5/HTML/Mason/Request.pm line 481<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> eval {...} called at
/usr/share/perl5/HTML/Mason/Request.pm line 433<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x575a4d0)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x575a4d0)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x4cc17f8)',
'Apache2::RequestRec=SCALAR(0x5772ad8)') called at
/usr/share/request-tracker3.8/libexec/webmux.pl line 166<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> eval {...} called at
/usr/share/request-tracker3.8/libexec/webmux.pl line 166<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x5772ad8)') called at -e line 0<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US> eval {...} called at -e line 0
(/usr/share/perl/5.10/Carp.pm:47)<o:p></o:p></span></p>
<p class=MsoNormal>[Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed:
FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369<o:p></o:p></p>
<p class=MsoNormal>HINT: Dieser Fehler kann auch auftreten, wenn die
Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet,
welche durch »client_encoding« bestimmt wird.
(/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm:191)<o:p></o:p></p>
<p class=MsoNormal>[Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed:
FEHLER: ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369<o:p></o:p></p>
<p class=MsoNormal>HINT: Dieser Fehler kann auch auftreten, wenn die
Bytesequenz nicht mit der Kodierung übereinstimmt, die der Server erwartet,
welche durch »client_encoding« bestimmt wird. <span lang=EN-US>(/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm:164)<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US>Mit freundlichen Grüßen,<br>
Torben Nehmer</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:7.5pt'>-------<br>
Torben Nehmer<br>
Diplom Informatiker (FH)<br>
Business System Developer</span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:7.5pt'>CANCOM Deutschland GmbH<br>
Messerschmittstr. 20<br>
89343 Scheppach<br>
Germany</span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
lang=EN-US style='font-size:7.5pt'>Tel.: +49 8225 - 996-1118<br>
Fax: +49 8225 - 996-41118<br>
</span><span style='font-size:12.0pt'><a href="mailto:torben.nehmer@cancom.de"><span
lang=EN-US style='font-size:7.5pt;color:blue'>torben.nehmer@cancom.de</span></a></span><span
lang=EN-US style='font-size:10.0pt'><br>
</span><span style='font-size:10.0pt'><a href="http://www.cancom.de"><span
lang=EN-US style='font-size:7.5pt;color:blue'>www.cancom.de</span></a></span><span
lang=EN-US style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:7.5pt'>CANCOM Deutschland GmbH<br>
Sitz der Gesellschaft: Jettingen-Scheppach<br>
HRB 10653 Memmingen<br>
<span style='color:black'>Geschäftsführer: Paul Holdschik, Christian
Linder</span></span><span style='font-size:12.0pt'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:7.5pt'>Diese E-Mail und alle
mitgesendeten Dateien sind vertraulich und ausschließlich für den Gebrauch
durch den Empfänger bestimmt! <br>
</span><span lang=EN-US style='font-size:7.5pt'>This e-mail and any files
transmitted with it are confidential intended solely for the use of the
addressee!</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</body>
</html>