lighthouse-ci icon indicating copy to clipboard operation
lighthouse-ci copied to clipboard

Server does not support SSL connections

Open UsamaHameed opened this issue 2 years ago • 0 comments

Describe the bug I tried to set up the server to use SSL connections to the DB following https://github.com/GoogleChrome/lighthouse-ci/blob/main/docs/configuration.md#custom-ssl-certificate-for-database-connection but I get the error

ConnectionError [SequelizeConnectionError]: The server does not support SSL connections

To Reproduce Steps to reproduce the behavior: Setup the server like so:

createServer({
  port: process.env.PORT, // 3000
  storage: {
    storageMethod: "sql",
    sqlDialect: "postgres",
    sqlConnectionUrl: process.env.DATABASE_URL, // postgresql://postgres:postgres@postgres:5432/lighthouse?sslmode=require
    sqlConnectionSsl: true,
    sqlDialectOptions: {
      ssl: { require: true },
    },
  },
}).then(({ port }) => console.log("LHCI listening on port", port));

I also tried using ssl: true and ?ssl=true but I get the same error

Expected behavior SSL connections are accepted by the server

Logs/Screenshots If applicable, add LHCI logs or screenshots to help explain your problem.

Environment (please complete the following information):

  • OS: macOS
  • Browser: NA
  • Version: NA

Additional context Add any other context about the problem here.

UsamaHameed avatar Jul 08 '22 09:07 UsamaHameed