Postgres Pro
Downloads
Home   >   mailing lists

Re: SSL connectivity issue from PGAdmin to Google Cloud SQL - Mailing list pgadmin-support

From Yogesh Mahajan
Subject Re: SSL connectivity issue from PGAdmin to Google Cloud SQL
Date
Msg-id CAMa=N=NWWrn6jau=N7oftJNo_AzTkBa6n2BVgn=5izTHpzOZhg@mail.gmail.com
Whole thread Raw
In response to SSL connectivity issue from PGAdmin to Google Cloud SQL  (Prashanth Golla <prashanth@modiface.com>)
List pgadmin-support
Tree view
Hi,

Error indicates the issue is with ssl certificates itself.
Can you please try connecting via terminal using these certificates?

Thanks,
Yogesh Mahajan
EnterpriseDB


On Thu, May 23, 2024 at 6:46 PM Prashanth Golla <prashanth@modiface.com> wrote:
Hi Support team,

We have hosted PGAdmin on Google cloud run and are able to successfully connect to google cloud sql server. We are enforcing ssl connection on google cloud sql for which we copied the ssl certs to pgadmin(1. using volume mounts on cloud run, 2. Added a simple Dockerfile to copy certs) and then we used ssl parameters from PGAdmin console and specified the respective paths for client cert, client key and server cert. 

We get the following error when we select SSL mode as verify-full

image.png


The following error when we choose SSL mode as require or verify-ca

image.png

Note: We tried both copying the certs to custom path i.e. /var/lib/pgadmin/certs and also the default path /var/lib/pgadmin/.postgresql/, neither of them works and we cannot update the path for client certs from pgadmin console

Could you please take a look and help us to troubleshoot?

Thanks,
Prashanth Golla
Attachment

pgadmin-support by date:

Previous
From: Prashanth Golla
Date:
Subject: SSL connectivity issue from PGAdmin to Google Cloud SQL
Next
From: Yogesh Mahajan
Date:
Subject: Re: SSL connectivity issue from PGAdmin to Google Cloud SQL