Re: Docker TLS for PGAdmin - Mailing list pgadmin-support

Hi Omar,

The logs say there's insufficient permission given to the mapped volume - /private/var/lib/pgadmin. Please go through - https://www.pgadmin.org/docs/pgadmin4/4.23/container_deployment.html#mapped-files-and-directories once and make sure the requirements are satisfied.

On Fri, Jun 26, 2020 at 1:55 PM Omar Francis <omar.francis@branchbot.com> wrote:

Hi Aditya 

Please find the lovs below thanks :)



ubuntu@my-ip:~$ docker logs tender_goodall 
WARNING: Failed to set ACL on the directory containing the configuration database: [Errno 1] Operation not permitted: '/var/lib/pgadmin'
Traceback (most recent call last):
  File "run_pgadmin.py", line 4, in <module>
    from pgAdmin4 import app
  File "/pgadmin4/pgAdmin4.py", line 92, in <module>
    app = create_app()
  File "/pgadmin4/pgadmin/__init__.py", line 241, in create_app
    create_app_data_directory(config)
  File "/pgadmin4/pgadmin/setup/data_directory.py", line 40, in create_app_data_directory
    _create_directory_if_not_exists(config.SESSION_DB_PATH)
  File "/pgadmin4/pgadmin/setup/data_directory.py", line 16, in _create_directory_if_not_exists
    os.mkdir(_path)
PermissionError: [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
WARNING: Failed to set ACL on the directory containing the configuration database: [Errno 1] Operation not permitted: '/var/lib/pgadmin'
Traceback (most recent call last):
  File "/pgadmin4/setup.py", line 407, in <module>
    load_servers(args)
  File "/pgadmin4/setup.py", line 167, in load_servers
    app = create_app()
  File "/pgadmin4/pgadmin/__init__.py", line 241, in create_app
    create_app_data_directory(config)
  File "/pgadmin4/pgadmin/setup/data_directory.py", line 40, in create_app_data_directory
    _create_directory_if_not_exists(config.SESSION_DB_PATH)
  File "/pgadmin4/pgadmin/setup/data_directory.py", line 16, in _create_directory_if_not_exists
    os.mkdir(_path)
PermissionError: [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
sudo: setrlimit(RLIMIT_CORE): Operation not permitted
[2020-06-26 08:21:48 +0000] [1] [INFO] Starting gunicorn 19.9.0
[2020-06-26 08:21:48 +0000] [1] [INFO] Listening at: http://[::]:443 (1)
[2020-06-26 08:21:48 +0000] [1] [INFO] Using worker: threads
/usr/local/lib/python3.8/os.py:1023: RuntimeWarning: line buffering (buffering=1) isn't supported in binary mode, the default buffer size will be used
  return io.open(fd, *args, **kwargs)
[2020-06-26 08:21:48 +0000] [91] [INFO] Booting worker with pid: 91
[2020-06-26 08:21:49 +0000] [91] [ERROR] Exception in worker process
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/site-packages/gunicorn/arbiter.py", line 583, in spawn_worker
    worker.init_process()
  File "/usr/local/lib/python3.8/site-packages/gunicorn/workers/gthread.py", line 104, in init_process
    super(ThreadWorker, self).init_process()
  File "/usr/local/lib/python3.8/site-packages/gunicorn/workers/base.py", line 129, in init_process
    self.load_wsgi()
  File "/usr/local/lib/python3.8/site-packages/gunicorn/workers/base.py", line 138, in load_wsgi
    self.wsgi = self.app.wsgi()
  File "/usr/local/lib/python3.8/site-packages/gunicorn/app/base.py", line 67, in wsgi
    self.callable = self.load()
  File "/usr/local/lib/python3.8/site-packages/gunicorn/app/wsgiapp.py", line 52, in load
    return self.load_wsgiapp()
  File "/usr/local/lib/python3.8/site-packages/gunicorn/app/wsgiapp.py", line 41, in load_wsgiapp
    return util.import_app(self.app_uri)
  File "/usr/local/lib/python3.8/site-packages/gunicorn/util.py", line 350, in import_app
    __import__(module)
  File "/pgadmin4/run_pgadmin.py", line 4, in <module>
    from pgAdmin4 import app
  File "/pgadmin4/pgAdmin4.py", line 92, in <module>
    app = create_app()
  File "/pgadmin4/pgadmin/__init__.py", line 241, in create_app
    create_app_data_directory(config)
  File "/pgadmin4/pgadmin/setup/data_directory.py", line 40, in create_app_data_directory
    _create_directory_if_not_exists(config.SESSION_DB_PATH)
  File "/pgadmin4/pgadmin/setup/data_directory.py", line 16, in _create_directory_if_not_exists
    os.mkdir(_path)
PermissionError: [Errno 13] Permission denied: '/var/lib/pgadmin/sessions'
[2020-06-26 08:21:49 +0000] [91] [INFO] Worker exiting (pid: 91)
WARNING: Failed to set ACL on the directory containing the configuration database: [Errno 1] Operation not permitted: '/var/lib/pgadmin'
/usr/local/lib/python3.8/os.py:1023: RuntimeWarning: line buffering (buffering=1) isn't supported in binary mode, the default buffer size will be used
  return io.open(fd, *args, **kwargs)
[2020-06-26 08:21:49 +0000] [1] [INFO] Shutting down: Master
[2020-06-26 08:21:49 +0000] [1] [INFO] Reason: Worker failed to boot.

On 26 Jun 2020, at 06:53, Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi Omar,

I meant the "docker logs" command. Refer- https://docs.docker.com/engine/reference/commandline/logs/. Run "docker ps -a", grab the container id and user "docker logs <container id>".

On Thu, Jun 25, 2020 at 7:03 PM Omar Francis <omar.francis@branchbot.com> wrote:

Hi Aditya

Below is the output from when I run it in ubuntu. Moments after running docker ps the first time the container exits

ubuntu@my-ip:~$ docker run -p 443:443 -v /private/var/lib/pgadmin:/var/lib/pgadmin -v /etc/ssl/certs/server.cert:/certs/server.cert -v /etc/ssl/private/server.key:/certs/server.key -v /private/var/lib/pgadmin/servers.json:/pgadmin4/servers.json -e 'PGADMIN_DEFAULT_EMAIL=somebody@anyemail.com' -e 'PGADMIN_DEFAULT_PASSWORD=userpwd' -e 'PGADMIN_ENABLE_TLS=True' -d dpage/pgadmin4
f17b1525d62908a8440a3f8caa73c8442de077e652d311e44df6630f5cc3babd
ubuntu@my-ip:~$ docker ps
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS                          NAMES
f17b1525d629        dpage/pgadmin4      "/entrypoint.sh"    4 seconds ago       Up 3 seconds        80/tcp, 0.0.0.0:443->443/tcp   gracious_shockley
ubuntu@my-ip:~$ docker ps
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES
ubuntu@my-ip:~$

On 25 Jun 2020, at 11:25, Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:

Hi Omar,

Could you please share docker logs ? Might get something helpful there.

On Thu, Jun 25, 2020 at 3:29 PM Omar Francis <omar.francis@branchbot.com> wrote:

Hi am I emailing the right mailbox? Dave Page advised this was the correct channel for support on his image.

Regards

Omar

> On 22 Jun 2020, at 09:38, Omar Francis <omar.francis@branchbot.com> wrote:
>
> Hi all
>
> I am looking to run PGAdmin4 over TLS through a Docker container in a Ubuntu terminal. I have been able to run over a simple http connection but when I pass in the arguments below to set up TLS the container ID runs for several seconds before exiting.
>
> docker run -p 443:443 \
>    -v /private/var/lib/pgadmin:/var/lib/pgadmin \
>    -v /etc/ssl/certs/server.cert:/certs/server.cert \
>    -v /etc/ssl/private/server.key:/certs/server.key \
>    -v /private/var/lib/pgadmin/servers.json:/pgadmin4/servers.json \
>    -e 'PGADMIN_DEFAULT_EMAIL=user@email.com' \
>    -e 'PGADMIN_DEFAULT_PASSWORD=userpwd' \
>    -e 'PGADMIN_ENABLE_TLS=True' \
>    -d dpage/pgadmin4
>
> I have created the key, certificates required and am pointing to the correct directories. Would anyone who has connected through Docker be able to shed some light?
>
> Thanks

--

Thanks and Regards,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"

--

Thanks and Regards,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"

--

Thanks and Regards,

Aditya Toshniwal

pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune

"Don't Complain about Heat, Plant a TREE"