Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Docker Compose 环境无法启动 #71

Closed
wokula99 opened this issue Jul 21, 2022 · 10 comments
Closed

Docker Compose 环境无法启动 #71

wokula99 opened this issue Jul 21, 2022 · 10 comments
Assignees
Labels

Comments

@wokula99
Copy link

环境版本:
centos 7 + Docker Compose version v2.7.0

按照官网文档修改了IP 和 NGINX 域名。

image

[root@dingtalk_snyc docker]# docker-compose logs -f maxkey
maxkey | 2022-07-21 15:28:31.391 INFO [main] org.maxkey.MaxKeyApplication:46 - Start MaxKeyApplication ...
maxkey | 2022-07-21 15:28:33.202 INFO [main] org.springframework.boot.SpringApplication:62 -
maxkey | __ ___ __ __
maxkey | / |/ /__ ___ __ / ///__ __ __
maxkey | / /|
/ / _ /\ \ // ,< / -_) // / maxkey | /_/ /_/\_,_//_\_\/_/|_|\__/\_, / maxkey | /___/ maxkey | :: MaxKey :: (v3.5.2 GA) maxkey | maxkey | 2022-07-21 15:28:33.224 INFO [main] org.maxkey.MaxKeyApplication:651 - The following 1 profile is active: "http" maxkey | 2022-07-21 15:28:36.648 INFO [main] org.springframework.cloud.context.scope.GenericScope:283 - BeanFactory id=74b62cb5-36cf-3623-822a-9577ab370051 maxkey | 2022-07-21 15:28:37.257 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:78 - Basename classpath:messages/message maxkey | 2022-07-21 15:28:37.444 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:244 - WebServerFactoryCustomizer ... maxkey | 2022-07-21 15:28:37.702 INFO [main] org.springframework.boot.web.embedded.tomcat.TomcatWebServer:108 - Tomcat initialized with port(s): 9527 (http) maxkey | Jul 21, 2022 3:28:37 PM org.apache.coyote.AbstractProtocol init maxkey | INFO: Initializing ProtocolHandler ["http-nio-9527"] maxkey | Jul 21, 2022 3:28:37 PM org.apache.catalina.core.StandardService startInternal maxkey | INFO: Starting service [Tomcat] maxkey | Jul 21, 2022 3:28:37 PM org.apache.catalina.core.StandardEngine startInternal maxkey | INFO: Starting Servlet engine: [Apache Tomcat/9.0.63] maxkey | Jul 21, 2022 3:28:37 PM org.apache.catalina.core.ApplicationContext log maxkey | INFO: Initializing Spring embedded WebApplicationContext maxkey | 2022-07-21 15:28:37.980 INFO [main] org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext:290 - Root WebApplicationContext: initialization completed in 4728 ms maxkey | 2022-07-21 15:28:38.045 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:280 - delegatingFilterProxy init for /* maxkey | 2022-07-21 15:28:38.047 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:293 - webXssRequestFilter init for /* maxkey | 2022-07-21 15:28:38.057 INFO [main] com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure:56 - Init DruidDataSource maxkey | 2022-07-21 15:28:38.341 INFO [main] com.alibaba.druid.pool.DruidDataSource:995 - {dataSource-1} inited maxkey | 2022-07-21 15:28:38.505 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:305 - WebInstRequestFilter init for /* maxkey | 2022-07-21 15:28:38.517 DEBUG [main] org.maxkey.autoconfigure.Oauth20AutoConfiguration:76 - TokenEndpointAuthenticationFilter init maxkey | 2022-07-21 15:28:38.818 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:258 - securityContextHolderAwareRequestFilter init maxkey | 2022-07-21 15:28:38.853 DEBUG [main] org.maxkey.authn.web.HttpSessionListenerAdapter:38 - SessionListenerAdapter inited . maxkey | 2022-07-21 15:28:38.925 DEBUG [main] org.maxkey.web.WebXssRequestFilter:242 - Filter 'webXssRequestFilter' configured for use maxkey | 2022-07-21 15:28:38.926 DEBUG [main] org.maxkey.web.WebInstRequestFilter:242 - Filter 'webInstRequestFilter' configured for use maxkey | 2022-07-21 15:28:39.024 DEBUG [main] org.maxkey.autoconfigure.RedisAutoConfiguration:63 - redisConnFactory init . maxkey | 2022-07-21 15:28:39.055 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:205 - session timeout 1800 maxkey | 2022-07-21 15:28:39.061 DEBUG [main] org.maxkey.authn.session.SessionManagerFactory:76 - InMemorySessionManager maxkey | 2022-07-21 15:28:39.087 DEBUG [main] org.maxkey.autoconfigure.ApplicationAutoConfiguration:121 - bcrypt is default encoder maxkey | RocketMQLog:WARN No appenders could be found for logger (io.netty.util.internal.InternalThreadLocalMap). maxkey | RocketMQLog:WARN Please initialize the logger system properly. maxkey | 2022-07-21 15:28:40.473 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:178 - OneTimePasswordService InMemory inited. maxkey | 2022-07-21 15:28:40.495 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:95 - init authentication Provider . maxkey | 2022-07-21 15:28:40.497 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:111 - init Mobile authentication Provider . maxkey | 2022-07-21 15:28:40.499 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:126 - init Mobile authentication Provider . maxkey | 2022-07-21 15:28:44.696 ERROR [Druid-ConnectionPool-Create-1634001207] com.alibaba.druid.pool.DruidDataSource:2842 - create connection SQLException, url: jdbc:mysql://10.0.8.33:3306/maxkey?autoReconnect=true&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 0, state 08001 maxkey | java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1667) ~[druid-1.2.10.jar:1.2.10] maxkey | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1733) ~[druid-1.2.10.jar:1.2.10] maxkey | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2840) ~[druid-1.2.10.jar:1.2.10] maxkey | Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure maxkey | maxkey | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. maxkey | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_292] maxkey | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_292] maxkey | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_292] maxkey | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_292] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | ... 7 more maxkey | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. maxkey | at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | ... 7 more maxkey | 2022-07-21 15:28:48.707 ERROR [Druid-ConnectionPool-Create-1634001207] com.alibaba.druid.pool.DruidDataSource:2842 - create connection SQLException, url: jdbc:mysql://10.0.8.33:3306/maxkey?autoReconnect=true&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 0, state 08001 maxkey | java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1667) ~[druid-1.2.10.jar:1.2.10] maxkey | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1733) ~[druid-1.2.10.jar:1.2.10] maxkey | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2840) ~[druid-1.2.10.jar:1.2.10] maxkey | Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure maxkey | maxkey | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. maxkey | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_292] maxkey | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_292] maxkey | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_292] maxkey | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_292] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | ... 7 more maxkey | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. maxkey | at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | ... 7 more maxkey | 2022-07-21 15:28:48.709 INFO [Druid-ConnectionPool-Create-1634001207] com.alibaba.druid.pool.DruidAbstractDataSource:1814 - {dataSource-1} failContinuous is true maxkey | 2022-07-21 15:28:49.445 INFO [Druid-ConnectionPool-Create-1634001207] com.alibaba.druid.pool.DruidAbstractDataSource:1819 - {dataSource-1} failContinuous is false maxkey | 2022-07-21 15:28:49.563 WARN [main] org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext:591 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'loginEntryPoint': Unsatisfied dependency expressed through field 'socialSignOnProviderService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'socialSignOnProviderService' defined in class path resource [org/maxkey/autoconfigure/SocialSignOnAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.maxkey.authn.support.socialsignon.service.SocialSignOnProviderService]: Factory method 'socialSignOnProviderService' threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from mxk_socials_provider where instid = ? and status = 1 order by sortindex]; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_socials_provider' doesn't exist maxkey | 2022-07-21 15:28:49.607 INFO [main] com.alibaba.druid.pool.DruidDataSource:2073 - {dataSource-1} closing ... maxkey | 2022-07-21 15:28:49.624 INFO [main] com.alibaba.druid.pool.DruidDataSource:2146 - {dataSource-1} closed maxkey | Jul 21, 2022 3:28:49 PM org.apache.catalina.core.StandardService stopInternal maxkey | INFO: Stopping service [Tomcat] maxkey | 2022-07-21 15:28:49.650 INFO [main] org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener:136 - maxkey | maxkey | Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. maxkey | 2022-07-21 15:28:49.673 ERROR [main] org.springframework.boot.SpringApplication:835 - Application run failed maxkey | org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'loginEntryPoint': Unsatisfied dependency expressed through field 'socialSignOnProviderService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'socialSignOnProviderService' defined in class path resource [org/maxkey/autoconfigure/SocialSignOnAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.maxkey.authn.support.socialsignon.service.SocialSignOnProviderService]: Factory method 'socialSignOnProviderService' threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from mxk_socials_provider where instid = ? and status = 1 order by sortindex]; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_socials_provider' doesn't exist maxkey | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:659) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:639) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.21.jar:5.3.21] maxkey | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.21.jar:5.3.21] maxkey | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.9.jar:2.6.9] maxkey | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) ~[spring-boot-2.6.9.jar:2.6.9] maxkey | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) ~[spring-boot-2.6.9.jar:2.6.9] maxkey | at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) ~[spring-boot-2.6.9.jar:2.6.9] maxkey | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) ~[spring-boot-2.6.9.jar:2.6.9] maxkey | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) ~[spring-boot-2.6.9.jar:2.6.9] maxkey | at org.maxkey.MaxKeyApplication.main(MaxKeyApplication.java:50) ~[classes/:?] maxkey | Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'socialSignOnProviderService' defined in class path resource [org/maxkey/autoconfigure/SocialSignOnAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.maxkey.authn.support.socialsignon.service.SocialSignOnProviderService]: Factory method 'socialSignOnProviderService' threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from mxk_socials_provider where instid = ? and status = 1 order by sortindex]; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_socials_provider' doesn't exist maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | ... 20 more maxkey | Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.maxkey.authn.support.socialsignon.service.SocialSignOnProviderService]: Factory method 'socialSignOnProviderService' threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from mxk_socials_provider where instid = ? and status = 1 order by sortindex]; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_socials_provider' doesn't exist maxkey | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | ... 20 more maxkey | Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from mxk_socials_provider where instid = ? and status = 1 order by sortindex]; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_socials_provider' doesn't exist maxkey | at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:815) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.maxkey.authn.support.socialsignon.service.SocialSignOnProviderService.loadSocials(SocialSignOnProviderService.java:184) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration.socialSignOnProviderService(SocialSignOnAutoConfiguration.java:46) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration$$EnhancerBySpringCGLIB$$13489654.CGLIB$socialSignOnProviderService$1(<generated>) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration$$EnhancerBySpringCGLIB$$13489654$$FastClassBySpringCGLIB$$81c084bd.invoke(<generated>) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.3.21.jar:5.3.21] maxkey | at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.3.21.jar:5.3.21] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration$$EnhancerBySpringCGLIB$$13489654.socialSignOnProviderService(<generated>) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292] maxkey | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292] maxkey | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292] maxkey | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292] maxkey | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | ... 20 more maxkey | Caused by: java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_socials_provider' doesn't exist maxkey | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey | at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227) ~[druid-1.2.10.jar:1.2.10] maxkey | at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:722) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:815) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey | at org.maxkey.authn.support.socialsignon.service.SocialSignOnProviderService.loadSocials(SocialSignOnProviderService.java:184) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration.socialSignOnProviderService(SocialSignOnAutoConfiguration.java:46) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration$$EnhancerBySpringCGLIB$$13489654.CGLIB$socialSignOnProviderService$1(<generated>) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration$$EnhancerBySpringCGLIB$$13489654$$FastClassBySpringCGLIB$$81c084bd.invoke(<generated>) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.3.21.jar:5.3.21] maxkey | at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.3.21.jar:5.3.21] maxkey | at org.maxkey.autoconfigure.SocialSignOnAutoConfiguration$$EnhancerBySpringCGLIB$$13489654.socialSignOnProviderService(<generated>) ~[maxkey-authentication-social-3.5.2.jar:3.5.2] maxkey | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292] maxkey | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292] maxkey | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292] maxkey | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292] maxkey | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.resolveFieldValue(AutowiredAnnotationBeanPostProcessor.java:656) ~[spring-beans-5.3.21.jar:5.3.21] maxkey | ... 20 more maxkey | 2022-07-21 15:34:46.569 INFO [main] org.maxkey.MaxKeyApplication:46 - Start MaxKeyApplication ... maxkey | 2022-07-21 15:34:47.646 INFO [main] org.springframework.boot.SpringApplication:62 - maxkey | __ ___ __ __ maxkey | / |/ /__ ___ __ / //_/__ __ __ maxkey | / /|_/ / _ /\ \ // ,< / -) // /
maxkey | /
/ //_,//_//||_/_, /
maxkey | /___/
maxkey | :: MaxKey :: (v3.5.2 GA)

@wokula99
Copy link
Author

[root@dingtalk_snyc docker]# docker-compose logs -f maxkey-mgt
maxkey-mgt | 2022-07-21 15:28:31.236 INFO [main] org.maxkey.MaxKeyMgtApplication:64 - Start MaxKeyMgtApplication ...
maxkey-mgt | 2022-07-21 15:28:32.915 INFO [main] org.springframework.boot.SpringApplication:62 -
maxkey-mgt | __ ___ __ __
maxkey-mgt | / |/ /__ ___ __ / ///__ __ __
maxkey-mgt | / /|
/ / _ /\ \ // ,< / -_) // / maxkey-mgt | /_/ /_/\_,_//_\_\/_/|_|\__/\_, / maxkey-mgt | /___/ maxkey-mgt | :: MaxKey :: (v3.5.2 GA) maxkey-mgt | maxkey-mgt | 2022-07-21 15:28:32.936 INFO [main] org.maxkey.MaxKeyMgtApplication:651 - The following 1 profile is active: "http" maxkey-mgt | 2022-07-21 15:28:36.095 INFO [main] org.springframework.cloud.context.scope.GenericScope:283 - BeanFactory id=671e1bbf-7f68-3133-9c6f-fd42a18391d3 maxkey-mgt | 2022-07-21 15:28:36.731 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:78 - Basename classpath:messages/message maxkey-mgt | 2022-07-21 15:28:36.890 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:244 - WebServerFactoryCustomizer ... maxkey-mgt | 2022-07-21 15:28:37.085 INFO [main] org.springframework.boot.web.embedded.tomcat.TomcatWebServer:108 - Tomcat initialized with port(s): 9526 (http) maxkey-mgt | Jul 21, 2022 3:28:37 PM org.apache.coyote.AbstractProtocol init maxkey-mgt | INFO: Initializing ProtocolHandler ["http-nio-9526"] maxkey-mgt | Jul 21, 2022 3:28:37 PM org.apache.catalina.core.StandardService startInternal maxkey-mgt | INFO: Starting service [Tomcat] maxkey-mgt | Jul 21, 2022 3:28:37 PM org.apache.catalina.core.StandardEngine startInternal maxkey-mgt | INFO: Starting Servlet engine: [Apache Tomcat/9.0.63] maxkey-mgt | Jul 21, 2022 3:28:37 PM org.apache.catalina.core.ApplicationContext log maxkey-mgt | INFO: Initializing Spring embedded WebApplicationContext maxkey-mgt | 2022-07-21 15:28:37.335 INFO [main] org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext:290 - Root WebApplicationContext: initialization completed in 4363 ms maxkey-mgt | 2022-07-21 15:28:37.379 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:280 - delegatingFilterProxy init for /* maxkey-mgt | 2022-07-21 15:28:37.380 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:293 - webXssRequestFilter init for /* maxkey-mgt | 2022-07-21 15:28:37.389 INFO [main] com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure:56 - Init DruidDataSource maxkey-mgt | 2022-07-21 15:28:37.563 INFO [main] com.alibaba.druid.pool.DruidDataSource:995 - {dataSource-1} inited maxkey-mgt | 2022-07-21 15:28:37.742 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:305 - WebInstRequestFilter init for /* maxkey-mgt | 2022-07-21 15:28:37.996 DEBUG [main] org.maxkey.autoconfigure.MvcAutoConfiguration:258 - securityContextHolderAwareRequestFilter init maxkey-mgt | 2022-07-21 15:28:38.062 DEBUG [main] org.maxkey.authn.web.HttpSessionListenerAdapter:38 - SessionListenerAdapter inited . maxkey-mgt | 2022-07-21 15:28:38.163 DEBUG [main] org.maxkey.web.WebXssRequestFilter:242 - Filter 'webXssRequestFilter' configured for use maxkey-mgt | 2022-07-21 15:28:38.164 DEBUG [main] org.maxkey.web.WebInstRequestFilter:242 - Filter 'webInstRequestFilter' configured for use maxkey-mgt | 2022-07-21 15:28:38.246 DEBUG [main] org.maxkey.autoconfigure.ApplicationAutoConfiguration:121 - bcrypt is default encoder maxkey-mgt | RocketMQLog:WARN No appenders could be found for logger (io.netty.util.internal.InternalThreadLocalMap). maxkey-mgt | RocketMQLog:WARN Please initialize the logger system properly. maxkey-mgt | 2022-07-21 15:28:39.116 DEBUG [main] org.maxkey.MaxKeyMgtConfig:57 - JdbcAuthenticationRealm inited. maxkey-mgt | 2022-07-21 15:28:39.162 DEBUG [main] org.maxkey.autoconfigure.RedisAutoConfiguration:63 - redisConnFactory init . maxkey-mgt | 2022-07-21 15:28:39.230 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:205 - session timeout 1800 maxkey-mgt | 2022-07-21 15:28:39.238 DEBUG [main] org.maxkey.authn.session.SessionManagerFactory:76 - InMemorySessionManager maxkey-mgt | 2022-07-21 15:28:39.268 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:95 - init authentication Provider . maxkey-mgt | 2022-07-21 15:28:39.325 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:178 - OneTimePasswordService InMemory inited. maxkey-mgt | 2022-07-21 15:28:39.326 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:111 - init Mobile authentication Provider . maxkey-mgt | 2022-07-21 15:28:39.332 DEBUG [main] org.maxkey.autoconfigure.AuthenticationAutoConfiguration:126 - init Mobile authentication Provider . maxkey-mgt | 2022-07-21 15:28:39.372 DEBUG [main] org.maxkey.crypto.jose.keystore.JWKSetKeyStore:77 - JWK location file:/app/resources/config/loginjwkkeystore.jwks maxkey-mgt | 2022-07-21 15:28:39.739 DEBUG [main] org.maxkey.autoconfigure.JwtAuthnAutoConfiguration:49 - JWT Login JwkSet KeyStore init. maxkey-mgt | 2022-07-21 15:28:39.768 DEBUG [main] org.maxkey.autoconfigure.JwtAuthnAutoConfiguration:68 - JWT Login Signing and Validation init. maxkey-mgt | 2022-07-21 15:28:39.777 DEBUG [main] org.maxkey.autoconfigure.JwtAuthnAutoConfiguration:85 - JWT Login Service init. maxkey-mgt | 2022-07-21 15:28:40.105 DEBUG [main] org.maxkey.MaxKeyMgtConfig:64 - TimeBasedOtpAuthn inited. maxkey-mgt | 2022-07-21 15:28:40.134 DEBUG [main] org.maxkey.Oauth20ClientAutoConfiguration:54 - JdbcClientDetailsService inited. maxkey-mgt | 2022-07-21 15:28:40.140 DEBUG [main] org.maxkey.crypto.keystore.KeyStoreLoader:85 - Load KeyStore from file file:/app/resources/config/samlServerKeystore.jks maxkey-mgt | 2022-07-21 15:28:40.290 DEBUG [main] org.maxkey.crypto.keystore.KeyStoreLoader:89 - Load KeyStore success . maxkey-mgt | 2022-07-21 15:28:40.290 DEBUG [main] org.maxkey.crypto.keystore.KeyStoreLoader:94 - KeyStore alias name 0 : maxkey.top maxkey-mgt | 2022-07-21 15:28:40.329 DEBUG [main] org.maxkey.Oauth20ClientAutoConfiguration:74 - InMemoryTokenStore maxkey-mgt | 2022-07-21 15:28:40.366 DEBUG [main] org.maxkey.Oauth20ClientAutoConfiguration:112 - OAuth 2 Client Authentication Manager init. maxkey-mgt | 2022-07-21 15:28:40.374 DEBUG [main] org.maxkey.autoconfigure.KaptchaAutoConfiguration:47 - Kaptcha config file jar:file:/app/libs/maxkey-authentication-captcha-3.5.2.jar!/kaptcha.properties maxkey-mgt | 2022-07-21 15:28:40.775 INFO [main] org.quartz.impl.StdSchedulerFactory:1220 - Using default implementation for ThreadExecutor maxkey-mgt | 2022-07-21 15:28:40.805 INFO [main] org.quartz.core.SchedulerSignalerImpl:61 - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl maxkey-mgt | 2022-07-21 15:28:40.805 INFO [main] org.quartz.core.QuartzScheduler:229 - Quartz Scheduler v.2.3.2 created. maxkey-mgt | 2022-07-21 15:28:40.806 INFO [main] org.quartz.simpl.RAMJobStore:155 - RAMJobStore initialized. maxkey-mgt | 2022-07-21 15:28:40.807 INFO [main] org.quartz.core.QuartzScheduler:294 - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' maxkey-mgt | Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. maxkey-mgt | NOT STARTED. maxkey-mgt | Currently in standby mode. maxkey-mgt | Number of jobs executed: 0 maxkey-mgt | Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. maxkey-mgt | Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. maxkey-mgt | maxkey-mgt | 2022-07-21 15:28:40.807 INFO [main] org.quartz.impl.StdSchedulerFactory:1374 - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. maxkey-mgt | 2022-07-21 15:28:40.808 INFO [main] org.quartz.impl.StdSchedulerFactory:1378 - Quartz scheduler version: 2.3.2 maxkey-mgt | 2022-07-21 15:28:40.808 INFO [main] org.quartz.core.QuartzScheduler:2293 - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@1328f482 maxkey-mgt | 2022-07-21 15:28:45.003 ERROR [Druid-ConnectionPool-Create-391928890] com.alibaba.druid.pool.DruidDataSource:2842 - create connection SQLException, url: jdbc:mysql://10.0.8.33:3306/maxkey?autoReconnect=true&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 0, state 08001 maxkey-mgt | java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1667) ~[druid-1.2.10.jar:1.2.10] maxkey-mgt | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1733) ~[druid-1.2.10.jar:1.2.10] maxkey-mgt | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2840) ~[druid-1.2.10.jar:1.2.10] maxkey-mgt | Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure maxkey-mgt | maxkey-mgt | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. maxkey-mgt | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_292] maxkey-mgt | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_292] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | ... 7 more maxkey-mgt | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. maxkey-mgt | at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | ... 7 more maxkey-mgt | 2022-07-21 15:28:49.016 ERROR [Druid-ConnectionPool-Create-391928890] com.alibaba.druid.pool.DruidDataSource:2842 - create connection SQLException, url: jdbc:mysql://10.0.8.33:3306/maxkey?autoReconnect=true&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 0, state 08001 maxkey-mgt | java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1667) ~[druid-1.2.10.jar:1.2.10] maxkey-mgt | at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1733) ~[druid-1.2.10.jar:1.2.10] maxkey-mgt | at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2840) ~[druid-1.2.10.jar:1.2.10] maxkey-mgt | Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure maxkey-mgt | maxkey-mgt | The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. maxkey-mgt | at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_292] maxkey-mgt | at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_292] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | ... 7 more maxkey-mgt | Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. maxkey-mgt | at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:536) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:423) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1431) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.NativeSession.connect(NativeSession.java:133) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | ... 7 more maxkey-mgt | 2022-07-21 15:28:49.018 INFO [Druid-ConnectionPool-Create-391928890] com.alibaba.druid.pool.DruidAbstractDataSource:1814 - {dataSource-1} failContinuous is true maxkey-mgt | 2022-07-21 15:28:49.778 INFO [Druid-ConnectionPool-Create-391928890] com.alibaba.druid.pool.DruidAbstractDataSource:1819 - {dataSource-1} failContinuous is false maxkey-mgt | 2022-07-21 15:28:49.867 WARN [main] org.springframework.boot.web.servlet.context.AnnotationConfigServletWebServerApplicationContext:591 - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulerSynchronizerJobs' defined in class path resource [org/maxkey/synchronizer/autoconfigure/SynchronizerAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [java.lang.String]: Factory method 'schedulerSynchronizerJobs' threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from mxk_synchronizers where status ='1']; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_synchronizers' doesn't exist maxkey-mgt | 2022-07-21 15:28:49.867 INFO [main] org.springframework.scheduling.quartz.SchedulerFactoryBean:847 - Shutting down Quartz Scheduler maxkey-mgt | 2022-07-21 15:28:49.867 INFO [main] org.quartz.core.QuartzScheduler:666 - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. maxkey-mgt | 2022-07-21 15:28:49.868 INFO [main] org.quartz.core.QuartzScheduler:585 - Scheduler quartzScheduler_$_NON_CLUSTERED paused. maxkey-mgt | 2022-07-21 15:28:49.868 INFO [main] org.quartz.core.QuartzScheduler:740 - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. maxkey-mgt | 2022-07-21 15:28:49.882 INFO [main] com.alibaba.druid.pool.DruidDataSource:2073 - {dataSource-1} closing ... maxkey-mgt | 2022-07-21 15:28:49.886 INFO [main] com.alibaba.druid.pool.DruidDataSource:2146 - {dataSource-1} closed maxkey-mgt | Jul 21, 2022 3:28:49 PM org.apache.catalina.core.StandardService stopInternal maxkey-mgt | INFO: Stopping service [Tomcat] maxkey-mgt | 2022-07-21 15:28:49.913 INFO [main] org.springframework.boot.autoconfigure.logging.ConditionEvaluationReportLoggingListener:136 - maxkey-mgt | maxkey-mgt | Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled. maxkey-mgt | 2022-07-21 15:28:49.936 ERROR [main] org.springframework.boot.SpringApplication:835 - Application run failed maxkey-mgt | org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulerSynchronizerJobs' defined in class path resource [org/maxkey/synchronizer/autoconfigure/SynchronizerAutoConfiguration.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [java.lang.String]: Factory method 'schedulerSynchronizerJobs' threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from mxk_synchronizers where status ='1']; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_synchronizers' doesn't exist maxkey-mgt | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:658) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:638) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.9.jar:2.6.9] maxkey-mgt | at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) ~[spring-boot-2.6.9.jar:2.6.9] maxkey-mgt | at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) ~[spring-boot-2.6.9.jar:2.6.9] maxkey-mgt | at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) ~[spring-boot-2.6.9.jar:2.6.9] maxkey-mgt | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) ~[spring-boot-2.6.9.jar:2.6.9] maxkey-mgt | at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) ~[spring-boot-2.6.9.jar:2.6.9] maxkey-mgt | at org.maxkey.MaxKeyMgtApplication.main(MaxKeyMgtApplication.java:67) ~[classes/:?] maxkey-mgt | Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [java.lang.String]: Factory method 'schedulerSynchronizerJobs' threw exception; nested exception is org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from mxk_synchronizers where status ='1']; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_synchronizers' doesn't exist maxkey-mgt | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | ... 19 more maxkey-mgt | Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select * from mxk_synchronizers where status ='1']; nested exception is java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_synchronizers' doesn't exist maxkey-mgt | at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:393) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration.querySynchronizers(SynchronizerAutoConfiguration.java:98) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration.schedulerSynchronizerJobs(SynchronizerAutoConfiguration.java:61) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration$$EnhancerBySpringCGLIB$$4a064625.CGLIB$schedulerSynchronizerJobs$1(<generated>) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration$$EnhancerBySpringCGLIB$$4a064625$$FastClassBySpringCGLIB$$391e62c6.invoke(<generated>) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.3.21.jar:5.3.21] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration$$EnhancerBySpringCGLIB$$4a064625.schedulerSynchronizerJobs(<generated>) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292] maxkey-mgt | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292] maxkey-mgt | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | ... 19 more maxkey-mgt | Caused by: java.sql.SQLSyntaxErrorException: Table 'maxkey.mxk_synchronizers' doesn't exist maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1201) ~[mysql-connector-java-8.0.29.jar:8.0.29] maxkey-mgt | at com.alibaba.druid.pool.DruidPooledStatement.executeQuery(DruidPooledStatement.java:308) ~[druid-1.2.10.jar:1.2.10] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475) ~[spring-jdbc-5.3.21.jar:5.3.21] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration.querySynchronizers(SynchronizerAutoConfiguration.java:98) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration.schedulerSynchronizerJobs(SynchronizerAutoConfiguration.java:61) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration$$EnhancerBySpringCGLIB$$4a064625.CGLIB$schedulerSynchronizerJobs$1(<generated>) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration$$EnhancerBySpringCGLIB$$4a064625$$FastClassBySpringCGLIB$$391e62c6.invoke(<generated>) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244) ~[spring-core-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331) ~[spring-context-5.3.21.jar:5.3.21] maxkey-mgt | at org.maxkey.synchronizer.autoconfigure.SynchronizerAutoConfiguration$$EnhancerBySpringCGLIB$$4a064625.schedulerSynchronizerJobs(<generated>) ~[maxkey-synchronizer-3.5.2.jar:3.5.2] maxkey-mgt | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292] maxkey-mgt | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292] maxkey-mgt | at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292] maxkey-mgt | at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:653) ~[spring-beans-5.3.21.jar:5.3.21] maxkey-mgt | ... 19 more maxkey-mgt | 2022-07-21 15:44:59.350 INFO [main] org.maxkey.MaxKeyMgtApplication:64 - Start MaxKeyMgtApplication ... maxkey-mgt | 2022-07-21 15:45:00.954 INFO [main] org.springframework.boot.SpringApplication:62 - maxkey-mgt | __ ___ __ __ maxkey-mgt | / |/ /__ ___ __ / //_/__ __ __ maxkey-mgt | / /|_/ / _ /\ \ // ,< / -) // /
maxkey-mgt | /
/ //_,//_//||_/_, /
maxkey-mgt | /___/
maxkey-mgt | :: MaxKey :: (v3.5.2 GA)
maxkey-mgt |

@shimingxy
Copy link
Collaborator

请确保数据库正确创建,数据库的连接参数正确无误

@shimingxy shimingxy self-assigned this Jul 22, 2022
@new1943
Copy link

new1943 commented Jul 28, 2022

我也出现这个问题了,我本机用Navicat去连接是可以的,日志中出现的错误是:
maxkey | 2022-07-28 14:55:20.091 ERROR [Druid-ConnectionPool-Create-1848568533] com.alibaba.druid.pool.DruidDataSource:2815 - create connection SQLException, url: jdbc:mysql://localhost:3306/maxkey?autoReconnect=true&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 0, state 08001

@wokula99
Copy link
Author

我在gitee 上也提过ISSUES ,说回复没有问题,产品支持,说真的。开发者对使用他们开源产品的支持非常不友好。

@shimingxy
Copy link
Collaborator

com.alibaba.druid.pool.DruidDataSource:2815 - create connection SQLException, url: jdbc:mysql://localhost:3306/maxkey?autoReconnect=true&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 0, state 08001
日志中的连接地址为localhost,docker中无法判断localhost的,需要改成实际的IP地址

@shimingxy
Copy link
Collaborator

shimingxy commented Jul 30, 2022

以下文件中的DATABASE_HOST改为实际数据库IP地址
1、数据库路径配置

mysql:
	 image: maxkey:mysql
 	 container_name: mysql
	 build: ./docker-mysql
 	 volumes:
 	 - /root/mysql/data:/var/lib/mysql 
 	 - /root/mysql/logs:/var/log/mysql 
  	 - /root/docker-mysql:/etc/mysql/conf.d 
  	 - /root/docker-mysql/sql:/docker-entrypoint-initdb.d 

2、docker-maxkey/Dockerfile中的DATABASE_HOST=192.168.0.105
3、docker-maxkey-mgt/Dockerfile中的DATABASE_HOST=192.168.0.105
4、docker-compose.yml中的DATABASE_HOST:192.168.0.105
5、docker-nginx/nginx.conf中的映射

#认证后端
location /sign/ {
	proxy_pass http://192.168.0.105:9527/sign/;
}

#认证前端
location /maxkey/ {
	proxy_pass http://192.168.0.105:8527/maxkey/;
}

#管理后端
location /maxkey-mgt-api/ {
	proxy_pass http://192.168.0.105:9526/maxkey-mgt-api/;
}

#管理前端
location /maxkey-mgt/ {
	proxy_pass http://192.168.0.105:8526/maxkey-mgt/;
}

详细请参考文档https://maxkey.top/zh/conf/deploy_docker.html

@shimingxy shimingxy pinned this issue Jul 30, 2022
@wokula99
Copy link
Author

wokula99 commented Oct 11, 2022 via email

@shimingxy
Copy link
Collaborator

当前的docker是被合并的新版本,针对该问题会重新验证一下,并更新文档

@shimingxy
Copy link
Collaborator

新版问题已经修复

@ArronYR
Copy link

ArronYR commented Sep 10, 2024

#226 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants