Re: Problem related to volume creation to pgadmin 4 Docker image

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 <rodmariano13(at)gmail(dot)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 <rodmariano13(at)gmail(dot)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 <rodmariano13(at)gmail(dot)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=postgres(at)localhost(dot)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"