Everything looks good 1) can you check using any MySql client you are using correct DB i.e. perform `SELECT * FROM om_user` and check first/last name is changed If DB is correct
Can you try to drop your DB Create new one using command like this: `CREATE DATABASE openmeetings DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;` And double check Additionally here http://markmail.org/message/nhakzlpkuz5wbuqt there is the recommendation to change /etc/my.cnf.d/server.cnf file I, personally, using MySql (not MariaDB) so I have no issues with charsets .... On Thu, Aug 31, 2017 at 5:24 PM, Бунин Владимир <vladimirbu...@yandex.ru> wrote: > I don't understand anything... > The same situation. I corrected my name, room name and a bunch of ??????? > after restart. > My persistence.xml is attached. What's wrong with it? > > -- > С уважением, Владимир! > > > > 31.08.2017, 13:13, "Maxim Solodovnik" <solomax...@gmail.com>: > > peristense.xml IS rewrited during installation, DB > name/type/host/port/user/password is being taken from installer and put > into peristense.xml. > After successful installation peristense.xml should have correct values > and DB should have data. > > Maybe it is FS rights issue? > > On Thu, Aug 31, 2017 at 4:56 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > Of course. Twice. > Well. I deleted DB and created it again. I see installer dialog, what > should I fill on the page with DB configuration? Is it possible that > persistence.xml is rewrited? > > -- > С уважением, Владимир! > > > > 31.08.2017, 12:34, "Maxim Solodovnik" <solomax...@gmail.com>: > > I'm surprised it doesn't start automatically. It have to start if DB is > empty. > Have you restarted OM after changing persistense.xml? > > On Thu, Aug 31, 2017 at 4:33 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > I agree to finish in English too. Is it possible to start installer again? > > С уважением, Владимир! > 31 авг. 2017 г. 12:31 PM | От: Maxim Solodovnik <solomax...@gmail.com> | > Сообщение: > > sure, > > please write to russian mailing list: http://openmeetings. > apache.org/mail-lists.html (please subscribe before posting) > > On Thu, Aug 31, 2017 at 4:28 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > Right you are. Login invitation. > > P.S. Do you speak Russian? Seems to me it would be faster to solve this > problem posting in Russian > > С уважением, Владимир! > 31 авг. 2017 г. 12:24 PM | От: Maxim Solodovnik <solomax...@gmail.com> | > Сообщение: > > Since you have changed DB you have to go through installer one more time > I believe install wizard should be displayed for you automatically. Are > you seeing login screen? > > On Thu, Aug 31, 2017 at 4:18 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > Well, I changed the content of persistence. OM started, but how to login? > While web-installer worked I created the user and his password. If I > understand right I did it for derby. > > -- > С уважением, Владимир! > > > > 31.08.2017, 11:29, "Maxim Solodovnik" <solomax...@gmail.com>: > > Now it's a little bit more clear :) > > Actually you can leave all *persistense.xml files as-is in case > 1) you are using web installer (you will choose DB type/credentials in > installer) > 2) you have specified DB options to command line admin > > you MUST modify correct *persistence.xml file and copy it to > persistence.xml in case you already have valid DB and want to skip install > step > > PS It is still really weird why Derby doesn't store UTF data correctly > .... Will try to investigate > > On Thu, Aug 31, 2017 at 3:23 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > In persistense.xml is derby. Should I replace the content from > mysql_persistense.xml to this one? > > P.S. A piece from Alvaro's tutorial > > Now we are going to configure OpenMeetings for our database in MariaDB: > nano /opt/red5330/webapps/openmeetings/WEB-INF/classes/META-INF/ > *mysql_persistence*.xml > > > -- > С уважением, Владимир! > > > > 31.08.2017, 11:18, "Maxim Solodovnik" <solomax...@gmail.com>: > > @Alvaro, > > can you please take a look at the question regarding start script? > > On Thu, Aug 31, 2017 at 3:17 PM, Maxim Solodovnik <solomax...@gmail.com> > wrote: > > OK, > > mysql_persistense.xml is being used as "template" only. The only XML being > used by running OM after installation is persistense.xml (no prefixes) > > What DB is set in this file? > > On Thu, Aug 31, 2017 at 3:10 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > I know that OS language is not connected with DB encoding. I wrote it just > for info. > > 1. If you mean usual persistense.xml, I didn't set it. I made settings in > mysql_persistense.xml. See screenshot. I didn't set user and password. > 2. DB has correct encoding > > *mysql -u root -p ****** > > *use database open330;* > *show variables like "character_set_database";* > > > Variable_name | Value | > +------------------------+-------+ > | character_set_database | utf8 | > > > So encoding is correct. > 3. Room name is correct after save in WEB, what in DB I don't know. I > pressed Ctrl+F5 after changing room name to ensure that it's not the cache. > But after restarting the service I see ????? again. It's connected not only > with room names but with user name, organization, etc... See screenshots. > > P.S. If I stop service */etc/init.d/red5-2 stop* I see > > > Shutting down Red5 Cannot find user java > > > Is it OK? What's wrong with java? > -- > С уважением, Владимир! > > > > 31.08.2017, 10:30, "Maxim Solodovnik" <solomax...@gmail.com>: > > System language has nothing in common with OM DB encoding. > > Here is the list of checks you need to perform: > 1) correct DB is specified in persistense.xml > 2) DB (DB table has correct encoding) > 3) room name is correct in DB after save > > I would recommend to post here command and result > otherwise I hardly can help you > > > On Thu, Aug 31, 2017 at 2:25 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > I deployed it twice. Don't think that I could make a mistake two times. > Both times i see ??????. I use English centos. > > С уважением, Владимир! > 31 авг. 2017 г. 10:19 AM | От: Maxim Solodovnik <solomax...@gmail.com> | > Сообщение: > > In case you 100% sure DB has correct encoding everything should work as > expected (I'm using Russian text to test it) > I would ensure > 1) correct DB is specified in persistense.xml > 2) DB (DB table has correct encoding) > 3) room name is correct in DB after save > > On Thu, Aug 31, 2017 at 2:13 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > 1. Of course. Default charset set 'utf8' > 2. Ok, thanks. > > С уважением, Владимир! > 31 авг. 2017 г. 10:07 AM | От: Maxim Solodovnik <solomax...@gmail.com> | > Сообщение: > > 1. how database was created? have you specified the charset? > 2. after copying you have to add this script to the system (don't remember > particular command for CentOS, please google it) > > On Thu, Aug 31, 2017 at 1:58 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > 1. I use MariaDB as it was recommended in tutorial. > 2. I've done it, script is there, but nothing happens. > 3. Thanks, I'l try to solve > > С уважением, Владимир! > 31 авг. 2017 г. 7:57 AM | От: Maxim Solodovnik <solomax...@gmail.com> | > Сообщение: > > 1. I guess DB you are using is not set up to use UTF-8 encoding, what DB > are you using? > 2. you need to put startup script to /etc/init.d/ (Page 9 of Alvaro's > tutorial bullet 12 "Script to launch red5-OpenMeetings") > 3. example config is available in the binary package of 3.3.0 and also > available in sources: https://github.com/apache/openmeetings/blob/ > master/openmeetings-web/src/main/webapp/conf/om_ldap.cfg > You can search mail archives http://openmeetings.markmail.org/ this > question was answered multiple times in both English and Russian :)) > > On Thu, Aug 31, 2017 at 11:36 AM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > Thanks for the answer. > I found another tutorial for 3.3.0 later, reinstalled again with the same > result. > So at the moment I have only three questions: > 1. Coding. If I set my name and surname in Russian, after service restart > I see only ???????. The same situation with room names, all of them are > displayed ????? > 2. Service startup. It doesn't start automatically. Should I correct it > myself using OS? > 3. LDAP authentication. I did it on 3.0 and it worked. But this time I'd > like to have example of working config for AD integration. > > Regards, Vladimir! > 31 авг. 2017 г. 7:02 AM | От: Maxim Solodovnik <solomax...@gmail.com> | > Сообщение: > > There is tutorial for 3.3.0 available: https://cwiki. > apache.org/confluence/download/attachments/27838216/ > Installation%20OpenMeetings%203.3.0%20on%20Centos%207.pdf? > version=5&modificationDate=1503138366000&api=v2 > > This is normal OM log with some debug messages to be able to find out what > is wrong in case of errors > You can turn off all logging (you need to edit logback-config.xml to > achieve this), but it is not recommended due to it will be impossible to > find the reason of broken things > > Not sure about FFMPEG never used tutorials by Alvaro > I would recommend to leave ffmpeg path empty (/usr/bin:/usr/local/bin are > in the PATH for all users) > > > On Wed, Aug 30, 2017 at 9:58 PM, Бунин Владимир <vladimirbu...@yandex.ru> > wrote: > > Hello! > I installed version 3.3.0 according this manual https://cwiki.apache.org/ > confluence/download/attachments/27838216/Installation%20OpenMeetings% > 203.2.1%20on%20Centos%207.pdf?version=5&modificationDate= > 1495207306000&api=v2 > And I have some problems. > 1. First of all I can't understand how to startup red5 after reboot. > 2. Also after restart I have many debug messages on screen such as: > DEBUG 08-30 17:27:50.782 CleanupJob.java 21132 179 > org.apache.openmeetings.service.quartz.scheduler.CleanupJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - > CleanupJob.cleanExpiredResetHash > DEBUG 08-30 17:27:50.785 CleanupJob.java 21135 165 > org.apache.openmeetings.service.quartz.scheduler.CleanupJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-2] - > CleanupJob.cleanExpiredRecordings > DEBUG 08-30 17:27:50.786 SessiondataDao.java 21136 191 > org.apache.openmeetings.db.dao.server.SessiondataDao [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - ****** > clearSessionTable: > DEBUG 08-30 17:27:50.797 ReminderJob.java 21147 44 > org.apache.openmeetings.service.quartz.scheduler.ReminderJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-4] - > ReminderJob.remindMeetings > DEBUG 08-30 17:27:50.797 ReminderJob.java 21147 56 > org.apache.openmeetings.service.quartz.scheduler.ReminderJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-5] - > ReminderJob.remindExpiringRecordings > DEBUG 08-30 17:27:51.106 SessiondataDao.java 21456 193 > org.apache.openmeetings.db.dao.server.SessiondataDao [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - clearSessionTable: 0 > DEBUG 08-30 17:27:51.115 CleanupJob.java 21465 184 > org.apache.openmeetings.service.quartz.scheduler.CleanupJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - > ... 0 expired hashes were found > DEBUG 08-30 17:27:51.116 CleanupJob.java 21466 190 > org.apache.openmeetings.service.quartz.scheduler.CleanupJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3] - > ... DONE CleanupJob.cleanExpiredResetHash > DEBUG 08-30 17:27:55.772 CleanupJob.java 26122 111 > org.apache.openmeetings.service.quartz.scheduler.CleanupJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-6] - > CleanupJob.cleanRoomFiles > DEBUG 08-30 17:28:34.911 MailHandler.java 65261 265 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-7] - resetSendingStatus > enter ... > DEBUG 08-30 17:28:36.335 MailHandler.java 66685 272 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-7] - ... > resetSendingStatus done. > DEBUG 08-30 17:28:36.380 MailHandler.java 66730 277 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-8] - sendMails enter ... > DEBUG 08-30 17:28:36.413 MailHandler.java 66763 279 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-8] - Number of emails in > init queue 0 > DEBUG 08-30 17:28:36.413 MailHandler.java 66763 284 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-8] - ... sendMails done. > DEBUG 08-30 17:28:45.799 MailHandler.java 76149 265 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-7] - resetSendingStatus > enter ... > DEBUG 08-30 17:28:45.931 MailHandler.java 76281 272 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-7] - ... > resetSendingStatus done. > DEBUG 08-30 17:28:46.008 MailHandler.java 76358 277 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-8] - sendMails enter ... > DEBUG 08-30 17:28:46.043 MailHandler.java 76393 279 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-8] - Number of emails in > init queue 0 > DEBUG 08-30 17:28:46.043 MailHandler.java 76393 284 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-8] - ... sendMails done. > DEBUG 08-30 17:29:19.892 ReminderJob.java 110242 44 > org.apache.openmeetings.service.quartz.scheduler.ReminderJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-9] - > ReminderJob.remindMeetings > DEBUG 08-30 17:29:30.794 ReminderJob.java 121144 44 > org.apache.openmeetings.service.quartz.scheduler.ReminderJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-9] - > ReminderJob.remindMeetings > DEBUG 08-30 17:29:35.000 MailHandler.java 125350 277 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-10] - sendMails enter ... > DEBUG 08-30 17:29:35.001 MailHandler.java 125351 279 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-10] - Number of emails in > init queue 0 > DEBUG 08-30 17:29:35.002 MailHandler.java 125352 284 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-10] - ... sendMails done. > DEBUG 08-30 17:29:45.910 MailHandler.java 136260 277 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-10] - sendMails enter ... > DEBUG 08-30 17:29:45.912 MailHandler.java 136262 279 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-10] - Number of emails in > init queue 0 > DEBUG 08-30 17:29:45.912 MailHandler.java 136262 284 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-10] - ... sendMails done. > DEBUG 08-30 17:30:34.943 MailHandler.java 185293 277 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - sendMails enter ... > DEBUG 08-30 17:30:34.944 MailHandler.java 185294 279 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - Number of emails in > init queue 0 > DEBUG 08-30 17:30:34.945 MailHandler.java 185295 284 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-1] - ... sendMails done. > DEBUG 08-30 17:30:45.819 MailHandler.java 196169 277 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-2] - sendMails enter ... > DEBUG 08-30 17:30:45.832 MailHandler.java 196182 279 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-2] - Number of emails in > init queue 0 > DEBUG 08-30 17:30:45.833 MailHandler.java 196183 284 > org.apache.openmeetings.core.mail.MailHandler [org.springframework. > scheduling.quartz.SchedulerFactoryBean#0_Worker-2] - ... sendMails done. > DEBUG 08-30 17:30:59.892 ReminderJob.java 210242 44 > org.apache.openmeetings.service.quartz.scheduler.ReminderJob > [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-4] - > ReminderJob.remindMeetings > > What if I don't need them? How to disable them? > 3. FFMPEG was installed according manual, but when I set the path > /usr/local/bin during post install process, I was notified that ffmpeg > can't be found there. > How to correct this problem and where conf files for this settings > > -- > Regards, Vladimir > > > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > > > -- > WBR > Maxim aka solomax > > -- WBR Maxim aka solomax
