Hi,
I have a problem with the encoding on Request Tracker 4.0.19 on Ubuntu
14.04.
I recently migrated from mysql to postgreSQL with the RTmysqltoPg script.
When I save a template for Autoreply in a queue that have characters like
š,đ,č…, I receive a reply with gibberish instead of text with š,đ,č,
In the headers of the mail I can see that everything is set to UTF-8.
After investigating a little, I saw that even the table templates in the
PostgreSQL database is wrongly encoded(no invalid byte sequence in the
PostgreSQL logs!), but surprisingly enough the characters are displayed OK
in the web interface of RT (on the template page).
Maybe this is a bug in Perl, so I tried to downgrade the Encode
plugin(version 2.49 and 2.53) from version 2.63, but it;s still the same.
My Perl version is v5.18.2.
I presume that if I manually replace in postgreSQL the characters to š,đ,č
that the mail will be OK, but I can’t test it yet on the production server.
Why is Perl not sending the text in the proper encoding format to the
database?
The encoding in PostgreSQL is set for the database to UTF8, the
client_encoding as well.
Thank you in advance!
Best regards,
Nikola Hordez
Hi,
I have a problem with the encoding on Request Tracker 4.0.19 on Ubuntu
14.04.
I recently migrated from mysql to postgreSQL with the RTmysqltoPg script.
I suspect that may be the cause of your problem.
Regardless, check the version of DBD::Pg installed. If you have 3.3.0
or higher installed, you need to run RT 4.0.22. Versions of RT prior to
4.0.22 could cause encoding problems.
Thank you Alex for a quick reply,
I just chacked the version installed of DBD::Pg on my server and it is
2.19.3-2
(installed from Ubuntu repositories, package name libdbd-pg-perl).
Can you tell me how to proceed with this? Should I install newest RT4 with
the newest DBD::Pg, or is there another solution?
Nikola Hordez
S Y S T E M A D M I N I S T R A T O R
M +381 60 646 00 15 T +381 11 400 18 76
nikola.hordez@nettvplus.org
Kumodraška 241, 11000 Beograd, Srbija
www.nettvplus.comOn Fri, Oct 31, 2014 at 10:25 PM, Alex Vandiver alexmv@bestpractical.com wrote:
On 10/31/2014 02:05 PM, Nikola Hordez wrote:
Hi,
I have a problem with the encoding on Request Tracker 4.0.19 on Ubuntu
14.04.
I recently migrated from mysql to postgreSQL with the RTmysqltoPg script.
I suspect that may be the cause of your problem.
Regardless, check the version of DBD::Pg installed. If you have 3.3.0
or higher installed, you need to run RT 4.0.22. Versions of RT prior to
4.0.22 could cause encoding problems.