Re: Running pgadmin4:5.5 behind reverse-proxy only shows progress indicator after successful login

From: Jörg Liebig <joliebig(at)gmail(dot)com>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Running pgadmin4:5.5 behind reverse-proxy only shows progress indicator after successful login
Date: 2021-08-12 07:06:31
Message-ID: CAEFuO3ZePR2Vwy0XY5qSLmGw6ZObCUa5AY9t9sfJRTXZb6vBiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Aditya,

The setting solved the problem and pgadmin works now. Thank you.

Best regards
Jörg Liebig

On Thu, Aug 12, 2021 at 8:58 AM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> Hi Jorg,
>
> Can you try setting - PGADMIN_CONFIG_ENHANCED_COOKIE_PROTECTION=False for
> docker env ?
>
> On Thu, Aug 12, 2021 at 11:06 AM Jörg Liebig <joliebig(at)gmail(dot)com> wrote:
>
>> Hi Aditya,
>>
>> No, I'm not getting any errors in browser developer tools. Besides the
>> effect I already mentioned before with the progress indicator, I'm getting
>> more 302 (see attachment) and redirection errors shown in the browser. This
>> happens during authentication at the login screen. Additionally, when
>> trying to login I get "CSRF tokens do not match" and the layout of the page
>> is disrupted (see attachment).
>>
>> What can I do?
>> Jörg Liebig
>>
>> On Thu, Aug 12, 2021 at 6:35 AM Aditya Toshniwal <
>> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>>
>>> Hi Jorg,
>>>
>>> Are you getting any console errors in browser developer tools ?
>>>
>>> On Wed, Aug 11, 2021 at 9:35 PM Jörg Liebig <joliebig(at)gmail(dot)com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I'm trying to run pgadmin in a Kubernetes cluster with the following
>>>> setup:
>>>> +-------+
>>>> | Vouch |
>>>> | Proxy |
>>>> +-^---+-+
>>>> | |
>>>> | |
>>>> +---------+ +-+---v---+ +-----------+
>>>> | Browser +--------> Reverse +------> /pgadmin4 |
>>>> | | | Proxy | | |
>>>> +---------+ +---------+ +-----------+
>>>> pgadmin runs in a container at endpoint /pgadmin4 behind a reverse
>>>> proxy using nginx (version 1.21.1). Proxy header X-Forwarded-* are set as
>>>> follows:
>>>> 1. X-Forwarded-For: $proxy_add_x_forwarded_for
>>>> 2. X-Forwarded-Proto: https
>>>> 3. X-Forwarded-Host: dev.<...>.com
>>>> 4. X-Forwarded-Port: 443
>>>> 5. X-Forwarded-Prefix: /pgadmin4
>>>> 6. X-Script-Name: /pgadmin4
>>>>
>>>> Vouch Proxy (version 0.32.0) checks client credentials via a configured
>>>> IDP.
>>>>
>>>> pgadmin itself is only configured with PGADMIN_DEFAULT_EMAIL and
>>>> PGADMIN_DEFAULT_PASSWORD and runs using port 80, which is also used in
>>>> nginx proxy configuration.
>>>>
>>>> After successful login I only see the progress indicator (see
>>>> attachment). Looking at browser developer tools I see that besides 200
>>>> status responses there are a lot of 302 responses too, e.g., 302 GET
>>>> dev.<...>.com /pgadmin4/browser
>>>>
>>>> Creating a port-forward in Kubernetes towards the /pgadmin4 container
>>>> works right away.
>>>>
>>>> I tried to modify the pgadmin environment according to
>>>> https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html#pgadmin-x-forwarded-configuration
>>>> by setting all values to "1". But it did not work. Furthermore, I don't
>>>> understand the purpose and possible configuration setups.
>>>>
>>>> What can I do?
>>>>
>>>> Thanks in advance
>>>> Jörg Liebig
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>> Thanks,
>>> Aditya Toshniwal
>>> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
>>> <http://edbpostgres.com>
>>> "Don't Complain about Heat, Plant a TREE"
>>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2021-08-12 07:26:38 Re: Running pgadmin4:5.5 behind reverse-proxy only shows progress indicator after successful login
Previous Message Aditya Toshniwal 2021-08-12 06:58:07 Re: Running pgadmin4:5.5 behind reverse-proxy only shows progress indicator after successful login