Postgresql integration with Microsoft AD

From: Sandeep Sivashankaran <sasivash(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Postgresql integration with Microsoft AD
Date: 2024-04-15 07:09:25
Message-ID: CAP3Fzs_JKs1JvdSgca3SS5ZOyzJRjC+w4jMvudQstkeETeh=rA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am getting the below error while trying to connect to the postgres
database user with the AD account .We are using kerboros authentication...

DETAIL: Unspecified GSS failure. Minor code may provide more information:
Request ticket server <service principal> not found in keytab (ticket kvno
6)

We have created the service principal in the AD and also placed the keytab
file in the postgres db server.

We verified the kvno is the same in the service principal and the keytab
file..Also verified the service principal name in the keytab file using
ktutil command and it is the correct one..

What could be the reason for this error ?

Command trying to connect to the postgresql db :

psql -U <AD username> -h hostname -d postgres

The same AD user is created in the database also...

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Wagner 2024-04-15 09:03:41 Re: From CROSSTAB: One Column data with Two results columns
Previous Message M Sarwar 2024-04-14 20:54:19 From CROSSTAB: One Column data with Two results columns