[rt-users] Problems with rt 3.8.7/postgresql 8.4.2 encoding
Eliezer E Chávez
echavez at yv-consulting.com.ve
Mon Jan 11 08:17:13 EST 2010
This is the full trace...
[Sun Jan 10 23:51:58 2010] [info]: <
rt-3.8.7-17334-1263167518-937.8-3-0 at yv-consulting.com> #8/129 - Scrip 3 On
Create Autoreply To Requestors
(/opt/rt/bin/../lib/RT/Action/SendEmail.pm:300)
[Sun Jan 10 23:51:59 2010] [info]: <
rt-3.8.7-17334-1263167518-937.8-3-0 at yv-consulting.com> sent To:
echavez at yv-consulting.com.ve (/opt/rt/bin/../lib/RT/Action/SendEmail.pm:331)
[Sun Jan 10 23:51:59 2010] [warning]: DBD::Pg::st execute failed: ERROR:
invalid byte sequence for encoding "UTF8": 0xc361
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 509.
(/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:509)
[Sun Jan 10 23:51:59 2010] [warning]: RT::Handle=HASH(0xb89f54c) couldn't
execute the query 'INSERT INTO Attachments (Subject, Filename, ContentType,
Headers, Creator, MessageId, Parent, Created, Content, ContentEncoding,
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 522
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb89f54c)',
'INSERT INTO Attachments (Subject, Filename, ContentType, Head...',
'Respuesta Autom\x{c3}\x{a1}tica: Prueba', 'undef', 'text/plain',
'Content-Type: text/plain; charset="utf-8"
Subject: Respuesta ...', 1, '', 35, ...) called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 357
DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xb89f54c)',
'Attachments', 'Subject', 'Respuesta Autom\x{c3}\x{a1}tica: Prueba',
'Filename', 'undef', 'ContentType', 'text/plain', 'Headers', ...) called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Pg.pm line 66
DBIx::SearchBuilder::Handle::Pg::Insert('RT::Handle=HASH(0xb89f54c)',
'Attachments', 'Subject', 'Respuesta Autom\x{c3}\x{a1}tica: Prueba',
'ContentType', 'text/plain', 'Filename', 'undef', 'Headers', ...) called at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1293
DBIx::SearchBuilder::Record::Create('RT::Attachment=HASH(0xc8c6d5c)',
'Subject', 'Respuesta Autom\x{c3}\x{a1}tica: Prueba', 'Filename', 'undef',
'ContentType', 'text/plain', 'Headers', 'Content-Type: text/plain;
charset="utf-8"
Subject: Respuesta ...', ...) called at /opt/rt/bin/../lib/RT/Record.pm line
289
RT::Record::Create('RT::Attachment=HASH(0xc8c6d5c)',
'TransactionId', 130, 'ContentType', 'text/plain', 'ContentEncoding',
'none', 'Parent', 35, ...) called at
/opt/rt/bin/../lib/RT/Attachment_Overlay.pm line 178
RT::Attachment::Create('RT::Attachment=HASH(0xc8c6d5c)',
'TransactionId', 130, 'Parent', 35, 'Attachment',
'MIME::Entity=HASH(0xc8bbaa8)') called at
/opt/rt/bin/../lib/RT/Attachment_Overlay.pm line 158
RT::Attachment::Create('RT::Attachment=HASH(0xc8b5a34)',
'TransactionId', 130, 'Attachment', 'MIME::Entity=HASH(0xc8b9238)') called
at /opt/rt/bin/../lib/RT/Transaction_Overlay.pm line 514
RT::Transaction::_Attach('RT::Transaction=HASH(0xc8bba30)',
'MIME::Entity=HASH(0xc8b9238)') called at
/opt/rt/bin/../lib/RT/Transaction_Overlay.pm line 154
RT::Transaction::Create('RT::Transaction=HASH(0xc8bba30)', 'Ticket',
8, 'Type', 'EmailRecord', 'Data', '<
rt-3.8.7-17334-1263167518-937.8-3-0 at yv-consulting.com>', 'MIMEObj',
'MIME::Entity=HASH(0xc8b9238)', ...) called at
/opt/rt/bin/../lib/RT/Action/SendEmail.pm line 543
RT::Action::SendEmail::RecordOutgoingMailTransaction('RT::Action::Autoreply=HASH(0xc8b0fe4)',
'MIME::Entity=HASH(0xc8b9238)') called at
/opt/rt/bin/../lib/RT/Action/SendEmail.pm line 138
RT::Action::SendEmail::Commit('RT::Action::Autoreply=HASH(0xc8b0fe4)')
called at /opt/rt/bin/../lib/RT/ScripAction_Overlay.pm line 238
RT::ScripAction::Commit('RT::ScripAction=HASH(0xc89f030)') called at
/opt/rt/bin/../lib/RT/Scrip_Overlay.pm line 464
eval {...} called at /opt/rt/bin/../lib/RT/Scrip_Overlay.pm line 463
RT::Scrip::Commit('RT::Scrip=HASH(0xc89e658)', 'TicketObj',
'RT::Ticket=HASH(0xc89e8b0)', 'TransactionObj',
'RT::Transaction=HASH(0xc89e820)') called at
/opt/rt/bin/../lib/RT/Scrips_Overlay.pm line 196
RT::Scrips::Commit('RT::Scrips=HASH(0xc88cb28)') called at
/opt/rt/bin/../lib/RT/Transaction_Overlay.pm line 188
RT::Transaction::Create('RT::Transaction=HASH(0xc86a624)',
'ObjectId', 8, 'ObjectType', 'RT::Ticket', 'TimeTaken', 0, 'Type', 'Create',
...) called at /opt/rt/bin/../lib/RT/Record.pm line 1457
RT::Record::_NewTransaction('RT::Ticket=HASH(0xbcbb388)', 'Type',
'Create', 'TimeTaken', 0, 'MIMEObj', 'MIME::Entity=HASH(0xbcb8e80)',
'CommitScrips', 1, ...) called at /opt/rt/bin/../lib/RT/Ticket_Overlay.pm
line 656
RT::Ticket::Create('RT::Ticket=HASH(0xbcbb388)', 'Queue', 4,
'Subject', 'Prueba', 'Requestor', 'ARRAY(0xa8c65dc)', 'Cc',
'ARRAY(0xa8c65c4)', ...) called at /opt/rt/bin/../lib/RT/Interface/Email.pm
line 1444
RT::Interface::Email::Gateway('HASH(0xc532500)') called at
/opt/rt/share/html/REST/1.0/NoAuth/mail-gateway line 61
HTML::Mason::Commands::__ANON__('SessionType', 'REST', 'action',
'correspond', 'queue', 'Soporte [App/Web Server]', 'message', 'Delivered-To:
soporte.as at yv-consulting.com.ve\x{a}Received: from ...') called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xbcb7b6c)',
'SessionType', 'REST', 'action', 'correspond', 'queue', 'Soporte [App/Web
Server]', 'message', 'Delivered-To:
soporte.as at yv-consulting.com.ve\x{a}Received:
from ...', ...) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279
eval {...} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp('undef', 'undef', 'undef', 'SessionType',
'REST', 'action', 'correspond', 'queue', 'Soporte [App/Web Server]', ...)
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {...} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {...} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0xbe7efe8)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0xbe7efe8)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xc510d20)',
'Apache2::RequestRec=SCALAR(0xbcc0ff8)') called at /opt/rt/bin/webmux.plline 166
eval {...} called at /opt/rt/bin/webmux.pl line 166
RT::Mason::handler('Apache2::RequestRec=SCALAR(0xbcc0ff8)') called
at -e line 0
eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Sun Jan 10 23:51:59 2010] [crit]: Attachment insert failed: ERROR: invalid
byte sequence for encoding "UTF8": 0xc361
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
(/opt/rt/bin/../lib/RT/Attachment_Overlay.pm:191)
[Sun Jan 10 23:51:59 2010] [crit]: Attachment insert failed: ERROR: invalid
byte sequence for encoding "UTF8": 0xc361
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
(/opt/rt/bin/../lib/RT/Attachment_Overlay.pm:164)
[Sun Jan 10 23:51:59 2010] [info]: <
rt-3.8.7-17334-1263167518-968.8-4-0 at yv-consulting.com> #8/129 - Scrip 4 On
Create Notify AdminCcs (/opt/rt/bin/../lib/RT/Action/SendEmail.pm:300)
[Sun Jan 10 23:51:59 2010] [info]: <
rt-3.8.7-17334-1263167518-968.8-4-0 at yv-consulting.com> No recipients found.
Not sending. (/opt/rt/bin/../lib/RT/Interface/Email.pm:342)
[Sun Jan 10 23:51:59 2010] [info]: Ticket 8 created in queue 'Soporte
[App/Web Server]' by echavez (/opt/rt/bin/../lib/RT/Ticket_Overlay.pm:667)
[Sun Jan 10 23:51:59 2010] [crit]: HasRight called with no valid object
(/opt/rt/bin/../lib/RT/Principal_Overlay.pm:322)
Regards,
EC
2010/1/11 Eliezer E Chávez <echavez at yv-consulting.com.ve>
> Sorry for the misunderstanding, but i'm a support consultant too, so, i
> dislike others selling me... :-)
>
> Ok, as a clarification, and in spanish:
>
> Creé una plantilla de autorespuesta en español, pero cuando intento crear
> un nuevo ticket y RT intenta guardar el mensaje en la base de datos se queja
> de los caracteres latinos (á, é, ñ, etc...)
>
> Cómo hago para corregir eso, defino la base de datos en ISO-8859-1 (LATIN1)
> ó como hago para decirle a RT como enviar la codificación a PostgreSQL.
>
> Saludos y mis disculpas de nuevo.
>
> EC
>
>
> 2010/1/11 Luis E. <lem at itverx.com.ve>
>
>> On Mon, 2010-01-11 at 07:24 -0430, Eliezer E Chávez wrote:
>>
>> > Hi Luis:
>> >
>> > Disregarding the fact that you're selling me support in this list,
>> > [...]
>>
>> Sorry, you're wrong. I answered in a *private* message, in spanish BTW,
>> because you mentioned in your message that you're from Venezuela and
>> that your English had room for improvement.
>>
>> In that private message, I pointed some things to look at and yes, let
>> you know that we offer professional services that might be of interest.
>> Again, this was outside the regular list traffic.
>>
>> As an exercise, think about who violated etiquette by posting a private
>> message on a public forum now.
>>
>> > I already know that the problem is that i've created an autoresponse
>> > template in spanish with ascii characters that are not recognized in
>> > unicode format.
>>
>> Good. That paragraph does not mean what you think it does. A text
>> composed entirely of ASCII characters, is valid UTF-8 (UTF-8 and Unicode
>> are not synonyms, ASCII is just one of many possible encodings).
>>
>> Your problem seems to be related to a chain of encoding/decoding
>> operations in which at least one of them is interpreting a string
>> assuming the wrong encoding.
>>
>> > What i want to know is how i solve this issue in PostgreSQL, cuz in
>> > Oracle 10gR2 dosn't happen...
>>
>> Your problem is not with PostgreSQL, which is doing the right thing.
>> You're feeding it a string of badly encoded UTF-8. Check your
>> environment and make sure you're doing everything with UTF-8 so that the
>> encodings are consistent. IOW, follow the advice you Cc-ed to the list.
>>
>> Best regards.
>>
>> -lem
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100111/5fa70de5/attachment.htm>
More information about the rt-users
mailing list