天天看点

jpress连接数据库mysql_通过Tomcat jpress连接不到数据库

--

jpress连接数据库mysql_通过Tomcat jpress连接不到数据库

实际数据库、用户名,密码,主机账号,端口号均正确

提示如下:

jpress连接数据库mysql_通过Tomcat jpress连接不到数据库

异常如下:

------------------------------------------------------------------------------

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.(ConnectionImpl.java:768)

at com.mysql.jdbc.JDBC4Connection.(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.(HikariPool.java:115)

at com.zaxxer.hikari.HikariDataSource.(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.(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.(HikariPool.java:115)

at com.zaxxer.hikari.HikariDataSource.(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.(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.(ConnectionImpl.java:768)

at com.mysql.jdbc.JDBC4Connection.(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)