node.js - NodeJS-SequelizeConnectionError : self signed certificate

Question

我正在尝试连接到 Heroku 中托管的 PostgreSQL 数据库

if (process.env.DATABASE_URL) {
  //Heroku
  console.log("Init sequelize with process.env.DATABASE_URL")
  sequelize = new Sequelize(process.env.DATABASE_URL, {
    dialect: 'postgres',
    protocol: 'postgres',
    dialectOptions: {
        ssl: true,
        rejectUnauthorized: false
    }
  });
  console.log("Finished sequelize with process.env.DATABASE_URL")
} else {
  console.log("Init sequelize with config.database")
  var sequelize = new Sequelize(config.database, config.username, config.password, config);
  console.log("Finished sequelize with config.database")
}

这是我用于本地主机的 config.json:

{
  "production": {
    "use_env_variable": "DATABASE_URL",
    "dialect": "postgres",
    "ssl":true,
    "dialectOptions":{
        "ssl":{
          "require":true,
          "rejectUnauthorized": false
        }
    }
  }
}

当我使用 pm2 start --env=production 运行我的服务时，我收到以下错误:

ConnectionError [SequelizeConnectionError]: self signed certificate

Node 版本:v14.16.0

“Sequelize ”:“^6.6.0”

"pg": "^8.5.1"

有人能告诉我这是怎么回事吗？

提前致谢

Answer 1

在您的 Heroku 连接中，尝试将 ssl 通知为:

          dialectOptions: {
               ssl: {
                    require: true,
                    rejectUnauthorized: false
                  }
          }