Hi Daryl
On Fri, Jul 13, 2018 at 5:35 AM, Daryl Roche <dro...@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 | dro...@bcchr.ubc.ca
>
>
>
--
*Akshay Joshi*
*Sr. Software Architect *
*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
