Re: dpage/pgadmin4 container failed in rancher/kubernetes , but worksdirectly from dockerd

Thank you very much, Dave !

I added environment variable "PGADMIN_PORT = 5432" to the container and it's now up and running . 

ср, 17 июл. 2019 г. в 11:06, Dave Page <dpage@pgadmin.org>:

Hi

[Please keep replies on the mailing list]

The code where the error is happening (pgAdmin4.py, line 131 per your report) looks like this:

port = os.environ['PGADMIN_PORT']
app.logger.debug(
    'Not running under the desktop runtime, port: %s',
    port
)
server_port = int(port)

It's setting the 'port' variable to the value of the PGADMIN_PORT environment variable, and then trying to convert it to an integer and store that in the server_port variable. That last line is where the error occurs, and it's reporting that it cannot convert 'tcp://10.43.151.247:80' (obviously a string) to an integer. The only possible way I can see this happening is if *something* is setting the PGADMIN_PORT environment variable to  'tcp://10.43.151.247:80'. pgAdmin never sets that variable in the environment, so it must be coming from somewhere else. Perhaps Rancher is setting that environment variable, based on the container name or something?

On Tue, Jul 16, 2019 at 4:59 PM Dmitry Zhirkov <dmitry.zhirkov@gmail.com> wrote:

Hi Dave,

here are  my environment settings for the container :

...

allowPrivilegeEscalation": false,
"environment": {

    "PGADMIN_DEFAULT_EMAIL": "<my email>",
    "PGADMIN_DEFAULT_PASSWORD": "secret",
    "PGADMIN_LISTEN_PORT": "80"

},

...

and log is the same - please, see below. What is wrong ?

....

NOTE: Configuring authentication for SERVER mode.

Traceback (most recent call last):
  File "run_pgadmin.py", line 4, in <module>
    from pgAdmin4 import app
  File "/pgadmin4/pgAdmin4.py", line 131, in <module>
    server_port = int(port)
ValueError: invalid literal for int() with base 10: 'tcp://10.43.151.247:80'
postfix/postfix-script: starting the Postfix mail system
[2019-07-16 15:56:29 +0000] [1] [INFO] Starting gunicorn 19.9.0
[2019-07-16 15:56:29 +0000] [1] [INFO] Listening at: http://[::]:80 (1)
[2019-07-16 15:56:29 +0000] [1] [INFO] Using worker: threads
[2019-07-16 15:56:29 +0000] [80] [INFO] Booting worker with pid: 80
[2019-07-16 15:56:37 +0000] [80] [ERROR] Exception in worker process
Traceback (most recent call last):
  File "/usr/local/lib/python3.7/site-packages/gunicorn/arbiter.py", line 583, in spawn_worker
    worker.init_process()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/workers/gthread.py", line 104, in init_process
    super(ThreadWorker, self).init_process()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/workers/base.py", line 129, in init_process
    self.load_wsgi()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/workers/base.py", line 138, in load_wsgi
    self.wsgi = self.app.wsgi()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/app/base.py", line 67, in wsgi
    self.callable = self.load()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py", line 52, in load
    return self.load_wsgiapp()
  File "/usr/local/lib/python3.7/site-packages/gunicorn/app/wsgiapp.py", line 41, in load_wsgiapp
    return util.import_app(self.app_uri)
  File "/usr/local/lib/python3.7/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 131, in <module>
    server_port = int(port)
ValueError: invalid literal for int() with base 10: 'tcp://10.43.151.247:80'
[2019-07-16 15:56:37 +0000] [80] [INFO] Worker exiting (pid: 80)
[2019-07-16 15:56:37 +0000] [1] [INFO] Shutting down: Master
[2019-07-16 15:56:37 +0000] [1] [INFO] Reason: Worker failed to boot.

пт, 12 июл. 2019 г. в 16:21, Dave Page <dpage@pgadmin.org>:

Hi

On Fri, Jul 12, 2019 at 2:11 PM Dmitry Zhirkov <dmitry.zhirkov@gmail.com> wrote:

Traceback (most recent call last):
  File "run_pgadmin.py", line 4, in <module>
    from pgAdmin4 import app
  File "/pgadmin4/pgAdmin4.py", line 131, in <module>
    server_port = int(port)
ValueError: invalid literal for int() with base 10: 'tcp://10.43.151.247:80'

That would suggest that PGADMIN_PORT is set in the environment to 'tcp://10.43.151.247:80'. If you set that environment variable (and in a containerised environment, I cannot think of a compelling reason to do so - you should use PGADMIN_LISTEN_PORT), it must be set to a valid port number only.

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--

С уважением,
Дмитрий Жирков

--

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--

С уважением,
Дмитрий Жирков