[Backlogmanager] [FIWARE-JIRA] (HELP-17957) [fiware-stackoverflow] Connect external SQL database to orion context broker

Fernando Lopez (JIRA) jira-help-desk at jira.fiware.org
Fri Jul 2 09:19:00 CEST 2021


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

Fernando Lopez reassigned HELP-17957:
-------------------------------------

    Assignee: Miguel Ángel Pedraza

> [fiware-stackoverflow] Connect external SQL database to orion context broker
> ----------------------------------------------------------------------------
>
>                 Key: HELP-17957
>                 URL: https://jira.fiware.org/browse/HELP-17957
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>            Assignee: Miguel Ángel Pedraza
>              Labels: docker, fiware, postgresql, raspberry-pi
>
> Created question in FIWARE Q/A platform on 30-06-2021 at 09:06
> {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/68192351/connect-external-sql-database-to-orion-context-broker
> +Question:+
> Connect external SQL database to orion context broker
> +Description:+
> Target: Subscribe to Orion context broker entity changes and store this data to an external SQL database
> Environment:
> Link to picture
> Used these documents for overlay network between laptop and RPi. (Part: "Use an overlay network for standalone containers"): https://docs.docker.com/network/network-tutorial-overlay/
> My steps: Docker swarm -> create overlay -> connect containers with docker network connect.
> Now I can see the same network with the same ID on both of my devices.
> All the containers all now in the same network and subnet. Cygnus(bridge) is connected to the Orion entity changes and when I manually use CuRL to change entity values, Cygnus responds and tries to send the message to the database but nothing is received on my laptop/database.
> UPDATE when I was writing this:
> It seems that docker-compose creates its own network for the containers (i need to use docker-compose because I'm using prebuild images for arm64) and I cant just bypass them by connecting them to another network (I disconnected the containers from the network that compose made for them and nothing works now). So RPi containers were connected to the overlay network but not using it.
> UPDATE:
> I found how to make a docker-compose file so that it connects to the pre-existing network.
> Communication between multiple docker-compose projects
> All the containers are in the same overlay network but still no message to the database.
> UPDATE: Tried to ping from a container(database) to container(Orion) and it doesn't work. I think my overlay network is correct but I have some issues with the ports. I can ping regularly from my computer to RPI.



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


More information about the Backlogmanager mailing list

You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy   Cookies policy