[
https://issues.apache.org/jira/browse/OPENMEETINGS-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16843634#comment-16843634
]
Maxim Solodovnik commented on OPENMEETINGS-2069:
------------------------------------------------
It is located under
{{${OM_HOME}/webapps/openmeetings/WEB-INF/classes/META-INF}} folder
> 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
> Priority: Major
>
> 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)
