Unable to connect db because of "throw new MongoParseError('Invalid scheme, expected connection string to start with "mongodb://" or "mongodb+srv://"');"

olena_dunamiss · 2022-07-25T09:06:00.438Z

Thank you so much for your response and the materials that you added!
The tutorial: Build a GraphQL API with NodeJS and MongoDB (Full-stack MERN Tutorial ) - YouTube
I added console.log(DB_URI) and I have the following:

undefined
C:\Users\Svetl\test\node_modules\mongodb-connection-string-url\lib\index.js:9
    return (connectionString.startsWith('mongodb://') ||
                             ^

TypeError: Cannot read properties of undefined (reading 'startsWith')``

Neck_Abdullah · 2022-10-09T17:35:28.661Z

did you install dotenv package, I almost had same error and I found out I need to install dotenv package so I can access to .env variables dotenv in npm registry

Ubong_Udotai · 2022-12-16T12:30:51.338Z

I had this same issue and I resolved it by simply removing the “;” at the end of the connection string. So you connection string should just be:

"mongodb+srv://username:password@cluster0.lghcp.mongodb.net/?retryWrites=true&w=majority"

That is without the semi-colon at the end.

Adam_Machowczyk · 2022-12-17T12:27:58.326Z

At this moment, I believe I should just quit my job and become a chef… Thank you, kind sir.

Ubong_Udotai · 2022-12-18T00:39:15.632Z

Lol… What are you currently working as btw… thanks Adam!

Brian_A · 2023-01-18T17:49:57.681Z

This was my problem when the mongoose.connect() in my index.js file would not read my process.env. value.

Inside my .env file I had the semi-colon at the end as I usually do when writing JavaScript code:
MONGO_URL=“mongodb+srv:…”;

After removing the semi-colons in my .env files thing were finally working in index.js.

Thank you for this solution.

Brian_A · 2023-01-18T17:53:43.570Z

I don’t know if you are still having this problem, but as one other person said you need to remove the semi-colon ( ; ) from your variables in your .env file. That should make the process.env work properly.

jnr_wadeya · 2023-03-19T13:27:19.378Z

WTH!!! Thanks man. Can’t understand coding anymore. 2 full days trying to sort this…

amastaneh · 2023-05-11T16:56:15.221Z

Awesome, I removed the ; from end of line of .env and it’s resolved. Thank you;

amastaneh · 2023-05-11T16:57:26.827Z

Fantastic, I removed the semicolon at the end of the line .env, and the problem is solved. Thank you;

Tohirul_Islam · 2023-06-05T08:43:15.409Z

After five long hours of troubleshooting, I see this response. And Guess what happened.

T.R_Methu_N_A · 2023-08-10T04:18:12.911Z

After 14 hours of troubleshooting, I finally found the solution to my problem. I was able to find the solution to my problem by searching the documentation for “connection string”.

See - https://www.mongodb.com/docs/atlas/troubleshoot-connection/#special-characters-in-connection-string-password

Natalie_Gillam · 2023-10-15T22:32:50.188Z

This solved my problem, too - thank you! Very glad I stumbled upon your solution.

R_Codes_N_A · 2024-01-15T13:22:10.893Z

Bruh!!! Thx for help though

andi_tazlauanu · 2024-01-16T11:37:55.732Z

Cheers, it worked for me as well.

Sachdev_R · 2024-02-05T03:42:59.624Z

Hi Guys, does anyone know the reason why it works when semicolon is removed? Also Thank you for the solution @Ubong_Udotai

chris · 2024-02-05T12:28:39.680Z

https://www.npmjs.com/package/dotenv#what-rules-does-the-parsing-engine-follow

From the parsing rules dotenv is preserving the inner quotes, example:

# .env file
URI0="mongodb://foo:solarwinds123@host0,host1,host2/?tls=true"
URI1="mongodb://foo:solarwinds123@host0,host1,host2/?tls=true";

require("dotenv").config()
{
  parsed: {
    URI0: 'mongodb://foo:solarwinds123@host0,host1,host2/?tls=true',
    URI1: '"mongodb://foo:solarwinds123@host0,host1,host2/?tls=true";',
  }
}

Gurban_Gulamov · 2024-04-24T07:54:52.558Z

No dotenv needed ,nothing. Just make sure you do the following:

"ATLAS_URI=“mongodb+srv://…” with NO SPACES .

Yes. It is that easy. Sometimes it might also work if you simply move your config.env from the “server” folder into the root folder of the project.
However, getting rid of whitespaces around “=” is way easier.

George_Adly · 2024-06-25T05:30:18.324Z

Thank you
I had a problem connecting, and when I read your article, I found that the password contained %, and I removed it, and the problem was removed.

Prakhar_Diwaker · 2024-07-17T15:42:48.949Z

Hey, having a similar issue and when I console.log(DB_URI) it is showing undefined , what can be the possibles error, did mean there is some mistake while initializing mongodb or something else, please help.