Hi
On Tue, Jul 8, 2014 at 5:23 PM, Colin Wright <colin.wri...@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:dp...@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.wri...@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 > > <http://www.thinkwhere.com> > > t: 01786 476060 (Office) > t: 01786 476083 (Direct Dial) > w:www.thinkwhere.com > > Glendevon House > Castle Business Park > Stirling FK9 4TZ > <https://twitter.com/thinkWhere1> > <http://www.linkedin.com/company/1509510?trk=companies_home_ycp_logo_forth-valley-gis> > > 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
