TTN + MQTT + Node-RED + MySQL = local backup of your LoRaWAN data

[PiAir]

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.

[livius]

@prakash
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
https://www.ibm.com/developerworks/linux/tutorials/l-php/index.html

You can use any other method like .net, java...

[prakash]

Hi,
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 .

[henkhofstra]

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 ;-)

[RobTuDelft]

Very cool Pierre!

I'm also trying to build something similiar, so this post is a nice reference :)

[PiAir]

It might help if I also link to the blogpost:
https://ictoblog.nl/2017/04/15/ttn-mqtt-node-red-mysql-local-backup-of-your-lorawan-data :)