Bug 105 - Unable to connect to PostgreSQL database using SSL
Summary: Unable to connect to PostgreSQL database using SSL
Status: RESOLVED FIXED
Alias: None
Product: Orthanc
Classification: Unclassified
Component: Plugin - PostgreSQL (show other bugs)
Version: unspecified
Hardware: All All
: --- enhancement
Assignee: Sébastien Jodogne
URL:
Depends on:
Blocks:
 
Reported: 2020-06-29 15:14 CEST by Sébastien Jodogne
Modified: 2020-06-29 15:23 CEST (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Sébastien Jodogne 2020-06-29 15:14:27 CEST 
[BitBucket date: 2018-10-19.13:26:23]

Using the following config:


```
#!json

  "PostgreSQL" : {
    "EnableIndex" : true,
    "EnableStorage" : true,
    "ConnectionUri" : "postgresql://user:pwd@host:5432/orthanc?sslmode=require"
  }
```

Results in an error on startup:

> PostgreSQL error: sslmode value "require" invalid when SSL support is not compiled in
Comment 1 Sébastien Jodogne 2020-06-29 15:22:59 CEST 
[BitBucket user: Georg Grab]
[BitBucket date: 2018-12-20.10:54:17]

I'm running into this as well.
Comment 2 Sébastien Jodogne 2020-06-29 15:23:31 CEST 
[BitBucket user: Sébastien Jodogne]
[BitBucket date: 2019-01-10.11:54:12]

This is issue is resolved by the following changeset: https://hg.orthanc-server.com/orthanc-databases/changeset/16df1a6ea452f324454d3f7b52a6bea3823db4d0