Authentication failure while trying to save to mongodb

by

Where, i.e. in which database did you create the user? Typically users are created in database admin. When you connect to a MongoDB then you should always specify the authentication database and the database you like to use.

The defaults are a bit confusing and not really consistent, see this table to get an overview:

+----------------------------------------------------------------------------------------+
|Connection string                                           | Authentication | Current  |
|                                                            | database       | database |
+----------------------------------------------------------------------------------------+
|mongo -u <...> -p <...> --authenticationDatabase admin myDB |     admin      |   myDB   |
|mongo -u <...> -p <...> myDB                                |     myDB       |   myDB   |
|mongo -u <...> -p <...> --authenticationDatabase admin      |     admin      |   test   |
|mongo -u <...> -p <...> localhost:27017                     |     test       |   test   |
|mongo -u <...> -p <...> --host localhost:27017              |     admin      |   test   |
|mongo -u <...> -p <...>                                     |     admin      |   test   |
+----------------------------------------------------------------------------------------+

If you like to use Connection string in URI format, it would correspond to these ones:

mongodb://<username>:<password>@hostname/myDB?authSource=admin
mongodb://<username>:<password>@hostname/myDB
mongodb://<username>:<password>@hostname?authSource=admin
mongodb://<username>:<password>@hostname

I guess you created the user in admin database but as you don’t specify authenticationDatabase while connecting, Mongo defaults it to mydatabase where it fails, because user does not exist in database mydatabase.

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. how to convert string to numerical values in mongodb
  3. Auto increment in MongoDB to store sequence of Unique User ID
  4. Fastest way to remove duplicate documents in mongodb
  5. Using map/reduce for mapping the properties in a collection
  6. MongoDB Aggregation: How to get total records count?
  7. Average Aggregation Queries in Meteor
  8. How to query MongoDB to test if an item exists?
  9. Working with special characters in a Mongo collection
  10. Mongo sort on a calculated condition
  11. MongoDB: output ‘id’ instead of ‘_id’
  12. MongoDB: Updating subdocument
  13. MongoDB $gt/$lt operators with prices stored as strings
  14. MongoDB: Calculate dwell time between every status value change
  15. How to export all collections in MongoDB?
  16. Couldn’t connect to server 127.0.0.1:27017
  17. Is GridFS fast and reliable enough for production?
  18. Dealing with schema changes in Mongoose
  19. Batch insert/update using Mongoid?
  20. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  21. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  22. How to flatten a subdocument into root level in MongoDB?
  23. How to access overall document count during arithmetic aggregation expression
  24. Does MongoDB support floating point types?
  25. How to deal with the timezone issue when storing dates in utc using mongod?
  26. Fuzzy Searching with Mongodb?
  27. How to check if an array field contains a unique value or another array in MongoDB?
  28. MongoDB.service failed with result exit-code
  29. MongoDB index/RAM relationship
  30. MongoDB {aggregation $match} vs {find} speed

Leave a Comment