Connect to PostgreSQL via SSL

TJ_Moretto · October 17, 2018, 1:30pm

Hi - Is it possible to configure Orthanc to connect to PostgreSQL using SSL?

Not seeing any options in the JSON config. Other drivers I’ve used (Ruby), do it by default when required by the database.

I currently have an AWS PostgreSQL RDS instance that requires SSL, and am seeing the following error on startup:

jodogne · October 18, 2018, 7:22am

This feature has never been tested so far.

Please give a try by fine-tuning the “ConnectionUri” configuration option of the PostgreSQL plugins:
http://book.orthanc-server.com/plugins/postgresql.html

Sébastien-

TJ_Moretto · October 19, 2018, 3:54am

Thanks for the pointer - I forgot about the URL params. I tried adding sslmode=require, but I’m still getting an error.

Here’s the config:

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

And, the error message:

jodogne · October 19, 2018, 7:11am

I’ll try and give a look in the following weeks.

TJ_Moretto · October 19, 2018, 1:26pm

Thanks!