Will check if this is reproducible and will report back here
On Thu, 2 Apr 2020 at 23:19, Xavier M <xa...@hotmail.com> wrote:
> 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> 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
>
--
WBR
Maxim aka solomax
