MongoDB连接报错

落日映苍穹つ 2024-04-18 07:36 86阅读 0赞

MongoDB 启动报错，连接异常：mechanism=SCRAM-SHA-1

org.springframework.data.mongodb.UncategorizedMongoDbException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='tan', source='db', 
    password=<hidden>, mechanismProperties={}}; nested exception is com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, 
    userName='tan', source='db', password=<hidden>, mechanismProperties={}}
    	at org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:138)
    	at org.springframework.data.mongodb.core.MongoTemplate.potentiallyConvertRuntimeException(MongoTemplate.java:2781)
    	at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:547)
    	at org.springframework.data.mongodb.core.MongoTemplate.doRemove(MongoTemplate.java:1689)
    	at org.springframework.data.mongodb.core.MongoTemplate.remove(MongoTemplate.java:1677)
    	at org.springframework.data.mongodb.core.MongoTemplate.remove(MongoTemplate.java:1670)
    	at com.zhan.db.schedule.CheckAPISchedule.execute(CheckAPISchedule.java:85)
    	at com.zhan.db.schedule.CheckAPISchedule.autoCheck(CheckAPISchedule.java:72)
    	at com.zhan.db.schedule.CheckAPISchedule$$FastClassBySpringCGLIB$$b9ae1eee.invoke(<generated>)
    	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    	at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
    	at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
    	at java.util.concurrent.FutureTask.run(FutureTask.java)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='tan', source='db', password=<hidden>, 
    mechanismProperties={}}
    	at com.mongodb.internal.connection.SaslAuthenticator.wrapException(SaslAuthenticator.java:173)
    	at com.mongodb.internal.connection.SaslAuthenticator.access$300(SaslAuthenticator.java:40)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:70)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:47)
    	at com.mongodb.internal.connection.SaslAuthenticator.doAsSubject(SaslAuthenticator.java:179)
    	at com.mongodb.internal.connection.SaslAuthenticator.authenticate(SaslAuthenticator.java:47)
    	at com.mongodb.internal.connection.InternalStreamConnectionInitializer.authenticateAll(InternalStreamConnectionInitializer.java:151)
    	at com.mongodb.internal.connection.InternalStreamConnectionInitializer.initialize(InternalStreamConnectionInitializer.java:64)
    	at com.mongodb.internal.connection.InternalStreamConnection.open(InternalStreamConnection.java:127)
    	at com.mongodb.internal.connection.UsageTrackingInternalConnection.open(UsageTrackingInternalConnection.java:50)
    	at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.open(DefaultConnectionPool.java:390)
    	at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:106)
    	at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:92)
    	at com.mongodb.internal.connection.DefaultServer.getConnection(DefaultServer.java:85)
    	at com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource.getConnection(ClusterBinding.java:114)
    	at com.mongodb.operation.OperationHelper.withReleasableConnection(OperationHelper.java:424)
    	at com.mongodb.operation.MixedBulkWriteOperation.execute(MixedBulkWriteOperation.java:191)
    	at com.mongodb.operation.MixedBulkWriteOperation.execute(MixedBulkWriteOperation.java:67)
    	at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:193)
    	at com.mongodb.client.internal.MongoCollectionImpl.executeSingleWriteRequest(MongoCollectionImpl.java:960)
    	at com.mongodb.client.internal.MongoCollectionImpl.executeDelete(MongoCollectionImpl.java:940)
    	at com.mongodb.client.internal.MongoCollectionImpl.deleteMany(MongoCollectionImpl.java:551)
    	at org.springframework.data.mongodb.core.MongoTemplate$9.doInCollection(MongoTemplate.java:1729)
    	at org.springframework.data.mongodb.core.MongoTemplate$9.doInCollection(MongoTemplate.java:1689)
    	at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:545)
    	... 15 more
    Caused by: com.mongodb.MongoCommandException: Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server 192.168.31.36:27017. The full 
    response is { "ok" : 0.0, "errmsg" : "Authentication failed.", "code" : 18, "codeName" : "AuthenticationFailed" }
    	at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:179)
    	at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:293)
    	at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)
    	at com.mongodb.internal.connection.CommandHelper.sendAndReceive(CommandHelper.java:83)
    	at com.mongodb.internal.connection.CommandHelper.executeCommand(CommandHelper.java:33)
    	at com.mongodb.internal.connection.SaslAuthenticator.sendSaslStart(SaslAuthenticator.java:130)
    	at com.mongodb.internal.connection.SaslAuthenticator.access$100(SaslAuthenticator.java:40)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:54)
    	... 37 more
    org.springframework.data.mongodb.UncategorizedMongoDbException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='tan', source='db', 
    password=<hidden>, mechanismProperties={}}; nested exception is com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, 
    userName='tan', source='db', password=<hidden>, mechanismProperties={}}
    	at org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:138)
    	at org.springframework.data.mongodb.core.MongoTemplate.potentiallyConvertRuntimeException(MongoTemplate.java:2781)
    	at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:547)
    	at org.springframework.data.mongodb.core.MongoTemplate.doRemove(MongoTemplate.java:1689)
    	at org.springframework.data.mongodb.core.MongoTemplate.remove(MongoTemplate.java:1677)
    	at org.springframework.data.mongodb.core.MongoTemplate.remove(MongoTemplate.java:1670)
    	at com.zhan.db.schedule.HiveSynchStatsSchedule.statistics(HiveSynchStatsSchedule.java:59)
    	at com.zhan.db.schedule.HiveSynchStatsSchedule$$FastClassBySpringCGLIB$$c58d6a3e.invoke(<generated>)
    	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    	at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
    	at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
    	at java.util.concurrent.FutureTask.run(FutureTask.java)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='tan', source='db', password=<hidden>, 
    mechanismProperties={}}
    	at com.mongodb.internal.connection.SaslAuthenticator.wrapException(SaslAuthenticator.java:173)
    	at com.mongodb.internal.connection.SaslAuthenticator.access$300(SaslAuthenticator.java:40)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:70)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:47)
    	at com.mongodb.internal.connection.SaslAuthenticator.doAsSubject(SaslAuthenticator.java:179)
    	at com.mongodb.internal.connection.SaslAuthenticator.authenticate(SaslAuthenticator.java:47)
    	at com.mongodb.internal.connection.InternalStreamConnectionInitializer.authenticateAll(InternalStreamConnectionInitializer.java:151)
    	at com.mongodb.internal.connection.InternalStreamConnectionInitializer.initialize(InternalStreamConnectionInitializer.java:64)
    	at com.mongodb.internal.connection.InternalStreamConnection.open(InternalStreamConnection.java:127)
    	at com.mongodb.internal.connection.UsageTrackingInternalConnection.open(UsageTrackingInternalConnection.java:50)
    	at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.open(DefaultConnectionPool.java:390)
    	at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:106)
    	at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:92)
    	at com.mongodb.internal.connection.DefaultServer.getConnection(DefaultServer.java:85)
    	at com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource.getConnection(ClusterBinding.java:114)
    	at com.mongodb.operation.OperationHelper.withReleasableConnection(OperationHelper.java:424)
    	at com.mongodb.operation.MixedBulkWriteOperation.execute(MixedBulkWriteOperation.java:191)
    	at com.mongodb.operation.MixedBulkWriteOperation.execute(MixedBulkWriteOperation.java:67)
    	at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:193)
    	at com.mongodb.client.internal.MongoCollectionImpl.executeSingleWriteRequest(MongoCollectionImpl.java:960)
    	at com.mongodb.client.internal.MongoCollectionImpl.executeDelete(MongoCollectionImpl.java:940)
    	at com.mongodb.client.internal.MongoCollectionImpl.deleteMany(MongoCollectionImpl.java:551)
    	at org.springframework.data.mongodb.core.MongoTemplate$9.doInCollection(MongoTemplate.java:1729)
    	at org.springframework.data.mongodb.core.MongoTemplate$9.doInCollection(MongoTemplate.java:1689)
    	at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:545)
    	... 14 more
    Caused by: com.mongodb.MongoCommandException: Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server 192.168.31.36:27017. The full 
    response is { "ok" : 0.0, "errmsg" : "Authentication failed.", "code" : 18, "codeName" : "AuthenticationFailed" }
    	at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:179)
    	at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:293)
    	at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)
    	at com.mongodb.internal.connection.CommandHelper.sendAndReceive(CommandHelper.java:83)
    	at com.mongodb.internal.connection.CommandHelper.executeCommand(CommandHelper.java:33)
    	at com.mongodb.internal.connection.SaslAuthenticator.sendSaslStart(SaslAuthenticator.java:130)
    	at com.mongodb.internal.connection.SaslAuthenticator.access$100(SaslAuthenticator.java:40)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:54)
    	... 36 more
    org.springframework.data.mongodb.UncategorizedMongoDbException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='tan', source='db', 
    password=<hidden>, mechanismProperties={}}; nested exception is com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, 
    userName='tan', source='db', password=<hidden>, mechanismProperties={}}
    	at org.springframework.data.mongodb.core.MongoExceptionTranslator.translateExceptionIfPossible(MongoExceptionTranslator.java:138)
    	at org.springframework.data.mongodb.core.MongoTemplate.potentiallyConvertRuntimeException(MongoTemplate.java:2781)
    	at org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:2636)
    	at org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:2360)
    	at org.springframework.data.mongodb.core.MongoTemplate.findById(MongoTemplate.java:850)
    	at org.springframework.data.mongodb.core.MongoTemplate.findById(MongoTemplate.java:837)
    	at com.zhan.db.schedule.CalculateDelaySchedule.calculate(CalculateDelaySchedule.java:108)
    	at com.zhan.db.schedule.CalculateDelaySchedule.calculateDelay(CalculateDelaySchedule.java:90)
    	at com.zhan.db.schedule.CalculateDelaySchedule$$FastClassBySpringCGLIB$$49b6f5f9.invoke(<generated>)
    	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    	at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
    	at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
    	at java.util.concurrent.FutureTask.run(FutureTask.java)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='tan', source='db', password=<hidden>, 
    mechanismProperties={}}
    	at com.mongodb.internal.connection.SaslAuthenticator.wrapException(SaslAuthenticator.java:173)
    	at com.mongodb.internal.connection.SaslAuthenticator.access$300(SaslAuthenticator.java:40)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:70)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:47)
    	at com.mongodb.internal.connection.SaslAuthenticator.doAsSubject(SaslAuthenticator.java:179)
    	at com.mongodb.internal.connection.SaslAuthenticator.authenticate(SaslAuthenticator.java:47)
    	at com.mongodb.internal.connection.InternalStreamConnectionInitializer.authenticateAll(InternalStreamConnectionInitializer.java:151)
    	at com.mongodb.internal.connection.InternalStreamConnectionInitializer.initialize(InternalStreamConnectionInitializer.java:64)
    	at com.mongodb.internal.connection.InternalStreamConnection.open(InternalStreamConnection.java:127)
    	at com.mongodb.internal.connection.UsageTrackingInternalConnection.open(UsageTrackingInternalConnection.java:50)
    	at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.open(DefaultConnectionPool.java:390)
    	at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:106)
    	at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:92)
    	at com.mongodb.internal.connection.DefaultServer.getConnection(DefaultServer.java:85)
    	at com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource.getConnection(ClusterBinding.java:114)
    	at com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:460)
    	at com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:406)
    	at com.mongodb.operation.FindOperation.execute(FindOperation.java:695)
    	at com.mongodb.operation.FindOperation.execute(FindOperation.java:83)
    	at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:179)
    	at com.mongodb.client.internal.FindIterableImpl.first(FindIterableImpl.java:198)
    	at org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:2820)
    	at org.springframework.data.mongodb.core.MongoTemplate$FindOneCallback.doInCollection(MongoTemplate.java:2795)
    	at org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:2633)
    	... 15 more
    Caused by: com.mongodb.MongoCommandException: Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server 192.168.31.36:27017. The full 
    response is { "ok" : 0.0, "errmsg" : "Authentication failed.", "code" : 18, "codeName" : "AuthenticationFailed" }
    	at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:179)
    	at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:293)
    	at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)
    	at com.mongodb.internal.connection.CommandHelper.sendAndReceive(CommandHelper.java:83)
    	at com.mongodb.internal.connection.CommandHelper.executeCommand(CommandHelper.java:33)
    	at com.mongodb.internal.connection.SaslAuthenticator.sendSaslStart(SaslAuthenticator.java:130)
    	at com.mongodb.internal.connection.SaslAuthenticator.access$100(SaslAuthenticator.java:40)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:54)
    	... 36 more

解决：连接 url加上  **?authSource=admin&authMechanism=SCRAM-SHA-1**

@Bean
    public MongoDbFactory secondaryFactory(MongoProperties mongo) throws Exception {
    
        if (StringUtils.isEmpty(mongo.getUsername()) || mongo.getPassword() == null ) {
            return new SimpleMongoDbFactory(new MongoClient(mongo.getHost(), mongo.getPort()),
                    mongo.getDatabase());
        } else {
            String password = String.valueOf(mongo.getPassword());
            String url = "mongodb://" + mongo.getUsername()
                    + ":" + password
                    + "@" + mongo.getHost() + ":" + mongo.getPort() + "/" + mongo.getDatabase()
                    + "?authSource=admin&authMechanism=SCRAM-SHA-1";
            return new SimpleMongoDbFactory(new MongoClientURI(url));
        }
    }

### 详细例子请看 ： [Spring Boot 多个MongoDB 数据源配置与实现][Spring Boot _MongoDB] ###

\- 完毕

[Spring Boot _MongoDB]: https://blog.csdn.net/zhan107876/article/details/94588388