Mongodb4.0使用问题记录

左手的ㄟ右手 2022-01-07 10:15 468阅读 0赞

**1. mongod和mongo**

**mongod官方文档描述地址：[https://docs.mongodb.com/manual/reference/program/mongod.exe/index.html][https_docs.mongodb.com_manual_reference_program_mongod.exe_index.html]**

**[https://docs.mongodb.com/manual/reference/program/mongod/\#bin.mongod][https_docs.mongodb.com_manual_reference_program_mongod_bin.mongod]**

Synopsis
    mongod is the primary daemon process for the MongoDB system. It handles data requests, 
    manages data access, and performs background management operations.
    
    This document provides a complete overview of all command line options for mongod. 
    These command line options are primarily useful for testing: In common operation, 
    use the configuration file options to control the behavior of your database.

**mongo官方文档描述地址：[https://docs.mongodb.com/manual/reference/program/mongo/][https_docs.mongodb.com_manual_reference_program_mongo]**

Description
    mongo is an interactive JavaScript shell interface to MongoDB, which provides a powerful interface for system 
    administrators as well as a way for developers to test queries and operations directly with the database. 
    mongo also provides a fully functional JavaScript environment for use with a MongoDB. 
    The mongo shell is part of the MongoDB distributions.

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70][]

2. 异常：java.util.concurrent.ExecutionException: java.lang.IllegalArgumentException: invalid hexadecimal representation of an ObjectId: \[180d3afd-5b3d-4924-855a-31d1d8787b5c\]

异常背景：通过UUID生成id插入到mongodb数据库，数据保存成功，但是通过ObjectId取出的时候报错

![20190628180745309.png][]

异常原因：ObjectId 使用12 字节的存储空间，每个字节两位十六进制数字，是一个24 位的字符串

解决方案：id使用mongodb默认方式

3. 异常：org.springframework.data.mongodb.UncategorizedMongoDbException: Exception authenticating MongoCredential\{mechanism=SCRAM-SHA-256, userName='zsx', source='mongodb\_test', password=<hidden>, mechanismProperties=\{\}\}; nested exception is com.mongodb.MongoSecurityException: Exception authenticating MongoCredential\{mechanism=SCRAM-SHA-256, userName='zsx', source='mongodb\_test', password=<hidden>, mechanismProperties=\{\}\}

org.springframework.data.mongodb.UncategorizedMongoDbException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-256, userName='zsx', source='mongodb_test', password=<hidden>, mechanismProperties={}}; nested exception is com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-256, userName='zsx', source='mongodb_test', 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.insertDocument(MongoTemplate.java:1436)
    	at org.springframework.data.mongodb.core.MongoTemplate.doInsert(MongoTemplate.java:1244)
    	at org.springframework.data.mongodb.core.MongoTemplate.insert(MongoTemplate.java:1178)
    	at org.springframework.data.mongodb.repository.support.SimpleMongoRepository.save(SimpleMongoRepository.java:81)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    	at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:359)
    	at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:200)
    	at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:644)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:608)
    	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$invoke$3(RepositoryFactorySupport.java:595)
    	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:595)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    	at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    	at com.sun.proxy.$Proxy76.save(Unknown Source)
    	at com.zsx.test.repositoty.CustomerRepositoryTest.testSave(CustomerRepositoryTest.java:20)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    	at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:532)
    	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:115)
    	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:171)
    	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:72)
    	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:167)
    	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:114)
    	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:59)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$4(NodeTestTask.java:108)
    	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:72)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:98)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:74)
    	at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
    	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$4(NodeTestTask.java:112)
    	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:72)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:98)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:74)
    	at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
    	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$4(NodeTestTask.java:112)
    	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:72)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:98)
    	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:74)
    	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
    	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
    	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
    	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:220)
    	at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$6(DefaultLauncher.java:188)
    	at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:202)
    	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:181)
    	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:128)
    	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:69)
    	at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
    	at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
    	at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
    Caused by: com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-256, userName='zsx', source='mongodb_test', 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.executeInsertOne(MongoCollectionImpl.java:494)
    	at com.mongodb.client.internal.MongoCollectionImpl.insertOne(MongoCollectionImpl.java:478)
    	at com.mongodb.client.internal.MongoCollectionImpl.insertOne(MongoCollectionImpl.java:472)
    	at org.springframework.data.mongodb.core.MongoTemplate$6.doInCollection(MongoTemplate.java:1443)
    	at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:545)
    	... 64 more
    Caused by: com.mongodb.MongoCommandException: Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server 127.0.0.1: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.sendSaslContinue(SaslAuthenticator.java:134)
    	at com.mongodb.internal.connection.SaslAuthenticator.access$200(SaslAuthenticator.java:40)
    	at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:67)
    	... 86 more

异常背景：使用springboot连接mongodb，mongodb配置如下

spring: 
      data: 
        mongodb:
          database: mongodb_test
          host: 127.0.0.1
          port: 27017
          username: zsx
          password: 1234

原因：MongoClientFactory在解析配置配置文件中的password时，将纯数字当成一个char处理了

// org.springframework.boot.autoconfigure.mongo.MongoClientFactory
    private MongoCredential getCredentials(MongoProperties properties) {
    		if (!hasCustomCredentials()) {
    			return null;
    		}
    		String username = properties.getUsername();
    		String database = getValue(properties.getAuthenticationDatabase(),
    				properties.getMongoClientDatabase());
    		char[] password = properties.getPassword();
    		return MongoCredential.createCredential(username, database, password);
    	}

![20190704224417730.png][]

uri方式映射时，密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 1][]

解决方法：

**1. 通过uri方式连接**

spring: 
      data: 
        mongodb:
          uri: mongodb://zsx:1234@localhost:27017/mongodb_test

**2. 修改密码，不要设置为纯数字即可**

**参考地址：[https://docs.mongodb.com/manual/core/authentication-mechanisms/][https_docs.mongodb.com_manual_core_authentication-mechanisms]**

[https_docs.mongodb.com_manual_reference_program_mongod.exe_index.html]: https://docs.mongodb.com/manual/reference/program/mongod.exe/index.html
[https_docs.mongodb.com_manual_reference_program_mongod_bin.mongod]: https://docs.mongodb.com/manual/reference/program/mongod/#bin.mongod
[https_docs.mongodb.com_manual_reference_program_mongo]: https://docs.mongodb.com/manual/reference/program/mongo/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70]: /images/20211223/6ef04d859b24406eb5fc5e4407ae11f0.png
[20190628180745309.png]: /images/20211223/ba9c26f31f2d4a6094d025ebab9fb761.png
[20190704224417730.png]: /images/20211223/e109c12d600544ba8a767b97e954ce4c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pzeDE4MjczMTE3MDAz_size_16_color_FFFFFF_t_70 1]: /images/20211223/1eadd76a094b4e7c8e3b2b4f0955b96a.png
[https_docs.mongodb.com_manual_core_authentication-mechanisms]: https://docs.mongodb.com/manual/core/authentication-mechanisms/