通過Tomcat jpress連接不到資料庫 - ⎝⎛CodingNote.cc ⎞⎠

通過Tomcat jpress連接不到資料庫

2020 年 8 月 29 日
筆記
BUG_記錄

--

實際資料庫、用戶名，密碼，主機帳號，埠號均正確

提示如下:




異常如下：
------------------------------------------------------------------------------
2020-08-29 17:27:28.959 ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-7 - Exception during pool initialization.
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864)
        at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        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.jdbc.Util.handleNewInstance(Util.java:425)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
        at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
        at io.jboot.db.datasource.HikariDataSourceFactory.createDataSource(HikariDataSourceFactory.java:61)
        at io.jboot.db.datasource.DataSourceBuilder.createDataSource(DataSourceBuilder.java:64)
        at io.jboot.db.datasource.DataSourceBuilder.build(DataSourceBuilder.java:43)
        at io.jpress.core.install.DbExecuter.<init>(DbExecuter.java:63)
        at io.jpress.core.install.InstallManager.init(InstallManager.java:55)
        at io.jpress.web.install.InstallController.gotoStep3(InstallController.java:104)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:97)
        at io.jpress.web.install.InstallInterceptor.intercept(InstallInterceptor.java:31)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
        at io.jpress.web.interceptor.JPressInterceptor.intercept(JPressInterceptor.java:60)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
        at io.jpress.web.interceptor.UTMInterceptor.intercept(UTMInterceptor.java:47)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:47)
        at io.jpress.core.addon.interceptor.AddonInterceptorProcesser.intercept(AddonInterceptorProcesser.java:34)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.seata.interceptor.SeataGlobalTransactionalInterceptor.intercept(SeataGlobalTransactionalInterceptor.java:42)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.metric.JbootMetricInterceptor.intercept(JbootMetricInterceptor.java:43)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.shiro.JbootShiroInterceptor.intercept(JbootShiroInterceptor.java:34)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.jwt.JwtInterceptor.intercept(JwtInterceptor.java:40)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.web.validate.ParaValidateInterceptor.intercept(ParaValidateInterceptor.java:53)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.web.cors.CORSInterceptor.intercept(CORSInterceptor.java:42)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.components.limiter.LimiterInterceptor.intercept(LimiterInterceptor.java:50)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.sentinel.SentinelInterceptor.intercept(SentinelInterceptor.java:35)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.web.handler.JbootActionHandler.invokeInvocation(JbootActionHandler.java:212)
        at io.jboot.web.handler.JbootActionHandler.handle(JbootActionHandler.java:123)
        at io.jboot.web.handler.JbootHandler.doHandle(JbootHandler.java:46)
        at io.jboot.web.handler.JbootHandler.handle(JbootHandler.java:36)
        at io.jboot.web.handler.JbootFilterHandler.handle(JbootFilterHandler.java:45)
        at io.jboot.components.gateway.JbootGatewayHandler.handle(JbootGatewayHandler.java:37)
        at io.jpress.core.addon.handler.AddonHandlerProcesser.handle(AddonHandlerProcesser.java:32)
        at io.jpress.web.handler.JPressHandler.handle(JPressHandler.java:98)
        at io.jpress.web.sitemap.SitemapHandler.handle(SitemapHandler.java:42)
        at io.jpress.core.install.InstallHandler.handle(InstallHandler.java:42)
        at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:90)
        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:202)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
        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:690)
        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:373)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Access denied for user 'root'@'localhost' (using password: YES)
        at com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:595)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:581)
        at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
        at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
        at io.jboot.db.datasource.HikariDataSourceFactory.createDataSource(HikariDataSourceFactory.java:61)
        at io.jboot.db.datasource.DataSourceBuilder.createDataSource(DataSourceBuilder.java:64)
        at io.jboot.db.datasource.DataSourceBuilder.build(DataSourceBuilder.java:43)
        at io.jpress.core.install.DbExecuter.<init>(DbExecuter.java:63)
        at io.jpress.core.install.InstallManager.init(InstallManager.java:55)
        at io.jpress.web.install.InstallController.gotoStep3(InstallController.java:104)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:97)
        at io.jpress.web.install.InstallInterceptor.intercept(InstallInterceptor.java:31)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
        at io.jpress.web.interceptor.JPressInterceptor.intercept(JPressInterceptor.java:60)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
        at io.jpress.web.interceptor.UTMInterceptor.intercept(UTMInterceptor.java:47)
        at com.jfinal.aop.Invocation.invoke(Invocation.java:91)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:47)
        at io.jpress.core.addon.interceptor.AddonInterceptorProcesser.intercept(AddonInterceptorProcesser.java:34)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.seata.interceptor.SeataGlobalTransactionalInterceptor.intercept(SeataGlobalTransactionalInterceptor.java:42)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.metric.JbootMetricInterceptor.intercept(JbootMetricInterceptor.java:43)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.shiro.JbootShiroInterceptor.intercept(JbootShiroInterceptor.java:34)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.jwt.JwtInterceptor.intercept(JwtInterceptor.java:40)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.web.validate.ParaValidateInterceptor.intercept(ParaValidateInterceptor.java:53)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.web.cors.CORSInterceptor.intercept(CORSInterceptor.java:42)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.components.limiter.LimiterInterceptor.intercept(LimiterInterceptor.java:50)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.support.sentinel.SentinelInterceptor.intercept(SentinelInterceptor.java:35)
        at io.jboot.web.fixedinterceptor.FixedInvocation.invoke(FixedInvocation.java:45)
        at io.jboot.web.handler.JbootActionHandler.invokeInvocation(JbootActionHandler.java:212)
        at io.jboot.web.handler.JbootActionHandler.handle(JbootActionHandler.java:123)
        at io.jboot.web.handler.JbootHandler.doHandle(JbootHandler.java:46)
        at io.jboot.web.handler.JbootHandler.handle(JbootHandler.java:36)
        at io.jboot.web.handler.JbootFilterHandler.handle(JbootFilterHandler.java:45)
        at io.jboot.components.gateway.JbootGatewayHandler.handle(JbootGatewayHandler.java:37)
        at io.jpress.core.addon.handler.AddonHandlerProcesser.handle(AddonHandlerProcesser.java:32)
        at io.jpress.web.handler.JPressHandler.handle(JPressHandler.java:98)
        at io.jpress.web.sitemap.SitemapHandler.handle(SitemapHandler.java:42)
        at io.jpress.core.install.InstallHandler.handle(InstallHandler.java:42)
        at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:90)
        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:202)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
        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:690)
        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:373)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864)
        at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707)
        at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        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.jdbc.Util.handleNewInstance(Util.java:425)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
        at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
        at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358)
        at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
        at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477)
        at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560)
        ... 68 more

JFinal-4.9 action report -------- 2020-08-29 17:27:29 --------------------------
Url         : GET /install/error
Controller  : io.jpress.web.install.InstallController.(InstallController.java:1)
Method      : error
Interceptor : io.jpress.web.interceptor.UTMInterceptor.(UTMInterceptor.java:1)
              io.jpress.web.interceptor.JPressInterceptor.(JPressInterceptor.java:1)
              io.jpress.web.install.InstallInterceptor.(InstallInterceptor.java:1)

　　

Tags: BUG_記錄

Previous post

8.深入k8s：資源控制Qos和eviction及其源碼分析

Next post

python sqlite3簡單操作