Re: SSL Mode in PGAdmin 1.18.1 - Mailing list pgadmin-support

Hi

On Tue, Jul 8, 2014 at 5:23 PM, Colin Wright <colin.wright@thinkwhere.com> wrote:

Hi Dave,

 

It is always either the version bundled with PG 9.3.x downloaded from http://www.enterprisedb.com/products-services-training/pgdownload#windows , or the stand-alone version from http://www.postgresql.org/ftp/pgadmin3/release/v1.18.1/win32/

 

When I do set up PGAdmin with a copy of the server certificate it does connect to the database OK, so at least some of the SSL functionality must be there.

 

OK, I checked the MSI package and the 32 and 64 bit PG installers from EDB. I see this issue on the 64bit EDB installer only - the others are all OK. 

Sandeep, can you look into this ASAP please - it's behaving as if PG_SSL isn't defined.

 

From: Dave Page [mailto:dpage@pgadmin.org]
Sent: 08 July 2014 16:52
To: Colin Wright
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] SSL Mode in PGAdmin 1.18.1

 

 

 

On Tue, Jul 8, 2014 at 4:42 PM, Colin Wright <colin.wright@thinkwhere.com> wrote:

Hi,

I’ve been trying to set up SSL connections to our postgres databases but I’m coming across some difficulties with the way the settings are working with the latest version of PGAdmin.  Can someone tell me if these are known bugs with the use of SSL in PGAdmin 1.18.1 (windows 7), and if there are any work-arounds?  

 

The SSL drop-down is empty which I assume is a bug? It had a list of options in previous versions.

 

When I try to connect to a database that forces SSL (using a self-signed certificate) it is failing to connect because of being unable to validate the certificate.    Does this mean that PGAdmin is defaulting to either  “verify-ca” or “verify-all” SSL option?  Is there any way of changing this to “require” instead so that I don’t need to set up the server certificate on every PC running PGAdmin (given that the drop-down doesn’t have any options)?

 

In PGAdmin 1.18.0 and earlier there was a list of SSL settings on the properties tab of the details pane for the connection, including whether or not you were using an encrypted connection.  Is this information still available somehow as it can be useful confirmation that you are using an encrypted connection?

 

Thanks in advance for any tips and advice you can provide

 

 

It sounds like your build has SSL disabled. Where did it come from?

 

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Colin Wright Principal Developer
t: 01786 476060 (Office) t: 01786 476083 (Direct Dial) w:www.thinkwhere.com	Glendevon House Castle Business Park Stirling FK9 4TZ

This email and its attachments are private and confidential. If you believe you have received this email in error, please contact the sender immediately on 01786 476060. If you are not the intended recipient, you may not rely on, use or disclose this email or any attachments in any way.

thinkWhere Limited does not accept any liability for any damage that may be caused to the recipient's system or data by this email or any attachments. Please note that our email system may be subject to random monitoring by us. This Company accepts no liability for personal emails.

thinkWhere is a limited company registered in Scotland with Registered Number SC315349 and having its Registered Office at Glendevon House, Castle Business Park, Stirling, FK9 4TZ.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company