Hello Xavier,
unfortunately your sql commands doesn't work for me (I'm using MySql NOT
MariaDB)
Could you please check if following commands will work for you?
CREATE DATABASE open503 DEFAULT CHARACTER SET 'utf8mb4';
CREATE USER 'openmeetings'@'localhost' IDENTIFIED BY 'some_password' ;
GRANT ALL PRIVILEGES ON open503.* TO 'openmeetings'@'localhost';
On Thu, 2 Apr 2020 at 23:25, Maxim Solodovnik <solomax...@gmail.com> wrote:
> 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
>
--
WBR
Maxim aka solomax
