pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruno Wolff III <bruno@wolff.to>
Cc: Victor Danilchenko <danilche@cs.umass.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Help with access control settings in pg_hba.conf --
Date: Fri, 28 Jan 2005 17:53:10 -0500
Message-ID: <27056.1106952790@sss.pgh.pa.us> (raw)
In-Reply-To: <20050127175733.GB23613@wolff.to>
References: <Pine.OSX.4.50.0501270949130.17513-100000@phobos.cs.umass.edu>
	<Pine.OSX.4.50.0501271014330.17513-100000@phobos.cs.umass.edu>
	<Pine.OSX.4.50.0501271126540.19131-100000@phobos.cs.umass.edu>
	<20050127175733.GB23613@wolff.to>

Bruno Wolff III <bruno@wolff.to> writes:
>   Victor Danilchenko <danilche@cs.umass.edu> wrote:
>> the solution was in disabling the 'result:encrypt' option
>> (setting it to 'no') in the /etc/identd.conf file.

> When you encrypt names for ident, the other host isn't supposed to be
> able to figure out who is making the request. If the remote site has
> a problem they can give the string back to the connecting site's admins
> and then they can figure out who is causing problems.

I have added a note to our SGML docs pointing out that this doesn't work.

In one sense it *should* not work, by design, since the whole point of
an encrypting ident server is to not let the remote side figure out the
real name of its user.  However, we already point out that

    [ident is] only appropriate for closed networks where each client
    machine is under tight control and where the database and system
    administrators operate in close contact. 

You could argue that in this scenario it is appropriate for the database
to have a copy of the encryption key that the client's ident server is
using, and then it would be just a small matter of programming to make
PostgreSQL accept encrypted responses.  I'm not sure it's worth the
trouble though.  One problem is that so far as I've been able to find,
there is not a recognized standard for the encryption transformation,
and so you might need different code for each ident server
implementation you deal with.  Also, at least some ident servers can
be configured to deliver encrypted responses to some questioners and
unencrypted responses to others --- so the simplest solution is to use
one of those and configure it to give cleartext responses to your
database server.

			regards, tom lane



view thread (7+ messages)  latest in thread

Message-ID: <27056.1106952790@sss.pgh.pa.us>
Permalink:  ../27056.1106952790@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/27056.1106952790@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, bruno@wolff.to, danilche@cs.umass.edu
  Subject: Re: Help with access control settings in pg_hba.conf --
  In-Reply-To: <27056.1106952790@sss.pgh.pa.us>
  References: <Pine.OSX.4.50.0501270949130.17513-100000@phobos.cs.umass.edu> <Pine.OSX.4.50.0501271014330.17513-100000@phobos.cs.umass.edu> <Pine.OSX.4.50.0501271126540.19131-100000@phobos.cs.umass.edu> <20050127175733.GB23613@wolff.to> <27056.1106952790@sss.pgh.pa.us>

* 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