Re: SSL certificates issue

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: Asia <asia123321(at)op(dot)pl>
Cc: " " <pgsql-general(at)postgresql(dot)org>
Subject: Re: SSL certificates issue
Date: 2011-09-07 13:32:28
Message-ID: 8d5ed95a5242ec6dc639d24ff94d490d@mail.softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 07 Sep 2011 13:49:30 +0200, Asia wrote:
>>
>> I think problem is as follows, server sends to client certificates
>> it
>> can accept (as accepted parents), without intermediate CA, Java sees
>> only top-level cert and tries to find client cert issued directly by
>> top-level CA, I may only assume, that without intermediate CA you
>> will
>> be able to auth against any cert signed by top-level CA (this may
>> cause
>> small security hole as well).
>>
>> I think this is not needed, but I suggest You too check cert
>> "policies"
>> with v3 extensions.
>>
>> Java is really pedantic, about security.
>>
>> Regards,
>> Radek
>>
>
>
> The problem is that I believe that this configuration could be better
> but I cannot put part
> of CA chain in root.crt as it was advised.
> For Java it all depends on current SSL Factory implementation, I was
> using the default one.
> If I wrote my own implementation I would probably be able to have
> common with libpq,
> requiring the least info, configuration (but actually I would prefer
> to avoid it).
>
> Kind regards,
> Joanna

I personally haven't tired SSL for PostgreSQL but, I think, You should
put in root.crt only intermediate certificate (C1 - from prev post), so
all and only all "sub-certs" of intermediate CA will be able to
establish connection (paranoic security).

Putting intermediate CAs as trusted in Java keystore may be solution,
but I'm not sure if in situation of cert invalidation, such cert will be
rejected.

If you want to write SSL Factory, you should re-implement KeyManager
only, to give ability of extended search.

Regards,
Radek

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-09-07 13:59:41 Re: SSL certificates issue
Previous Message Alex Lai 2011-09-07 12:28:12 Re: Demoting master to slave without an rsync...is it safe?