Thanks Akshay, I’ve created https://redmine.postgresql.org/issues/3508 to track the problem.
From: Akshay Joshi [mailto:[email protected]] Sent: Monday, July 16, 2018 10:46 PM To: Daryl Roche <[email protected]> Cc: [email protected] Subject: Re: pgadmin4 + SSH Tunnel Hi Daryl On Mon, Jul 16, 2018 at 9:50 PM, Daryl Roche <[email protected]<mailto:[email protected]>> wrote: Both tests worked. I ended up having to create a client certificate to get pgadmin 4 to work. It would be great if I didn’t have to go that route as our dev environment doesn’t require the added security of managing client certificates. It’d be great if pgadmin 4 supported SSL with verify-ca without needing client certificates, and just the root certificate. Can you please create a RM @ https://redmine.postgresql.org/projects/pgadmin4/ From: Akshay Joshi [mailto:[email protected]<mailto:[email protected]>] Sent: Thursday, July 12, 2018 11:20 PM To: Daryl Roche <[email protected]<mailto:[email protected]>> Cc: [email protected]<mailto:[email protected]> Subject: Re: pgadmin4 + SSH Tunnel Hi Daryl On Fri, Jul 13, 2018 at 5:35 AM, Daryl Roche <[email protected]<mailto:[email protected]>> 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<http://IM.IT> BC Children's Hospital Research Institute University of British Columbia 604-875-2345 x4648 | [email protected]<mailto:[email protected]> -- Akshay Joshi Sr. Software Architect [http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png] Phone: +91 20-3058-9517 Mobile: +91 976-788-8246 -- Akshay Joshi Sr. Software Architect [http://www.enterprisedb.com/sites/default/files/EDB-logo-4c.png] Phone: +91 20-3058-9517 Mobile: +91 976-788-8246
