Pgwatch3 Grafana dashboards UI not working

[ced75]

Hi,
I've just installed pgwatch3 with docker compose on a dedicated server.
On this server, all containers seem to be up:

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
85ffa65b52f0 grafana/grafana:10.4.7 "/run.sh" 33 minutes ago Up 7 seconds 0.0.0.0:3000->3000/tcp docker-grafana-1
21da4702ed0d cybertecpostgresql/pgwatch:latest "/pgwatch/pgwatch" 33 minutes ago Up 33 minutes 8081/tcp, 0.0.0.0:8080->8080/tcp, 9187/tcp docker-pgwatch-1
6faf0bc1d12a postgres-plpython3u:latest "docker-entrypoint.s…" 33 minutes ago Up 33 minutes (healthy) 0.0.0.0:5432->5432/tcp docker-postgres-1

I have successfully configured a server to monitor on pgwatch dashboard (http://10.132.32.9:8080). In the postgres logs on this server, I can see pgwatch queries running.

But connecting to the dashboards UI (http://10.132.32.9:3000) fails, giving a connection error:

What did I do wrong?

Thanks in advance for your help,

Cedric

[pashagolub]

I believe, this is host related. Can you log into dedicated server and curl localhost:3000 there to check if Grafana responds?

[ced75]

Hi Pavlo and thanks for your help.
I didn't mention it, but I tried it with apparently no success:
curl localhost:3000

curl: (52) Empty reply from server

The response is different with 127.0.0.1 address:
curl 127.0.0.1:3000

curl: (56) Recv failure: Connexion ré-initialisée par le correspondant

[pashagolub]

Would you please check the logs for grafana:

$ docker compose logs grafana

There should be no errors.

[ced75]

$ docker compose logs grafana

no configuration file provided: not found

If I check the logs of the container corresponding to grafana, I get a long list of errors:
$ docker logs 85ffa65b52f0

Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": dial tcp 34.120.177.193:443: i/o timeout (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": dial tcp 34.120.177.193:443: i/o timeout (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": dial tcp 34.120.177.193:443: i/o timeout (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)
Error: ✗ Get "https://grafana.com/api/plugins/marcusolsson-treemap-panel/versions": context deadline exceeded (Client.Timeout exceeded while awaiting headers)

Could it be related to a proxy issue? The server is behind a proxy.

[pashagolub]

Aha, now I see. Yeah, Grafana tries to install additional plug-in but fails for whatever reason.

The quick fix is to comment out

services:
  grafana:
    # to use latest Grafana v11, update the dashboards provisioning folder below
    image: grafana/grafana:10.4.7
    user: "0:0"
    environment:
		...
    	# GF_INSTALL_PLUGINS: marcusolsson-treemap-panel
...

[ced75]

Yes, that did it!
If it happens to anybody else, the solution is to edit the file docker/compose.grafana.yaml and comment the line.
Then, execute again docker compose:
docker compose -f docker/docker-compose.yml up --detach

Thanks Pavlo for the help and quick answers.
I'm quite sure it is related to the proxy...