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
