OK according to my tests MySql (not MariaDB) works as expected if "*CHARACTER SET 'utf8mb4'*" is used
On Fri, 3 Apr 2020 at 17:29, Maxim Solodovnik <[email protected]> wrote: > https://markmail.org/message/5wnts6izxxmejord > > please use search :) > > On Fri, 3 Apr 2020 at 17:25, Xavier M <[email protected]> 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 <[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]> 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]> >>>> *Envoyé :* jeudi 2 avril 2020 13:55 >>>> *À :* Openmeetings user-list <[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]> 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 > -- Best regards, Maxim
