LoRa App Server InfluxDB integration (with Grafana)

brocaar · May 24, 2018, 12:27pm

Edit: I have fixed the issue and am currently releasing a bug fix release Thanks for reporting this issue!

~~If you would be able to create a GitHub issue (see my previous link), that would be much appreciated That way I have all my “todo’s” in one place. I’ll look into this asap.~~

Please do this the next time, the forum is great for discussions etc… but for bugs it is easier for me to have them in one place.

datalab · May 24, 2018, 2:28pm

Hello @brocaar:

I was reporting the issue when I read your reply. So I have canceled the issue report.

Thank you very much for your support. I will report an issue when I find another bug as you have told me.

I want to take this opportunity to tell you that you are doing an amazing work with LoRa Server and its new feature “influxDB integration”.

Kind regards.

vikkymahdrey · May 31, 2018, 11:33am

Hi,
I have configured influxdb with database xyz and measurement temp1. Here temp1 storing key-name with value like key as data and keyName “censor_data” and value 0.63

e.g, INSERT temp1,data=censor_data value=0.63
On selecting database xyz corresponding measurement temp1 getting censor_data values
e.g, select * from temp1

I configured influxdb integration in my application on Lora-app-server with database xyz , url , username, password but not able to get anything in influxdb
So, where I’m doing mistake here?
Is it problem during influxdb integration time or somewhere else?
Please help us

brocaar · May 31, 2018, 3:12pm

LoRa App Server generates its own measurement names based on your decoded data. Please use the show measurements query to list them.

dicarva · August 6, 2018, 2:59pm

Could you share the code of your image because I open the repo and doesn’t show anything

mario_perez_gomariz · October 4, 2018, 1:11pm

Hi, it is not clear to me how to configure the InfluxDB integration. ¿How i can connect the lora app server with InfluxDB? Thanks.

brocaar · October 4, 2018, 2:14pm

See: https://www.loraserver.io/lora-app-server/integrate/sending-receiving/influxdb/

lyon121024 · October 23, 2018, 3:32am

Hello, I’m doing the InfluxDB integration. I will report any progress.

lyon121024 · October 24, 2018, 3:11am

I’ve done it, and it seems to be working well

My system is ubuntu16, and the docker version is:

Docker - compose version:

My configuration process is as follows.you can refer to:
Start by installing influxDB;
Start the program;
Then go to the loraserverweb interface to operate:

The following:

And then:

Then I can see the data at the influxDB. (by the way, the influxDB only needs to create a database. When loraserver receives the data, it will automatically create the corresponding table and save the data.)

mario_perez_gomariz · December 3, 2018, 8:13am

Hi, is the influxDB compatible with the https protocol?

Is this possible in the current version?

brocaar · December 5, 2018, 8:56pm

Have you tried it?

pratik_shah · December 6, 2018, 6:12am

I just spent the last 3 weeks coding to discover all the magic i need is here, with lorasever.io and it writes directly to InfluxDB ( with cayenne).

Man you’re a rock star.

mario_perez_gomariz · December 9, 2018, 11:12am

Yes, I have tried. I configured the influexDB API to https but the lora app server does not store any data in the data base. However lora app server save data if i use http API of Influx.

brocaar · December 9, 2018, 1:40pm

Please check the log output of LoRa App Server for any hints.

mario_perez_gomariz · December 10, 2018, 10:29am

I receive the following message:

I think the problem is the use of self-signed certificates in InfluxDB. Therefore LoRaAppServer can not verify the identity of the influxdb server.
I do not know if it will be possible to set up an https connection between LoRaAppServer and InfluxDB using self-signed certificates in Influx.

Madhukar · April 15, 2019, 4:34pm

Given links are not working any more

Coach · August 18, 2019, 1:51am

Dude,

I am seriously losing my cool with this. It should clearly state in the assumptions of all guides for LoRaServer the following:

You are a Yoda or some other form of higher being before attempting to use LoRaServer
You thrive on sitting in front of your computer and struggling to sift through our (and others) lack of documentation
You wrote LoRaServer so you only have these guide as a vanity to trick others into following your lead.

I dig through forums and google for hours and can’t seem to figure any of this non-sense out. What really pisses me off is that I have $36K of LoRa Gateways going up for the city and can’t even figure this BS out.

Cheers,

Coach

kuroro · December 14, 2019, 7:12am

Any luck on this one?
I have my own Lora Application Server running on Raspberry using postgreSQL. I don’t know how to integrate it to Grafana either, I need to study more since I am not a Yoda.

Moukuri001 · April 22, 2020, 7:22am

I am trying to use my Gateway and have previously used https integration. Now, I want to use Influxdb integration but have faced some probles to install Infludb on my Gateway. Now, i am trying to use Influxdb server to use it online. But, was unsuccessful. Could you guide me how to get my data up and running in Grafana?

eugenev · April 22, 2020, 8:57am

are you correctly getting data in influx? connect to influx via web with port 8083 or via cli and inspect the databases and measurement data
read this: https://grafana.com/docs/grafana/latest/features/datasources/influxdb/