On Thu, Oct 21, 2021 at 12:27 PM Rodrigo Mariano <rodmarian...@gmail.com> wrote:
> Hi Aditya, > > According to the documentation, I need to change user and group of my host > folder to *5050:5050* through *chown*. > > If my default user and group is *rodrigo:rodrigo*, how could my default > user access a folder that belongs to another one (i.e. *5050:5050*)? > The pgAdmin processes in the container run under uid 5050, gid 5050. > > As far as I know, I cannot access a folder that belongs to other user > normally. > > Maybe should I add my default user (i.e. *rodrigo*) to pgadmin group > (i.e. *5050*)? > I've never needed to do that with plain Docker or Kubernetes. I've never used Docker Compose though. > If I should, I believe this information could be written on the > documentation. > > Thank you. > > Best regards, > Rodrigo > On 21/10/2021 02:06, Aditya Toshniwal wrote: > > Hi Rodrigo, > > pgAdmin just needs a readable and writable directory. pgAdmin cannot > change any permission on its own. It might be some other ownership issue on > your system then. > > On Wed, Oct 20, 2021 at 11:29 PM Rodrigo Mariano <rodmarian...@gmail.com> > wrote: > >> Hi Aditya, >> >> I did both. >> >> First, I changed the folder permissions to 5050:5050 and the Docker >> container worked, but I was not able to get into the folder; the folder is >> locked and I cannot access its subfolders, even through terminal. For >> example: >> >> After that, I tried using default permissions, however that error message >> appeared. >> >> Thank you. >> >> Best regards, >> Rodrigo >> On 20/10/2021 10:08, Aditya Toshniwal wrote: >> >> 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" >> >> > > -- > Thanks, > Aditya Toshniwal > pgAdmin Hacker | Software Architect | *edbpostgres.com* > <http://edbpostgres.com> > "Don't Complain about Heat, Plant a TREE" > > -- Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com
