postgresql - Postgres 和 Sequelize 的 Heroku 部署问题

Question

我正在尝试将我的应用程序部署到 Heroku。在本地运行时它工作得很好。从我部署它(通过 github 集成部署)的那一刻起，我就收到了通用的应用程序错误屏幕。下面是我的heroku日志。这些实际上运行了 3 次，但我将相同的内容发布 3 次是没有意义的。它们总是以:

2017-05-02T14:59:26.033702+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=calm-crag-40902.herokuapp.com request_id=6b64883e-9697-4d58-84d9-2f173d5b4cb1 fwd="70.
54.76.222" dyno= connect= service= status=503 bytes= protocol=https
2017-05-02T14:59:27.425435+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/favicon.ico" host=calm-crag-40902.herokuapp.com request_id=d3719d8f-4670-4621-a044-a511ee6884
10 fwd="70.54.76.222" dyno= connect= service= status=503 bytes= protocol=https

这将在每个连续错误屏幕后打印 2 到 4 次。第一个错误与 .env 文件未运行有关，第二个错误是尝试连接到 sequelize。我的主要重点是整理 .env，因为如果整理出来，至少该应用程序将显示我的应用程序将可见。

.env 错误:

{ Error: ENOENT: no such file or directory, open '.env'
2017-05-02T16:09:39.622865+00:00 app[web.1]:     at Error (native)
2017-05-02T16:09:39.622866+00:00 app[web.1]:     at Object.fs.openSync (fs.js:641:18)
2017-05-02T16:09:39.622867+00:00 app[web.1]:     at Object.fs.readFileSync (fs.js:509:33)
2017-05-02T16:09:39.622867+00:00 app[web.1]:     at Object.config (/app/node_modules/dotenv/lib/main.js:30:37)
2017-05-02T16:09:39.622868+00:00 app[web.1]:     at Object.<anonymous> (/app/server.js:3:19)
2017-05-02T16:09:39.622869+00:00 app[web.1]:     at Module._compile (module.js:570:32)
2017-05-02T16:09:39.622869+00:00 app[web.1]:     at Object.Module._extensions..js (module.js:579:10)
2017-05-02T16:09:39.622870+00:00 app[web.1]:     at Module.load (module.js:487:32)
2017-05-02T16:09:39.622871+00:00 app[web.1]:     at tryModuleLoad (module.js:446:12)
2017-05-02T16:09:39.622871+00:00 app[web.1]:     at Function.Module._load (module.js:438:3) errno: -2, code: 'ENOENT', syscall: 'open', path: '.env' }
2017-05-02T16:09:40.242885+00:00 app[web.1]: Unhandled rejection

Sequelize 错误:

SequelizeConnectionRefusedError: connect ECONNREFUSED 127.0.0.1:5432
2017-05-02T16:09:40.242902+00:00 app[web.1]:     at /app/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:98:20
2017-05-02T16:09:40.242903+00:00 app[web.1]:     at Connection.<anonymous> (/app/node_modules/pg/lib/client.js:186:5)
2017-05-02T16:09:40.242904+00:00 app[web.1]:     at emitOne (events.js:96:13)
2017-05-02T16:09:40.242905+00:00 app[web.1]:     at Connection.emit (events.js:188:7)
2017-05-02T16:09:40.242905+00:00 app[web.1]:     at Socket.<anonymous> (/app/node_modules/pg/lib/connection.js:86:10)
2017-05-02T16:09:40.242906+00:00 app[web.1]:     at emitOne (events.js:96:13)
2017-05-02T16:09:40.242907+00:00 app[web.1]:     at emitErrorNT (net.js:1281:8)
2017-05-02T16:09:40.242907+00:00 app[web.1]:     at Socket.emit (events.js:188:7)
2017-05-02T16:09:40.242909+00:00 app[web.1]:     at process._tickCallback (internal/process/next_tick.js:104:9)
2017-05-02T16:09:40.242908+00:00 app[web.1]:     at _combinedTickCallback (internal/process/next_tick.js:80:11)
2017-05-02T16:09:40.360035+00:00 heroku[web.1]: Process exited with status 0
2017-05-02T16:09:40.373996+00:00 heroku[web.1]: State changed from starting to crashed

这是我的 index.js:

'use strict';

const fs        = require('fs');
const path      = require('path');
const Sequelize = require('sequelize');
const basename  = path.basename(module.filename);
const env       = process.env.NODE_ENV || 'development';
const config    = require(__dirname + '/../config/config.json')[env];
const db        = {};

if (config.use_env_variable) {
  const sequelize = new Sequelize(process.env[config.use_env_variable]);
} else {
  const 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;

配置文件:

{
  "development": {
    "username": "",
    "password": "",
    "database": "late_file",
    "host": "127.0.0.1",
    "dialect": "postgres"
  },
  "test": {
    "username": "",
    "password": "",
    "database": "database_test",
    "host": "127.0.0.1",
    "dialect": "postgres"
  },
  "production": {
    "use_env_variable": "DATABASE_URL",
    "dialect": "postgres"
  }
}

.env，修改为排除事物的特定名称

DB_HOST=localhost
DB_USER=
DB_PASS=
DB_NAME=
DB_SSL=true if heroku
DB_PORT=5432
DATABASE_URL=postgres://appropriate/url

server.js 的适用部分

const pg = require('pg');

pg.defaults.ssl = true;
pg.connect(process.env.DATABASE_URL, function(err, client) {
  if (err) throw err;
  console.log('Connected to postgres! Getting schemas...');

  client
    .query('SELECT table_schema,table_name FROM information_schema.tables;')
    .on('row', function(row) {
      console.log(JSON.stringify(row));
    });
});

任何帮助将不胜感激!
预先感谢任何提供任何支持的人!

Answer 1

布兰登，

我正在使用 JAWS_DB 和 MySQL 在 Heroku 上运行一个应用程序，但其他方面相同的 config.json 和 index.js。就我在 Heroku 上的情况而言，“if (config.use_env_variable) {const sequelize = new Sequelize(process.env[config.use_env_variable])”语句连接到数据库没有错误。日志似乎指向 server.js 中的“pg.connect”失败。我不清楚(没有看到您的其余代码)为什么需要在 index.js 中连接到数据库，然后在 server.js 中再次连接。如果您可以从 pg.connect 删除连接并尝试仅使用来自 index.js 的连接运行它可能会阻止此错误。