Created question in FIWARE Q/A platform on 25-08-2022 at 15:08
Please, ANSWER this question AT https://stackoverflow.com/questions/73490092/what-can-be-the-reason-why-i-cant-connect-to-catedb-with-grafana-and-locally-wi

Question:
What can be the reason why I can't connect to CateDB with grafana and locally with Dbeaver?

Description:
Cheers
I am currently trying to reproduce the tutorial to develop an application / solution with Fiware seen in: Desarrolla tu primer aplicación en Fiware and I am having difficulty connecting Grafana with the Crate database (recommended by Fiware).
My docker-compose file configuration is:
version: "3.5"

services:

orion:
image: fiware/orion
hostname: orion
container_name: fiware-orion
networks:

• fiware_network
  depends_on:
• mongo-db
  ports:
• "1026:1026"
  command: -dbhost mongo-db -logLevel DEBUG -noCache

mongo-db:
image: mongo:3.6
hostname: mongo-db
container_name: db-mongo
networks:

• fiware_network
  ports:
• "27017:27017"
  command: --bind_ip_all --smallfiles
  volumes:
• mongo-db:/data

grafana:
image: grafana/grafana:8.2.6
container_name: fiware-grafana
networks:

• fiware_network
  ports:
• "3000:3000"
  depends_on:
• crate

quantumleap:
image: fiware/quantum-leap
container_name: fiware-quantumleap
networks:

• fiware_network
  ports:
• "8668:8668"
  depends_on:
• mongo-db
• orion
• crate
  environment:
• CRATE_HOST=crate

crate:
image: crate:1.0.5
networks:

• fiware_network
  ports:

1. Admin UI

• "4200:4200"

1. Transport protocol

• "4300:4300"
  command: -Ccluster.name=democluster -Chttp.cors.enabled=true -Chttp.cors.allow-origin="*"
  volumes:
• cratedata:/data

volumes:
mongo-db:
cratedata:

networks:
fiware_network:
driver: bridge

After starting the containers, I have a positive response from OCB (Orion), from Quantumleap and even after creating the subscription between Orion and quantumleap, in the Crate database, the data is stored and updated correctly.
Unfortunately I am not able to get the visualization of the data in grafana.
I thought that the reason was the fact that crateDB was removed as a grafana plugin versions ago, but after researching how to connect crateDB with grafana, through a postgres data source (I read on: Visualizing time series data with Grafana and CrateDB), I'm still having difficulty getting the connection, getting in grafana "Query error
dbquery error: EOF"
grafana settings img
The difference with respect to the guide is the listening port, since with input port 5432 I get a response indicating that it is not possible to connect to the server. I'm using port 4300.
After configuring, and trying to query from grafana, I get the mentioned EOF error
EOF error in grafana img
I tried to connect from a database IDE (Dbeaver) and I get exactly the same problem.
EOF error in Dbeaver img
Is there something I am missing?
What should I change in my docker configuration, or ports, or anything else to fix this?
I think it is worth mentioning that I am studying this because I am being asked in a project to visualize context switches in real time with Fiware and grafana.
Thanks in advance