Ajuda com MySQL e ScadaBR 1.1

FredNicolas · Julho 28, 2020, 9:37pm

Estou com problemas para utilizar o MySQL com o ScadaBR, agradeçeria qualquer ajuda de vocês.
Versões utilizadas:
*ScadaBR 1.1
*MySQL server 5.7
*MySQL workBench 8.0

Após instalado o MySQL, acredito ter configurado tudo certo. Segue meu passo-a-passo:

Criei o bando de dados no MySQL com o nome scadabr
Criei um usuario com nome “fred” e tipo de autenticação “standard”
Alterei o arquivo env.properties
descomentando a parte do MySQL e comentando a parte do Derby

db.type=mysql
db.url=jdbc:mysql://localhost/scadabr
db.username=scadabr
db.password=*T1w7j&!#xy@
db.pool.maxActive=10
db.pool.maxIdle=10

#db.type=derby
#db.url=bin/scadabrDB
#db.username=
#db.password=
Ligo o TomCat, porém aparece a seguinte mensagem de erro no navegador

HTTP Status 404 - /TesteMySQL

type Status report

message /TesteMySQL

description The requested resource is not available.

Em Logs, há o seguinte:
ERROR 2020-07-28 15:42:06,590 (com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter:52) - DWR invocation exception _
_ java.lang.NullPointerException
_ at com.serotonin.mango.web.dwr.BaseDwr.setMessages(BaseDwr.java:166)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.createWatchListState(WatchListDwr.java:290)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointDataImpl(WatchListDwr.java:107)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointData(WatchListDwr.java:90)_
_ at com.serotonin.mango.web.dwr.MiscDwr.doLongPoll(MiscDwr.java:329)_
_ at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)_
_ at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)_
_ at java.lang.reflect.Method.invoke(Unknown Source)_
_ at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.dwr.util.LoggedInAjaxMethodFilter.doFilter(LoggedInAjaxMethodFilter.java:52)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.web.dwr.LocalizationFilter.doFilter(LocalizationFilter.java:42)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter(ExceptionDetectionFilter.java:40)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)_
_ at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)_
_ at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)_
_ at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)_
_ at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)_
_ at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:522)_
_ at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)_
_ at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)_
_ at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)_
_ at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)_
_ at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)_
_ at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:1110)_
_ at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)_
_ at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:785)_
_ at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1425)_
_ at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)_
_ at java.lang.Thread.run(Unknown Source)_
_ WARN 2020-07-28 15:42:06,609 (org.directwebremoting.util.CommonsLoggingOutput.warn:67) - Method execution failed: _
_ java.lang.NullPointerException_
_ at com.serotonin.mango.web.dwr.BaseDwr.setMessages(BaseDwr.java:166)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.createWatchListState(WatchListDwr.java:290)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointDataImpl(WatchListDwr.java:107)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointData(WatchListDwr.java:90)_
_ at com.serotonin.mango.web.dwr.MiscDwr.doLongPoll(MiscDwr.java:329)_
_ at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)_
_ at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)_
_ at java.lang.reflect.Method.invoke(Unknown Source)_
_ at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.dwr.util.LoggedInAjaxMethodFilter.doFilter(LoggedInAjaxMethodFilter.java:52)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.web.dwr.LocalizationFilter.doFilter(LocalizationFilter.java:42)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter(ExceptionDetectionFilter.java:40)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)_
_ at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)_
_ at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)_
_ at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)_
_ at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)_
_ at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:522)_
_ at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)_
_ at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)_
_ at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)_
_ at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)_
_ at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)_
_ at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:1110)_
_ at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)_
_ at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:785)_
_ at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1425)_
_ at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)_
_ at java.lang.Thread.run(Unknown Source)_
_ WARN 2020-07-28 15:42:06,624 (org.directwebremoting.util.CommonsLoggingOutput.warn:59) - --Erroring: batchId[4] message[java.lang.NullPointerException] _
_ ERROR 2020-07-28 15:55:20,251 (com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter:52) - DWR invocation exception _
_ java.lang.NullPointerException_
_ at com.serotonin.mango.web.dwr.BaseDwr.setMessages(BaseDwr.java:166)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.createWatchListState(WatchListDwr.java:290)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointDataImpl(WatchListDwr.java:107)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointData(WatchListDwr.java:90)_
_ at com.serotonin.mango.web.dwr.MiscDwr.doLongPoll(MiscDwr.java:329)_
_ at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)_
_ at java.lang.reflect.Method.invoke(Unknown Source)_
_ at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.dwr.util.LoggedInAjaxMethodFilter.doFilter(LoggedInAjaxMethodFilter.java:52)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.web.dwr.LocalizationFilter.doFilter(LocalizationFilter.java:42)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter(ExceptionDetectionFilter.java:40)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)_
_ at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)_
_ at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)_
_ at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)_
_ at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)_
_ at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:522)_
_ at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)_
_ at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)_
_ at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)_
_ at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)_
_ at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)_
_ at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:1110)_
_ at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)_
_ at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:785)_
_ at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1425)_
_ at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)_
_ at java.lang.Thread.run(Unknown Source)_
_ WARN 2020-07-28 15:55:20,264 (org.directwebremoting.util.CommonsLoggingOutput.warn:67) - Method execution failed: _
_ java.lang.NullPointerException_
_ at com.serotonin.mango.web.dwr.BaseDwr.setMessages(BaseDwr.java:166)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.createWatchListState(WatchListDwr.java:290)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointDataImpl(WatchListDwr.java:107)_
_ at com.serotonin.mango.web.dwr.WatchListDwr.getPointData(WatchListDwr.java:90)_
_ at com.serotonin.mango.web.dwr.MiscDwr.doLongPoll(MiscDwr.java:329)_
_ at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source)_
_ at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)_
_ at java.lang.reflect.Method.invoke(Unknown Source)_
_ at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.dwr.util.LoggedInAjaxMethodFilter.doFilter(LoggedInAjaxMethodFilter.java:52)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.web.dwr.LocalizationFilter.doFilter(LocalizationFilter.java:42)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter(ExceptionDetectionFilter.java:40)_
_ at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)_
_ at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)_
_ at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)_
_ at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)_
_ at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)_
_ at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)_
_ at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)_
_ at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)_
_ at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)_
_ at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)_
_ at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:522)_
_ at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)_
_ at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)_
_ at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)_
_ at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)_
_ at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)_
_ at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:1110)_
_ at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)_
_ at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:785)_
_ at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1425)_
_ at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)_
_ at java.lang.Thread.run(Unknown Source)_
_ WARN 2020-07-28 15:55:20,281 (org.directwebremoting.util.CommonsLoggingOutput.warn:59) - --Erroring: batchId[15] message[java.lang.NullPointerException] _
_ FATAL 2020-07-28 15:58:04,467 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure_

_ Last packet sent to the server was 0 ms ago.)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure_

_ Last packet sent to the server was 0 ms ago.)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure_

_ Last packet sent to the server was 0 ms ago._
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure_

_ Last packet sent to the server was 0 ms ago._
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)_
_ at com.mysql.jdbc.MysqlIO.(MysqlIO.java:335)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)_
_ … 35 more_
_ Caused by: java.net.ConnectException: Connection refused: connect_
_ at java.net.DualStackPlainSocketImpl.connect0(Native Method)_
_ at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)_
_ at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)_
_ at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)_
_ at java.net.AbstractPlainSocketImpl.connect(Unknown Source)_
_ at java.net.PlainSocketImpl.connect(Unknown Source)_
_ at java.net.SocksSocketImpl.connect(Unknown Source)_
_ at java.net.Socket.connect(Unknown Source)_
_ at java.net.Socket.connect(Unknown Source)_
_ at java.net.Socket.(Unknown Source)_
_ at java.net.Socket.(Unknown Source)_
_ at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)_
_ at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)_
_ … 36 more_
_ WARN 2020-07-28 16:04:10,874 (com.serotonin.mango.MangoContextListener.contextInitialized:118) - Mango’s known servlet context path has changed from /ScadaBR to /testebd. Are there two instances of Mango running? _
_ FATAL 2020-07-28 16:11:01,719 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure_

_ Last packet sent to the server was 0 ms ago.)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Communications link failure_

_ Last packet sent to the server was 0 ms ago.)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure_

_ Last packet sent to the server was 0 ms ago._
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure_

continua…

Agradeço qualquer ajuda.

FredNicolas · Julho 28, 2020, 9:38pm

_ Last packet sent to the server was 0 ms ago._
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)_
_ at com.mysql.jdbc.MysqlIO.(MysqlIO.java:335)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)_
_ … 35 more_
_ Caused by: java.net.ConnectException: Connection refused: connect_
_ at java.net.DualStackPlainSocketImpl.connect0(Native Method)_
_ at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)_
_ at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)_
_ at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)_
_ at java.net.AbstractPlainSocketImpl.connect(Unknown Source)_
_ at java.net.PlainSocketImpl.connect(Unknown Source)_
_ at java.net.SocksSocketImpl.connect(Unknown Source)_
_ at java.net.Socket.connect(Unknown Source)_
_ at java.net.Socket.connect(Unknown Source)_
_ at java.net.Socket.(Unknown Source)_
_ at java.net.Socket.(Unknown Source)_
_ at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)_
_ at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284)_
_ … 36 more_
_ WARN 2020-07-28 16:11:22,329 (com.serotonin.mango.MangoContextListener.contextInitialized:118) - Mango’s known servlet context path has changed from /testebd to /ScadaBR. Are there two instances of Mango running? _
_ FATAL 2020-07-28 16:24:09,606 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@‘localhost’ to database ‘scadabr’)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@‘localhost’ to database ‘scadabr’)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘scadabr’@‘localhost’ to database ‘scadabr’_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.Util.getInstance(Util.java:381)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ FATAL 2020-07-28 16:27:15,256 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@‘localhost’ to database ‘scadabr’)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@‘localhost’ to database ‘scadabr’)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘scadabr’@‘localhost’ to database ‘scadabr’_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.Util.getInstance(Util.java:381)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ FATAL 2020-07-28 16:33:47,119 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@’%’ to database ‘scadabr’)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@’%’ to database ‘scadabr’)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘scadabr’@’%’ to database ‘scadabr’_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.Util.getInstance(Util.java:381)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ FATAL 2020-07-28 16:48:36,705 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@’%’ to database ‘scadabr3’)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@’%’ to database ‘scadabr3’)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘scadabr’@’%’ to database ‘scadabr3’_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.Util.getInstance(Util.java:381)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ WARN 2020-07-28 16:52:27,826 (com.serotonin.mango.MangoContextListener.contextInitialized:118) - Mango’s known servlet context path has changed from /ScadaBR to /testebd. Are there two instances of Mango running? _

FredNicolas · Julho 28, 2020, 9:38pm

_ FATAL 2020-07-28 17:06:31,615 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘fred’@’%’ to database ‘scadabr3’)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘fred’@’%’ to database ‘scadabr3’)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘fred’@’%’ to database ‘scadabr3’_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.Util.getInstance(Util.java:381)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ WARN 2020-07-28 17:06:51,437 (com.serotonin.mango.MangoContextListener.contextInitialized:118) - Mango’s known servlet context path has changed from /testebd to /ScadaBR. Are there two instances of Mango running? _
_ FATAL 2020-07-28 17:12:53,182 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘fred’@’%’ to database ‘scadabr3’)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘fred’@’%’ to database ‘scadabr3’)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘fred’@’%’ to database ‘scadabr3’_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.Util.getInstance(Util.java:381)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ WARN 2020-07-28 18:09:52,960 (com.serotonin.mango.MangoContextListener.contextInitialized:118) - Mango’s known servlet context path has changed from /ScadaBR to /TesteMySQL. Are there two instances of Mango running? _
_ FATAL 2020-07-28 18:12:28,251 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘fred’@‘localhost’ (using password: YES))_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘fred’@‘localhost’ (using password: YES))_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: java.sql.SQLException: Access denied for user ‘fred’@‘localhost’ (using password: YES)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_
_ WARN 2020-07-28 18:12:58,174 (com.serotonin.mango.MangoContextListener.contextInitialized:118) - Mango’s known servlet context path has changed from /TesteMySQL to /ScadaBR. Are there two instances of Mango running? _
_ FATAL 2020-07-28 18:16:12,125 (com.serotonin.mango.db.DatabaseAccess.initialize:168) - Unable to connect to database of type MYSQL _
_ org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@’%’ to database ‘scadabr3’)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)_
_ at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:428)_
_ at com.serotonin.mango.db.MySQLAccess.newDatabaseCheck(MySQLAccess.java:76)_
_ at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:113)_
_ at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:301)_
_ at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:108)_
_ at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4716)_
_ at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5178)_
_ at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:152)_
_ at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)_
_ at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)_
_ at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)_
_ at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:952)_
_ at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1823)_
_ at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)_
_ at java.util.concurrent.FutureTask.run(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)_
_ at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)_
_ at java.lang.Thread.run(Unknown Source)_
_ Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@’%’ to database ‘scadabr3’)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1232)_
_ at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:881)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)_
_ at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)_
_ … 19 more_
_ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ‘scadabr’@’%’ to database ‘scadabr3’_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.Util.getInstance(Util.java:381)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)_
_ at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)_
_ at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)_
_ at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)_
_ at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)_
_ at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2048)_
_ at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:723)_
_ at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)_
_ at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)_
_ at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)_
_ at java.lang.reflect.Constructor.newInstance(Unknown Source)_
_ at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)_
_ at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)_
_ at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)_
_ at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)_
_ at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)_
_ at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1254)_
_ at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1228)_
_ … 22 more_

FredNicolas · Julho 28, 2020, 10:06pm

Resolvido
Acredito que o problema era no usuário que eu havia criado no MySQL
Mudei para o usuário root e deu tudo certo!

WagnerdeQueiroz · Outubro 14, 2020, 6:33am

Olá Fred. Desculpa a demora em ver a sua mensagem. Que bom que resolveu. Para quem tiver problema igual no futuro, olhe abaixo…

O erro abaixo dizia isso:
.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user ‘scadabr’@‘localhost’ to database ‘scadabr’)_…

No seu post, disse que criou o usuário Fred. Mas no env.properties o usuário era o scadabr que acessa o banco.

Se o usuário e senha não batem, o MySQL recusa conexão.

A mensagem disse acesso negado ao usuário scadabr no banco scadabr.

Em env.properties se a senha não estava errada podia ser que o usuário não tinha permissão de acesso ao banco scadabr.

Isso era fácil de saber. Era só logar no MySQL com as credenciais que usa no env.properties e ver se vc podia ler ou gravar tabelas no banco scadabr como esse usuário. De toda forma voce tem que assegurar que esses três passos foram dados no MySQL:

create database scadabr;
Isso cria o banco ScadaBR. O sistema não faz isso sozinho.

CREATE USER ‘scadabr’ IDENTIFIED BY ‘scadabr’;
Você tem que criar o usuário que acessa o MySQL

GRANT ALL PRIVILEGES ON scadabr.* TO scadabr;
Esse comando da privilégio ao usuário ScadaBR para fazer qualquer coisa no banco ScadaBR.

Segue um conselho importante…

É recomendável nunca, nunca usar o usuário root como usuário do banco de dados scadabr, pois se um crackudo ler o env.properties ele poderá invadir o MySQL e fazer estrago.

Se o crackudo ler e ficar sabendo do usuário scadabr o máximo que ele pode fazer é mexer no banco do scadaBR mas se tiver um backup, geralmente resolve.

Mas como root… Ele pode mudar a senha e vc não poderia fazer nada. Nem backup, nem ler dados… Ele pode fazer muita coisa ruim.

Ajuda com MySQL e ScadaBR 1.1

HTTP Status 404 - /TesteMySQL