How to integration with MySQL?

Agent_G_G · September 3, 2018, 9:48am

Hi,

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

brocaar · September 3, 2018, 1:26pm

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/.

Agent_G_G · September 4, 2018, 1:41am

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

Kieren_Black · November 17, 2018, 9:58am

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?