question about pgAdmin on windows 7 client using a MIT Kerberos enabled Postgresql server - Mailing list pgadmin-support

From Michiel van Es
Subject question about pgAdmin on windows 7 client using a MIT Kerberos enabled Postgresql server
Date
Msg-id D08DE779-6312-4770-9C34-7C2F30DD00F9@pragmasec.nl
Whole thread Raw
List 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 by date:

Previous
From: Christoph Berg
Date:
Subject: Bug#797804: pgadmin3 segfaults after rightclick (fwd)
Next
From: Dave Page
Date:
Subject: pgAdmin v1.22.0 Beta 1 released