Connecting Heroku App to Atlas MongoDB Cloud service

by

What I think might fix your problem

Disclaimer: I have used neither Heroku nor MongoDB Atlas but I am looking into them.

According to a Github issue I found, you will get that error message if you haven’t whitelisted the server IP addresses in MongoDB Atlas.

Reading the MongoDB Atlas docs, the only way I see to do this in combination with Heroku dynos is to add 0.0.0.0/0 (i.e. all addresses) to your MongoDB Atlas whitelist.

Give that a try and please report back whether you can instantiate a connection.

On SSL

Trying to reply to the SSL question, I do not think that you need to enable it on Heroku based on what I read, although I am not totally sure.

If the MongoDB server performed certificate validation, the Node.js code for connecting to it would have to look like the following (taken from the Node.js driver documentation):

var MongoClient = require('mongodb').MongoClient,
  f = require('util').format,
  fs = require('fs');

// Read the certificates
var ca = [fs.readFileSync(__dirname + "/ssl/ca.pem")];
var cert = fs.readFileSync(__dirname + "/ssl/client.pem");
var key = fs.readFileSync(__dirname + "/ssl/client.pem");

// Connect validating the returned certificates from the server
MongoClient.connect("mongodb://localhost:27017/test?ssl=true", {
  server: {
      sslValidate:true
    , sslCA:ca
    , sslKey:key
    , sslCert:cert
    , sslPass:'10gen'
  }
}, function(err, db) {
  db.close();
});

If the MongoDB server does not check for any SSL certificates, you can simply use code like the following (also taken from the Node.js driver documentation):

var MongoClient = require('mongodb').MongoClient;

MongoClient.connect("mongodb://localhost:27017/test?ssl=true", function(err, db) {
  db.close();
});

Given that the Atlas documentation contains the following example code for connecting to it from Node.js, I think that you do not have to enable SSL on Heroku:

var MongoClient = require('mongodb').MongoClient;

var uri = "mongodb://kay:[email protected]:27017,mycluster0-shard-00-01-wpeiv.mongodb.net:27017,mycluster0-shard-00-02-wpeiv.mongodb.net:27017/admin?ssl=true&replicaSet=Mycluster0-shard-0&authSource=admin";
MongoClient.connect(uri, function(err, db) {
  db.close();
});

More Related Contents:

  1. Heroku app crashes after MongoDB updated to 3.0
  2. Querying after populate in Mongoose
  3. Populate nested array in mongoose
  4. Cannot overwrite model once compiled Mongoose
  5. Comparing mongoose _id and strings
  6. Mongoose Unique values in nested array of objects
  7. Mongoose Schema hasn’t been registered for model
  8. Mongoose duplicate key error with upsert
  9. How to protect the password field in Mongoose/MongoDB so it won’t return in a query when I populate collections?
  10. How can I use a cursor.forEach() in MongoDB using Node.js?
  11. Fill missing dates in records
  12. Mongoose, find, return specific properties
  13. How to drop a database with Mongoose?
  14. How to use mongoose findOne
  15. Mongoose indexing in production code
  16. Mongoose optional search query parameters?
  17. Mongodb sort with case insensitive manner
  18. Difference between MongoDB and Mongoose
  19. How can I save multiple documents concurrently in Mongoose/Node.js?
  20. Fail to connect Mongoose to Atlas
  21. log all queries that mongoose fire in the application
  22. Combine two OR-queries with AND in Mongoose
  23. How do I increment a Number value in Mongoose?
  24. How to reference another schema in my Mongoose schema?
  25. Mongoose findOneAndUpdate and runValidators not working
  26. Populate a mongoose model with a field that isn’t an id
  27. Mongoose select fields to return from findOneAndUpdate
  28. mongoose recursive populate
  29. MongoDB $lookup vs Mongoose populate
  30. Error at connecting to MongoDb Atlas Server

Leave a Comment