pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tomas Pospisek <tpo2@sourcepole.ch>
To: pgsql-general@postgresql.org
Subject: can't get psql authentication against Active Directory working
Date: Sat, 18 Feb 2023 15:02:00 +0100
Message-ID: <08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch> (raw)

Hello all,

so I'm trying to authenticate psql (on Windows) -> postgres (on Linux) 
via Active Directory.

psql (Linux) -> postgres (Linux) with authentication against Active 
Directory does work.

However the same with psql.exe on Windows does not. I get:

     D:\>C:\OSGeo4W\bin\psql.exe service=the_db
     psql: error: connection to server at "dbserver.example.lan
     (192.168.4.104), port 5432 failed: could not initiate GSSAPI
     security context: No credentials were supplied, or the credentials
     were unavailable or inaccessible: Internal credentials cache error

psql.exe from the OSGeo4W QGIS Installer *does* include GSS support. (I 
have tried with a different psql.exe without GSS support and it would 
tell me that it does not support GSS).

The .pg_service.conf file in the users $HOME directory looks like this:

     [the_db]
     host=dbserver.example.lan
     port=5432
     user=user@EXAMPLE.LAN
     gssencmode=require

This same pg_service.conf does work for psql (Linux).

Also getting a Kerberos ticket for the service on Windows does work:

     D:\> klist get postgres/dbserver.example.lan@EXAMPLE.LAN
     [...]
     This will list the ticket

But when using psql.exe it will not get a ticket for the service nor 
will it apparently use the existing service ticket.

I have tried to trace psql.exe with Window's Process Monitor and I can't 
see it accessing no keytab file (I'm not sure whether a keytab file 
exists at all under Windows or if psql.exe doesn't instead need to 
access some Windows service). I see that psql.exe will open and close a 
TCP connection to dbserver.example.lan, however as far as I can see that 
connection is completely irrelevant for the aquisition of a Kerberos 
ticket for the service since that is a business purely between psql.exe 
and Active Directory or respectively between psql.exe and the 
credentials cache. And there is no other TCP connection being opened to 
anywhere from psql.exe.

What I find suspicious about the error above is "... the credentials 
were unavailable or inaccessible: Internal credentials cache error", 
since that looks like either psql.exe can't access the (inexisting) 
keytab file, or it can't access Window's Kerberos service.

Also, I see that psql.exe is trying to access a ccapiserver.exe which 
does not exist. Should psql.exe be able to access that ccapiserver.exe 
file? That means is the OSGeo4W QGIS installer, that also installs all 
things necessary for psql missing that ccapiserver.exe executable?

* has anybody ever succeeded in authenticating with psql.exe against 
Active Directory?
* can you maybe tell me what's wrong from the error message above?
* how can I proceed from here?

Thanks a lot for any pointers and/or help!!!
*t

PS: Any way to make GSS more talkative? At this moment all that I can 
get as logs is the above "computer says no".





view thread (10+ messages)  latest in thread

Message-ID: <08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch>
Permalink:  ../08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch/
Also on:    postgresql.org/message-id/08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: tpo2@sourcepole.ch
  Subject: Re: can't get psql authentication against Active Directory working
  In-Reply-To: <08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch>
  References: <08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox