Skip site navigation (1) Skip section navigation (2)

Location of certs -Windows 7 SSL mode?

From: Lou Picciano <LouPicciano(at)comcast(dot)net>
To: pgsql-testers(at)postgresql(dot)org
Subject: Location of certs -Windows 7 SSL mode?
Date: 2010-07-06 23:37:46
Message-ID: 323E0FB3-767F-457F-A041-908B0A805C68@comcast.net (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-testers
[TEST REPORT]
[Release]: 9.0Beta2
[Test Type]: Testing connection - pgAdmin - using certificate on Windows 7 - Specifically, what is correct default placement of certs?
[Test]: Attempt to connect - SSL required or better - using standard AppData/Roaming location for certs, key.
[Platform]: Windows 7 Ultimate 64-bit - attempting connection using pgAdminIII as a test of SSL connectivity.
[Parameters]: First, attempted connection, with SSL required and NO certs, to determine default location based on error message!
[Failure]: Yes
[Results]: Installation of a pre-packaged PostgreSQL, using an installer (in this case a b1 packaged by EnterpriseDB), did create a postgresql folder in the expected location: C:\Users\<username>\AppData\Roaming\postgresql.  After placement of valid certs and key in this folder, cannot connect in any SSL mode.
Interestingly, the error message reverses the pathname delimiter, halfway through the message, from Windows-standard to UNIX-standard (is this relevant?)...
"Error connecting to the server: could not open certificate file "C:\Users\<username>\AppData\roaming/postgresql/potgresql.crt": No such file or directory.
[Comments]: Again, perhaps the joys of the Windows 'security' model?

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2010-07-07 01:34:51
Subject: Re: BUG #5542: Query optimization problem
Previous:From: Tom LaneDate: 2010-07-06 20:52:16
Subject: Re: ERROR: cannot handle unplanned sub-select

pgsql-testers by date

Next:From: Magnus HaganderDate: 2010-07-07 08:50:03
Subject: Re: [TESTERS] Location of certs -Windows 7 SSL mode?
Previous:From: Bruce MomjianDate: 2010-06-23 20:04:22
Subject: Re: [TESTERS] R: Postgresql 9.0b2 : pg_upgrade not passing username to pgdumpall ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group