LoRa Gateway with DB

76 views
Skip to first unread message

Dev Shin

unread,
Aug 31, 2020, 10:55:02 PM8/31/20
to Dragino-user
Hello.

Our company considers Dragion's LoRa gateway to be a very good solution for certain environments.

I would like to configure the system using LoRa shield and LPS8.

If I use LPS8 to send data to MySQL web server, can I program for MySQL processing in LPS8?

I am also curious about how to program to process data transmitted through the LoRa shield.

BR,
Miller

Edwin Chen

unread,
Sep 1, 2020, 12:11:09 AM9/1/20
to Dev Shin, Dragino-user
 Hi, Miller,.
 
1. First you can see how to use LPS8 get data and decrypted from a LoRaWAn End node http://wiki.dragino.com/index.php?title=Communication_with_ABP_End_Node 
2. And you can see how to reuse the data for MySQL connection: https://wiki.dragino.com/index.php?title=Save_Data_to_MySQL . The SQL link is very old for other product. but the method is same as use for LPS8.
 
Best Regards
Edwin Chen
 
----- Original Message -----
From:Dev Shin
Date:2020-09-01 10:55
Subject:LoRa Gateway with DB
 
--
You received this message because you are subscribed to the Google Groups "Dragino-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dragino-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dragino-user/920c408c-3cd9-4876-81e5-11b49544742dn%40googlegroups.com.

Dev Shin

unread,
Sep 1, 2020, 12:56:47 AM9/1/20
to Dragino-user
Hello,

Thank you so much for the quick answer.

Regarding answer #1, do you mean I create /root/linkmysql.lua file on LPS8 and then execute Arduino source code on the shield side?

BR,
Miller
2020년 9월 1일 화요일 오후 1시 11분 9초 UTC+9에 Chen Edwin님이 작성:

Edwin Chen

unread,
Sep 1, 2020, 2:20:52 AM9/1/20
to Dev Shin, Dragino-user
 On the shield, you can run source code to let it works as an LoRaWAN ABP Sensor.
 
Best Regards
Edwin Chen
 
----- Original Message -----
From:Dev Shin
Date:2020-09-01 12:56
Subject:Re: LoRa Gateway with DB
 
Reply all
Reply to author
Forward
0 new messages