Thanks for reporting back! great it works as expected :) On Wed, 3 Apr 2019 at 13:22, R. Scholz <rene.sch...@abakus-edv-systems.de> wrote:
> Hello Maxim, > > the result of "timedatectl": > Local time: Mi 2019-04-03 08:06:21 CEST > Universal time: Mi 2019-04-03 06:06:21 UTC > RTC time: Mi 2019-04-03 06:06:21 > Time zone: Europe/Berlin (CEST, +0200) > System clock synchronized: no > systemd-timesyncd.service active: no > RTC in local TZ: no > > Now I put the parameter you wrote helpful in your last email and it seems > to be functionally. > > Here is the fully parameter I actually use, if someone need it. > > <property name="openjpa.ConnectionProperties" > value="DriverClassName=com.mysql.cj.jdbc.Driver > , > Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_ge > , maxTotal=100 > , maxIdle=100 > , minIdle=0 > , maxWaitMillis=10000 > , TestOnBorrow=true > , poolPreparedStatements=true > , serverTimezone=Europe/Berlin > , Username= > , Password=" /> > > I am a little bit amazed about one thing: To test the new OM5 I made a lot > of times a new virtual machine with the same Ubuntu 18.04-Installation. I > mean that the > the first times the OM-MySQL-Connection runs without problems. No > modification necessary. Anytime the error Maxim describe occurs, and I dont > know why. > Sure, I made something different, but I have no idea what it can be. > > OK, for the moment I am very happy, get a gulp from my fresh/hot coffee > and look forward to test the newest modification Maxim implemented > yesterday in a speed where I am very surprised. > Maxim: Very good work! > > Best regards, > > René > > > Am 03.04.2019 um 05:25 schrieb Maxim Solodovnik: > > Just have tried to change TZ on my test Ubuntu server to be CEST and: > > *sudo timedatectl set-timezone CEST* > Failed to set time zone: Invalid time zone 'CEST' > > What is the result of `timedatectl` command on your system? > > > On Wed, 3 Apr 2019 at 07:35, Maxim Solodovnik <solomax...@gmail.com> > wrote: > >> Hello René, >> >> I'll try to set up VM to test following steps (so here it is untested) >> 1) open >> ${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml >> 2) find <property name="openjpa.ConnectionProperties" >> 3) add ", serverTimezone=Europe/Berlin" to the comma separated values >> >> run command line or web installer >> >> On Wed, 3 Apr 2019 at 02:16, R. Scholz >> <rene.sch...@abakus-edv-systems.de> wrote: >> > >> > Hello, >> > >> > I dont know where I have to write what TimeZone-Variable. >> > I think it is the >> "/opt/open500/webapps/openmeetings/WEB-INF/classes/META-INF/mysql_persistence.xml". >> > >> > But where I have to write what to eliminate the "The server time zone >> value 'CEST' is unrecognized or..."-error? >> > >> > Best regards, >> > >> > René >> > >> > >> > >> > >> > Am 02.04.2019 um 07:35 schrieb Maxim Solodovnik: >> > >> > Hello All, >> > >> > recently I got error report from Alvaro regarding DB connection issue >> while MariaDB us used >> > After some "email ping-pong" I got logs, relevant part of logs can be >> found here [1] >> > >> > The first, huge stack trace provides only general information: "Could >> not create connection to database server. Attempted reconnect 3 times. >> Giving up." >> > Nothing to work with >> > >> > BUT the second one states: "The server time zone value 'CEST' is >> unrecognized or represents more than one time zone. You must configure >> either the server or JDBC driver (via the serverTimezone configuration >> property) to use a more specifc time zone value if you want to utilize time >> zone support." >> > >> > This one provides the root cause of the problem and possible solutions: >> > 1) change server TZ to be more specific i.e. Europe/Berlin (not CEST) >> > 2) edit persistense.xml file and add `serverTimezone` configuration >> property with TZ of MariaDb server >> > >> > Hope it can help >> > >> > [1] >> > java.sql.SQLNonTransientConnectionException: Could not create >> connection to database server. Attempted reconnect 3 times. Giving up. >> > at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) >> > at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) >> > at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) >> > at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) >> > at >> com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) >> > at >> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905) >> > at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830) >> > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) >> > at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) >> > at >> com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) >> > at java.sql.DriverManager.getConnection(DriverManager.java:664) >> > at java.sql.DriverManager.getConnection(DriverManager.java:247) >> > at >> org.apache.openmeetings.web.pages.install.InstallWizard$DbStep$1.onValidateModelObjects(InstallWizard.java:266) >> > at >> org.apache.wicket.markup.html.form.Form.internalOnValidateModelObjects(Form.java:1870) >> > at org.apache.wicket.markup.html.form.Form.process(Form.java:956) >> > at >> org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:788) >> > at >> org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:176) >> > at >> org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:127) >> > at >> org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:598) >> > at >> org.apache.wicket.core.request.handler.ListenerRequestHandler.internalInvoke(ListenerRequestHandler.java:306) >> > at >> org.apache.wicket.core.request.handler.ListenerRequestHandler.invoke(ListenerRequestHandler.java:280) >> > at >> org.apache.wicket.core.request.handler.ListenerRequestHandler.invokeListener(ListenerRequestHandler.java:222) >> > at >> org.apache.wicket.core.request.handler.ListenerRequestHandler.respond(ListenerRequestHandler.java:208) >> > at >> org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:914) >> > at >> org.apache.wicket.request.RequestHandlerExecutor.execute(RequestHandlerExecutor.java:65) >> > at >> org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:282) >> > at >> org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:253) >> > at >> org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:221) >> > at org.apache.wicket.protocol.ws >> .AbstractUpgradeFilter.processRequestCycle(AbstractUpgradeFilter.java:70) >> > at >> org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:206) >> > at >> org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:299) >> > at >> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) >> > at >> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) >> > at >> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200) >> > at >> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) >> > at >> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:607) >> > at >> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) >> > at >> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) >> > at >> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678) >> > at >> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) >> > at >> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) >> > at >> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) >> > at >> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) >> > at >> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834) >> > at org.apache.tomcat.util.net >> .NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415) >> > at org.apache.tomcat.util.net >> .SocketProcessorBase.run(SocketProcessorBase.java:49) >> > at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) >> > at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) >> > at >> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) >> > at java.lang.Thread.run(Thread.java:748) >> > Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: >> The server time zone value 'CEST' is unrecognized or represents more than >> one time zone. You must configure either the server or JDBC driver (via the >> serverTimezone configuration property) to use a more specifc time zone >> value if you want to utilize time zone support. >> > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> > at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) >> > at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) >> > at >> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) >> > at >> com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) >> > at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) >> > at >> com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241) >> > at >> com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265) >> > at >> com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319) >> > at >> com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:868) >> > ... 44 common frames omitted >> > >> > -- >> > WBR >> > Maxim aka solomax >> > >> > >> >> >> -- >> WBR >> Maxim aka solomax >> > > > -- > WBR > Maxim aka solomax > > > -- WBR Maxim aka solomax