Issue with Pgadmin4 Docker nginx reverse proxy

[Anbuselvam2001]

Issue with Pgadmin4 Docker nginx reverse proxy

[adityatoshniwal]

Some times login page load and some times login page not loading

Could you please share the apache2 sample conf file.

You said its already setup. Setting up reverse proxy is not pgAdmin scope. So you provide what I asked here #7479 (comment). You also shared your docker compose so I asked this - #7479 (comment).

Without this, we can't help you.

[khushboovashi]

@Anbuselvam2001, try the solution given here, https://serverfault.com/questions/1134033/strict-mime-type-checking-is-enabled-issue-with-pgadmin-in-azure-application-gat

[yogeshmahajan-1903]

@Anbuselvam2001
Can you please try accessing pgadmin in private/incognito browser?

[Anbuselvam2001]

@yogeshmahajan-1903 Thanks for your Response.

Am tried @yogeshmahajan-1903 . But am getting the below screen only

And also am getting the same console errors.

[Anbuselvam2001]

@yogeshmahajan-1903
Could you please guide me how to achieve the same in apache2 reverse proxy?

[adityatoshniwal]

Hi @Anbuselvam2001,
I'm trying to fix the issue you're getting in the console. Download the attached
render_page.html.zip
file, unzip it and follow the steps below:

1. Run docker ps and get the pgAdmin container id.
2. Run

docker cp <zip folder>/render_page.html <container id>:/pgadmin4/pgadmin/templates/security/

3. Run docker restart <container id>.
4. Try to access pgAdmin

[Anbuselvam2001]

Thanks for your Response @adityatoshniwal

I have two layer of reverse proxy http://localhost:5051/pgadmin4/login works as Expected. But Parent Reverse proxy is apache2 reverse proxy which is manage few web applications. once am try to access using dns way it was showing the above errors.
Could you please guide me how to resolve the below error

Refused to execute script from 'https://YYYYYY.com/pgadmin4/login?next=%2Fpgadmin4%2Fbrowser%2F' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.

[adityatoshniwal]

Hi @Anbuselvam2001,
Open the browser, open dev tools and go to network tab. Then open pgAdmin url and check the network url with security.pages.js. Share the response tab of the URL.

[Anbuselvam2001]

Some times login page load and some times login page not loading

Could you please share the apache2 sample conf file.

[Anbuselvam2001]

Here is my response of security.pages.js.

[adityatoshniwal]

Here is my response of security.pages.js. res.txt

I think this is a success case, I'll need the failure case.

[Anbuselvam2001]

Here is failure file

my security.pages.js.

failure.txt

[adityatoshniwal]

@Anbuselvam2001 What else is failing in the network tab? Can you also share endpoints.js.

[Anbuselvam2001]

Below response I get in endpoints.js

[adityatoshniwal]

Below response I get in endpoints.js

I think this is the issue. enpoints.js is not loading. Can you please share more details from the network tab for endpoints.js? Details like what is the complete URL of endpointjs, and where it is redirecting to - redirect URL.

[barrelltitor]

I have the same issue, but with a single layer of nginx proxy and I don't have pgadmin on a sub-location, it's on /

The js files get 302'd and never actually load in the browser

[adityatoshniwal]

I have the same issue, but with a single layer of nginx proxy and I don't have pgadmin on a sub-location, it's on /

The js files get 302'd and never actually load in the browser

Can you share you nginx config please?

[adityatoshniwal]

@Anbuselvam2001 Try adding below env to docker compose:

PGADMIN_CONFIG_PROXY_X_FOR_COUNT=2
PGADMIN_CONFIG_PROXY_X_PROTO_COUNT=2
PGADMIN_CONFIG_PROXY_X_HOST_COUNT=2
PGADMIN_CONFIG_PROXY_X_PORT_COUNT=2

[Anbuselvam2001]

@Anbuselvam2001 Try adding below env to docker compose:

PGADMIN_CONFIG_PROXY_X_FOR_COUNT=2
PGADMIN_CONFIG_PROXY_X_PROTO_COUNT=2
PGADMIN_CONFIG_PROXY_X_HOST_COUNT=2
PGADMIN_CONFIG_PROXY_X_PORT_COUNT=2

@adityatoshniwal I tried but getting the same.

[Anbuselvam2001]

@Anbuselvam2001, try the solution given here, https://serverfault.com/questions/1134033/strict-mime-type-checking-is-enabled-issue-with-pgadmin-in-azure-application-gat

@khushboovashi Thanks for your response. The above issue was Fixed.

[khushboovashi]

Closing the issue as the issue is fixed, confirmed by the user.