Error: self signed certificate in certificate chain when connecting to TLS enabled Postgres instance with sslmode=prefer
#3185
-
The bugThis is a follow up to #902. I'm connecting to a Postgres database that uses TLS. I don't want to verify the CA, but I want to ensure that Immich connects to the Postgres cluster with SSL. The
The expected behaviour would be to use SSL but ignore the fact that the certificate is not trusted. The OS that Immich Server is running onKubernetes, Ubuntu 22 Version of Immich Server
Version of Immich Mobile Appn/a Platform with the issue
Your docker-compose.yml contentUsing https://github.com/immich-app/immich-charts/ v0.1.2 Your .env contentSee `DB_URL` above Reproduction steps1. Set up Postgres cluster with TLS with self-signed certificate
2. Try to connect Immich to it Additional informationNo response |
Beta Was this translation helpful? Give feedback.
Replies: 3 comments 8 replies
-
I realized there's a comment about "not requiring a CA certificate" in #902, but I can't figure out how I would go about configuring this.
|
Beta Was this translation helpful? Give feedback.
-
Hi @NiklasRosenstein . Can you share how do you passed |
Beta Was this translation helpful? Give feedback.
-
I'm also running into this problem and I haven't found a way to make it work. |
Beta Was this translation helpful? Give feedback.
If you want to accept self signed certificate, use sslmode=no-verify