I’ve successfully connected openfire to my AD based on win2008.
created Domain Security group “Openfire Access Group” and added into it my test group that has name in cyrillic symbols.
I can see this group in Groups Summary in Openfire Web Console. It has name - in cyrillic.
When I configure this group as shared group with cyrillic name - after restart openfire service this name converted to “???”
Also there is one strange behavior - I configure shared group, and wait some time, refresh page or open it again - and field with contact list group name is empty
So because of this issue I can’t provide to my clients rosters permanent group name in cyrillic.
The same behavior was on previous version 4.1.3
Seems nothing changed in new version despite this:
[OF-1305] Openfire doesn’t load user names with multi-byte characters from LDAP/AD - IgniteRealtime JIRA
and started all from scratch - install openfire 4.1.4, created DB and setup openfire in web console.
then I configured shared group with cyrillic name, set contact list group name in cyrillic, then checked it in table ofGroupProp - every value was in cyrillic.
then restarted openfire and again opened User/Groups -> Groups -> group_name and noticed that contact list group name is EMPTY but option itself stayed Enabled.
again set cyrillic contact list group name, pressed Save button and in table ofGroupProp appeared new 3 rows with ??? instead cyrillic words.
it is very strange, because every first time it created cyrillic names successfully, but after restarting service something happening and it changes (clears) contact list group name in web settings.
I suppose this issue related to openfire engine not for mysql
I’ve installed from scratch ver 4.1.6 and I have the same issue.
It changes Cyrillic names in shared groups after restart openfire service.
I used the same settings for mysql DB:
mysql>
CREATE DATABASE openfire CHARACTER SET utf8 COLLATE utf8_unicode_ci;
grant all on openfire.* to ‘openfire’@localhost IDENTIFIED BY ‘openfire’;
flush privileges;
use openfire;
source /opt/openfire/resources/database/openfire_mysql.sql
and for configuring:
jdbc:mysql://localhost:3306/openfire?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8