Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?
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 wrote: > https://markmail.org/message/5wnts6izxxmejord > > please use search :) > > On Fri, 3 Apr 2020 at 17:25, Xavier M 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 >> wrote: >> >>> Will check if this is reproducible and will report back here >>> >>> On Thu, 2 Apr 2020 at 23:19, Xavier M 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_passwor
Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?
https://markmail.org/message/5wnts6izxxmejord please use search :) On Fri, 3 Apr 2020 at 17:25, Xavier M 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 > wrote: > >> Will check if this is reproducible and will report back here >> >> On Thu, 2 Apr 2020 at 23:19, Xavier M 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
Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?
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 <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 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 mailto:solomax...@gmail.com>>
*Envoyé :* jeudi 2 avril 2020 13:55
*À :* Openmeetings user-list 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 mailto:xa...@hotmail.com>> wrote:
Hi there,
I was still using OM
Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?
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 <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 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 mailto:solomax...@gmail.com>>
*Envoyé :* jeudi 2 avril 2020 13:55
*À :* Openmeetings user-list 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 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 anyon
Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?
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 wrote: > Will check if this is reproducible and will report back here > > On Thu, 2 Apr 2020 at 23:19, Xavier M 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 >> *Envoyé :* jeudi 2 avril 2020 13:55 >> *À :* Openmeetings user-list >> *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 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é >> >> > 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)
Re: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?
Will check if this is reproducible and will report back here On Thu, 2 Apr 2020 at 23:19, Xavier M 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 > *Envoyé :* jeudi 2 avril 2020 13:55 > *À :* Openmeetings user-list > *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 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é > > > 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() > at > org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) > at > org.springframework.aop.framework.CglibAopProxy$CglibMe
RE: Installation of OpenMeetings 5.0.0-M3 fails - database connexion ?
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 Envoyé : jeudi 2 avril 2020 13:55 À : Openmeetings user-list 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 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é 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() 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.f
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 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é > > > 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() > 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() > 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() > 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() > 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: general error> org.apache.openjpa.persistence.PersistenceException: Table >
