Thread: PGAdmin Connectivity Issues
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,
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,
Hello Khushboo,
Yes, we are using Kerberos for postgres connections.
Thanks,
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
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,
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,
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,
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 IssuesEXTERNAL EMAILHi,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,