search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.4k stars 632 forks source link

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

Open dmckay-thig opened 3 weeks ago

dmckay-thig commented 3 weeks ago

I have a postgres cluster running in AWS Aurora. We are trying to connect using Kerberos with pgadmin from a Windows client. When trying to connect we get "SSPI continuation error: The specified target is unknown or unreachable (80090303)". We have the host name right and logs reflect the failed login on the cluster. We are using AWS managed AD with a one way trust for authentication. This setup works with dbeaver using a krb5.ini file with all the realms in the file. Just not able to get pgadmin to work.

RohitBhati8269 commented 2 weeks ago

What steps did you follow to set up Kerberos with the pgAdmin4 desktop application on Windows? Your setup works with DBeaver, So are you creating a Kerberos ticket manually or is it using Windows default behavior for the Kerberos ticket?

dmckay-thig commented 2 weeks ago

For DBeaver we needed to create a KRB5.ini file that has all the realms in it. We have not come across anything showing that we need to create anything like that for pgAdmin.