Albert Palomas

Electronics & Life Lover

LoRa – MySQL link using two Hope RFM69W and a Raspberry Pi

After looking for a already implemented solution for getting data from remote sensors, I decided to build my own solution, using existing components like Arduino, Raspberry Pi and especially I was interested on using the low cost RFM69W LoRa module.

My other target was to send the data to my own MySQL server instead of using third-party parterns like TTN.

And how it works? Basically it consist of two parts: sensors and gateway.

Sensor

It uses an Arduino Mini Pro 3.3V – 8MHz version as a processing core. It remains on deep-sleep mode, consuming less than 5 micro amperes and it wakes up every 10 minutes, sends data during few seconds, and sleep again. This strategy allows the sensor to be powered from 2 standard AA batteries and having an autonomy longer than a year.

Sensor powered from 2 AA batteries

The RFM69W module is connected to the Arduino using SPI and few control signals:

Arduino Mini PROLoRa RFM69W module
10 – SLAVE SELECTNNS
11 – MOSIMOSI
12 – MISOMISO
13 – SCKSCK
A0 – RESETRESET
2 – DIO0DIO0
7 – DIO1 (not used)DIO1
8 – DIO2 (not used)DIO2

It also contains a Adafruit Si7020 temerature & humidity sensor, connected via I2C to the Arduino (I removes and bridged transistors of this module to work at 3.3V)

Gateway

The gateway is mostly a Rasperry Pi connected to a RFM69 module using SPI and control signals This is the pinout:

Raspberry Pi (BCM numeration)LoRa RFM69 module
9 – MISOMISO
10 – MOSIMOSI
11 – SCKSCK
8NSS
25DIO0
22RESET
23EXTERNAL LED (not in module)

TODO: Write about software and firmware

2 Comments

  1. Leandro Noguera

    08/03/2019 at 17:05

    Hola. Soy un estudiante de Ingeniería Electrónica en Ecuador… Felicitándolo por su desempeño e ideas presentadas en su sitio WEB. Me gustaría entablar una conversación con usted, con el fin de pedirle ayuda o guía para un trabajo a realizarse con dispositivos LORA y bases de datos my SQL. Estaría muy agradecido si me brinda parte de su valioso tiempo al igual de sus amplios conocimientos

  2. Silvio Alvim

    16/10/2019 at 14:48

    Hello! I’m from Brazil and i like to know more details about communication LORA sending data to a mysql server. Your idea is amazing, can you send me more information about it? I appreciate any contact!

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2020 Albert Palomas

Theme by Anders NorenUp ↑