The end goal is just to get a prototype up and running on Heroku. I was hoping Strapi would be a quick and easy solution. Deploying it on Heroku has really been no fun though.

I can connect now with atlas through MongoDBCompas, so It's working, but Strapi A) doesn't give helpful errors for missed connections and B) just won't connect.

I'm currently looking at AWS options and hoping that will work.

I'm having the same problem. Absolute nightmare trying to make it work on Heroku.
I think the problem is the recent release of the Stable Version without updating the docs.
Have you had any luck in making it work?

I'm having the same problem. Absolute nightmare trying to make it work on Heroku.
I think the problem is the recent release of the Stable Version without updating the docs.
Have you had any luck in making it work?

I was able to get it working, but I had to have Atlas Open (0.0.0.0) and I wasn't soo keen on that. I got it running on my personal server with NOIP and a lets Encrypt certificate atm because I just wanted to get going.

I have already set me network access to be open everywhere, set user permissions for the database user, checked my password, encoded special characters and still nothing works.

I can connect to it locally and through MongoDB Compass just Heroku always fails with "invalid connection string".

Sorry, I forgot to mention that instead of the uri string from "Connect to your App" I tried the string from Connect to MongoDB Compass. It works on both local and Heroku instances, which is ideal because I can use the Dev env on my local machine and it updates the Production API as well.

Thanks I'll give that a try, is there any reason (security) why using that might be a bad idea?

Just one more layer of security. See here https://stackoverflow.com/questions/56387832/mongo-db-atlas-is-it-safe-to-whitelist-all-ip-because-someone-attempting-to-acc

I actually finally managed to make this work using the URI string. Hopefully Strapi will update their official documentation now the stable release is out and things have changed quite a lot for deploying to Heroku.

Looks like the handling of environments has totally changed as has the reading the of environment variables.

In case anyone else stumbles on this thread here's my complete database file. This works for both production and local. I created a .env.production file to save all my environment variables in to test the connection locally. Then you'll need to copy them into Heroku as well. This can be done with the CLI or in the GUI for the webapp. I recommend using the GUI as the CLI was confused by some of the query params on the end of the string (at least for me).

module.exports = ({ env }) => ({ defaultConnection: "default", connections: { default: { connector: "mongoose", settings: { client: "mongo", uri: env("DATABASE_HOST"), host: env("DATABASE_HOST", "127.0.0.1"), srv: env.bool("DATABASE_SRV", false), port: env.int("DATABASE_PORT", 27017), database: env("DATABASE_NAME", "strapi_portfolio"), username: env("DATABASE_USERNAME", ""), password: env("DATABASE_PASSWORD", ""), }, options: { authenticationDatabase: env("AUTHENTICATION_DATABASE", null), ssl: env.bool("DATABASE_SSL", false), }, }, }, });