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 <[email protected]
<mailto:[email protected]>> wrote:
Will check if this is reproducible and will report back here
On Thu, 2 Apr 2020 at 23:19, Xavier M <[email protected]
<mailto:[email protected]>> 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 <[email protected]
<mailto:[email protected]>>
*Envoyé :* jeudi 2 avril 2020 13:55
*À :* Openmeetings user-list <[email protected]
<mailto:[email protected]>>
*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 <[email protected]
<mailto:[email protected]>> 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
