pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Craig Ringer <craig@postnewspapers.com.au>
To: Magnus Hagander <magnus@hagander.net>
Cc: pgsql-bugs <pgsql-bugs@postgresql.org>
Subject: Re: [TESTERS] Location of certs -Windows 7 SSL mode?
Date: Fri, 09 Jul 2010 10:58:25 +0800
Message-ID: <4C369051.3030308@postnewspapers.com.au> (raw)
In-Reply-To: <AANLkTimwiP-xdlBbA5E_nfjiCYK0yKwnDYSs63ZjkX23@mail.gmail.com>
References: <1808543951.199438.1278512926661.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
	<4C352585.40206@postnewspapers.com.au>
	<AANLkTimwiP-xdlBbA5E_nfjiCYK0yKwnDYSs63ZjkX23@mail.gmail.com>

On 8/07/2010 6:31 PM, Magnus Hagander wrote:
> On Thu, Jul 8, 2010 at 03:10, Craig Ringer<craig@postnewspapers.com.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.

--
Craig Ringer



view thread (9+ messages)  latest in thread

Message-ID: <4C369051.3030308@postnewspapers.com.au>
Permalink:  ../4C369051.3030308@postnewspapers.com.au/
Also on:    postgresql.org/message-id/4C369051.3030308@postnewspapers.com.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-testers@postgresql.org
  Cc: craig@postnewspapers.com.au, magnus@hagander.net, pgsql-bugs@postgresql.org
  Subject: Re: [TESTERS] Location of certs -Windows 7 SSL mode?
  In-Reply-To: <4C369051.3030308@postnewspapers.com.au>
  References: <1808543951.199438.1278512926661.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> <4C352585.40206@postnewspapers.com.au> <AANLkTimwiP-xdlBbA5E_nfjiCYK0yKwnDYSs63ZjkX23@mail.gmail.com> <4C369051.3030308@postnewspapers.com.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox