-
Type: Task
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: 3.2.0
-
Component/s: Configuration
-
Labels:None
-
Environment:Window 7, JDK 1.7
Hi Team,
we are facing below issue
Query failed with error code 13 and error message 'not authorized for query dbname.collectionName.
We checked using No Sql Manager and have correct privileges on collection.
Below are POM.XML
<!-- Spring Data MongoDB --> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-mongodb</artifactId> <version>1.7.0.RELEASE</version> <type>jar</type> <scope>compile</scope> </dependency> <!-- MongoDB Java Driver --> <dependency> <groupId>org.mongodb</groupId> <artifactId>mongo-java-driver</artifactId> <version>3.2.0</version> <type>jar</type> <scope>compile</scope> </dependency>
We are using Spring Version - 4.0.1 Release.
Driver Connection Configuration
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:util="http://www.springframework.org/schema/util" xmlns:task="http://www.springframework.org/schema/task" xmlns:mongo="http://www.springframework.org/schema/data/mongo" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/data/mongo http://www.springframework.org/schema/data/mongo/spring-mongo-1.8.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-3.0.xsd"> <bean id="mdbProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean"> <!-- <property name="location" value="WEB-INF/spring-data.properties" /> --> <property name="locations"> <list> <value>WEB-INF/mdb-data-local.properties</value> </list> </property> </bean> <context:property-placeholder properties-ref="mdbProperties" ignore-resource-not-found="true" /> <mongo:mongo-client id="mongo" replica-set="${mdb.replica_set}"> <mongo:client-options connections-per-host="100" threads-allowed-to-block-for-connection-multiplier="10" connect-timeout="5000" max-wait-time="600000" max-connection-idle-time="600000" write-concern="JOURNAL_SAFE" read-preference="PRIMARY" /> </mongo:mongo-client> <bean id="mongoCredentials" class="com.cisco.ccw.oo.utility.UserCredentials"> <constructor-arg name="username" value="${mdb.username}" /> <constructor-arg name="password" value="${mdb.password}" /> </bean> <bean id="mongoDbFactory" class="org.springframework.data.mongodb.core.SimpleMongoDbFactory"> <constructor-arg name="mongo" ref="mongo" /> <constructor-arg name="databaseName" value="${mdb.dbname}" /> <constructor-arg name="credentials" ref="mongoCredentials" /> </bean> <!-- <mongo:db-factory dbname="${mdb.dbname}" mongo-ref="mongo" username="${mdb.username}" password="${mdb.password}" /> --> <mongo:mapping-converter id="mappingConverter"> <mongo:custom-converters> <mongo:converter> <bean class="com.cisco.ccw.oo.utility.BigDecimalReadConverter" /> </mongo:converter> <mongo:converter> <bean class="com.cisco.ccw.oo.utility.BigDecimalWriteConverter" /> </mongo:converter> <mongo:converter> <bean class="com.cisco.ccw.oo.utility.DateTimeWriteConverter" /> </mongo:converter> </mongo:custom-converters> </mongo:mapping-converter> <bean id="mongoTemplate" class="org.springframework.data.mongodb.core.MongoTemplate"> <constructor-arg name="mongoDbFactory" ref="mongoDbFactory" /> <constructor-arg name="mongoConverter" ref="mappingConverter" /> </bean> </beans>