Postgres Pro
Downloads
Home   >   mailing lists

Re: pgadmin and keycloak - Mailing list pgadmin-support

From Yogesh Mahajan
Subject Re: pgadmin and keycloak
Date
Msg-id CAMa=N=N-zD9POxzEuHBrZDQdL+OxujS0wWd=gCPJNKqMNU6MAg@mail.gmail.com
Whole thread Raw
In response to pgadmin and keycloak  (Jose M Barreiro <jmbarreiro@gmail.com>)
Responses Re: pgadmin and keycloak  (Jose M Barreiro <jmbarreiro@gmail.com>)
List pgadmin-support
Tree view
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@gmail.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

pgadmin-support by date:

Previous
From: Yogesh Mahajan
Date:
Subject: Re: Advocate For Support
Next
From: Jose M Barreiro
Date:
Subject: Re: pgadmin and keycloak