NextJS won't connect to MongoDB when built and put on a server

Veljko_N_A · 2024-10-13T23:58:15.917Z

I have NextJS app that has backend routes inside where I connect to the database. Everything works fine locally and I don’t get any errors but as soon as I deploy the app to the server I start getting this error:

Error connecting to the database: MongooseServerSelectionError: Could not connect to any servers in your MongoDB Atlas cluster. One common reason is that you're trying to access the database from an IP that isn't whitelisted. Make sure your current IP address is on your Atlas cluster's IP whitelist: https://www.mongodb.com/docs/atlas/security-whitelist/

I have whitelisted my IP address, IP address of my website and also whitelisted all IP addresses with 0.0.0.0/0 but the error persists.

Veljko_N_A · 2024-10-14T20:55:27.050Z

I have solved this issue by calling my host provider and asking them to allow me a specific port so that my website can connect to it. The port was 27017

EdU_N_A1 · 2024-11-18T12:09:02.386Z

Solved.
In my case, Im deplying NextJS v14.0.2.
Downgrading packages
mongoose 8.3.4 → 8.1.0
mongodb 6.10.0 → 6.3.0
Solved the five days pain in the head.
NodeJS 12.13.0
Regards!