Re: multiple Kerberos Server Principals from 1 instance of pgadmin

Поиск
Список
Период
Сортировка
От Ivan Novick
Тема Re: multiple Kerberos Server Principals from 1 instance of pgadmin
Дата
Msg-id CAPJXddaJUTQt2aZGcUjZd3AGK210zayCPif-qfJKn1_TMfwfkg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: multiple Kerberos Server Principals from 1 instance of pgadmin  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: multiple Kerberos Server Principals from 1 instance of pgadmin  (Stephen Frost <sfrost@snowman.net>)
Список pgadmin-support
Hi Stephen,

For greenplum database it would be gpadmin instead of postgres

PGKRBSRVNAME is typically either 'postgres' or 'POSTGRES', depending on
if you are dealing with Active Directory clients or not.  I agree that
it's theoretically possible that you might need to be able to configure
PGKRBSRVNAME on a per-server/cluster basis, but you definitely don't
need to be able to do so on a per-database basis and the PGKRBSRVNAME
has absolutely nothing to do with the user's username, nor the unix user
that the server actually runs as.

What, exactly, are you thinking that value would be set to?

Can you show what klist -k /path/to/keytab on the PG server returns?

 
You can see here a sample output that gpadmin is referenced.
klist -k /var/spool/keytabs/gpadmin

Keytab name: FILE:/var/spool/keytabs/gpadmin

KVNO Timestamp         Principal
---- ----------------- --------------------------------------------------------
   2 04/09/15 06:56:33 gpadmin/srv101.prd21.acme.com@is1.acme
   2 04/09/15 06:56:33 gpadmin/srv101.prd21.acme.com@is1.acme
   2 04/09/15 06:56:33 gpadmin/srv101.prd21.acme.com@is1.acme
   2 04/09/15 06:56:33 gpadmin/srv101.prd21.acme.com@is1.acme


What would help a lot is when setting up the Server properties in pgadmin4 if we could add a PGKRBSRVNAME variable so it can be different for each server.

Does that make sense?

If the idea makes sense and is agreed, i could probably find a developer that would be interested to help code it up and submit.

Thanks!
Ivan

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

Предыдущее
От: Pierre Ochsenbein
Дата:
Сообщение: pgAdmin Citrix
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: multiple Kerberos Server Principals from 1 instance of pgadmin