when using dotenv error - URL malformed, cannot be parsed

[mathiesha]

following the guide on the official nestjs docs, when trying to load a db connection string via a dotenv file, a error is thrown "URL malformed, cannot be parsed".

e.g.
dotenv file

db_connection = 'mongodb://localhost:27017/foo'

root.module

@ module({
modules: [
MongooseModule.forRoot(process.env.db_connection),
....
],
})

not sure if this is an implementation error from my part.

thanks,

[nixoncode]

the problem is not with mongoose or dotenv it has to do with the way you are initializing dotEnv package.
Please ensure that on the file where you are creating the mongoose connection you are also requiring dotEnv.

  require('dotenv').config()

after that line the you can now initialized mongoose

  mongoose.connect(process.env.MONGO_URI)
    .then(connection => {
        console.log('Connected to MongoDB')
    })
    .catch(error => {
      console.log(error.message)
     })

hope that helps.

[mathiesha]

@nickhq thanks a lot, was a stupid mistake I was doing. I can confirm your suggestion works.

[nixoncode]

Awesome! You can go ahead and close it now

[artworkad]

@mtziyo the issue is describe here in more detail https://github.com/motdotla/dotenv#how-do-i-use-dotenv-with-import

I like the approach of removing dotenv.config from my project and adding following script to package.json

"start:local": "ts-node --require dotenv/config -r tsconfig-paths/register src/server.ts"

Because in staging/production environments I don't need dotenv at all.

[nixoncode]

this is awesome, thanks for the heads up. [image: MailTag] Sent with MailTag <https://www.mailtag.io>

…

On Thu, Jul 5, 2018 at 6:13 PM Artjom Zabelin ***@***.***> wrote: @mtziyo <https://github.com/mtziyo> the issue is describe here in more detail https://github.com/motdotla/dotenv#how-do-i-use-dotenv-with-import I like the approach of removing dotenv.config from my project and adding following script to package.json "start:local": "ts-node --require dotenv/config -r tsconfig-paths/register src/server.ts" Because in staging/production environments I don't need dotenv at all. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#9 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AO_26OLRtKiAJag03E1gh36gJOubQNsOks5uDiz9gaJpZM4TN9Gz> .

[mathiesha]

hey @artjomzab, this is a nice approach thanks for sharing :)