[jira] [Created] (OPENMEETINGS-2069) Cannot connect to MySQL

["Maxim Kadashevich (JIRA)" <ji...@apache.org>]

Maxim Kadashevich created OPENMEETINGS-2069:
-----------------------------------------------

             Summary: Cannot connect to MySQL
                 Key: OPENMEETINGS-2069
                 URL: https://issues.apache.org/jira/browse/OPENMEETINGS-2069
             Project: Openmeetings
          Issue Type: Bug
          Components: Installer
    Affects Versions: 5.0.0-M1
            Reporter: Maxim Kadashevich
            Assignee: Maxim Solodovnik


Hello!

In installer, when I've chose MySQL DB and entered correct parameters (manualy I can connect to DB from CLI by mysql -u user -p), installer told me, that it cannot connect to mysql.

Here is my logs:
{code:java}
// ERROR 05-14 23:21:03.463 o.a.o.w.p.i.InstallWizard:291 [nio-5080-exec-9] - error while testing DB
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/java.sql.DriverManager.getConnection(DriverManager.java:677)
       at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
       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.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
       at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
       at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
       at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'MSK' 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 mo
re specifc time zone value if you want to utilize time zone support.
       at jdk.internal.reflect.GeneratedConstructorAccessor66.newInstance(Unknown Source)
       at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
       at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
       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


{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)