Re: pgadmin4 + SSH Tunnel

Поиск
Список
Период
Сортировка
От Akshay Joshi
Тема Re: pgadmin4 + SSH Tunnel
Дата
Msg-id CANxoLDdjhjo-xfGMKP=uqvP4zrtoiKCntMh6ZUVaPJuZUTigOQ@mail.gmail.com
обсуждение исходный текст
Ответ на pgadmin4 + SSH Tunnel  (Daryl Roche <droche@bcchr.ubc.ca>)
Ответы RE: pgadmin4 + SSH Tunnel
Список pgadmin-support
Дерево обсуждения
Hi Daryl

On Fri, Jul 13, 2018 at 5:35 AM, Daryl Roche <droche@bcchr.ubc.ca> wrote:
Hello,

I have no problem connecting without SSL to my postgresql server utilizing an ssh tunnel, but if I try to enable SSL for the postgresql db connection with verify-ca it doesn't work. I'm supplying the root certificate, but we don't use client certificates for authentication, only username/password. I'm able to get this same setup working in sqlworkbench, but for some reason, I'm not able to use SSL for the DB connection using verify-ca supplying only the root.crt. Do I need to be using client certificate authentication for SSL to work for the db connection.

    Can you please try following things:
  • Is that works without creating SSH Tunnel?
  • Try to connect using psql? If that works can you please create SSH Tunnel manually from command prompt and then try to connect DB using psql.     


Daryl Roche
Systems Administrator, Research IM.IT
BC Children's Hospital Research Institute
University of British Columbia
604-875-2345 x4648 | droche@bcchr.ubc.ca





--
Akshay Joshi
Sr. Software Architect


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

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