From: Erik Wienhold <ewie@ewie.name>
To: Tomas Pospisek <tpo2@sourcepole.ch>
To: pgsql-general@postgresql.org
Subject: Re: can't get psql authentication against Active Directory working
Date: Sat, 18 Feb 2023 17:16:12 +0100 (CET)
Message-ID: <1036920458.361352.1676736972050@office.mailbox.org> (raw)
In-Reply-To: <08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch>
References: <08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch>
> On 18/02/2023 15:02 CET Tomas Pospisek <tpo2@sourcepole.ch> wrote:
>
> 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).
On Windows the service file is not read from $home/.pg_service.conf but
$env:appdata/postgresql/.pg_service.conf (or %appdata%/postgresql/.pg_service.conf
when using cmd.exe.)
--
Erik
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: ewie@ewie.name, tpo2@sourcepole.ch
Subject: Re: can't get psql authentication against Active Directory working
In-Reply-To: <1036920458.361352.1676736972050@office.mailbox.org>
References: <08b836a7-272a-2309-da45-ac691fccacb8@sourcepole.ch> <1036920458.361352.1676736972050@office.mailbox.org>
* 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