Re: pgadmin4 + SSH Tunnel

Hi Daryl

On Fri, Jul 13, 2018 at 5:35 AM, Daryl Roche <droche(at)bcchr(dot)ubc(dot)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(at)bcchr(dot)ubc(dot)ca
>
>
>

--
*Akshay Joshi*

*Sr. Software Architect *

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