1

I'm trying to login using rmongodb and it does not authenticate. Here's my connection string:

myMongoConnection <- mongo.create(host = "<myip>",db = "geoLoc", username = "<myusername>", password = "<mypassword>")

However, if I open a mongo shell on my computer and type:

mongo <myip>/geoLoc -u '<myusername>' -p '<mypassword>'

it connects just fine.

Moreover, if I log into the server and disable authentication by commenting out: auth = true, and then try:

myMongoConnection <- mongo.create(host = "<myip>",db = "geoLoc)"

it also works fine. So this is something to do with the username and password. I have no idea what though as I know they are "correct" as I can login with them!

user1357015
  • 11,168
  • 22
  • 66
  • 111

1 Answers1

2

You are likely running a server version of MongoDB 3.0 or above ( 3.x series current as writing ), which has an updated security authentication mechanism ( SCRAM-SHA-1 from MONGODB-CR ) that is not compatible with older driver versions that do not support it.

The as of current rmongodb package release ( version 1.8.0 of writing ), this driver is based on the legacy C driver implementation which is not compatible with the new authentication methods. As is also noted in the issues on that repository, the author notes this driver dependency and states that the package would require a rewrite to utilize the new API that supports the new authentication method.

As of writing, there does not appear to be any moves to make any such changes, aside for establishing a new branch which is not presently ready for release.

Your options therefore presently are:

  • Work without authentication where possible
  • Downgrade the MongoDB server version to one that supports the old authentication
  • Look for other driver implementations that support the new authentication.

So "rmongodb" itself cannot currently connect to MongoDB 3.x servers. Either apply one of the other choices, and/or contribute to the respository yourself if you are able to speed it's development into the next version with full authentication suppport.

Other possible driver alternatives are linked or dicussed in the issue linked in this answer.

Blakes Seven
  • 49,422
  • 14
  • 129
  • 135