SSL connectivity issue from PGAdmin to Google Cloud SQL

Поиск
Список
Период
Сортировка
От Prashanth Golla
Тема SSL connectivity issue from PGAdmin to Google Cloud SQL
Дата
Msg-id CANMZC=rHHKp6uUtORGC9ZhMvbcagFdHERy09DGwtTXDfYBV=BA@mail.gmail.com
обсуждение исходный текст
Ответы Re: SSL connectivity issue from PGAdmin to Google Cloud SQL
Список pgadmin-support
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
Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: Yogesh Mahajan
Дата:
Сообщение: Re: Groups for local users pgadmin4
Следующее
От: Yogesh Mahajan
Дата:
Сообщение: Re: SSL connectivity issue from PGAdmin to Google Cloud SQL