Re: pgAdmin Docker container: specify web URL path prefix?

From: Glen Bakeman <gbakeman(at)live(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Cc: Yogesh Mahajan <yogesh(dot)mahajan(at)enterprisedb(dot)com>
Subject: Re: pgAdmin Docker container: specify web URL path prefix?
Date: 2022-04-14 02:32:54
Message-ID: MW4PR17MB4513B69FEC2ADBA803669F68ABEF9@MW4PR17MB4513.namprd17.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-admin

For anyone watching this: I've made an issue
<https://redmine.postgresql.org/issues/7315> to track updating the docs.
If someone can give me the OK I'll go and get it done.

Glen

On 4/13/2022 11:40 AM, Glen Bakeman wrote:
>
> Of course! My docker labels are as follows:
>
> - "traefik.http.routers.pgadmin4.rule=Host(`host.example.com`) &&
> PathPrefix(`/pgadmin4`)"
> - "traefik.http.routers.pgadmin4.tls=true"
>
> This assumes that the chosen name for the instance is "pgadmin4",
> which is entirely up the user. The Host portion was necessary because
> Traefik will complain otherwise about a lack of specificity in the
> rule. I also added the .tls line since Traefik will only forward
> insecure requests without it (not sure why yet). Otherwise, Traefik is
> able to automatically identify the necessary port on the service to
> communicate with. I added the SCRIPT_NAME environment variable which
> seemed to be the key I was missing.
>
> Thanks again for your help,
>
> Glen
>
> On 4/12/2022 10:19 PM, Yogesh Mahajan wrote:
>> Glad to hear it!
>> Can you please share what additional steps are required?
>>
>> Thanks,
>> Yogesh Mahajan
>> EnterpriseDB
>>
>>
>> On Wed, Apr 13, 2022 at 7:49 AM Glen Bakeman <gbakeman(at)live(dot)com> wrote:
>>
>> Yogesh,
>>
>> Not only was my DuckDuckGo-fu failing me, I didn't even get to
>> the bottom of the page...
>>
>> I had to make a few small tweaks since I'm on Traefikv2, but I'd
>> be happy to update the documentation. Thank you for putting me in
>> the right direction!
>>
>> Glen
>>
>> On 4/11/2022 9:11 PM, Yogesh Mahajan wrote:
>>> Hi Glen,
>>>
>>> Please refer to the last point at this
>>> <https://www.pgadmin.org/docs/pgadmin4/6.8/container_deployment.html>
>>> web-page for hosting pgadmin4 under subdirectory with Traefik.
>>> Here is example when pgadmin4 is hosted under /pgadmin4/
>>> docker run --name"pgadmin4" \
>>> -e"PGADMIN_DEFAULT_EMAIL=user(at)domain(dot)com" \
>>> -e"PGADMIN_DEFAULT_PASSWORD=SuperSecret" \
>>> -e"SCRIPT_NAME=/pgadmin4" \
>>> -l"traefik.frontend.rule=PathPrefix:/pgadmin4" \
>>> -d dpage/pgadmin4
>>>
>>> Thanks,
>>> Yogesh Mahajan
>>> EnterpriseDB
>>>
>>>
>>> On Tue, Apr 12, 2022 at 6:23 AM Glen Bakeman <gbakeman(at)live(dot)com>
>>> wrote:
>>>
>>> Hi everyone,
>>>
>>> I'm getting into containerized hosting, and I'd like to
>>> setup the
>>> pgAdmin docker container with a reverse proxy (Traefik).
>>> Traefik
>>> supports Path Prefix proxying for services (i.e, I'd like to
>>> access
>>> pgAdmin at host.example.com/pgadmin/
>>> <http://host.example.com/pgadmin/>). The issue seems to be that
>>> pgAdmin automatically rewrites requests to
>>> host.example.com/login <http://host.example.com/login>, which
>>> breaks the proxy.
>>>
>>> I can't seem to find any options that allow us to specify
>>> the web path
>>> pgAdmin uses, from the perspective of configuring the docker
>>> container.
>>> Can anyone please confirm this?
>>>
>>> Thanks in advance,
>>>
>>> Glen
>>>
>>>
>>>

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Pradip Parkale 2022-04-14 03:12:09 Re: [pgAdmin][RM7308]: Server activity - Preserve sorting on refresh
Previous Message Glen Bakeman 2022-04-13 18:40:47 Re: pgAdmin Docker container: specify web URL path prefix?

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2022-04-14 19:19:38 query to show locked / disabled users?
Previous Message Glen Bakeman 2022-04-13 18:40:47 Re: pgAdmin Docker container: specify web URL path prefix?