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

From: Michiel van Es <mve(at)pragmasec(dot)nl>
To: pgadmin-support(at)postgresql(dot)org
Subject: question about pgAdmin on windows 7 client using a MIT Kerberos enabled Postgresql server
Date: 2015-10-08 11:45:10
Message-ID: D08DE779-6312-4770-9C34-7C2F30DD00F9@pragmasec.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-xp but 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 MIT kerberos 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 using ps monitor) so I can perhaps see what is going wrong?

Thanks for any help.

Cheers,

Michiel

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2015-10-09 13:11:59 pgAdmin v1.22.0 Beta 1 released
Previous Message Dave Page 2015-10-05 14:30:09 Re: [PATCH] Fix EVT_STC_PAINTED recursion issue (Was: Re: Repaint lockup in ctlSQLBox::OnPositionStc on windows)