Using both ident and password in pg_hba.conf

Поиск
Список
Период
Сортировка
От D'Arcy J.M. Cain
Тема Using both ident and password in pg_hba.conf
Дата
Msg-id 20160509154428.0ab363bf@imp
обсуждение исходный текст
Ответы Re: Using both ident and password in pg_hba.conf  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Using both ident and password in pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Here's my situation.  I have a mix of users.  Some are running PHP
sites and some are not.  PHP runs as the web server owner, "nobody."
Everyone else runs as their own user.

Since the PHP sites run as nobody I want to require password but accept
ident (from the server I control) for the rest.  There does not appear
to be a way to specif that.  Here was one attempt:

host    all       nobody   192.168.151.75/32       password
host    all       all      192.168.151.75/32       ident

But that doesn't work.  The actual user according to ident is nobody
but the request is for a specific user.  As a result it isn't
recognized by the first line so it tries ident anyway and fails.

Is there any way to accomplish what I want?  Any help appreciated.

Cheers.

--
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 788 2246     (DoD#0082)    (eNTP)   |  what's for dinner.
IM: darcy@Vex.Net, VoIP: sip:darcy@druid.net


В списке pgsql-general по дате отправления:

Предыдущее
От: Christoph Berg
Дата:
Сообщение: Re: Ubuntu/Debian PGDP
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Using both ident and password in pg_hba.conf