Having trouble with connecting to database via kerberos

From: "Haskin, Daniel J" <DHaskin(at)verisk(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Having trouble with connecting to database via kerberos
Date: 2020-08-27 23:01:08
Message-ID: BYAPR13MB26000499D28D06BD39BA30C4D7550@BYAPR13MB2600.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello!

I wonder if you folks can help me. I am having the hardest time location documentation on, or otherwise figuring out how to connect to a Kerberos-authenticated database using pgAdmin in Amazon RDS.

I can connect to the database just fine with psql + kinit on linux, but the rest of my team is on Windows and pgAdmin.

How, in general, do you connect to a Kerberos-authenticated database from pgAdmin on Windows? I haven't been able to find the answer to this question.

In particular, I am connecting to a 12.3 pgsql database hosted on amazon RDS. No matter what I try, whenever I try to auth via Kerberos, I get this error:

SSPI continuation error: The specified target is unknown or unreachable
(80090303)

If I connect using a local pg user, the connection succeeds.
If I connect using kinit + psql on linux, the connection succeeds.
If I connect using the correct host endpoint, I get the error above.
If I connect using the AWS alternative method described here[1] of connecting to <endpoint>.<aws-ad-domain>, I *still* get the error above.

Is there anyone who can help?

1: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-kerberos-connecting.html

Daniel Haskin

________________________________

This email is intended solely for the recipient. It may contain privileged, proprietary or confidential information or material. If you are not the intended recipient, please delete this email and any attachments and notify the sender of the error.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Akshay Joshi 2020-08-28 03:34:28 Re: URGENT ACTION : Fatal Error with launching pgAdmn
Previous Message Jack Royal-Gordon 2020-08-27 14:43:49 Re: Critical bug: pgAdmin v4.25 has started ignoring my "Browser Command" which completely cripples me and makes me unable to manage my PostgreSQL database.