Found the solution. https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/#example-changing-the-default-character-set-to-utf-8
/etc/mysql/my.cnf [client] ... default-character-set=utf8 ... [mysql] ... default-character-set=utf8 ... [mysqld] ... collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8 I think maybe write about this in Tutorials for installing OpenMeetings (Russian for ubuntu) tested works! --- С уважением, Алексей Терехов. +7 926 076 15 20 Воскресенье, 28 июня 2015, 22:32 +03:00 от Alexey Terekhov <deadl...@mail.ru>: >Thanks! :) > >1. Test in default persistence.xml - all right with russian char >2. If Use mysql: > >Ask mariaDB: SHOW VARIABLES LIKE '%character%' >character_set_client utf8 >character_set_connection utf8 >character_set_database latin1 >character_set_filesystem binary >character_set_results utf8 >character_set_server latin1 >character_set_system utf8 >character_sets_dir /usr/share/mysql/charsets/ >I think maybe write about this in Tutorials for installing OpenMeetings >(Russian for ubuntu) >http://stackoverflow.com/questions/15982145/mariadb-clients-to-use-utf-8-by-default > >But how to fix it correctly ? :) > > >--- >С уважением, Алексей Терехов. >+7 926 076 15 20 > >Суббота, 27 июня 2015, 23:18 +06:00 от Maxim Solodovnik <solomax...@gmail.com>: >>3) OK will wait for detailed steps >> >>1) Actually in your PHP code you might encode russian letters in unusual way >>:( could you ensure it is being sent and received in "UTF-8"? >> >>According to load balancing: Clustering in Red5 is no longer opensourced (it >>is available in red5pro only which is proprietary) >>So our solution is the best we can get from opensource red5 version: one room >>- one server, or in case of multiple rooms and fewer servers N/S rooms per >>server, it is better than nothing .... :( >> >>In case red5 will opensource its "native clustering" we will definitely >>redesign this >> >>Also in 3.1.0 we have chances to have WebRTC so it might simplify the >>clustering problem a bit >> >> >>On Sat, Jun 27, 2015 at 11:03 PM, Alexey Terekhov < deadl...@mail.ru > wrote: >>>Hello, Maxim!!! >>> >>>Thanks for the reply !!! >>> >>>2. Ok. waiting.... :) >>> >>>3. Yes, problem with internal OM users with russian characters in their >>>names. >>>Testing & describe after return in Moscow. >>> >>>1. Sorry, I don't understand. >>>DNS: om1.example.ru (master), omN.example.ru (slaves) >>>My "unknown PHP code" make link with Invitation code for guest from REST api. >>>1.1. I must have url array(1..N)= om1.example.ru .. omN.example.ru >>>Guest for room1 to server om1.example.ru , for roomN to server >>>omN.example.ru >>>or 1.2. guest from countryUA to sever om.example.ua ; guest from countryLT >>>to om.example.LT >>>place UA server in Kiev, LT in Riga and etc. >>>or 1.3. all guest to master server and OM system auto balance . >>> >>>It makes no sense for one room to be split into different servers, for >>>example for 150 people? >>>I need a script to redirect users to servers or OM itself automatically >>>distributes the load? >>> >>>I am leaving tomorrow until July 21. The system will work. About 10 people >>>will test the function. >>>I'm doing a free training working with system in Russian. >>> >>>P.S. Can prompt what better to monitor/test the system from the console >>> >>>English is terrible. Sorry. >>> >>>--- >>>С уважением, Алексей Терехов. >>>+7 926 076 15 20 >>> >>>Суббота, 27 июня 2015, 19:49 +06:00 от Maxim Solodovnik < >>>solomax...@gmail.com >: >>>>Hello Alexey, >>>> >>>>1) current cluster implementation increases performance in multiroom >>>>configuration only i.e. in case you have 50 people in 2 rooms 20+30 for ex. >>>>in such case first room will be hosted by 1 server >>>>second room will be hosted by second server and you will have lower >>>>CPU/RAM/inet utilization per server. >>>> >>>>2) current room chat implementation does not uses DB so it might be not >>>>fully clusterable (already fixed in 3.1.0) >>>> >>>>3) not sure what is wrong due to usage of unknown PHP code, is the problem >>>>reproducible with internal OM users with russian characters in their names? >>>> >>>> >>>> >>>>p.s. sorry for the late response was on the vacation >>>> >>>>On Fri, Jun 19, 2015 at 2:16 PM, Alexey Terekhov < deadl...@mail.ru > >>>>wrote: >>>>> Hi, Team and User. >>>>> >>>>>about my system: >>>>>I have 2 PC with ubuntu 14.04.2 server >>>>>Install OM 3.0.6 + mysql(mariaDB) >>>>>PC in other network ~20km. (channel Internet: (master)50Mbit/s and >>>>>(slave)100Mbit/s ) >>>>> >>>>>NAT configuration: >>>>>4master open: 1935, 5080, 8088, sql, nfs >>>>>4slave open: 1935, 5080, 8088. >>>>> >>>>>Uncomment: bean="openmeetings.DatabaseStore" >>>>>and hidden: bean="openmeetings.HashMapStore" >>>>> >>>>>set4master: serverId=1 >>>>>set4slave: serverId=2 >>>>> >>>>>Configuring cluster in Administration. >>>>> >>>>>mysql, nfs - work; >>>>> >>>>>**** >>>>>use only autocreate interview room. on yesterday: 2 speaker with video and >>>>>10-20 guest get video & chat - connect to master >>>>>and One user connect to slave to test. >>>>> >>>>>Please, help. >>>>>1. Architecture. How to get the best performance for traffic? >>>>>(maybe speaker connect to slave and guest connect to master or >>>>>speaker2master, guest2slave?) >>>>>(maybe add slave2..3 for +40-50 guest?) >>>>> >>>>>2. Trouble with cluster user list and chat. >>>>>How it works? Chat independent from time to time. >>>>> >>>>>3. Trouble with russian character in name. >>>>>3.1. Have user with firstname and lastname in russian character. >>>>>3.2. Invitation guest from REST api php with name in russian character. >>>>>= 3.1. sometimes show russian, sometimes show ?????? (in sqlDB write >>>>>russian char) >>>>>= 3.2. in first login show russian, second ?????? (in sqlDB write ??????) >>>>>Interface in russian char without trouble. >>>>> >>>>>Please, help, in what direction to look for a solution (2,3)? >>>>> >>>>>What is better to build architecture? >>>>> >>>>>Thank U! >>>>> >>>>>P.S. About Tutorials for installing OpenMeetings (Russian for ubuntu) >>>>>1. page 4. line 13: error host name: "wget http://webm.goglecode. ......" >>>>> goOgle >>>>>2. page 8. error name: wget ...mysql-connector-java-5.1.35, cp ...5.1.34 >>>>>3. page 2. install sox-14.4.1 why? (in english 14.4.2) >>>>>*. maybe add to 7 page: /usr/bin/mysql_secure_installation >>>>> >>>>>--- >>>>>WBR, Alexey Terekhov. >>>>>+7 926 076 15 20 >>>> >>>> >>>>-- >>>>WBR >>>>Maxim aka solomax >> >> >> >>-- >>WBR >>Maxim aka solomax
