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

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/)?

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/)?
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
> <rodmariano13(at)gmail(dot)com <mailto: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
>> <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 <mailto: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 <mailto: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 <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=postgres(at)localhost(dot)com
>>> <mailto: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"