NodeJS - SequelizeConnectionError:自签名证书

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

节点版本: v14.16.0

"sequelize"："^6.6.0“

"pg"："^8.5.1“

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

提前感谢

Answer 1

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

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