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

Re: [TESTERS] Location of certs -Windows 7 SSL mode?

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: [TESTERS] Location of certs -Windows 7 SSL mode?
Date: 2010-07-09 17:17:59
Message-ID: AANLkTilbrPYLnGxbjZEUfqe3pJOw3_SX15a3RJCIJkvD@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-testers
On Fri, Jul 9, 2010 at 04:58, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> wrote:
> On 8/07/2010 6:31 PM, Magnus Hagander wrote:
>>
>> On Thu, Jul 8, 2010 at 03:10, Craig Ringer<craig(at)postnewspapers(dot)com(dot)au>
>>  wrote:
>>>
>>> IIRC on Windows client certificates live in
>>>
>>>  %APPDATA%\.postgresql\
>>
>> That's a typo, it should be %APPDATA%\postgresql\ (no leading period).
>
> You're quite right. Sorry - I thought it used .postgresql as it does on
> *nix, but a quick test confirms that it's:
>
>  %APPDATA%\postgresql\postgresql.crt
>  %APPDATA%\postgresql\postgresql.key
>
>>>> (No one else here is using certs under Windows 7?)
>>>
>>> I use client certificates on Windows, but only via a Java app with JDBC,
>>> so I haven't been too worried about libpq's client cert handling.
>>
>> It'd be great if you can check that it works in your environment,
>> since you clearly have a working server-side and client-in-java env.
>> If it doesn't work for you, that's a whole lot of thinsg we can rule
>> out as the culprits then :-)
>
> I just set up a test, and it works fine with my win7 test box connecting to
> a Linux server that requires a client cert to permit connections.

Ok, that's good. Then we k now it's not a generic issue on Win7, but
must be something specific to the OP's problem.

Did you also, or could you also, test the connection parameters and/or
environment variables that tells libpq to look for the certificate in
a different location?


-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

pgsql-bugs by date

Next:From: Daniel GraceDate: 2010-07-09 17:56:13
Subject: Re: BUG #5548: ERROR: invalid attnum ## for rangetable entry on EXPLAIN VERBOSE, not on EXPLAIN
Previous:From: Bruce MomjianDate: 2010-07-09 16:59:26
Subject: Re: pg_upgrade issues

pgsql-testers by date

Next:From: Stefan WolfDate: 2010-07-13 08:50:49
Subject: pgAdmin 1.12.0 Beta 3 - Error viewing Server-Status
Previous:From: Craig RingerDate: 2010-07-09 02:58:25
Subject: Re: [TESTERS] Location of certs -Windows 7 SSL mode?

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