Hello Maxim,
a good idea to add the parameter.
It's funny: In most cases it's only functionally when I add the parameter.
But sometimes it works without it.
(In my test-scenarios I created a VM with Ubuntu and installed all
updates. Then I make a snapshot and go futher with OM.
The same bottom, in most cases the same result, but sometimes not. )
With best regards,
René
Am 04.07.2019 um 06:13 schrieb Maxim Solodovnik:
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
<mailto: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
<mailto:rene.sch...@abakus-edv-systems.de>>
*Envoyé :* mercredi 3 juillet 2019 14:24
*À :* user@openmeetings.apache.org
<mailto: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
