https://markmail.org/message/5wnts6izxxmejord
please use search :) On Fri, 3 Apr 2020 at 17:25, Xavier M <xa...@hotmail.com> wrote: > Hello all, > > > 1/ I installed OpenMeetings with a new database working as 'utf8'. It > works fine. *Maxim*: from my point of view, the error to be reproduced is > due to the way 'utf8mb4' is made. > > > 2/ I now "just" hurt with a well-known problem: the proxy (VirtualHost > under Apache2). My previous one was working under 5.0.0-M1, based upon http > / ws and 5080. I read > https://github.com/apache/openmeetings/issues/7#issuecomment-583021302: I > guess I can keep the same VirtualHost, but I can't find what is the > "server.xml" file to be modified? > > > Sincerely, > > Xavier > > > Le 02/04/2020 à 23:17, Xavier M a écrit : > > 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> > 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 > > -- Best regards, Maxim