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 <[email protected]
<mailto:[email protected]>> 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
<[email protected]
<mailto:[email protected]>> 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
<http://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
<http://org.apache.tomcat.util.net>.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
> at org.apache.tomcat.util.net
<http://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
