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 ?
On Wed, Oct 20, 2021 at 6:14 PM Rodrigo Mariano <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> > 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 >> - >> 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 >> - 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"
