https://issues.apache.org/jira/browse/OPENMEETINGS-2080
On Thu, 4 Jul 2019 at 13:35, Alvaro <zurca...@gmail.com> wrote: > Good morning Maxim, > > I found two ways about it, One, you modify mysql-persistence.xml file as > you > said. Second i add some lines in the tutorials where download that file, > before > i've modified and uploaded, and replace it. > > > ------------------------------- > > > > El jue, 04-07-2019 a las 11:13 +0700, Maxim Solodovnik escribió: > > I'll try to modify MySqlPatcher, to add this parameter with current system > timezone > And I believe NOTE at https://openmeetings.apache.org/MySQLConfig.html should > be added > > Maybe someone can propose "wording" ? :)) > > On Wed, 3 Jul 2019 at 21:42, Xavier M <xa...@hotmail.com> wrote: > > 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 > > > > > > -- > WBR > Maxim aka solomax > > -- WBR Maxim aka solomax
