question about pgAdmin on windows 7 client using a MIT Kerberos enabled Postgresql server

От: Michiel van Es
Тема: question about pgAdmin on windows 7 client using a MIT Kerberos enabled Postgresql server
Дата: ,
Msg-id: D08DE779-6312-4770-9C34-7C2F30DD00F9@pragmasec.nl
(см: обсуждение, исходный текст)
Список: pgadmin-support

Hello,

I got the following issue:

I am using the latest pgAdmin on OS X (El Capitan) and used the version included in the latest Postgres package from
enterpriseDB:http://www.enterprisedb.com/products-services-training/pgdownload (64 bit version) 

We are using kerberos auth on our postgresql servers using MIT kerberos.
For OS X this works without an issue using your received kerberos ticket.
For Windows 7 the same version does not seem to work and gives an error:

SSPI continuation error: No credentials are available in the security package

We are using MIT Kerberos Ticket Manager (kfw) and requesting a kerberos ticket from the MIT Kerberos server works
fine.
I also try to set it to GSSAPI and switched to SSPI using the system environment variables:

setx PGGSSLIB sspi /M
setx PGKRBSRVNAME postgres /M

I tried these settings reading a former issue:
http://grokbase.com/t/postgresql/pgsql-admin/089as0k65k/postgres-8-3-3-gssapi-and-windows-xpbut with no luck. 

So using the same pgAdmin version on OS X and using it’s native kerberos client works perfect with pgAdmin, using the
MITkerberos client on Windows and using the same pgAdmin version gives this error. 

Does anyone know how I can solve it or can I debug (aka strace) the pgAdmin.exe process on the windows client(I tried
usingps monitor) so I can perhaps see what is going wrong? 

Thanks for any help.

Cheers,

Michiel



В списке pgadmin-support по дате сообщения:

От: Michiel van Es
Дата:
Сообщение: question about pgAdmin on windows 7 client using a MIT Kerberos enabled Postgresql server
От: Dave Page
Дата:
Сообщение: pgAdmin v1.22.0 Beta 1 released