public inbox for [email protected]  

help / color / mirror / Atom feed

PGAdmin Connectivity Issues
4+ messages / 2 participants
[nested] [flat]

* PGAdmin Connectivity Issues
@ 2025-03-25 11:24  Ami Chovatiya <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Ami Chovatiya @ 2025-03-25 11:24 UTC (permalink / raw)
  To: [email protected] <[email protected]>

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

[email protected]<mailto:[email protected]>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PGAdmin Connectivity Issues
@ 2025-03-26 10:00  Khushboo Vashi <[email protected]>
  parent: Ami Chovatiya <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Khushboo Vashi @ 2025-03-26 10:00 UTC (permalink / raw)
  To: Ami Chovatiya <[email protected]>; +Cc: [email protected] <[email protected]>

Hi,

On Wed, Mar 26, 2025 at 3:05 PM Ami Chovatiya <[email protected]> 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
>
> [email protected] <[email protected]>
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PGAdmin Connectivity Issues
@ 2025-03-26 11:36  Ami Chovatiya <[email protected]>
  parent: Khushboo Vashi <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Ami Chovatiya @ 2025-03-26 11:36 UTC (permalink / raw)
  To: Khushboo Vashi <[email protected]>; +Cc: [email protected] <[email protected]>

Hello Khushboo,

Yes, we are using Kerberos for postgres connections.


Thanks,

Ami Chovatiya

CoStar Group

[email protected]<mailto:[email protected]>

________________________________
From: Khushboo Vashi <[email protected]>
Sent: Wednesday, March 26, 2025 6:00 AM
To: Ami Chovatiya <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: PGAdmin Connectivity Issues

EXTERNAL EMAIL
Hi,

On Wed, Mar 26, 2025 at 3:05 PM Ami Chovatiya <[email protected]<mailto:[email protected]>> 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

[email protected]<mailto:[email protected]>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PGAdmin Connectivity Issues
@ 2025-03-26 12:06  Khushboo Vashi <[email protected]>
  parent: Ami Chovatiya <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Khushboo Vashi @ 2025-03-26 12:06 UTC (permalink / raw)
  To: Ami Chovatiya <[email protected]>; +Cc: [email protected] <[email protected]>

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-7d969cd...

Thanks,
Khushboo

On Wed, Mar 26, 2025 at 5:07 PM Ami Chovatiya <[email protected]> wrote:

> Hello Khushboo,
>
> Yes, we are using Kerberos for postgres connections.
>
> Thanks,
>
> *Ami Chovatiya*
>
> CoStar Group
>
> [email protected] <[email protected]>
> ------------------------------
> *From:* Khushboo Vashi <[email protected]>
> *Sent:* Wednesday, March 26, 2025 6:00 AM
> *To:* Ami Chovatiya <[email protected]>
> *Cc:* [email protected] <
> [email protected]>
> *Subject:* Re: PGAdmin Connectivity Issues
>
> EXTERNAL EMAIL
> Hi,
>
> On Wed, Mar 26, 2025 at 3:05 PM Ami Chovatiya <[email protected]>
> 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
>
> [email protected] <[email protected]>
>
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2025-03-26 12:06 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-03-25 11:24 PGAdmin Connectivity Issues Ami Chovatiya <[email protected]>
2025-03-26 10:00 ` Khushboo Vashi <[email protected]>
2025-03-26 11:36   ` Ami Chovatiya <[email protected]>
2025-03-26 12:06     ` Khushboo Vashi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox