End node registration without Web UI

jith_cr1 · November 23, 2017, 6:39am

Hi,

Is it possible to register LoRa node device without using Web UI ?

brocaar · November 23, 2017, 7:23am

Yes you can, by using the gRPC or REST API. See also: https://docs.loraserver.io/lora-app-server/integrate/rest/. You can also directly use the LoRa Server gRPC API. For the description of this API see: https://github.com/brocaar/loraserver/blob/master/api/ns/ns.proto

jith_cr1 · November 23, 2017, 7:25am

Can you please share link for any sample application

brocaar · November 23, 2017, 7:44am

I don’t have sample applications, but when you use /api as path instead on the same host as the Web UI (e.g. https://localhost:8080/api), you’ll get a web-interface / console for the REST api of LoRa App Server.

jith_cr1 · November 23, 2017, 7:46am

Okay. Thank you so much …I will try same and update

jith_cr1 · November 23, 2017, 10:42am

Hi

currently I am getting below mentioned log while running loraserver in system.

–
:/home/cpu# ./loraserver --net-id 010203 --band IN_865_867 --postgres-dsn postgres://loraserver_ns:dbpassword@/loraserver_ns?sslmode=disable --gw-server-jwt-secret i31egubGv9W1QnFYRmRrqdEHop8JRwO+kc58vWCt7bA=
INFO[0000] starting LoRa Server band=“IN_865_867” docs=“https://docs.loraserver.io/” net_id=010203 version=0.22.0
INFO[0000] setup redis connection pool url=“redis://localhost:6379”
INFO[0000] connecting to postgresql
INFO[0000] backend/gateway: connecting to mqtt broker server=“tcp://localhost:1883”
INFO[0000] setup application-server client pool ca_cert= tls_cert= tls_key=
INFO[0000] configuring join-server ca_cert= server=“http://localhost:8003” tls_cert= tls_key=
INFO[0000] no network-controller configured
INFO[0000] starting api server bind=“0.0.0.0:8000” ca-cert= tls-cert= tls-key=
INFO[0000] starting gateway api server bind=“0.0.0.0:8002” ca-cert= tls-cert= tls-key=
INFO[0000] backend/gateway: connected to mqtt server
INFO[0000] backend/gateway: subscribing to rx topic topic=“gateway/+/rx”
INFO[0000] backend/gateway: subscribing to stats topic topic=“gateway/+/stats”

How can I see incoming payloads from LoRa node for debugging at server side purpose?

jith_cr1 · November 23, 2017, 10:50am

When I am staring loaserver after starting lora-gateway-bridge ,I am getting below messages

ERROR: relation “gateway” does not exist at character 15
STATEMENT: select * from gateway where mac = $1
ERRO[0003] handle stats packet error: get gateway error: select error: pq: relation “gateway” does not exist

Can you please comment on the logs

jith_cr1 · November 23, 2017, 12:18pm

sudo -u postgres psql
psql (9.4.5)
Type “help” for help.

postgres-# \c loraserver_ns
You are now connected to database “loraserver_ns” as user “postgres”.
loraserver_ns-# \dt
No relations found.
loraserver_ns-# \l

I am thinking like gateway named table is not created.- Is that the issue?

jith_cr1 · November 23, 2017, 1:24pm

Is this version okay??

brocaar · November 23, 2017, 3:26pm

https://docs.loraserver.io/install/requirements/

jith_cr1 · November 23, 2017, 4:31pm

Hello,Do you feel that the table in database is not getting created because of psql version change?
Installation Requirement link says psql 9.6 and I deployed psql 9.4

brocaar · November 24, 2017, 8:27am

Note that PostgreSQL 9.5+ is required

When your PostgreSQL version is below that version, it is very likely that this could be the cause. 9.5+ is a hard requirement. Please refer also to the log messages of LoRa (App) Server. They should give you some hints too.

jith_cr1 · December 1, 2017, 10:04am

Hi Brocaar,

Currently, I am using Postgres 9.6.6
but I am facing same issue

ERROR: relation “gateway” does not exist at character 15
STATEMENT: select * from gateway where mac = $1
ERRO[0003] handle stats packet error: get gateway error: select error: pq: relation “gateway” does not exist

–
Postgres verified using below command and out put for your reference
G18M:~$ psql -h localhost -U loraserver_as -W loraserver_as
Password for user loraserver_as:
psql (9.6.6)
Type “help” for help.

loraserver_as=>
loraserver_as=> \q
G18M:~$

brocaar · December 1, 2017, 11:45am

Don’t forget to set the --db-automigrate flag (this applies to both LoRa Server and Lora App Server, in case you’re also installing the latter). Please refer to the configuration documentation.

jith_cr1 · December 1, 2017, 1:50pm

in case you’re also installing the latter
Sorry I didn’t understand your comment.

When I tried with --db-automigrate gateway does not exist message still getting

INFO[0170] gateway: stat packet received addr=192.168.4.155:47013 mac=aa555a0000000101
INFO[0170] gateway: sending udp packet to gateway addr=192.168.4.155:47013 protocol_version=2 type=PushACK
INFO[0170] backend: publishing packet topic=“gateway/aa555a0000000101/stats”
INFO[0134] backend/gateway: gateway stats packet received mac=aa555a0000000101
ERRO[0134] handle stats packet error: get gateway error: gateway does not exist

Can you please comment on something like in what context we may get this kind of message

brocaar · December 1, 2017, 3:12pm

You didn’t create the gateway but LoRa Server received stats for that gateway, hence the error it can’t handle it since it doesn’t know about the gateway MAC. Please see the --gw-create-on-stats config. All config options: https://docs.loraserver.io/loraserver/install/config/

jith_cr1 · December 4, 2017, 6:17am

Ihave tried with below
1 ./lora-gateway-bridge --mqtt-server tcp://192.168.4.150:1883 &
2. ./loraserver --net-id 010203 --band IN_865_867 --db-automigrate --postgres-dsn postgres://loraserver_ns:dbpassword@/loraserver_ns?sslmode=disable --gw-server-jwt-secret pvReQM/cnxWNepAnVIZ+XlNuJ8YhFIx8yD9VIAhjYmI= --gw-create-on-stats

Log for your response

G18M:~$ INFO[0000] starting LoRa Gateway Bridge INFO[0000] backend: connecting to mqtt broker INFO[0000] gateway: starting gateway udp listener INFO[0000] backend: connected to mqtt broker
INFO[0008] gateway: received udp packet from gateway INFO[0008] backend: subscribing to topic INFO[0008] gateway: sending udp packet to gateway INFO[0009] gateway: received udp packet from gateway INFO[0009] gateway: stat packet received INFO[0009] gateway: sending udp packet to gateway INFO[0009] backend: publishing packet G18M:~$ loraserver --net-id 010203 --band INFO[0000] starting LoRa Server INFO[0000] setup redis connection pool INFO[0000] connecting to postgresql
INFO[0001] backend/gateway: connecting to mqtt broker INFO[0001] setup application-server client pool INFO[0001] configuring join-server INFO[0001] no network-controller configured
INFO[0001] applying database migrations
INFO[0001] backend/gateway: connected to INFO[0001] backend/gateway: subscribing to rx topic INFO[0001] backend/gateway: subscribing to stats topic INFO[0001] migrations applied INFO[0001] starting api server INFO[0001] starting gateway api server INFO[0018] gateway: received udp packet from gateway INFO[0018] gateway: sending udp packet to gateway INFO[0028] gateway: received udp packet from gateway INFO[0028] gateway: sending udp packet to gateway INFO[0038] gateway: received udp packet from gateway INFO[0038] gateway: sending udp packet to gateway INFO[0039] gateway: received udp packet from gateway INFO[0039] gateway: stat packet received INFO[0039] backend: publishing packet INFO[0039] gateway: sending udp packet to gateway INFO[0027] backend/gateway: gateway stats packet received INFO[0027] gateway created INFO[0048] gateway: received udp packet from gateway docs=“https://docs.loraserver.io/lora-gateway-bridge/” version=2.1.5
server=“tcp://192.168.4.150:1883”
addr=0.0.0.0:1700
addr=192.168.4.155:53568 protocol_version=2 type=PullData
topic=“gateway/aa555a0000000101/tx”
addr=192.168.4.155:53568 protocol_version=2 type=PullACK
addr=192.168.4.155:56658 protocol_version=2 type=PushData
addr=192.168.4.155:56658 mac=aa555a0000000101
addr=192.168.4.155:56658 protocol_version=2 type=PushACK
topic=“gateway/aa555a0000000101/stats”
IN_865_867 --db-automigrate --postgres-dsn postgres://loraserver_ns:dbpassword@/loraserver_ns?sslmode=disable --gw-server-jwt-secret pvReQM/cnxWNepAnVIZ+XlNuJ8YhFIx8yD9VIAhjYmI= --gw-create-on-stats
band=“IN_865_867” docs=“https://docs.loraserver.io/” net_id=010203 version=0.22.0
url=“redis://localhost:6379”
server=“tcp://localhost:1883”
ca_cert= tls_cert= tls_key=
ca_cert= server=“http://localhost:8003” tls_cert= tls_key=
mqtt server
topic=“gateway/+/rx”
topic=“gateway/+/stats”
count=0
bind=“0.0.0.0:8000” ca-cert= tls-cert= tls-key=
bind=“0.0.0.0:8002” ca-cert= tls-cert= tls-key=
addr=192.168.4.155:53568 protocol_version=2 type=PullData
addr=192.168.4.155:53568 protocol_version=2 type=PullACK
addr=192.168.4.155:53568 protocol_version=2 type=PullData
addr=192.168.4.155:53568 protocol_version=2 type=PullACK
addr=192.168.4.155:53568 protocol_version=2 type=PullData
addr=192.168.4.155:53568 protocol_version=2 type=PullACK
addr=192.168.4.155:56658 protocol_version=2 type=PushData
addr=192.168.4.155:56658 mac=aa555a0000000101
topic=“gateway/aa555a0000000101/stats”
addr=192.168.4.155:56658 protocol_version=2 type=PushACK
mac=aa555a0000000101
mac=aa555a0000000101
addr=192.168.4.155:53568 protocol_version=

gateway does not exist error is not coming now.
Thank you for your valuable input

jith_cr1 · December 4, 2017, 6:06pm

Hi Brocaar,

I am very new to REST apis .
Can you please give some more guidance to use the grPC API.I am using Krogoth Yocto Linux distribution(ARM platform).I have only Linux console. So I would like to explore more on node creation ,receiving data without WebUI.

brocaar · December 5, 2017, 7:27am

Rest != gRPC. Please refer to www.grpc.io for more information.

jith_cr1 · December 5, 2017, 8:54am

Hi Brocaar, Can you suggest me that for getting data from LoRa END device(without webui) which APIs need to be checked gRPC or REST in my Linux platform.