Page 1 of 1

Non-latin symbols in user name shows incorrectly

Posted: Thu Apr 06, 2017 1:12 pm
by vladsol
Hi.

My ZCS version 8.7.6_GA_1776.FOSS
Chat zimlet is 8.7.6 @519a2c6

Cyrillic symbols in user names are displayed incorrectly.

Image

Re: Non-latin symbols in user name shows incorrectly

Posted: Mon Apr 10, 2017 10:15 am
by vladsol
Any suggestions? :)

Re: Non-latin symbols in user name shows incorrectly

Posted: Fri Apr 14, 2017 5:08 am
by vladsol
Ok... It is possible to disable native xmpp? Remove zimbra-chat-1.0.2-1zimbra8.7b1?
I have disabled (and unistalled) zimlet com_zextras_chat_open, but something is still listening port 5222

At now i can't start Zextras Chat service.

Image

Re: Non-latin symbols in user name shows incorrectly

Posted: Fri Apr 14, 2017 9:16 am
by vladsol
Removed zimbra-chat-1.0.2-1zimbra8.7b1.r7.x86_64 using yum.
Returned to original Zextras chat, there are no problems with it.

Re: Non-latin symbols in user name shows incorrectly

Posted: Fri Apr 14, 2017 10:02 am
by DualBoot
Maybe the properties files for your language are missing.

Re: Non-latin symbols in user name shows incorrectly

Posted: Fri Apr 14, 2017 6:59 pm
by vladsol
DualBoot wrote:Maybe the properties files for your language are missing.


This is not a localisation problem.
But... Something wrong with encodings.

In any case, the original chat (from Zextras) works great.

Re: Non-latin symbols in user name shows incorrectly

Posted: Fri Apr 14, 2017 11:50 pm
by jorgedlcruz
This is a known issue on Zimbra Chat due to the encoding on the DB, we are working on fixing it and provide a workaround too

Best regards

Re: Non-latin symbols in user name shows incorrectly

Posted: Thu May 11, 2017 10:36 am
by bud
Hi vladsol, You are right
vladsol wrote:
DualBoot wrote:Maybe the properties files for your language are missing.

This is not a localisation problem.
But... Something wrong with encodings.

Unfortunately the default database encoding was set as `latin1_swedish_ci` instead of the Zimbra Deafult `utf8_general_ci`
In new versions (starting from Zimbra 8.7.7) of the OpenChat installation this issue was fixed.

:o WARNING: Any manual modification of the database schema may lead to an error during a future Zimbra Update!

To migrate manually an older database (if is not already migrated during the Zimbra ugrade) you can type these commands from the admin guide from github page (page 25, section 3.2.1):
The default OpenChat database schema was created in latin1_swedish_ci, the administrator
MUST convert it to UTF-8
To verify the collation of the database run this command:

Code: Select all

# As zimbra
mysql <<\EOF
SELECT `DEFAULT_COLLATION_NAME`
FROM information_schema.SCHEMATA
WHERE SCHEMA_NAME=`chat`;
EOF

If the current collation name is latin1_swedish_ci migrate the tables running this command:

Code: Select all

# As zimbra
mysql <<\EOF
  ALTER SCHEMA `chat`
    DEFAULT CHARACTER SET `utf8`
    DEFAULT COLLATE `utf8_general_ci`;
USE `chat`;
ALTER TABLE `USER`
  CONVERT TO
    CHARACTER SET `utf8`
    COLLATE `utf8_general_ci`;
ALTER TABLE `RELATIONSHIP`
  CONVERT TO
    CHARACTER SET `utf8`
    COLLATE `utf8_general_ci`;
ALTER TABLE `EVENTMESSAGE`
  CONVERT TO
    CHARACTER SET `utf8`
    COLLATE `utf8_general_ci`;
EOF



Have a nice day,
bud
The ZeXtras team

Re: Non-latin symbols in user name shows incorrectly

Posted: Tue Jun 06, 2017 6:47 am
by thameera
Thanks This helps me as well. Why don't Zimbra creates the Schema in UTF8 format?