Skip to content

PostgreSQL URI connection strict ?sslmode=require should enable dialectOptions.ssl=true #10015

@ceefour

Description

@ceefour

What are you doing?

"use_env_variable": "POSTGRESQL_URI" in config.json

The POSTGRESQL_URI contains ?sslmode=require as described in official libpq: https://www.postgresql.org/docs/9.3/static/libpq-ssl.html

(alternative to require: verify-ca and verify-full)

What do you expect to happen?

sequelize connects via SSL, i.e. implicitly sets dialectOptions.ssl=true

What is actually happening?

sequelize connects regularly.

Workaround is to set dialectOptions.ssl=true manually, however correct behavior is that this can be set from env variable.

Note: This is related to previous issues #9712, #6932, #5891,

Dialect: postgresql
Dialect version: 7.5.0
Database version: 10
Sequelize version: 4.39.0
Tested with latest release: Yes, 4.39.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    type: featureDEPRECATED: replace with the "feature" issue type

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions