Error changing sequelize-cli configuration to dynamic configuration

Question

I am running into a problem, trying change the sequelize-cli configuration to dynamic configuration, as described in the documentation. I created the .sequelizerc-file in the root-directory of my project and configured the path to config.js.

After running npx sequelize-cli db:migrate I get the following error:

Sequelize CLI [Node: 12.14.1, CLI: 5.5.1, ORM: 5.21.3]

Loaded configuration file "config/config.js".

Using environment "development".

ERROR: Server requests authentication using unknown plugin sha256_password. See TODO: add plugins doco here on how to configure or author authentication plugins.

It doesn't matter if I try it on my development environment (localhost) or on my production environment (clearDB with heroku) I still get the same Error message, not being able to connect to the server. Without the dynamic configuration (config in a *.json) everything worked fine.

This is the content of my .sequelizerc file

const path = require('path');

module.exports = {
      'config': path.resolve('config', 'config.js'),
}

and this is simply the content of my config.js

module.exports = {
  development: {
    username: process.env.DB_USER,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_NAME,
    host: process.env.DB_HOST,
    dialect: 'mysql',
  },
  production: {
    username: process.env.DB_PROD_USER,
    password: process.env.DB_PROD_PASSWORD,
    database: process.env.DB_PROD_NAME,
    host: process.env.DB_PROD_HOST,
    dialect: 'mysql',
  }
};

It doesn't matter if I try it on my development environment (localhost) or on my production environment (clearDB with heroku) I still get the same Error message, not being able to connect to the server. Without the dynamic configuration (config in a *.json) everything worked fine.

thank you! Just approved your edit :)

lub
– lub

2020-04-14 10:19:11 +00:00
Commented Apr 14, 2020 at 10:19 — lub
– lub, Commented Apr 14, 2020 at 10:19

lub · Accepted Answer · 2020-04-15 15:53:57Z

4

okay, after trying for a long time, I figured out, that my environment variables were undefined when I ran npx sequelize-cli-commands.

So i simply added require('dotenv').config(); to my .config.js now it works.

answered Apr 15, 2020 at 15:53

lub

1112 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mat Gilbert · Accepted Answer · 2024-11-04 14:30:31Z

1

4 years later the answer by lub is correct and helped me.

Here's what I did for anyone else who appreciates literal examples

require('dotenv').config();

module.exports =
{
    "development": {
      "username": process.env.MSSQL_USER,
      "password": process.env.MSSQL_PASSWORD,
      "database": process.env.MSSQL_DB,
      "host": process.env.MSSQL_HOST,
      "dialect": "mssql",
      "dialectOptions": {
        "options": {
            "encrypt": true
      }
    }    
    },
    "production": {
      "username": "root",
      "password": null,
      "database": "",
      "host": "",
      "dialect": "mysql"
    }
  }

answered Nov 4, 2024 at 14:30

Mat Gilbert

111 bronze badge

1 Comment

lub Over a year ago

Happy to hear, that my answer to my own question helps someone 4 years later!

Collectives™ on Stack Overflow

Error changing sequelize-cli configuration to dynamic configuration

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related