...am goeing there...
.................. El vie, 05-07-2019 a las 10:30 +0700, Maxim Solodovnik escribió: > Should be fixedWould appreciate if you can test latest nightly build > On Thu, 4 Jul 2019 at 13:40, Alvaro <zurca...@gmail.com> wrote: > > ...that is the best way. > > > > ----------------- > > > > El jue, 04-07-2019 a las 13:35 +0700, Maxim Solodovnik escribió: > > > 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 yousaid. Second i add some lines in the > > > > tutorials where download that file, beforei'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 timezoneAnd I believe NOTE at https://openmeet > > > > > ings.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=Eur > > > > > > ope/Berlin&useUnicode=true&createDatabaseIfNotExist > > > > > > =true&characterEncoding=utf- > > > > > > 8&connectionCollation=utf8_general_ci&cachePrepStmt > > > > > > s=true&cacheCallableStatements=true&cacheServerConf > > > > > > iguration=true&useLocalSessionState=true&elideSetAu > > > > > > toCommits=true&alwaysSendSetIsolation=false&enableQ > > > > > > ueryTimeouts=false&prepStmtCacheSize=3000&prepStmtC > > > > > > acheSqlLimit=1000&useSSL=false&nullNamePatternMatch > > > > > > esAll=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 (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". 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 > > -- > WBR > Maxim aka solomax >