ERROR: Error parsing url: undefined when migrating database to heroku

Question

I'm using Sequelize as an ORM and I'm trying to migrate my database to Heroku. When running heroku run sequelize db:migrate

I just get

Loaded configuration file "config/config.js".
Using environment "production".
ERROR: Error parsing url: undefined

Here's what my config file looks like:

  module.exports = {
  "development": {
    "username": "root",
    "password": "password",
    "database": "vueapp",
    "host": "127.0.0.1",
    "dialect": "postgres"
  },
  "test": {
    "username": "root",
    "password": null,
    "database": "database_test",
    "host": "127.0.0.1",
    "dialect": "mysql"
  },
  "production": {
    "use_env_variable": process.env.DATABASE_URL,
    "dialect": "postgres",
    "ssl": true,
    "dialectOptions": {
      "ssl": true
    }
  }
}

And the index file

const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(__filename);
const env = process.env.NODE_ENV || 'development';
const config = require(__dirname + '/../config/config')[env];

const User = require("./user")
const Hour = require('./hours');

const db = {
  User,
  Hour
};

let sequelize;
if (config.use_env_variable) {
  sequelize = new Sequelize(config.use_env_variable, config);
} else {
  sequelize = new Sequelize(config.database, config.username, config.password, config);
}

fs
  .readdirSync(__dirname)
  .filter(file => {
    return (file.indexOf('.') !== 0) && (file !== basename) && (file.slice(-3) === '.js');
  })
  .forEach(file => {
    const model = sequelize['import'](path.join(__dirname, file));
    db[model.name] = model;
  });

Object.keys(db).forEach(modelName => {
  if (db[modelName].associate) {
    db[modelName].associate(db);
  }
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

Not entirely sure what the issue is. Going through the heroku logs, I see a throw new Error('Dialect needs to be explicitly supplied as of v4.0.0');

But I have added the dialect in the config.js file. Does it matter if the config file is a .js file or a .json file?

Just to clarify, the actual web app opens up and I can see the error handler that I set up. So I'm not actually getting an application error when opening up the route URL

Did you later solve the problem. I need help

nnam4x
– nnam4x

2021-04-29 05:11:33 +00:00
Commented Apr 29, 2021 at 5:11 — nnam4x
– nnam4x, Commented Apr 29, 2021 at 5:11

Damilola Adekoya · Accepted Answer · 2019-03-08 21:33:32Z

1

production: { use_env_variable: 'DATABASE_URL', },

change your production to this and go to heroku to set environmental variable

answered Mar 8, 2019 at 21:33

Damilola Adekoya

1051 silver badge9 bronze badges

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

Comments

nnam4x · Accepted Answer · 2021-04-29 05:10:58Z

0

Did you later solve the problem

answered Apr 29, 2021 at 5:10

nnam4x

1591 gold badge1 silver badge12 bronze badges

Comments

helloJello · Accepted Answer · 2022-03-20 01:27:47Z

0

This is a little confusing but Damilola is correctly. You need need to leave the value for use_env_variable to 'DATABASE_URL'. You will be tempted to change this to process.env.DATABASE_URL. This is incorrect.

Leaving it like this will allow Sequelize to inject the value that is saved to the Heroku env variable DATABASE_URL.

production: { use_env_variable: 'DATABASE_URL', dialect: "postgres", protocol: "postgres" }

answered Mar 20, 2022 at 1:27

helloJello

1962 silver badges9 bronze badges

Collectives™ on Stack Overflow

ERROR: Error parsing url: undefined when migrating database to heroku

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related