OAUTH2 Problems

From: Francisco Cardoso <francisco(dot)cardoso(at)datascience-service(dot)at>
To: "pgadmin-hackers(at)postgresql(dot)org" <pgadmin-hackers(at)postgresql(dot)org>
Cc: Martin Beno <martin(dot)beno(at)datascience-service(dot)at>
Subject: OAUTH2 Problems
Date: 2021-11-12 14:50:55
Message-ID: VI1PR07MB44131E9FA5A301BC43168C6CD2959@VI1PR07MB4413.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hello pgadmin hackers,

I have problems with the configuration of the oauth2 with azureAD.

It seems like the configuration is not applied as the display name is not applied. If I click on the OAUTH2 button I get the error “Please set the configuration parameters properly.” In the UI.

Here is my config:

Version: 6.1

config_local.py
```
OAUTH2_NAME = "azure"
OAUTH2_BUTTON_COLOR = "#3253a8"
OAUTH2_CLIENT_ID = "[ID]"
OAUTH2_DISPLAY_NAME = "Azure"
OAUTH2_TOKEN_URL = "https://login.microsoftonline.com/.../oauth2/v2.0/token"
OAUTH2_AUTHORIZATION_URL = "https://login.microsoftonline.com/.../oauth2/v2.0/authorize"
OAUTH2_CLIENT_SECRET = "[secret]"
OAUTH2_ICON = "fa-github"
OAUTH2_SCOPE = "User.Read email openid profile"
OAUTH2_API_BASE_URL = "https://graph.microsoft.com/"
OAUTH2_USERINFO_ENDPOINT = "profile"
MASTER_PASSWORD_REQUIRED = True
AUTHENTICATION_SOURCES = ['oauth2', 'internal']
CONSOLE_LOG_LEVEL = 10
```

I run the pgadmin in a container. Here is the docker-compose file I use:

```
# https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html
version: "3"
services:
pgadmin:
image: dpage/pgadmin4:6.1
restart: always
environment:
PGADMIN_DEFAULT_EMAIL: "[MAIL]"
PGADMIN_DEFAULT_PASSWORD: "[PASS]"
PGADMIN_LISTEN_PORT: "11111"
network_mode: host
volumes:
- "${PWD}/data:/var/lib/pgadmin"
- "${PWD}/servers.json:/pgadmin4/servers.json"
- "${PWD}/config_local.py:/pgadmin4/config_local.py"
```

I also tried before to set everything via env variable but same result. For completeness here is the yaml with the env set:

```
version: "3"
services:
pgadmin:
image: dpage/pgadmin4:6.1
restart: always
environment:
PGADMIN_DEFAULT_EMAIL: "[MAIL]"
PGADMIN_DEFAULT_PASSWORD: "[PASS]"
PGADMIN_LISTEN_PORT: "11111"
PGADMIN_CONFIG_USER_INACTIVITY_TIMEOUT: "10800"
PGADMIN_CONFIG_MAX_QUERY_HIST_STORED : "1000"
PGADMIN_CONFIG_AUTHENTICATION_SOURCES: "['oauth2', 'internal']"
PGADMIN_CONFIG_OAUTH2_NAME: "'azure'"
PGADMIN_CONFIG_OAUTH2_DISPLAY_NAME: "Azure"
PGADMIN_CONFIG_MASTER_PASSWORD_REQUIRED: "True"
PGADMIN_CONFIG_OAUTH2_TOKEN_URL: "'https://login.microsoftonline.com/…/oauth2/v2.0/token'"
PGADMIN_CONFIG_OAUTH2_AUTHORIZATION_URL: "'https://login.microsoftonline.com/…/oauth2/v2.0/authorize'"
PGADMIN_CONFIG_OAUTH2_API_BASE_URL: "'https://graph.microsoft.com/'"
PGADMIN_CONFIG_OAUTH2_USERINFO_ENDPOINT: " profile "
PGADMIN_CONFIG_OAUTH2_CLIENT_ID: “’[ID]’”
PGADMIN_CONFIG_OAUTH2_CLIENT_SECRET: "'[SECRET]'"
PGADMIN_CONFIG_OAUTH2_BUTTON_COLOR: "'#0000ff'"
PGADMIN_CONFIG_DEBUG: "True"
PGADMIN_CONFIG_CONSOLE_LOG_LEVEL: "10"
network_mode: host
volumes:
- "${PWD}/data:/var/lib/pgadmin"
- "${PWD}/servers.json:/pgadmin4/servers.json"
```

Am I missing something ? Thanks for the help.

Best,

Francisco

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Domenico Sgarbossa 2021-11-12 18:40:39 Re: Translators: Release next week
Previous Message Akshay Joshi 2021-11-12 14:33:10 Translators: Release next week