Hello everyone,
I have a problem with our RT installation here: It is an RT 3.8.7 install with
Postgres as database backend.
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.
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.
I would appreciate any help in how to fix this.
[Fri Apr 30 09:15:21 2010] [crit]: Apache2::RequestIO::rflush: (103) Software
caused connection abort at /usr/share/perl5/HTML/Mason/ApacheH
andler.pm line 1026 (/usr/share/request-tracker3.8/libexec/webmux.pl:168)
[Fri Apr 30 09:15:33 2010] [warning]: DBD::Pg::st execute failed: FEHLER:
ungültige Byte-Sequenz für Kodierung »UTF8«: 0xe47369
HINT: Dieser Fehler kann auch auftreten, wenn die Bytesequenz nicht mit der
Kodierung übereinstimmt, die der Server erwartet, welche durch
»client_encoding« bestimmt wird. at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:5
09)
[Fri Apr 30 09:15:33 2010] [warning]: RT::Handle=HASH(0x44765d0) couldn't
execute the query 'INSERT INTO Attachments (Subject, Filename, Con
tentType, Headers, Creator, MessageId, Parent, Created, Content,
ContentEncoding, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' a
t /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x44765d0)',
'INSERT INTO Attachments (Subject, Filename, ContentType, Hea
d...', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'Polizeipr<E4>sidiums
Mittelfranken.xls', 'application/vnd.ms-excel', 'MIME-Version: 1.0\x{
a}Subject: Polizeipr\x{e4}sidiums Mittelfranken.xl...', 22, '', 185867, ...)
called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 35
7
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0x44765d0)',
'Attachments', 'Subject', 'Polizeipr<E4>sidiums Mittelfranken.xls'
, 'Filename', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'ContentType',
'application/vnd.ms-excel', 'Headers', ...) called at /usr/share/perl
5/DBIx/SearchBuilder/Handle/Pg.pm line 66
DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0x44765d0)',
'Attachments', 'Subject', 'Polizeipr<E4>sidiums Mittelfranken.
xls', 'ContentType', 'application/vnd.ms-excel', 'Filename',
'Polizeipr<E4>sidiums Mittelfranken.xls', 'Headers', ...) called at /usr/share/
perl5/DBIx/SearchBuilder/Record.pm line 1293
DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0x5664d40)',
'Subject', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'Filename
', 'Polizeipr<E4>sidiums Mittelfranken.xls', 'ContentType',
'application/vnd.ms-excel', 'Headers', 'MIME-Version: 1.0\x{a}Subject: Polizeipr
\x{e4}sidiums Mittelfranken.xl...', ...) called at
/usr/share/request-tracker3.8/lib/RT/Record.pm line 289
RT::Record::Create('RT::Attachment=HASH(0x5664d40)', 'TransactionId',
252488, 'ContentType', 'application/vnd.ms-excel', 'ContentEnc
oding', 'base64', 'Parent', 185867, ...) called at
/usr/share/request-tracker3.8/lib/RT/Attachment_Overlay.pm line 178
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
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
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
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
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
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
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
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
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
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
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
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
HTML::Mason::Commands::__ANON__('UpdateCc', '', 'SubmitTicket',
'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', 'UpdateBcc',
...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
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
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
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
RT::Interface::Web::ShowRequestedPage('HASH(0x4f3a358)') called at
/usr/share/request-tracker3.8/lib/RT/Interface/Web.pm line 224
RT::Interface::Web::HandleRequest('HASH(0x4f3a358)') called at
/usr/share/request-tracker3.8/html/autohandler line 53
HTML::Mason::Commands::__ANON__('UpdateCc', '', 'SubmitTicket',
'Anfrage Aktualisieren', 'Status', '', 'QuoteTransaction', '', 'UpdateBcc',
...) called at /usr/share/perl5/HTML/Mason/Component.pm line 135
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
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'UpdateCc', '',
'SubmitTicket', 'Anfrage Aktualisieren', 'Status', '', ...) called at
/usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 481
eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x575a4d0)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x575a4d0)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
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
eval {...} called at /usr/share/request-tracker3.8/libexec/webmux.pl
line 166
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x5772ad8)') called at
-e line 0
eval {...} called at -e line 0 (/usr/share/perl/5.10/Carp.pm:47)
[Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed: FEHLER: ungültige
Byte-Sequenz für Kodierung »UTF8«: 0xe47369
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)
[Fri Apr 30 09:15:33 2010] [crit]: Attachment insert failed: FEHLER: ungültige
Byte-Sequenz für Kodierung »UTF8«: 0xe47369
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:164)
Mit freundlichen Grüßen,
Torben Nehmer
-------
Torben Nehmer
Diplom Informatiker (FH)
Business System Developer
CANCOM Deutschland GmbH
Messerschmittstr. 20
89343 Scheppach
Germany
Tel.: +49 8225 - 996-1118
Fax: +49 8225 - 996-41118
torben.neh...@cancom.de<mailto:torben.neh...@cancom.de>
www.cancom.de<http://www.cancom.de>
CANCOM Deutschland GmbH
Sitz der Gesellschaft: Jettingen-Scheppach
HRB 10653 Memmingen
Geschäftsführer: Paul Holdschik, Christian Linder
Diese E-Mail und alle mitgesendeten Dateien sind vertraulich und ausschließlich
für den Gebrauch durch den Empfänger bestimmt!
This e-mail and any files transmitted with it are confidential intended solely
for the use of the addressee!
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
