Docker container - servers.json

From: Ashish Chandra <ashish(dot)cppdev(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Docker container - servers.json
Date: 2021-11-02 19:09:19
Message-ID: CAB4y7u3OtinPe0fBQbynrYaZKhCoXi-m5PXjPVRjq1nOtaX5cA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

According to
https://www.pgadmin.org/docs/pgadmin4/development/container_deployment.html
having a files servers.json in the /pgadmin4 folder should enable server
info to be pre-loaded into pgadmin4 when it launches.

However, I am unable to see any impact from having this file. Here are the
docker logs from the container:

[2021-11-02 18:49:31 +0000] [1] [INFO] Shutting down: Master
> [2021-11-02 18:49:53 +0000] [1] [INFO] Starting gunicorn 20.1.0
> [2021-11-02 18:49:53 +0000] [1] [INFO] Listening at: http://[::]:80 (1)
> [2021-11-02 18:49:53 +0000] [1] [INFO] Using worker: gthread
> [2021-11-02 18:49:53 +0000] [80] [INFO] Booting worker with pid: 80
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:52 +0000] "GET / HTTP/1.1" 302
> 237 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101
> Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:52 +0000] "GET /login?next=%2F
> HTTP/1.1" 200 1729 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0)
> Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:53 +0000] "GET
> /static/img/login.svg?ver=60100 HTTP/1.1" 200 0 "
> http://localhost:5050/login?next=%2F" "Mozilla/5.0 (X11; Ubuntu; Linux
> x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:53 +0000] "GET
> /favicon.ico?ver=60100 HTTP/1.1" 302 265 "
> http://localhost:5050/login?next=%2F" "Mozilla/5.0 (X11; Ubuntu; Linux
> x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "POST
> /authenticate/login HTTP/1.1" 302 209 "
> http://localhost:5050/login?next=%2F" "Mozilla/5.0 (X11; Ubuntu; Linux
> x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET / HTTP/1.1" 302
> 225 "http://localhost:5050/login?next=%2F" "Mozilla/5.0 (X11; Ubuntu;
> Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET /browser/
> HTTP/1.1" 200 2664 "http://localhost:5050/login?next=%2F" "Mozilla/5.0
> (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET
> /browser/browser.css?ver=60100 HTTP/1.1" 200 3755 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET
> /static/js/generated/fonts/fa-solid-900..woff2 HTTP/1.1" 200 0 "
> http://localhost:5050/static/js/generated/style.css?ver=60100"
> "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101
> Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET
> /browser/js/constants.js?ver=60100 HTTP/1.1" 200 455 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET
> /browser/js/endpoints.js?ver=60100 HTTP/1.1" 200 2595 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET
> /browser/js/messages.js?ver=60100 HTTP/1.1" 200 811 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET
> /browser/server/supported_servers.js?ver=60100 HTTP/1.1" 200 290 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:58 +0000] "GET
> /browser/js/utils.js?ver=60100 HTTP/1.1" 200 2298 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:59 +0000] "GET
> /tools/translations.js?ver=60100 HTTP/1.1" 200 321 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:59 +0000] "GET
> /user_management/current_user.js?ver=60100 HTTP/1.1" 200 312 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:59 +0000] "GET
> /static/css/webcabin.overrides.css?v=1635879299659 HTTP/1.1" 200 0 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:54:59 +0000] "GET /browser/nodes/
> HTTP/1.1" 200 255 "http://localhost:5050/browser/" "Mozilla/5.0 (X11;
> Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:00 +0000] "GET
> /browser/check_corrupted_db_file HTTP/1.1" 200 61 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:00 +0000] "POST
> /browser/master_password HTTP/1.1" 200 390 "http://localhost:5050/browser/"
> "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101
> Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:00 +0000] "GET /dashboard/
> HTTP/1.1" 200 6803 "http://localhost:5050/browser/" "Mozilla/5.0 (X11;
> Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:00 +0000] "POST /settings/store
> HTTP/1.1" 200 367 "http://localhost:5050/browser/" "Mozilla/5.0 (X11;
> Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:00 +0000] "POST /settings/store
> HTTP/1.1" 200 367 "http://localhost:5050/browser/" "Mozilla/5.0 (X11;
> Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:01 +0000] "GET
> /preferences/get_all HTTP/1.1" 200 8139 "http://localhost:5050/browser/"
> "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101
> Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:01 +0000] "GET
> /settings/get_tree_state/ HTTP/1.1" 200 2 "http://localhost:5050/browser/"
> "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101
> Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:01 +0000] "GET
> /misc/bgprocess/?_=1635879299049 HTTP/1.1" 200 2 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:18:55:31 +0000] "POST
> /settings/save_tree_state/ HTTP/1.1" 200 63 "
> http://localhost:5050/browser/" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64;
> rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:19:00:00 +0000] "POST /misc/cleanup
> HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (X11;
> Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
> ::ffff:192.168.96.1 - - [02/Nov/2021:19:05:00 +0000] "POST /misc/cleanup
> HTTP/1.1" 200 0 "http://localhost:5050/browser/" "Mozilla/5.0 (X11;
> Ubuntu; Linux x86_64; rv:90.0) Gecko/20100101 Firefox/90.0"
>

Here is my servers.json:

{
"Servers": {
"1": {
"Name": "mock",
"Group": "Server",
"Port": 5432,
"Username": "blockchain",
"Host": "172.17.0.1",
"SSLMode": "prefer",
"MaintenanceDB": "postgres",
"Password":"password"
}
}
}

Here is my Dockerfile:

FROM dpage/pgadmin4:latest
EXPOSE 80
COPY --chown=pgadmin:pgadmin servers.json .

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2021-11-03 04:35:47 Re: Docker container - servers.json
Previous Message Aditya Toshniwal 2021-10-30 06:33:55 Re: ER tool