How to integration with MySQL?


#1

Hi,

I would like to know can I send parameter to MySQL instead of influxdb. How should I do or What to learning.


#2

This is (currently) not provided and you need to implement this yourself. Eg. by implementing your own HTTP endpoint which saves the data into a MySQL database (or any other store). You could also implement a MQTT client which does this. This is up to you. See also: https://www.loraserver.io/lora-app-server/integrate/sending-receiving/.


#3

Thank you for your answer. I will implement on HTTP.


#4

Did you manage to get it working? I built an HTTP site using laravel that stores the data. It also adds the gateway and application data into separate tables. It grabs the data using the Cayenne data and puts the info into separate entries. It logs the gateway which received it, rssi, DR and frequency also. It also generate API keys for authentication.
How did you get on with the HTTP?