异常日志:
2019-05-30 10:10:24,252 [http-nio-8080-exec-1] DEBUG [java.sql.Connection] - ooo Connection Opened 2019-05-30 10:10:24,258 [http-nio-8080-exec-1] DEBUG [java.sql.PreparedStatement] - ==> Executing: insert into client_config ( appid, uid, config, created_time, creater, client_type, status ) values ( ?, ?, ?, now(), ?, ?, ? ) 2019-05-30 10:10:24,259 [http-nio-8080-exec-1] DEBUG [java.sql.PreparedStatement] - ==> Parameters: 1234(String), wulinfeng(String), By continuing to use our website, you agree with our use of cookies in accordance with our Cookie Policy.You can reject cookies by changing your browser settings.(String), 系统管理员(String), 1(String), 1(String) key=business:businessclientconfig:1:1234:wulinfeng 2019-05-30 10:10:24,960 [http-nio-8080-exec-1] DEBUG [java.sql.Connection] - ooo Connection Opened 2019-05-30 10:10:24,961 [http-nio-8080-exec-1] DEBUG [java.sql.PreparedStatement] - ==> Executing: select id,data_key,description,valid_time,status,created_time from cache_memcache_data where data_key like 'business:businessclientconfig:1:1234:wulinfeng%' 2019-05-30 10:10:24,961 [http-nio-8080-exec-1] DEBUG [java.sql.PreparedStatement] - ==> Parameters: 2019-05-30 10:12:02,921 [http-nio-8080-exec-1] INFO [org.mongodb.driver.connection] - Closed connection [connectionId{localValue:10}] to localhost:27017 because there was a socket exception raised by this connection. 2019-05-30 10:12:45,796 [http-nio-8080-exec-1] DEBUG [java.sql.Connection] - ooo Connection Opened 2019-05-30 10:12:45,799 [http-nio-8080-exec-1] DEBUG [java.sql.PreparedStatement] - ==> Executing: INSERT INTO log_web_exception ( op_user, op_user_name, error_level, page_name, class_name, method, input_params, log_desc, log_stack, create_time,source_type) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, now(),'1'); 2019-05-30 10:12:45,800 [http-nio-8080-exec-1] DEBUG [java.sql.PreparedStatement] - ==> Parameters: 系统管理员(String), admin(String), 1(String), 客户端配置(String), com.wlf.musicbox.business.controller.ClientConfigController(String), saveClientConfig(String), {"id":0,"appid":"1234","config":"By continuing to use our website, you agree with our use of cookies in accordance with our Cookie Policy.You can reject cookies by changing your browser settings.","creater":"系统管理员","status":"1","uid":"wulinfeng","clientType":"1"}(String), 保存客户端配置信息异常(String), class com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='', source='admin', password=<hidden>, mechanismProperties={}} 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: wrapException,行数: 173 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: access$300,行数: 40 类名: com.mongodb.internal.connection.SaslAuthenticator$1, 方法名: run,行数: 70 类名: com.mongodb.internal.connection.SaslAuthenticator$1, 方法名: run,行数: 47 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: doAsSubject,行数: 179 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: authenticate,行数: 47 类名: com.mongodb.internal.connection.InternalStreamConnectionInitializer, 方法名: authenticateAll,行数: 151 类名: com.mongodb.internal.connection.InternalStreamConnectionInitializer, 方法名: initialize,行数: 64 类名: com.mongodb.internal.connection.InternalStreamConnection, 方法名: open,行数: 127 类名: com.mongodb.internal.connection.UsageTrackingInternalConnection, 方法名: open,行数: 50 类名: com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection, 方法名: open,行数: 390 类名: com.mongodb.internal.connection.DefaultConnectionPool, 方法名: get,行数: 106 类名: com.mongodb.internal.connection.DefaultConnectionPool, 方法名: get,行数: 92 类名: com.mongodb.internal.connection.DefaultServer, 方法名: getConnection,行数: 85 类名: com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource, 方法名: getConnection,行数: 115 类名: com.mongodb.operation.OperationHelper, 方法名: withConnectionSource,行数: 460 com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='', source='admin', password=<hidden>, mechanismProperties={}} 类名: com.mongodb.operation.OperationHelper, 方法名: withConnection,行数: 406 类名: com.mongodb.operation.FindOperation, 方法名: execute,行数: 696 类名: com.mongodb.operation.FindOperation, 方法名: execute,行数: 83 类名: com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor, 方法名: execute,行数: 179 类名: com.mongodb.client.internal.MongoIterableImpl, 方法名: execute,行数: 132 类名: com.mongodb.client.internal.MongoIterableImpl, 方法名: iterator,行数: 86 类名: com.ll.musicbox.commonlibmongo.MongoDBUtil, 方法名: findAllCommonRecordsWithFiled,行数: 539 类名: com.ll.musicbox.commonlibmongo.MongoDBUtil, 方法名: findAllCommonRecords,行数: 519 类名: com.wlf.musicbox.system.service.MemCacheService, 方法名: getMemFromMongoForBlur,行数: 287 类名: com.wlf.musicbox.business.service.CommonService, 方法名: delMemFromMongoForBlur,行数: 1025 类名: com.wlf.musicbox.business.service.CommonService, 方法名: delMemByKeyValue,行数: 1284 类名: com.wlf.musicbox.business.controller.ClientConfigController, 方法名: saveClientConfig,行数: 238 类名: sun.reflect.NativeMethodAccessorImpl, 方法名: invoke0,行数: -2 类名: sun.reflect.NativeMethodAccessorImpl, 方法名: invoke,行数: 62 类名: sun.reflect.DelegatingMethodAccessorImpl, 方法名: invoke,行数: 43 类名: java.lang.reflect.Method, 方法名: invoke,行数: 498 at com.mongodb.internal.connection.SaslAuthenticator.wrapException(SaslAuthenticator.java:173) 类名: org.springframework.web.method.support.InvocableHandlerMethod, 方法名: invoke,行数: 212 at com.mongodb.internal.connection.SaslAuthenticator.access$300(SaslAuthenticator.java:40) 类名: org.springframework.web.method.support.InvocableHandlerMethod, 方法名: invokeForRequest,行数: 126 at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:70) at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:47) 类名: org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod, 方法名: invokeAndHandle,行数: 96 at com.mongodb.internal.connection.SaslAuthenticator.doAsSubject(SaslAuthenticator.java:179) 类名: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter, 方法名: invokeHandlerMethod,行数: 617 类名: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter, 方法名: handleInternal,行数: 578 at com.mongodb.internal.connection.SaslAuthenticator.authenticate(SaslAuthenticator.java:47) 类名: org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter, 方法名: handle,行数: 80 at com.mongodb.internal.connection.InternalStreamConnectionInitializer.authenticateAll(InternalStreamConnectionInitializer.java:151) 类名: org.springframework.web.servlet.DispatcherServlet, 方法名: doDispatch,行数: 900 at com.mongodb.internal.connection.InternalStreamConnectionInitializer.initialize(InternalStreamConnectionInitializer.java:64) 类名: org.springframework.web.servlet.DispatcherServlet, 方法名: doService,行数: 827 at com.mongodb.internal.connection.InternalStreamConnection.open(InternalStreamConnection.java:127) 类名: org.springframework.web.servlet.FrameworkServlet, 方法名: processRequest,行数: 882 at com.mongodb.internal.connection.UsageTrackingInternalConnection.open(UsageTrackingInternalConnection.java:50) 类名: org.springframework.web.servlet.FrameworkServlet, 方法名: doPost,行数: 789 at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.open(DefaultConnectionPool.java:390) 类名: javax.servlet.http.HttpServlet, 方法名: service,行数: 660 at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:106) 类名: javax.servlet.http.HttpServlet, 方法名: service,行数: 741 at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:92) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 231 at com.mongodb.internal.connection.DefaultServer.getConnection(DefaultServer.java:85) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 at com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource.getConnection(ClusterBinding.java:115) 类名: org.apache.tomcat.websocket.server.WsFilter, 方法名: doFilter,行数: 53 at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:460) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:406) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 at com.mongodb.operation.FindOperation.execute(FindOperation.java:696) at com.mongodb.operation.FindOperation.execute(FindOperation.java:83) 类名: org.springframework.web.filter.CharacterEncodingFilter, 方法名: doFilterInternal,行数: 88 at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:179) 类名: org.springframework.web.filter.OncePerRequestFilter, 方法名: doFilter,行数: 76 at com.mongodb.client.internal.MongoIterableImpl.execute(MongoIterableImpl.java:132) at com.mongodb.client.internal.MongoIterableImpl.iterator(MongoIterableImpl.java:86) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 at com.ll.musicbox.commonlibmongo.MongoDBUtil.findAllCommonRecordsWithFiled(MongoDBUtil.java:539) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 at com.ll.musicbox.commonlibmongo.MongoDBUtil.findAllCommonRecords(MongoDBUtil.java:519) 类名: com.wlf.musicbox.filter.HttpRequestFitler, 方法名: doFilter,行数: 44 at com.wlf.musicbox.system.service.MemCacheService.getMemFromMongoForBlur(MemCacheService.java:287) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 at com.wlf.musicbox.business.service.CommonService.delMemFromMongoForBlur(CommonService.java:1025) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 at com.wlf.musicbox.business.service.CommonService.delMemByKeyValue(CommonService.java:1284) 类名: org.apache.shiro.web.servlet.ProxiedFilterChain, 方法名: doFilter,行数: 61 at com.wlf.musicbox.business.controller.ClientConfigController.saveClientConfig(ClientConfigController.java:238) 类名: org.apache.shiro.web.servlet.AdviceFilter, 方法名: executeChain,行数: 108 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 类名: org.apache.shiro.web.servlet.AdviceFilter, 方法名: doFilterInternal,行数: 137 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 类名: org.apache.shiro.web.servlet.OncePerRequestFilter, 方法名: doFilter,行数: 125 at java.lang.reflect.Method.invoke(Method.java:498) 类名: org.apache.shiro.web.servlet.ProxiedFilterChain, 方法名: doFilter,行数: 66 at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:212) 类名: org.apache.shiro.web.servlet.AbstractShiroFilter, 方法名: executeChain,行数: 449 类名: org.apache.shiro.web.servlet.AbstractShiroFilter$1, 方法名: call,行数: 365 at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96) 类名: org.apache.shiro.subject.support.SubjectCallable, 方法名: doCall,行数: 90 at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) 类名: org.apache.shiro.subject.support.SubjectCallable, 方法名: call,行数: 83 at javax.servlet.http.HttpServlet.service(HttpServlet.java:660) 类名: org.apache.shiro.subject.support.DelegatingSubject, 方法名: execute,行数: 383 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) 类名: org.apache.shiro.web.servlet.AbstractShiroFilter, 方法名: doFilterInternal,行数: 362 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) 类名: org.apache.shiro.web.servlet.OncePerRequestFilter, 方法名: doFilter,行数: 125 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 类名: org.springframework.web.filter.DelegatingFilterProxy, 方法名: invokeDelegate,行数: 346 类名: org.springframework.web.filter.DelegatingFilterProxy, 方法名: doFilter,行数: 259 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) 类名: org.apache.catalina.core.StandardWrapperValve, 方法名: invoke,行数: 199 类名: org.apache.catalina.core.StandardContextValve, 方法名: invoke,行数: 96 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) 类名: org.apache.catalina.authenticator.AuthenticatorBase, 方法名: invoke,行数: 475 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 类名: org.apache.catalina.core.StandardHostValve, 方法名: invoke,行数: 140 类名: org.apache.catalina.valves.ErrorReportValve, 方法名: invoke,行数: 80 at com.wlf.musicbox.filter.HttpRequestFitler.doFilter(HttpRequestFitler.java:44) 类名: org.apache.catalina.valves.AbstractAccessLogValve, 方法名: invoke,行数: 651 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 类名: org.apache.catalina.core.StandardEngineValve, 方法名: invoke,行数: 87 at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61) 类名: org.apache.catalina.connector.CoyoteAdapter, 方法名: service,行数: 342 at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108) 类名: org.apache.coyote.http11.Http11Processor, 方法名: service,行数: 498 at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137) 类名: org.apache.coyote.AbstractProcessorLight, 方法名: process,行数: 66 at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) 类名: org.apache.coyote.AbstractProtocol$ConnectionHandler, 方法名: process,行数: 796 类名: org.apache.tomcat.util.net.NioEndpoint$SocketProcessor, 方法名: doRun,行数: 1374 at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66) 类名: org.apache.tomcat.util.net.SocketProcessorBase, 方法名: run,行数: 49 at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) 类名: java.util.concurrent.ThreadPoolExecutor, 方法名: runWorker,行数: 1142 at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) 类名: java.util.concurrent.ThreadPoolExecutor$Worker, 方法名: run,行数: 617 at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) 类名: org.apache.tomcat.util.threads.TaskThread$WrappingRunnable, 方法名: run,行数: 61 at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) 类名: java.lang.Thread, 方法名: run,行数: 745 at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) (String) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) 2019-05-30 10:12:45,814 [http-nio-8080-exec-1] ERROR [com.wlf.musicbox.business.controller.ClientConfigController] - 添加客户端配置异常:class com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='', source='admin', password=<hidden>, mechanismProperties={}} at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: wrapException,行数: 173 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: access$300,行数: 40 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) 类名: com.mongodb.internal.connection.SaslAuthenticator$1, 方法名: run,行数: 70 类名: com.mongodb.internal.connection.SaslAuthenticator$1, 方法名: run,行数: 47 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: doAsSubject,行数: 179 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475) 类名: com.mongodb.internal.connection.SaslAuthenticator, 方法名: authenticate,行数: 47 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) 类名: com.mongodb.internal.connection.InternalStreamConnectionInitializer, 方法名: authenticateAll,行数: 151 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) 类名: com.mongodb.internal.connection.InternalStreamConnectionInitializer, 方法名: initialize,行数: 64 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:651) 类名: com.mongodb.internal.connection.InternalStreamConnection, 方法名: open,行数: 127 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) 类名: com.mongodb.internal.connection.UsageTrackingInternalConnection, 方法名: open,行数: 50 类名: com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection, 方法名: open,行数: 390 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) 类名: com.mongodb.internal.connection.DefaultConnectionPool, 方法名: get,行数: 106 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498) 类名: com.mongodb.internal.connection.DefaultConnectionPool, 方法名: get,行数: 92 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) 类名: com.mongodb.internal.connection.DefaultServer, 方法名: getConnection,行数: 85 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796) 类名: com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource, 方法名: getConnection,行数: 115 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1374) 类名: com.mongodb.operation.OperationHelper, 方法名: withConnectionSource,行数: 460 at org.apache.tomcat.类名: com.mongodb.operation.OperationHelper, 方法名: withConnection,行数: 406 util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 类名: com.mongodb.operation.FindOperation, 方法名: execute,行数: 696 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 类名: com.mongodb.operation.FindOperation, 方法名: execute,行数: 83 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 类名: com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor, 方法名: execute,行数: 179 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) 类名: com.mongodb.client.internal.MongoIterableImpl, 方法名: execute,行数: 132 at java.lang.Thread.run(Thread.java:745) 类名: com.mongodb.client.internal.MongoIterableImpl, 方法名: iterator,行数: 86 Caused by: com.mongodb.MongoCommandException: Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server localhost:27017. The full response is { "ok" : 0.0, "errmsg" : "Authentication failed.", "code" : 18, "codeName" : "AuthenticationFailed" } 类名: com.ll.musicbox.commonlibmongo.MongoDBUtil, 方法名: findAllCommonRecordsWithFiled,行数: 539 at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:179) 类名: com.ll.musicbox.commonlibmongo.MongoDBUtil, 方法名: findAllCommonRecords,行数: 519 at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:299) 类名: com.wlf.musicbox.system.service.MemCacheService, 方法名: getMemFromMongoForBlur,行数: 287 at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255) 类名: com.wlf.musicbox.business.service.CommonService, 方法名: delMemFromMongoForBlur,行数: 1025 at com.mongodb.internal.connection.CommandHelper.sendAndReceive(CommandHelper.java:83) 类名: com.wlf.musicbox.business.service.CommonService, 方法名: delMemByKeyValue,行数: 1284 at com.mongodb.internal.connection.CommandHelper.executeCommand(CommandHelper.java:33) 类名: com.wlf.musicbox.business.controller.ClientConfigController, 方法名: saveClientConfig,行数: 238 at com.mongodb.internal.connection.SaslAuthenticator.sendSaslStart(SaslAuthenticator.java:130) 类名: sun.reflect.NativeMethodAccessorImpl, 方法名: invoke0,行数: -2 at com.mongodb.internal.connection.SaslAuthenticator.access$100(SaslAuthenticator.java:40) 类名: sun.reflect.NativeMethodAccessorImpl, 方法名: invoke,行数: 62 at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:54) 类名: sun.reflect.DelegatingMethodAccessorImpl, 方法名: invoke,行数: 43 ... 86 more 类名: java.lang.reflect.Method, 方法名: invoke,行数: 498 类名: org.springframework.web.method.support.InvocableHandlerMethod, 方法名: invoke,行数: 212 类名: org.springframework.web.method.support.InvocableHandlerMethod, 方法名: invokeForRequest,行数: 126 类名: org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod, 方法名: invokeAndHandle,行数: 96 类名: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter, 方法名: invokeHandlerMethod,行数: 617 类名: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter, 方法名: handleInternal,行数: 578 类名: org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter, 方法名: handle,行数: 80 类名: org.springframework.web.servlet.DispatcherServlet, 方法名: doDispatch,行数: 900 类名: org.springframework.web.servlet.DispatcherServlet, 方法名: doService,行数: 827 类名: org.springframework.web.servlet.FrameworkServlet, 方法名: processRequest,行数: 882 类名: org.springframework.web.servlet.FrameworkServlet, 方法名: doPost,行数: 789 类名: javax.servlet.http.HttpServlet, 方法名: service,行数: 660 类名: javax.servlet.http.HttpServlet, 方法名: service,行数: 741 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 231 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 类名: org.apache.tomcat.websocket.server.WsFilter, 方法名: doFilter,行数: 53 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 类名: org.springframework.web.filter.CharacterEncodingFilter, 方法名: doFilterInternal,行数: 88 类名: org.springframework.web.filter.OncePerRequestFilter, 方法名: doFilter,行数: 76 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 类名: com.wlf.musicbox.filter.HttpRequestFitler, 方法名: doFilter,行数: 44 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 类名: org.apache.shiro.web.servlet.ProxiedFilterChain, 方法名: doFilter,行数: 61 类名: org.apache.shiro.web.servlet.AdviceFilter, 方法名: executeChain,行数: 108 类名: org.apache.shiro.web.servlet.AdviceFilter, 方法名: doFilterInternal,行数: 137 类名: org.apache.shiro.web.servlet.OncePerRequestFilter, 方法名: doFilter,行数: 125 类名: org.apache.shiro.web.servlet.ProxiedFilterChain, 方法名: doFilter,行数: 66 类名: org.apache.shiro.web.servlet.AbstractShiroFilter, 方法名: executeChain,行数: 449 类名: org.apache.shiro.web.servlet.AbstractShiroFilter$1, 方法名: call,行数: 365 类名: org.apache.shiro.subject.support.SubjectCallable, 方法名: doCall,行数: 90 类名: org.apache.shiro.subject.support.SubjectCallable, 方法名: call,行数: 83 类名: org.apache.shiro.subject.support.DelegatingSubject, 方法名: execute,行数: 383 类名: org.apache.shiro.web.servlet.AbstractShiroFilter, 方法名: doFilterInternal,行数: 362 类名: org.apache.shiro.web.servlet.OncePerRequestFilter, 方法名: doFilter,行数: 125 类名: org.springframework.web.filter.DelegatingFilterProxy, 方法名: invokeDelegate,行数: 346 类名: org.springframework.web.filter.DelegatingFilterProxy, 方法名: doFilter,行数: 259 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: internalDoFilter,行数: 193 类名: org.apache.catalina.core.ApplicationFilterChain, 方法名: doFilter,行数: 166 类名: org.apache.catalina.core.StandardWrapperValve, 方法名: invoke,行数: 199 类名: org.apache.catalina.core.StandardContextValve, 方法名: invoke,行数: 96 类名: org.apache.catalina.authenticator.AuthenticatorBase, 方法名: invoke,行数: 475 类名: org.apache.catalina.core.StandardHostValve, 方法名: invoke,行数: 140 类名: org.apache.catalina.valves.ErrorReportValve, 方法名: invoke,行数: 80 类名: org.apache.catalina.valves.AbstractAccessLogValve, 方法名: invoke,行数: 651 类名: org.apache.catalina.core.StandardEngineValve, 方法名: invoke,行数: 87 类名: org.apache.catalina.connector.CoyoteAdapter, 方法名: service,行数: 342 类名: org.apache.coyote.http11.Http11Processor, 方法名: service,行数: 498 类名: org.apache.coyote.AbstractProcessorLight, 方法名: process,行数: 66 类名: org.apache.coyote.AbstractProtocol$ConnectionHandler, 方法名: process,行数: 796 类名: org.apache.tomcat.util.net.NioEndpoint$SocketProcessor, 方法名: doRun,行数: 1374 类名: org.apache.tomcat.util.net.SocketProcessorBase, 方法名: run,行数: 49 类名: java.util.concurrent.ThreadPoolExecutor, 方法名: runWorker,行数: 1142 类名: java.util.concurrent.ThreadPoolExecutor$Worker, 方法名: run,行数: 617 类名: org.apache.tomcat.util.threads.TaskThread$WrappingRunnable, 方法名: run,行数: 61 类名: java.lang.Thread, 方法名: run,行数: 745
调用链有点长,关键看标黄那一行,无非admin数据库做用户验证失败了。先看看系统启动时建立MongoDB数据库连接时的用户名和密码设置:
MongoDBUtil.getInstance().init(Cfg.get("configinfo.mongo.addr"), Integer.valueOf(Cfg.get("configinfo.mongo.pool")), 3000, Cfg.get("configinfo.mongo.user"), Cfg.get ("configinfo.mongo.pwd"), null);
这里的配置均从application.properties文件中读取:
configinfo.mongo.addr=localhost:27017
configinfo.mongo.pool=20
configinfo.mongo.user=
configinfo.mongo.pwd=
从上面看到我一开始并未设置用户名和密码,导致校验失败。那么我们来给admin设置一下用户名和密码:
> use admin switched to db admin > db.createUser({user:"wlf",pwd:"123",roles:["readWrite"]}) Successfully added user: { "user" : "wlf", "roles" : [ "readWrite" ] } > db.auth("wlf","123") 1
对应的配置项也改下:
configinfo.mongo.user=wlf
configinfo.mongo.pwd=123
然后重启下tomcat让配置生效,再跑下看看,这次没有再报错了。但有一点我觉得比较奇怪的是,我并未设置数据库为admin,为啥MongoDB默认就跑到admin了?看了MongoDBUtil类我才恍然大悟:
public synchronized void initWithTimeOutAndIsAuth(String address, int poolSize, int timeOut, String user, String pwd, ReadPreference readPreference, boolean isAuth) throws UnknownHostException, MongoException { if (poolSize == -1) { poolSize = 200; } System.setProperty("MONGO.POOLSIZE", String.valueOf(poolSize)); if (this.mongo == null) { List<ServerAddress> saddrs = new ArrayList(); String[] addrs = address.split(";"); String[] var13 = addrs; int var12 = addrs.length; for(int var11 = 0; var11 < var12; ++var11) { String addr = var13[var11]; String[] tmp = addr.split(":"); if (tmp.length == 2) { ServerAddress a = new ServerAddress(tmp[0], Integer.valueOf(tmp[1])); saddrs.add(a); } } Builder builder = new Builder(); builder.connectionsPerHost(poolSize).connectTimeout(timeOut).socketTimeout(timeOut).heartbeatConnectTimeout(3000).heartbeatSocketTimeout(3000).serverSelectionTimeout(timeOut).maxWaitTime(timeOut).maxConnectionIdleTime(timeOut); if (readPreference != null) { builder.readPreference(readPreference); } MongoClientOptions options = builder.build(); MongoCredential mongoCredential = null; if (isAuth) { mongoCredential = MongoCredential.createCredential(user, "admin", pwd.toCharArray()); } if (saddrs.size() == 1) { if (isAuth) { this.mongo = new MongoClient((ServerAddress)saddrs.get(0), mongoCredential, options); } else { this.mongo = new MongoClient((ServerAddress)saddrs.get(0), options); } } else if (isAuth) { this.mongo = new MongoClient(saddrs, mongoCredential, options); } else { this.mongo = new MongoClient(saddrs, options); } } }