pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rob Cherry <postgresadmin@lxrb.com>
To: pgsql-admin@postgresql.org
Subject: Multiple auth types for a connection
Date: Wed, 02 May 2007 16:22:51 -0400
Message-ID: <1178137371.17100.6.camel@sphere.lxrb.com> (raw)

Hi,

I am operating in an environment where we have regular users who will
authenticate via PAM and software users for automated processes that
would be more appropriate to authenticate via a password (encrypted or
not - irrelevant to this question).  I have taken a look through the
documentation and google and done some trial and error, but I dont seem
to be able to get this working for a single client to be able to use
either method.

My 2 guesses involved changing the $PGDATA$/pg_hba.conf to try these
options:

1:
host    all         all         0.0.0.0/0             pam,password

(also tried space seperated as well as comma seperated)

2:
host    all         all         0.0.0.0/0             pam
host    all         all         0.0.0.0/0             password

In both cases (neither caused an error) the first type wins and the
other gives access denied.

Does anyone know if it is possible to overload auth types like this such
that if pam fails password would be tried?

Many thanks in advance,

Rob Cherry








view thread (3+ messages)  latest in thread

Message-ID: <1178137371.17100.6.camel@sphere.lxrb.com>
Permalink:  ../1178137371.17100.6.camel@sphere.lxrb.com/
Also on:    postgresql.org/message-id/1178137371.17100.6.camel@sphere.lxrb.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: postgresadmin@lxrb.com
  Subject: Re: Multiple auth types for a connection
  In-Reply-To: <1178137371.17100.6.camel@sphere.lxrb.com>

* 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