Hi Rodrigo,
Did you run sudo chown -R 5050:5050 ./volumes/pgadmin4
and sudo chown -R 5050:5050 ./volumes/pgadmin4_storage
As per -
https://www.pgadmin.org/docs/pgadmin4/6.0/container_deployment.html#mapped-files-and-directories
<https://www.pgadmin.org/docs/pgadmin4/6.0/container_deployment.html#mapped-files-and-directories>
?
On Wed, Oct 20, 2021 at 6:14 PM Rodrigo Mariano
<rodmarian...@gmail.com
<mailto:rodmarian...@gmail.com>> wrote:
Hi Aditya,
I tried to create the volume to sub directory as
well (i.e.
//var/lib/pgadmin/storage/postgres_localhost.com
<http://postgres_localhost.com>/), but the same
error message appears.
I send below the traceback.
Thank you for your help.
Best regards,
Rodrigo
-
Traceback (most recent call last):
File
"/venv/lib/python3.8/site-packages/gunicorn/arbiter.py",
line 589, in spawn_worker
worker.init_process()
File
"/venv/lib/python3.8/site-packages/gunicorn/workers/gthread.py",
line 92, in init_process
super().init_process()
File
"/venv/lib/python3.8/site-packages/gunicorn/workers/base.py",
line 134, in init_process
self.load_wsgi()
File
"/venv/lib/python3.8/site-packages/gunicorn/workers/base.py",
line 146, in load_wsgi
self.wsgi = self.app.wsgi()
File
"/venv/lib/python3.8/site-packages/gunicorn/app/base.py",
line 67, in wsgi
self.callable = self.load()
File
"/venv/lib/python3.8/site-packages/gunicorn/app/wsgiapp.py",
line 58, in load
return self.load_wsgiapp()
File
"/venv/lib/python3.8/site-packages/gunicorn/app/wsgiapp.py",
line 48, in load_wsgiapp
return util.import_app(self.app_uri)
File
"/venv/lib/python3.8/site-packages/gunicorn/util.py",
line 359, in import_app
mod = importlib.import_module(module)
File "/usr/lib/python3.8/importlib/__init__.py",
line 127, in import_module
return _bootstrap._gcd_import(name[level:],
package, level)
File "<frozen importlib._bootstrap>", line 1014,
in _gcd_import
File "<frozen importlib._bootstrap>", line 991,
in _find_and_load
File "<frozen importlib._bootstrap>", line 975,
in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 671,
in _load_unlocked
File "<frozen importlib._bootstrap_external>",
line 848, in exec_module
File "<frozen importlib._bootstrap>", line 219,
in _call_with_frames_removed
File "/pgadmin4/run_pgadmin.py", line 4, in <module>
from pgAdmin4 import app
File "/pgadmin4/pgAdmin4.py", line 98, in <module>
app = create_app()
File "/pgadmin4/pgadmin/__init__.py", line 441,
in create_app
paths.init_app(app)
File "/pgadmin4/pgadmin/utils/paths.py", line
103, in init_app
raise InternalServerError(
werkzeug.exceptions.InternalServerError: 500
Internal Server Error: The user does not have
permission to read and write to the specified
storage directory.
On 20/10/2021 09:08, Aditya Toshniwal wrote:
Hi Rodrigo,
/var/lib/pgadmin/storage is the base directory. A
sub directory for each user will be created for
storing user files.
On Wed, Oct 20, 2021 at 5:10 PM Rodrigo Mariano
<rodmarian...@gmail.com
<mailto:rodmarian...@gmail.com>> wrote:
Hi,
I'm having a trouble related to pgadmin 4
Docker image
<https://hub.docker.com/r/dpage/pgadmin4>
<https://hub.docker.com/r/dpage/pgadmin4>.
I would like to create a volume to
//var/lib/pgadmin/storage/ folder, in order to
access backup files created by pgadmin 4
interface, however error messages about
permission denied are raised, for example:
werkzeug.exceptions.InternalServerError: 500
Internal Server Error: The user does not have
permission to read and write to the specified
storage directory.
Is there a way to create this volume?
I had to use a command to change user and
group of my volume to 5050:5050 (i.e. /sudo
chown -R 5050:5050 pgadmin4/), but now I'm not
able to get into the folder anymore, even when
I try creating a volume to
//var/lib/pgadmin/storage/ folder directly.
I send below my Docker compose file with
default values.
Thank you in advance.
Best regards,
Rodrigo
-
/docker-compose.yml/
version: '3'
services:
cdsr_postgis:
container_name: cdsr_postgis
image: kartoza/postgis:11.0-2.5
restart: on-failure
environment:
- POSTGRES_USER=postgres
- POSTGRES_PASS=postgres
- ALLOW_IP_RANGE=0.0.0.0/0
<http://0.0.0.0/0>
-
POSTGRES_MULTIPLE_EXTENSIONS=postgis,hstore,postgis_topology,pgrouting
volumes:
- ./volumes/postgresql:/var/lib/postgresql
networks:
- cdsr
ports:
- 6000:5432
cdsr_pgadmin4:
container_name: cdsr_pgadmin4
image: dpage/pgadmin4:5.4
restart: on-failure
environment:
-
PGADMIN_DEFAULT_EMAIL=postg...@localhost.com
<mailto:PGADMIN_DEFAULT_EMAIL=postg...@localhost.com>
- PGADMIN_DEFAULT_PASSWORD=postgres
volumes:
# to fix permission bugs:
# sudo chown -R 5050:5050 pgadmin4
- ./volumes/pgadmin4:/var/lib/pgadmin
-
./volumes/pgadmin4_storage:/var/lib/pgadmin/storage
networks:
- cdsr
depends_on:
- cdsr_postgis
ports:
- 6001:80
networks:
cdsr:
driver: bridge
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect |
*edbpostgres.com* <http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"
