Thread: PGAdmin Connectivity Issues

PGAdmin Connectivity Issues

From
Ami Chovatiya
Date:
Hello,

I hope this email finds you well!

We have a few engineers using pgadmin for postgres access, and they are running into the error below. 

Connection failed: connection to server at "100.64.1.5", port 5432 failed: FATAL: KERB_VALIDATION_INFO::UserFlags has USER_FLAGS_EXTRA_SIDS set, but there are no ExtraSids.

Please note that this error is only getting thrown for two users at the moment; everyone else can connect. From a system's perspective, all permissions align for the users that have access.

Would you be able to share what causes this error to get generated and what the solution is? 

Thanks,

Ami Chovatiya

CoStar Group

achovatiya@costar.com

Re: PGAdmin Connectivity Issues

From
Khushboo Vashi
Date:
Hi,

On Wed, Mar 26, 2025 at 3:05 PM Ami Chovatiya <achovatiya@costar.com> wrote:
Hello,

I hope this email finds you well!

We have a few engineers using pgadmin for postgres access, and they are running into the error below. 

Connection failed: connection to server at "100.64.1.5", port 5432 failed: FATAL: KERB_VALIDATION_INFO::UserFlags has USER_FLAGS_EXTRA_SIDS set, but there are no ExtraSids.

Are you using Kerberos for Postgres connection?
 
Please note that this error is only getting thrown for two users at the moment; everyone else can connect. From a system's perspective, all permissions align for the users that have access.

Would you be able to share what causes this error to get generated and what the solution is? 

Thanks,

Ami Chovatiya

CoStar Group

achovatiya@costar.com

Re: PGAdmin Connectivity Issues

From
Ami Chovatiya
Date:
Hello Khushboo,

Yes, we are using Kerberos for postgres connections. 

Thanks,

Ami Chovatiya

CoStar Group

achovatiya@costar.com


From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Sent: Wednesday, March 26, 2025 6:00 AM
To: Ami Chovatiya <achovatiya@costar.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: PGAdmin Connectivity Issues
 
EXTERNAL EMAIL
Hi,

On Wed, Mar 26, 2025 at 3:05 PM Ami Chovatiya <achovatiya@costar.com> wrote:
Hello,

I hope this email finds you well!

We have a few engineers using pgadmin for postgres access, and they are running into the error below. 

Connection failed: connection to server at "100.64.1.5", port 5432 failed: FATAL: KERB_VALIDATION_INFO::UserFlags has USER_FLAGS_EXTRA_SIDS set, but there are no ExtraSids.

Are you using Kerberos for Postgres connection?
 
Please note that this error is only getting thrown for two users at the moment; everyone else can connect. From a system's perspective, all permissions align for the users that have access.

Would you be able to share what causes this error to get generated and what the solution is? 

Thanks,

Ami Chovatiya

CoStar Group

achovatiya@costar.com

Re: PGAdmin Connectivity Issues

From
Khushboo Vashi
Date:
Hello,

It looks like it has something to do with your Kerberos user login issue; it's not a pgAdmin issue. The error suggests an ExtraSids misconfiguration, which is part of the Kerberos validation info structure.
Refer: https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-pac/69e86ccc-85e3-41b9-b514-7d969cd0ed73

Thanks,
Khushboo

On Wed, Mar 26, 2025 at 5:07 PM Ami Chovatiya <achovatiya@costar.com> wrote:
Hello Khushboo,

Yes, we are using Kerberos for postgres connections. 

Thanks,

Ami Chovatiya

CoStar Group

achovatiya@costar.com


From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Sent: Wednesday, March 26, 2025 6:00 AM
To: Ami Chovatiya <achovatiya@costar.com>
Cc: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Re: PGAdmin Connectivity Issues
 
EXTERNAL EMAIL
Hi,

On Wed, Mar 26, 2025 at 3:05 PM Ami Chovatiya <achovatiya@costar.com> wrote:
Hello,

I hope this email finds you well!

We have a few engineers using pgadmin for postgres access, and they are running into the error below. 

Connection failed: connection to server at "100.64.1.5", port 5432 failed: FATAL: KERB_VALIDATION_INFO::UserFlags has USER_FLAGS_EXTRA_SIDS set, but there are no ExtraSids.

Are you using Kerberos for Postgres connection?
 
Please note that this error is only getting thrown for two users at the moment; everyone else can connect. From a system's perspective, all permissions align for the users that have access.

Would you be able to share what causes this error to get generated and what the solution is? 

Thanks,

Ami Chovatiya

CoStar Group

achovatiya@costar.com