Create a $5 autonomous tracker with ESP8266 and Sigfox

There are multiple ways to track something or someone. Cellphone are using different method to be able to give you a precise location in most of the situation. The more global one is GPS, it works anywhere on earth but do not really work indoor. It is also costly (about 8$ or more) and power consuming. Outdoor your usually have a precision of 15 meters. The less precise one is triangulation : a message received by different antennas will be located by the network in an area covered by all these antennas. This solution works anywhere the network is covering and do not need specific power other than for communicating. The precision is usually from 500m to 10km.

The last usual method we use is the one we are going to implement in this post : the WiFi positioning. The tracker is listening for the WiFi access point around and ask one of the existing database knowing most of the WiFi location to get a position. This is working thanks to the crowding effort all of us are doing with our smartphone of capturing WiFi around us and associated locations. The WiFi solution is working where WiFi is, so usually in the cities ; around buildings. It works well indoor, better than outdoor where WiFi is less active. The precision is about 30-50 meters. The power consumption is lower than GPS.

Sigfox is a LPWA (Low Power Wide Area) network covering about 45 countries (as today) dedicated to low power autonomous devices aka IoT. Asset tracking is one of the best use-case.

The use of Sigfox with a WiFi tracker is allowing to create a low-cost tracker device, autonomous on battery from month to years, getting benefit in 45 countries of a WiFi + network localization.

This post will explain how to get started in this technology by using two standard, easy to use and low cost components allowing to get your prototype for about $5 of hardware.

Continue reading

Sigfox, from the poc to the prod

Sigfox is a really nice technology when you want to make a really quick experimentation in IoT. The Time To  Hello World will take you less than 5 minutes and it makes it really easy.

That said after the POC comes the production, and the way you manage your Sigfox backend for production is not the way you build your quick & dirty front-end platform for the POC.

This post will introduce how to make your Production platform and what is the difficulty you need to consider. I’ll propose you some architectural solution I’ve put in place but they are one of the ways to implement it. I won’t detail the pre-packages PaaS solution as i’m not a big fan of them : in my point of view, they are firstly responding to the POC situation, but it is only my own opinion.

Continue reading

LoRaWAN gateway from TheThingsNetwork

TTN Gateway

I’ve waited a long time to get it since I pledge on the kickstarter campaign but it’s now here and as all what TTN have done until now this it a really nice object.

The design itself is really good. You can easily fix it on a window or a wall.

You can hack this gateway a lot … by the way it is not yet my purpose.

And the installation process it so good.. You may understand I really liked it.

 

 

Continue reading

MongoDB collection format mass modifications

MongoDB is a NoSQL database and one of the main difference compared to relational DB is you can put in your collection documents with different structure. In fact you don’t really care about structure of documents and type of data you are storing.

This is particularly true when you start using your Mongo instance with langage like PHP or JS where the langage itself does not manage data type explicitly.

As a consequence your document format may not be optimized (like storing numbers in String and making search on them later) and once you decide to move your backend to a more structured language like Java you start to have to make this more robust and organized. At this point you may want to reformat your documents to match the right type, eventually update your previous documents to a new version.

This kind of operation can be done “easily” with Mongo scripting language. This post will details 2 of the current structure to manipulate and transform Documents.

Continue reading

Configure Adeunis field test device on The Things Network (TTN)

The Adeunis Field Tester is a simple way to make test on a LoRaWan network. The device provide GPS information, temperature and an accelerometer to activate communications.

The device is big but it have a screen and you can have a direct feedback of the transmissions on the screen. It make it good for testing coverage manually. You can also program it to send messages periodically and easily put it in a car to create coverage maps thanks to the embedded GPS.

The following post explains how to set it to use it with TheThingsNetwork (as for any other network by-the-way).

Continue reading

Centos 7 – install a mongo cluster with 3 replica set

This post is describing how to setup a Mongo Db database in a clustering mode. I choose to deploy 3 replica set on 3 different bare metal server running centos 7 and to add 1 arbiter to reduce vote problem during a server crash or reboot.

You will find the different steps to make this configuration running, the way to secure it in a vlan and to activate the authentication.

I also added some elements on the way to backup it. Feel free to propose enhancement and links in the comments.

Continue reading

SpringBoot – Mongo / Create a Mutex to synchronize multiple frontends

When deploying a API in a scalable environment we usually try tom implement a stateless solution to avoid parallelism conflicts between the different nodes.

This works well for event management synchronously executed. But in some case these event need to have a part of the work managed asynchronously. It was my was my case when I had to process alarm report potentially generating multiple communications with execution time not predictable. To manage this I decided to process theses operation asynchronously. There are multiple architecture for managing this like Queuing (my preferred) of dedicate asynchronous engine. I’ve in fact preferred another way to do it for keeping my infrastructure more simple : adding in all of my nodes a batch function processing the alarms asynchronously.

The alarm events are written into the database and processed by the first of the batch taking it. This allow to preserve a fully redundant and simple architecture. That said I need to ensure only one of the process will execute this process at a time and potentially split the work to do between all the nodes. For making this I had to create a mutex solution.

This post describes the way to create a Mutex solution based on MongoDB with Spring Boot.

Continue reading

Centos7 – Manage LVM & extend LVM

This is a recurrent operation I’m doing regularly these time : extending a Linux partition by adding new virtual disk I’ve attached to a growing VM. Nothing fantastic to expect in this post. Its purpose is to keep on my hand the solution I’ve used to stop searching google and getting a different one every time ;).

This tuto is applicable for centos 7. The content will be updated when I’ll have to perform different operations.

Continue reading