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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-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

Browse pgsql-bugs by date

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

Browse pgsql-testers by date

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