Re: Help with running pgadmin in a docker container

Note, I rolled back and used 6.21 of pgadmin...

pgadmin:

    container_name: pgadmin

    image: dpage/pgadmin4:6.21

    depends_on:

     - postgresdb

    environment:

     - PGADMIN_DEFAULT_PASSWORD=nottherealpassword

     - PGADMIN_DEFAULT_EMAIL=admin@domain.com

    ports:

     - "3004:80"

I still get an error, but this time the UX shows a red box lower right with the error...

"INTERNAL SERVER ERROR"

and then disappears.

again a whole load of 400 errors in the browser console.

The UX also doesn't show the "Servers" item under the "Browser" heading on the left hand menu.

Something not right. Would love some pointers as to how to get it working. I would imagine this would also fail for others as I am using a pretty standard container for both pgadmin and postgres.

Simon

---

From: Simon Thorpe <simon@thorpevillage.com>
Sent: Monday, May 15, 2023 5:40 PM
To: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
Subject: Help with running pgadmin in a docker container

 

Hi

I'm running a postgres server in a docker container and pgadmin in another docker container, i'm using a docker compose file to build them both. I am able to start both containers fine, I can access the pgadmin UI fine. I can login and add a new server, all seems well. I can see and navigate the postgres server via the pgadmin UX.

However, if I logout and back in, I cannot use the UX at all. The browser throws a lot of errors and I can't even re-add the server. Not sure what is going on. My environment is the following...

services:

  pgadmin:

    container_name: pgadmin

    image: dpage/pgadmin4

    depends_on:

     - postgresdb

    environment:

     - PGADMIN_DEFAULT_PASSWORD=nottherealpassword

     - PGADMIN_DEFAULT_EMAIL=admin@domain.com

    ports:

     - "3004:80"

  postgresdb:

    image: postgres:15

    container_name: postgresdb

    environment:

      - POSTGRES_DB=postgres

      - POSTGRES_PASSWORD=nottherealpassword

      - POSTGRES_USER=admin

    volumes:

     - postgresdb:/var/lib/postgresql/

volumes:

  postgresdb:

When I attempt to relogin, I can authenticate. But the browser throws the errors below. It hints that the local pgadmin database is corrupted (/var/lib/pgadmin/pgadmin4.db?).

Any clues as to how I get this working?

GET https://pgadmin.skyflash.co/browser/nodes/ 400

app.bundle.js?ver=70100:2 Uncaught (in promise) Error: Node Load Error...

    at app.bundle.js?ver=70100:2:2318033

    at s (app.bundle.js?ver=70100:2:2309094)

    at Generator.<anonymous> (app.bundle.js?ver=70100:2:2310431)

    at Generator.next (app.bundle.js?ver=70100:2:2309457)

    at y (app.bundle.js?ver=70100:2:2315084)

    at i (app.bundle.js?ver=70100:2:2315287)

POST https://pgadmin.skyflash.co/browser/master_password 400

GET https://pgadmin.skyflash.co/browser/check_corrupted_db_file 400

Error: Minified React error #31; visit https://reactjs.org/docs/error-decoder.html?invariant=31&args[]=Error%3A%20Request%20failed%20with%20status%20code%20400 for the full message or use the non-minified dev environment for full errors and additional helpful warnings.

    at xo (vendor.others.js?ver=70100:109:3096293)

    at vendor.others.js?ver=70100:109:3101114

    at Fs (vendor.others.js?ver=70100:109:3112100)

    at $a (vendor.others.js?ver=70100:109:3157983)

    at Tl (vendor.others.js?ver=70100:109:3143455)

    at kl (vendor.others.js?ver=70100:109:3143383)

    at El (vendor.others.js?ver=70100:109:3143246)

    at yl (vendor.others.js?ver=70100:109:3140233)

    at vendor.others.js?ver=70100:109:3089971

    at t.unstable_runWithPriority (vendor.others.js?ver=70100:109:3476540)

GET https://pgadmin.skyflash.co/misc/bgprocess/ 400

Error: Request failed with status code 400

    at e.exports (vendor.others.js?ver=70100:109:168712)

    at e.exports (vendor.others.js?ver=70100:109:171135)

    at XMLHttpRequest.v (vendor.others.js?ver=70100:109:164032)

Uncaught (in promise) Error: Minified React error #31; visit https://reactjs.org/docs/error-decoder.html?invariant=31&args[]=Error%3A%20Request%20failed%20with%20status%20code%20400 for the full message or use the non-minified dev environment for full errors and additional helpful warnings.

    at xo (vendor.others.js?ver=70100:109:3096293)

    at vendor.others.js?ver=70100:109:3101114

    at Fs (vendor.others.js?ver=70100:109:3112100)

    at $a (vendor.others.js?ver=70100:109:3157983)

    at Tl (vendor.others.js?ver=70100:109:3143455)

    at kl (vendor.others.js?ver=70100:109:3143383)

    at El (vendor.others.js?ver=70100:109:3143246)

    at yl (vendor.others.js?ver=70100:109:3140233)

    at vendor.others.js?ver=70100:109:3089971

    at t.unstable_runWithPriority (vendor.others.js?ver=70100:109:3476540)

POST https://pgadmin.skyflash.co/settings/store 400

Uncaught (in promise) Error: Request failed with status code 400

    at e.exports (vendor.others.js?ver=70100:109:168712)

    at e.exports (vendor.others.js?ver=70100:109:171135)

    at XMLHttpRequest.v (vendor.others.js?ver=70100:109:164032)