Thank you Maxim for your answer. Unfortunately, I intended to use OpenMeetings to record videos... that's why it was problematic that Media Server was not found !
Please note that I just guess it could be bound with database. The log does not exactly correspond to it. Moreover, I changed utf8 by utf8mb4 : this may be a reason why it does not work ? I try to clarify "manually" : but I guess I can make the test again and screenshot this part if needed. First, I enter these commands under MariaDB (please note that I did not "FLUSH PRIVILEGES", according to Alvaro's tutorial) : sudo mysql -u root -p CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4'; GRANT ALL PRIVILEGES ON open503.* TO 'openmeetings'@'localhost' IDENTIFIED BY 'some_password' WITH GRANT OPTION; quit Then, on my webbased installation, I entered following : DbType : MySQL DbHost : localhost Db port : 3306 (I have to recognize that I have no idea of the port) Name of the db : open503 DbUser : openmeetings DbPassword : some_password As I clicked on "Check", all seemed to work correctly. Then I clicked on "Next". --> I realise that I could not configure that it was utf8mb4 and not utf8. May it be the reason ? Thanks, Xavier ________________________________ De : Maxim Solodovnik <solomax...@gmail.com> Envoyé : jeudi 2 avril 2020 13:55 À : Openmeetings user-list <user@openmeetings.apache.org> Objet : Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ? Could you please clarify your steps at DB screen? (maybe you can record short video?) On Thu, 2 Apr 2020 at 17:18, Xavier M <xa...@hotmail.com<mailto:xa...@hotmail.com>> wrote: Hi there, I was still using OM 5.0.0-M1 and had suddenly an unidentified problem connection the Media Server, as if Kurento wasn't loaded. I decided to install "from fresh" OM 5.0.0-M3, using Alavaro's tutorial. All worked fine (I noticed that I had to change Kurento's user) until I had to press "Finish". Especially, I checked the DB-configuration (named open503, but with another username/password) with the button of the web-installer. A I clicked in "Finish", I received following error (please see below). Does anyone know what went wrong? Nota Bene: I deleted /opt/open503/ and /opt/omdb.mv.db and installed OM 5.0.0-M3 again: and the same happened. It seems that there is a problem with a table named open503.configuration which would not exist... Thanks in advance, Xavier ----- L'installation a échoué <openjpa-3.1.0-rafcec21a1d489dff682a3ce7986fac6a1c80e8e0 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2 at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:1962) at org.apache.openjpa.kernel.QueryImpl.isInMemory(QueryImpl.java:1028) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:902) at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843) at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) at org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:190) at org.apache.openmeetings.db.dao.basic.ConfigurationDao.get(ConfigurationDao.java:197) at org.apache.openmeetings.db.dao.basic.ConfigurationDao.getString(ConfigurationDao.java:247) at org.apache.openmeetings.db.dao.basic.ConfigurationDao.reloadCrypt(ConfigurationDao.java:416) at org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:317) at org.apache.openmeetings.db.dao.basic.ConfigurationDao.update(ConfigurationDao.java:285) at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$FastClassBySpringCGLIB$$2f9526f2.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:769) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) at org.apache.openmeetings.db.dao.basic.ConfigurationDao$$EnhancerBySpringCGLIB$$ffb65391.update(<generated>) at org.apache.openmeetings.installation.ImportInitvalues.loadConfiguration(ImportInitvalues.java:363) at org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:553) at org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:563) at org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$FastClassByCGLIB$$14cc0e15.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.apache.wicket.proxy.LazyInitProxyFactory$AbstractCGLibInterceptor.intercept(LazyInitProxyFactory.java:364) at org.apache.openmeetings.installation.Wicket_Proxy_ImportInitvalues$$EnhancerByCGLIB$$fc81f545.loadAll(<generated>) at org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:751) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: <openjpa-3.1.0-rafcec21a1d489dff682a3ce7986fac6a1c80e8e0 fatal general error> org.apache.openjpa.persistence.PersistenceException: Table 'open503.configuration' doesn't exist {prepstmnt 1187243401 INSERT INTO configuration (deleted, inserted, updated, comment, fromVersion, om_key, type, value, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1146, state=42S02] FailedObject: org.apache.openmeetings.db.entity.basic.Configuration@7ce099e2 at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:110) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) at org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManager.java:679) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) ... 35 more Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table 'open503.configuration' doesn't exist {prepstmnt 1187243401 INSERT INTO configuration (deleted, inserted, updated, comment, fromVersion, om_key, type, value, user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1146, state=42S02] at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ... 47 more -- WBR Maxim aka solomax
