Re: Docker container - servers.json

Hi Ashish,

Can you try mapping once "-v /tmp/servers.json:/pgadmin4/servers.json" if
it works ?

On Wed, Nov 3, 2021 at 12:39 AM Ashish Chandra <ashish(dot)cppdev(at)gmail(dot)com>
wrote:

> 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 .
>
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"