Re: pgadmin and keycloak

Hi Jose,

pgAdmin 4 supports keycloak for authentication. Is there any
error/difficulty while configuration?
Here is typical configuration for keycloak provider -

AUTHENTICATION_SOURCES = ['internal','oauth2']
OAUTH2_CONFIG = [

{ 'OAUTH2_NAME': 'keycloak',
'OAUTH2_DISPLAY_NAME': 'Login with Keycloak',
'OAUTH2_CLIENT_ID': '<keycloak client id>',
'OAUTH2_CLIENT_SECRET': '<client secret>',
'OAUTH2_TOKEN_URL': 'https://<keycloak server
ip:port>/realms/<realm_name>/protocol/openid-connect/token',
'OAUTH2_AUTHORIZATION_URL': 'https://<keycloak server
ip:port>/realms/<realm_name>/protocol/openid-connect/auth',

'OAUTH2_API_BASE_URL': None,
'OAUTH2_USERINFO_ENDPOINT': 'https://<keycloak server
ip:port>/realms/<realm_name>/protocol/openid-connect/userinfo',
'OAUTH2_SCOPE': 'openid',
'OAUTH2_USERNAME_CLAIM': None,
'OAUTH2_ICON': None,
'OAUTH2_BUTTON_COLOR': None,
'OAUTH2_SERVER_METADATA_URL': 'https://<keycloak server
ip:port>//realms/<realm_name>/.well-known/openid-configuration',
'OAUTH2_SSL_CERT_VERIFICATION': False
}]

Thanks,
Yogesh Mahajan
EnterpriseDB

On Mon, Jan 1, 2024 at 10:05 PM Jose M Barreiro <jmbarreiro(at)gmail(dot)com>
wrote:

> Hi,
>
> First of all, Happy New Year!!!!
>
> I have a problem with pgadmin and keycloak. We need to change our IDP,
> actually we are using okta and pgadmin is working fine with it.
>
> We need to configure pgadmin to use keycloak but it's not possible to
> configure pgadmin to work with keycloak.
>
> Can you help us to understand the reason?
>
> Best regards,
> Jose
>
>