pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon de Hartog <simon@dehartog.nl>
To: pgsql-admin@postgresql.org
Subject: Postgres using SSL connections
Date: Thu, 25 Aug 2005 20:27:18 +0200
Message-ID: <430E0D86.7020602@dehartog.nl> (raw)

Hi,

I want to have Postgres use an SSL certificate for secure access by
clients over the internet. I have a server that runs PostgreSQL and I
have created my own Certificate Authority. I now have a certificate and
corresponding private key in /etc/ssl. This pair is used without
problems by:
- Apache 2
- LDAP server
- Sendmail
- stunnel
- VPN software

I have added all the users these applications run as to a group called
"ssl". Permissions on the private key are owned by root, group ssl,
protection rw-r----- (640). When I tell PostgreSQL to use this key with
certificate (by using symlinks from server.key and server.crt in the
postgreSQL data dir) it tells me that owner and permissions are wrong.

It seems to me that they are only "wrong" by PostgreSQL's opinion. How
can I use this certificate and key for PostgreSQL (without copying the
key and changing owner and permissions etc, because then the whole idea
of centrally coordinated certificates is gone)?

I checked the archives. A lot of comments considering the unclear error
messages in previous versions, this has been solved IMHO. Also some
comments and patches to remove these checks, concluded by comments that
they must remain. All in all, it still doesn't work for my situation.
Would it be nice to have a configuration-file option to disable these
checks? Maybe possibly even configurable locations of these files,
instead of the defaults in the PostgreSQL data dir?

Kind regards and thanks in advance,

Simon de Hartog
-- 
"From every point in life, there's a road that leads to where you
  want to go."

E: simon <at-sign> dehartog <point> nl
W: http://simon.dehartog.nl/
P: +31-6-15094709
M: simon_net <at-sign> rootsr <point> com
I: 8714776
K: http://www.rootsr.com/simon.crt



Message-ID: <430E0D86.7020602@dehartog.nl>
Permalink:  ../430E0D86.7020602@dehartog.nl/
Also on:    postgresql.org/message-id/430E0D86.7020602@dehartog.nl

 · 

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-admin@postgresql.org
  Cc: simon@dehartog.nl
  Subject: Re: Postgres using SSL connections
  In-Reply-To: <430E0D86.7020602@dehartog.nl>
  References: <430E0D86.7020602@dehartog.nl>

* 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