Hello I want to connect to Azure Postgresql Flexible server using PgAdmin4 and using Entra ID group. I followed the steps from: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/how-to-configure-sign-in-azure-ad-authentication My Entra ID user account is owner of this Entra ID group. I'm using my token when prompted for password got by command az account get-access-token --resource https://ossrdbms-aad.database.windows.net at the end i got error: Maybe someone is using entra id group login and can help with that? I can login using my personal entra id with success but not as member of entra id group.

Hi Radek , Welcome to Microsoft Q&A forum. As I understand, you are getting error in Microsoft Entra ID for authentication with Azure Database for PostgreSQL fatal no pg_hba.conf entry for host. Is this the first time you are trying to connect or earlier it worked, and it is failing now? If first time, then please try restarting the server as mentioned here: https://video2.skills-academy.com/en-us/azure/postgresql/single-server/how-to-restart-server-portal Try in the Azure Portal change require_secure_transport from server parameters to OFF . Let us know if this helped. Awaiting your reply. Thanks

How to connect to azure postgresql flexible server using Microsoft Entra group

Radek 1

Hello

I want to connect to Azure Postgresql Flexible server using PgAdmin4 and using Entra ID group. I followed the steps from:

https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/how-to-configure-sign-in-azure-ad-authentication

entragroup

My Entra ID user account is owner of this Entra ID group.

pggroup

I'm using my token when prompted for password got by command

az account get-access-token --resource https://ossrdbms-aad.database.windows.net

token

at the end i got error:

error

Maybe someone is using entra id group login and can help with that?

I can login using my personal entra id with success but not as member of entra id group.

Radek 1 Reputation point

2024-09-03T11:14:39.6033333+00:00

Hello

Thank you for you answer, but i'm using azure postgresql flexible server and you provided info to single server.

It's first time, i setup new postgresql flexible server and tried to configure this kind of authentication but it's not working. Works only when authenticate with user Microsoft Entra ID.

update:

connection failed: connection to server at "xxx", port 5432 failed: FATAL: password authentication failed for user "postgresqlgr@xxx" connection to server at "xxx", port 5432 failed: FATAL: password authentication failed for user "postgresqlgr@xxx"

when i set require_secure_transport from server parameters to OFF one of the error gone. Left only one with password.

According to the documentation: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/concepts-azure-ad-authentication

What's the difference between group login and individual login?

The only difference between signing in as a Microsoft Entra group member and signing in as an individual Microsoft Entra user lies in the username. Signing in as an individual user requires an individual Microsoft Entra user ID. Signing in as a group member requires the group name. In both scenarios, you use the same individual Microsoft Entra token as the password.

and this is exatly what i'm doing.
ShaktiSingh-MSFT 15,056 Reputation points

2024-09-04T06:15:50.4233333+00:00

Hi Radek,

This is strange and not expected. I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks

1 answer

ShaktiSingh-MSFT 15,056 Reputation points

2024-09-03T10:16:51.5266667+00:00

Hi Radek,

Welcome to Microsoft Q&A forum.

As I understand, you are getting error in Microsoft Entra ID for authentication with Azure Database for PostgreSQL fatal no pg_hba.conf entry for host.

Is this the first time you are trying to connect or earlier it worked, and it is failing now?

If first time, then please try restarting the server as mentioned here:

https://video2.skills-academy.com/en-us/azure/postgresql/single-server/how-to-restart-server-portal

Try in the Azure Portal change require_secure_transport from server parameters to OFF.

Let us know if this helped.

Awaiting your reply.

Thanks
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to connect to azure postgresql flexible server using Microsoft Entra group

1 answer

Your answer