tc/RMongo

Rmongo Database authentication

Opened this issue · 0 comments

Hi I like to use RMongo for easier querying but having problems with connecting to database on mongo version 2.6.

The code i am to use to connect would be

port<- 27017
host <- 'SDMongo01'
db<-'Services'
user<-'svc'
pass<-'XYZ'
con <- mongoDbConnect(db,host,port)
authenticated <-dbAuthenticate(con,user,pass)
collection<-"SampleInformation"
query1 <- '{}'
query2<-'{"_id":0,"project_name":1}'
data<- dbGetQueryForKeys(con,collection,query1,query2)
Error in .jcall(rmongo.object@javaMongo, "S", "dbGetQuery", collection, :
com.mongodb.MongoException: not authorized for query on Services-Metrics-Val.SampleInformation

But similiar query using rmongodb works.

mongo <- mongo.create(host = "SDMongo01", username = "svc", password = "xyz", db = "Services")
if (mongo.is.connected(mongo)){

  • print(mongo.count(mongo, "Services-Metrics-Val.Firebrand"))
  • }
    [1] 11441

Can you tell me what I am missing? Is it something to do with new version of Mongodb?

Thanks a lot and and let me know if you need more information.

Ankit