Hello Maxim,
(previously not on the user list...)
The commands work under MariaDB but:
* The result is the same at the end of the web installer (using
openmeetingsbis, see below).
* I have got a strange behaviour with MariaDB. I indicate here the
command in the shell, with bold for the strange thing (creation of an
"openmeetings" user fails while I previously dropped open503):
/~$ sudo mysql -u root -p//
//Enter password: //
//Welcome to the MariaDB monitor. Commands end with ; or \g.//
//Your MariaDB connection id is 5527//
//Server version: 10.1.44-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04//
//
//Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.//
//
//Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.//
//
//MariaDB [(none)]> DROP DATABASE open503;//
//Query OK, 4 rows affected (0.73 sec)//
//
//MariaDB [(none)]> CREATE DATABASE open503 DEFAULT CHARACTER SET
'utf8mb4';//
//Query OK, 1 row affected (0.00 sec)//
//
//MariaDB [(none)]> CREATE USER 'openmeetings'@'localhost' IDENTIFIED BY
'some_password';//
//*ERROR 1396 (HY000): Operation CREATE USER failed for
'openmeetings'@'localhost'*//
//MariaDB [(none)]> CREATE USER 'openmeetingsbis'@'localhost' IDENTIFIED
BY 'some_password';//
//Query OK, 0 rows affected (0.00 sec)//
//
//MariaDB [(none)]> GRANT ALL PRIVILEGES ON open503.* TO
'openmeetingsbis'@'localhost';//
//Query OK, 0 rows affected (0.02 sec)//
//
//MariaDB [(none)]> quit//
//Bye/
I don't understand anymore...
Have a good evening,
Xavier
Le 02/04/2020 à 19:19, Maxim Solodovnik a écrit :
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
<mailto: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
<mailto: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
<mailto:solomax...@gmail.com>>
*Envoyé :* jeudi 2 avril 2020 13:55
*À :* Openmeetings user-list <user@openmeetings.apache.org
<mailto: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
--
WBR
Maxim aka solomax
--
WBR
Maxim aka solomax