[Backlogmanager] [FIWARE-JIRA] (HELP-19991) [fiware-stackoverflow] What can be the reason why I can' t connect to CateDB with grafana and locally with Dbeaver?

[Fernando Lopez (JIRA)]

     [ https://jira.fiware.org/browse/HELP-19991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fernando Lopez reassigned HELP-19991:
-------------------------------------

    Assignee: MARTEL

> [fiware-stackoverflow] What can be the reason why I can't connect to CateDB with grafana and locally with Dbeaver?
> ----------------------------------------------------------------------------------------------------------------------
>
>                 Key: HELP-19991
>                 URL: https://jira.fiware.org/browse/HELP-19991
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>            Assignee: MARTEL
>              Labels: cratedb, fiware, fiware-orion, grafana
>
> Created question in FIWARE Q/A platform on 25-08-2022 at 15:08
> {color: red}Please, ANSWER this question AT{color} 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:
>       # Admin UI
>       - "4200:4200"
>       # 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



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)