OAUTH2 Problems

Поиск
Список
Период
Сортировка
От Francisco Cardoso
Тема OAUTH2 Problems
Дата
Msg-id VI1PR07MB44131E9FA5A301BC43168C6CD2959@VI1PR07MB4413.eurprd07.prod.outlook.com
обсуждение исходный текст
Ответы Re: OAUTH2 Problems  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Список 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

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Akshay Joshi
Дата:
Сообщение: Translators: Release next week
Следующее
От: Domenico Sgarbossa
Дата:
Сообщение: Re: Translators: Release next week