SequelizeConnectionError: self signed certificate

by

This is due to an (accidental) breaking change in node-postgres version 8 (see this GitHub issue).

The solution is to pass rejectUnauthorized: false to the sequelize connection parameters inside of dialectOptions>ssl, as described here by GitHub user jsanta, bypassing the SSL certificate check (which is okay when connecting to a trusted server over a secure connection such as on your local host or between your own servers in the same network):

const sequelize = new Sequelize({
  database: "xxxxx",
  username: "xxxxx",
  password: "xxxxx",
  host: "xxxxx",
  port: 5432,
  dialect: "postgres",
  dialectOptions: {
    ssl: {
      require: true,
      rejectUnauthorized: false // <<<<<<< YOU NEED THIS
    }
  },
});

More Related Contents:

  1. What is the most efficient medium for both Node.js and Javascript to read and write a file?
  2. Error: Can’t set headers after they are sent to the client
  3. Download a file from NodeJS Server using Express
  4. How to properly reuse connection to Mongodb across NodeJs application and modules
  5. Make Axios send cookies in its requests automatically
  6. How to perform an HTTP file upload using express on Cloud Functions for Firebase (multer, busboy)
  7. SyntaxError: Unexpected token function – Async Await Nodejs
  8. How do you send images to node js with Axios?
  9. What is the meaning of “…args” (three dots) in a function definition?
  10. Why cant I inline call to res.json?
  11. How do sessions work in Express.js with Node.js?
  12. How to exclude some fields from the document
  13. How to disable Express BodyParser for file uploads (Node.js)
  14. Loop in Jade (currently known as “Pug”) template engine
  15. How to close electron app via javascript?
  16. How to get data passed from a form in Express (Node.js)
  17. how express forming the img URL
  18. how to get request path with express req object
  19. Service Worker registration error: Unsupported MIME type (‘text/html’)
  20. How do I stream response in express?
  21. Using Express Handlebars and Angular JS
  22. What does “res.render” do, and what does the html file look like?
  23. Async Await map not awaiting async function to complete inside map function before mapping next item
  24. Unable to send numbers using res.send() using express with node
  25. How to decipher string in node js which is encrypted in crypto js in javascript
  26. How to generate unique ID with node.js
  27. How can I use webpack with express?
  28. express.js – how to intercept response.send() / response.json()
  29. Node.js passing parameters to client via express render
  30. Can’t get rid of header X-Powered-By:Express

Leave a Comment