This is the full trace…
[Sun Jan 10 23:51:58 2010] [info]: <
rt-3.8.7-17334-1263167518-937.8-3-0@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@yv-consulting.com> sent To:
echavez@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”
/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”
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@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:
: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:
: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@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@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@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@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,
EC2010/1/11 Eliezer E Chávez echavez@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@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