Re: dpage/pgadmin4 container failed in rancher/kubernetes , but works directly 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(at)pgadmin(dot)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(dot)zhirkov(at)gmail(dot)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 <http://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
>> processTraceback (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 <modu*le>
>>
>>
>>
>>
>> * server_port = int(port)ValueError: invalid literal for int() with
>> base 10: 'tcp://10.43.151.247:80 <http://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(at)pgadmin(dot)org>:
>>
>>> Hi
>>>
>>> On Fri, Jul 12, 2019 at 2:11 PM Dmitry Zhirkov <dmitry(dot)zhirkov(at)gmail(dot)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 <http://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
>

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