LDAP, single sign on from Windows client

From: chlor <hans(dot)schou(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: LDAP, single sign on from Windows client
Date: 2021-04-06 12:17:00
Message-ID: CAApBw35bJPAmKkPXNHyGtCgE6D6AAXiJmpYPe=d8A2_LJQ=3bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have a Linux server which is setup with authentication via LDAP against a
Windows A/D. In pg_hba I have
host ... ldap ldapserver=example.org ldapprefix="" ldapsuffix="@example.org"

The user is also created in PostgreSQL but without a password.
I can then login with psql from a Windows client with a user defined in the
AD.

But the problem is that psql asks for a password.
Is it possible to make a single sign-on without the password prompt?

The Linux (Ubuntu) has been joined to the domain with "realm" but it
doesn't seem to change anything.

best regards
Hans Schou

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2021-04-06 13:22:47 Re: Upgrade from 11.3 to 13.1 failed with out of memory
Previous Message Laurenz Albe 2021-04-06 08:46:08 Re: questions about wraparound