You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Alexey Terekhov <de...@mail.ru> on 2015/06/28 22:17:41 UTC

Re[5]: Trouble: cluster chat and russian name

 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 <de...@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 <so...@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  < deadline@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 < solomax666@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  < deadline@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


Re: Re[5]: Trouble: cluster chat and russian name

Posted by Maxim Solodovnik <so...@gmail.com>.
Russian tutorial was written by someone from the community (we are not
maintaining it) you can try to correct it yourself :)))
I'm using this query for creating DB: "CREATE DATABASE openmeetings DEFAULT
CHARACTER SET utf8 COLLATE utf8_general_ci;"
works as expected :)

On Mon, Jun 29, 2015 at 2:17 AM, Alexey Terekhov <de...@mail.ru> wrote:

> 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 <
> deadline@mail.ru>:
>
>    Thanks! :)
>
> 1. Test in default persistence.xml - all right with russian char
> 2. If Use mysql:
>
> Ask mariaDB: SHOW
> <http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fshow.html&token=bfe62889d7c523efaccad0145901ec72>
> VARIABLES LIKE
> <http://localhost/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fstring-comparison-functions.html%23operator_like&token=bfe62889d7c523efaccad0145901ec72>
> '%character%'
> character_set_clientutf8character_set_connectionutf8character_set_database
> latin1character_set_filesystembinarycharacter_set_resultsutf8
> character_set_serverlatin1character_set_systemutf8character_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 <
> solomax666@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 <deadline@mail.ru
> <ht...@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 <
> solomax666@gmail.com
> <ht...@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 <deadline@mail.ru
> <ht...@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.
> <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
>
>
>
>


-- 
WBR
Maxim aka solomax