From: | Yogesh Mahajan <yogesh(dot)mahajan(at)enterprisedb(dot)com> |
---|---|
To: | Prashanth Golla <prashanth(at)modiface(dot)com> |
Cc: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Subject: | Re: SSL connectivity issue from PGAdmin to Google Cloud SQL |
Date: | 2024-05-24 04:02:45 |
Message-ID: | CAMa=N=NWWrn6jau=N7oftJNo_AzTkBa6n2BVgn=5izTHpzOZhg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)modiface(dot)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: image.png]
>
>
> The following error when we choose SSL mode as *require* or *verify-ca*
>
> [image: 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Yogesh Mahajan | 2024-05-27 04:36:17 | Re: SSL connectivity issue from PGAdmin to Google Cloud SQL |
Previous Message | Prashanth Golla | 2024-05-23 13:06:41 | SSL connectivity issue from PGAdmin to Google Cloud SQL |