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

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/