Hi Aditya Yes I can get a regular http connection with myip:80 when I run:
docker run -p 80:80 -e 'PGADMIN_DEFAULT_EMAIL=someb...@anyemail.com' -e 'PGADMIN_DEFAULT_PASSWORD=userpwd' -e 'PGADMIN_ENABLE_TLS=True' -d dpage/pgadmin4 I was able to do this last week when I first accessed the image. However my query has been about getting pgadmin to run with TLS with the following: 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=someb...@anyemail.com' -e 'PGADMIN_DEFAULT_PASSWORD=userpwd' -e 'PGADMIN_ENABLE_TLS=True' -d dpage/pgadmin4 Just to confirm I am on an EC2 instance running Ubuntu and all my certs and keys are self signed Regards Omar > On 26 Jun 2020, at 11:51, Aditya Toshniwal > <aditya.toshni...@enterprisedb.com> wrote: > > Hi Omar, > > It looks to be launched successfully. What does 'docker ps' show now ? For me > without TLS it shows following and works with 0.0.0.0:80 in the browser: > > adityatoshniwal@Laptop381pnin pgadmin4_copy % docker ps > CONTAINER ID IMAGE COMMAND CREATED > STATUS PORTS NAMES > a7f32fd312c7 dpage/pgadmin4 "/entrypoint.sh" 4 seconds ago > Up 3 seconds 0.0.0.0:80->80/tcp, 443/tcp objective_swanson > > > >> On Fri, Jun 26, 2020 at 3:09 PM Omar Francis <omar.fran...@branchbot.com> >> wrote: >> Hi Aditya thanks for your help I have given a+rwx to that dir. The container >> status is now up however I am not getting a pgadmin login screen on my >> browser when I navigate to publicip:443 >> >> Is there a critical connection flaw in the logs below that stops this? >> >> Thanks again :) >> >> >> WARNING: Failed to set ACL on the directory containing the configuration >> database: [Errno 1] Operation not permitted: '/var/lib/pgadmin' >> NOTE: Configuring authentication for SERVER mode. >> >> WARNING: Failed to set ACL on the directory containing the configuration >> database: [Errno 1] Operation not permitted: '/var/lib/pgadmin' >> Added 1 Server Group(s) and 1 Server(s). >> sudo: setrlimit(RLIMIT_CORE): Operation not permitted >> [2020-06-26 09:28:34 +0000] [1] [INFO] Starting gunicorn 19.9.0 >> [2020-06-26 09:28:34 +0000] [1] [INFO] Listening at: http://[::]:443 (1) >> [2020-06-26 09:28:34 +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 09:28:34 +0000] [91] [INFO] Booting worker with pid: 91 >> >> >> >> >>> On 26 Jun 2020, at 09:39, Aditya Toshniwal >>> <aditya.toshni...@enterprisedb.com> wrote: >>> >>> 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.fran...@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.toshni...@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.fran...@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=someb...@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.toshni...@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.fran...@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.fran...@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=u...@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" > > > -- > Thanks and Regards, > Aditya Toshniwal > pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune > "Don't Complain about Heat, Plant a TREE"
