Re: pgAdmin Docker container: specify web URL path prefix? - Mailing list pgsql-admin

From Glen Bakeman
Subject Re: pgAdmin Docker container: specify web URL path prefix?
Date
Msg-id MW4PR17MB45136D6BF73E622BDE40B093ABEC9@MW4PR17MB4513.namprd17.prod.outlook.com
Whole thread Raw
In response to pgAdmin Docker container: specify web URL path prefix?  (Glen Bakeman <gbakeman@live.com>)
Responses Re: pgAdmin Docker container: specify web URL path prefix?  (Glen Bakeman <gbakeman@live.com>)
List pgsql-admin

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@live.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 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@domain.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@live.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/). The issue seems to be that
pgAdmin automatically rewrites requests to 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



pgsql-admin by date:

Previous
From: Glen Bakeman
Date:
Subject: Re: pgAdmin Docker container: specify web URL path prefix?
Next
From: Glen Bakeman
Date:
Subject: Re: pgAdmin Docker container: specify web URL path prefix?