關於spring-data-mongodb使用者名稱密碼登入報錯問題：Failed to authenticate to database

標籤：密碼登入   nat   art   sel   https   got   預設   str   failed   

一.問題

　　1.spring-data-mongodb使用者名稱密碼登入報錯問題：Failed to authenticate to database 

     

org.springframework.data.mongodb.CannotGetMongoDbConnectionException: Failed to authenticate to database [ashop], username = [ashop], password = [g***********4]org.springframework.data.mongodb.core.ReflectiveDbInvoker.authenticate(ReflectiveDbInvoker.java:83)org.springframework.data.mongodb.core.MongoDbUtils.doGetDB(MongoDbUtils.java:127)org.springframework.data.mongodb.core.MongoDbUtils.getDB(MongoDbUtils.java:94)org.springframework.data.mongodb.core.SimpleMongoDbFactory.getDb(SimpleMongoDbFactory.java:203)org.springframework.data.mongodb.core.SimpleMongoDbFactory.getDb(SimpleMongoDbFactory.java:191)org.springframework.data.mongodb.core.MongoTemplate.getDb(MongoTemplate.java:1606)org.springframework.data.mongodb.core.MongoTemplate.executeFindOneInternal(MongoTemplate.java:1839)org.springframework.data.mongodb.core.MongoTemplate.doFindOne(MongoTemplate.java:1656)org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:564)org.springframework.data.mongodb.core.MongoTemplate.findOne(MongoTemplate.java:559)com.oneday.ashop.core.base.mongo.BaseMongoDaoSupport.findOne(BaseMongoDaoSupport.java:81)com.oneday.ashop.webgate.user.UserDao.findUser(UserDao.java:44)com.oneday.ashop.webgate.user.UserService.login(UserService.java:88)com.oneday.ashop.webgate.user.UserControl.login(UserControl.java:57)sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)java.lang.reflect.Method.invoke(Unknown Source)org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776)org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:868)javax.servlet.http.HttpServlet.service(HttpServlet.java:648)org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)javax.servlet.http.HttpServlet.service(HttpServlet.java:729)org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)

二.解決方案

2.1.首先是mongodb資料庫設定密碼

登入mong shell,

>use admin

>db.system.users.remove({})

>db.system.version.remove({})

>db.system.version.insert({"_id","authSchema","currentVersion":3})

>use testdb

>db.createUser({user:"abc",pwd:"123456"},roles["readWrite","dbAdmin"])

 

mongo服務以登入驗證許可權方式啟動命令：

切換到mongod安裝路徑下，執行：./mongod --dbpath=/home/db/data -auth --logpath=/home/db/logs/mongodb.log

2.2項目中spring配置

(1)添加相應jar包：

   Maven項目的pom.xml添加spring-data-mongodb的jar包，如下

　　<dependency>
　　　　<groupId>org.springframework.data</groupId>
　　　　<artifactId>spring-data-mongodb</artifactId>
　　　　<version>1.10.3.RELEASE</version>
　　　　</dependency>

　　由於spring-data-mongodb預設依賴的mongo-java-drive驅動包是2.*.*版本的，所以我們手動添加3.*版本的mongodb驅動包，如下

　　<dependency>
　　　　<groupId>org.mongodb</groupId>
　　　　<artifactId>mongo-java-driver</artifactId>
　　　　<version>3.2.2</version>
　　</dependency>

(2)設定檔

　　<mongo:mongo-client id="mongo" host="${mongo.host}"
　　port="${mongo.port}" credentials="${mongo.username}:${mongo.password}@${mongo.dbname}">
　　<mongo:client-options connections-per-host="${mongo.connectionsPerHost}"
　　write-concern="SAFE"
　　threads-allowed-to-block-for-connection-multiplier="${mongo.threadsAllowedToBlockForConnectionMultiplier}"
　　connect-timeout="${mongo.connectTimeout}" max-wait-time="${mongo.maxWaitTime}"
　　socket-keep-alive="${mongo.socketKeepAlive}" socket-timeout="${mongo.socketTimeout}" />
　　</mongo:mongo-client>
　　<!-- 設定使用的資料庫 名 -->
　　<mongo:db-factory id="mongoDbFactory" dbname="${mongo.dbname}"
　　mongo-ref="mongo" />
　　<!-- mongodb的模板 -->
　　<bean id="mongoTemplate" class="org.springframework.data.mongodb.core.MongoTemplate">
　　<constructor-arg name="mongoDbFactory" ref="mongoDbFactory" />

其中，mongodb3.×的java驅動包,屬性配置是<mongo:client-options>而不在是<mongo:options>.

 

關於spring-data-mongodb使用者名稱密碼登入報錯問題：Failed to authenticate to database