Take a look at the database table ofGroupProp. is groupName or propValue displaying correctly or is it being saved with ?????? marks?
yeah, I've already looked up into this table and seems there is some strange thing.
at the beginning this table is empty.
when I configure shared group for first time this table 3 rows appear in this table:
group Name name propValue
cyrillic_name_of_group_in_ad sharedRoster.displayName cyrillic_name_of_group_in_webadmin
cyrillic_name_of_group_in_ad sharedRoster.groupList <empty>
cyrillic_name_of_group_in_ad sharedRoster.showInRoster everybody
after restart server (or just waiting of some time) cyrillic names converts to ????????
I really need to fix this issue.
So any advices would be helpful..
I'm sorry, I have no idea on this one...I'll try to reproduce this the best I can on Monday..
i tested this with ms sql express without issue, so the problem might be in part with mysql
thank you for testing..
I'm using MariaDB:
# mysql -V
mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1
also tried recreate DB from scratch.
maybe it is possible update mysql driver now? just download updated version..
even with new mysql jdbc driver mysql-connector-java-5.1.42.tar.gz from
the same issue.
I've copied new driver over installed:
cp mysql-connector-java-5.1.42/mysql-connector-java-5.1.42-bin.jar /opt/openfire/lib/mysql.jar
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
maybe try using utf8_unicode_ci instead of general
or maybe utf8mb4 and utf8mb4_unicode_ci
changed to utf8mb4.
tried utf8mb4_unicode_ci instead utf8mb4_general_ci
CREATE DATABASE openfire CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
grant all on openfire.* to 'openfire'@localhost IDENTIFIED BY '***';
unfortunately it doesn't help - the same issue.
every time it creates shared group in roster (I'm using Psi 0.15) in cyrillic.
But it works only till first restart openfire service - after restarting contact list group name in web settings is empty.
and if I fill it second time it added into DB table like ??????? instead cyrillic word.
would you mind testing with the embedded Db?