use_env_variable returns undefined because not string value about cli

[saeidfiy]

I have same issue

Sequelize CLI [Node: 12.16.1, CLI: 5.5.1, ORM: 5.22.3]

Loaded configuration file "config\config.json".
Using environment "development".

ERROR: Error parsing url: undefined

[zkinsk]

@ArthurGuez So in the intial example:

production: {
    use_env_variable: process.env.DATABASE_URL,
    dialect: 'postgres',
    dialectOptions: {
      ssl: {
        require: true,
        rejectUnauthorized: false, // <<<<<<< YOU NEED THIS TO FIX UNHANDLED REJECTION 
      },
    },
  },

I instead did this:

production: {
    use_env_variable: DATABASE_URL,
    dialect: 'postgres',
    dialectOptions: {
      ssl: {
        require: true,
        rejectUnauthorized: false, // <<<<<<< YOU NEED THIS TO FIX UNHANDLED REJECTION 
      },
    },
  },

Because you are already saying find this as an environment variable with use_env_variable

[ArthurGuez]

Thanks @zkinsk :)

It's working for me now 👍

[Juan321654]

I found the solution to this stackoverflow question at https://stackoverflow.com/questions/49988002/getting-error-error-parsing-url-undefined-when-trying-to-run-migrations-with-s. In short, the .env file is not being loaded correctly by sequelize. To fix this issue, create a file in the root folder called .sequelizerc. Then, inside this file, add the following code. I changed it back to json because the original stackoverflow post was using a js file in the config folder.

// .sequelizerc
require("dotenv").config(); // <- require this here

// ...Any aditional configuration for sequelize-cli like custom folders for models and migrations
const path = require("path");
module.exports = {
  config: path.resolve("config", "config.json"),
  "models-path": path.resolve("models"),
  "seeders-path": path.resolve("seeders"),
  "migrations-path": path.resolve("migrations"),
};

[bozzmob]

I am facing the same issue.

internal/validators.js:120
    throw new ERR_INVALID_ARG_TYPE(name, 'string', value);
    ^

TypeError [ERR_INVALID_ARG_TYPE]: The "url" argument must be of type string. Received undefined
    at validateString (internal/validators.js:120:11)
    at Url.parse (url.js:159:3)
    at Object.urlParse [as parse] (url.js:154:13)
    at new Sequelize (/mnt/d/work/roughwork/backend/node_modules/sequelize/lib/sequelize.js:185:28)
    at Object.<anonymous> (/mnt/d/work/roughwork/backend/src/sequelize.js:11:19)
    at Module._compile (internal/modules/cjs/loader.js:1137:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1157:10)
    at Module.load (internal/modules/cjs/loader.js:985:32)
    at Function.Module._load (internal/modules/cjs/loader.js:878:14)
    at Module.require (internal/modules/cjs/loader.js:1025:19) {
  code: 'ERR_INVALID_ARG_TYPE'
}
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] start: `node src/server`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

[zkinsk]

This has worked for me.

use_env_variable: DATABASE_URL,

I don't think you need process.env as you are already declaring use_env_variable

[agus7fauzi]

i have no ide, anyone can give other solution?

[ArthurGuez]

This has worked for me.

use_env_variable: DATABASE_URL,

I don't think you need process.env as you are already declaring use_env_variable

Could you be more specific please?
Where did you use : use_env_variable: DATABASE_URL ?
Thanks

[github-actions]

This issue has been automatically marked as stale because it has been open for 7 days without activity. It will be closed if no further activity occurs. If this is still an issue, just leave a comment or remove the "stale" label. 🙂

[amauryplayero]

I am having the same issue

[ephys]

Looking into sequelize-cli's source code, use_env_variable must be the name of the environment variable, as a string. So to fix the above example:

production: {
  use_env_variable: 'DATABASE_URL',
  dialect: 'postgres',
  dialectOptions: {
    ssl: {
      require: true,
      rejectUnauthorized: false, // <<<<<<< YOU NEED THIS TO FIX UNHANDLED REJECTION 
    },
  },
},