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=ad...@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 <si...@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=ad...@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)
