sipcapture / homer-app

HOMER 7.x Front-End and API Server
http://sipcapture.io
GNU Affero General Public License v3.0
204 stars 81 forks source link

Postgres SSL #514

Closed idanam-del closed 1 year ago

idanam-del commented 1 year ago

hey, what are the options of SSL the app can connect to postgres db node? and where are the settings for it?

i don't see it at the webconfig.json at /etc in github repo.

thank you

github-actions[bot] commented 1 year ago

Your report is appreciated. Please star this repository to motivate its developers! :star:

adubovikov commented 1 year ago

The param is ->

"usessl": true, or "sslmode": "require"

in the database section

idanam-del commented 1 year ago

what if the postgress require ca? or full ca? will it still work with the parameters? what's the location the app reads for certs?

adubovikov commented 1 year ago

https://github.com/sipcapture/homer-app/commit/7164f8c86bc850d13b600ca5c243911d176c48f7

"sslmode": "verify-full",
"sslrootcert": "root.crt ",
"sslkey":"client.key",
"sslcert":client.crt",