TTN + MQTT + Node-RED + MySQL = local backup of your LoRaWAN data
Now everyone knows how to use MQTT thanks to Alex, I wanted to build a scenario where you retrieve the data that is being sent to The Things Network and then store that in a local MySQL database.
If your question is how to create webpage and access data in mysql
then this is not proper forum for such info.
but - look at this detailed tutorial with PHP technology
You can use any other method like .net, java...
I am able to storing the TTN data in MySQL database. Now i want to send those received TTN data from MySQL Database to my own web server(http://localhost:xxxx). can you please tell me the procedure how to do with the combination of TTN+MQTT+Node-RED+MySQL+HTTP.
i want access MySQL Database by using HTML page .
Have a problem with setting up a connection with the new TTN backend with Node-Red. I probably use the the wrong keys, because I do do not get authorisation. (Everything works in the console !) Who can help out in giving a few pointers, which keys to use. ( I can give more details about my keys in a private post ? ) thanks in advance ;-)
Very cool Pierre!
I'm also trying to build something similiar, so this post is a nice reference :)
It might help if I also link to the blogpost: