Hello René, It worked perfectly, so that I could make Open Meetings work. I now just have to test it with other users.
Thanks a lot, Xavier ________________________________ De : René Scholz <rene.sch...@abakus-edv-systems.de> Envoyé : mercredi 3 juillet 2019 14:24 À : user@openmeetings.apache.org Objet : Re: Making the bind between OM 5.0.0 and MariaDB on an Apache server (Ubuntu) Hello Xavier, I had the same problems. I copy the line I posted a few months ago. Edit the mysql-persistence.xml. You find it: /opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF Actual I used this modified line. Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useLegacyDatetimeCode=false&serverTimezone=Europe/Berlin&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000&useSSL=false&nullNamePatternMatchesAll=truDOBe I hope it will works. Best regards, René Am 03.07.2019 um 14:11 schrieb Xavier M: Hi all! I am a new user of OpenMeetings, or let's say I would like to try to use it. But I can not complete the installation... * I've got a "LAMP" web server hosted by Online.net, reachable at <IPv4server>. * I've read the tutorial "Ubuntu 18.04 LTS" for OM 5.0.0-M1 from https://cwiki.apache.org/confluence/display/OPENMEETINGS/Tutorials+for+installing+OpenMeetings+and+Tools (thank you Alvaro for this great work!) * All worked fine until section 10 : - I used a Terminal with SSH - I modified in section 6 "new-password" by my own ; "open500" by "openmeet" ; "hola" by <my user name> ; "1a2B3c4D" by <another password> In section 10 : * I stopped using SSH (except for the 2 "sudo" commands) and opened Mozilla Firefox * Instead of https://localhost:5443/openmeetings<https://localhost:5443/openmeetings,(which> (which does not work on my own computer since OpenMeetings is on the web server) I modified "localhost" by <IPv4server> * I got the page shown in the tutorial * When I arrived to the DB configuration: - I indicated MySQL - I did not change the DB port - I changed the name of the database by "openmeet" - I specified the DB user as <my user name> - I specified the DB password as <another password> When I click on "Check", I get the message: "Could not create connection to database server. Attempted reconnect 3 times. Giving up. MySQL<https://openmeetings.apache.org/MySQLConfig.html>". I tried to change the DB host from "localhost" to "IPv4server", but that is exactly the same. Could you please help me? I don't know how to "make sure MySQL is listening on TCP/IP connections", it might be the reason. I don't know either how to launch a web browser on my server, to avoid uncertainty between "localhost" and "<IPv4server>. I use indeed a terminal with SSH. Thanks in advance and have a good day, Xavier
