SSL error: certificate verify failed when connection to Azure PostgreSQL

Vitalii 0 Reputation points
2024-08-30T08:43:07.9066667+00:00

Hi, I have faced SSL error: certificate verify failed error today, while everything worked correctly yesterday. I specify sslmode="require" and sslrootcert="/path/to/DigiCertGlobalRootG2.crt.pem".

I also tried BaltimoreCyberTrustRoot.crt.pem as specified here: https://video2.skills-academy.com/en-us/answers/questions/114381/failed-to-connect-to-azure-postgresql-with-ssl-ena - I am getting the same error.

What could happen and how to fix it?

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vitalii 0 Reputation points
    2024-08-30T09:46:22.61+00:00

    Ok, I have found that you need to use this one:

    https://www.microsoft.com/pkiops/certs/Microsoft%20RSA%20Root%20Certificate%20Authority%202017.crt

    And don't forget to do: openssl x509 -inform DER -in certificate.crt -out certificate.pem -outform PEM (certificate.crt is just the renamed file that you will download from URL above)

    Source: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/concepts-networking-ssl-tls#downloading-root-ca-certificates-and-updating-application-clients-in-certificate-pinning-scenarios

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.