Created question in FIWARE Q/A platform on 30-06-2021 at 09:06
Please, ANSWER this question AT 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.