LoRa App Server InfluxDB integration (with Grafana)

I think there is some error connectin to Influx. I cannot access the portal using local host. image

if you are not configured your services to listen localhost bindings, you’re can’t connect to them via localhost:

Dear Eugenev,
I am entirely not sure if I am not connected to the localhost bindings. In CLI, it says connected to localhost:8086 and I can create and access Databases. But, when i try to push data through Loraserver, there’s no response. Could you kindly help meconnect to influx via web with 8083 port.

just type http://localhost:8083/ in your browser while you try to acces to influx running on the same host.

I tried to connect to 8083 port but there was no response. I could not connect to the website.

you need admin UI or use API or something else?
see /etc/influxdb/influxdb.conf
did you read the docs at Learn about InfluxDB OSS | InfluxDB OSS v1 Documentation ?

I’ve been through Influx db startup docs but nothing points me in the right direction. I can only access it via Cli. I din’t know about this admin UI. Do you have any reference docs for this? I am doing the API but was not sure about the retentionpolicyname. Have you done this previously?

if you want Influx web GUI you need to enable it in influxdb.conf
regarding retention field on your screenshot
just left it blank “” if youre not created policies in the influxdb.

@eugenev, thanks for your support, but I am not able to run this influxdb interface. Is there a possibility that anyone had already worked with Influxdb cloud for INFLUXDB integration or with https integration? @brocaar could you help me with the visualization tools/alternatives?

I downgraded to version 1.8.3 because it works directly with current integration settings.

Did you manage to get it to push data to influx v2 from the standard influx integration?

Instructions to install InfluxDB and Grafana:

During the installation you will need to define user name, user password and DB name
use them inside the ChirpStack App server to define integration at integrations tab of your app
for that you will need to click on InfluxDB there,
API endpoint will be http:/
/localhost:8086/write

To check that integration works you can run “influx” command ( using putty ? ) and inside that shell use commands like
use you_db_name
show measurements ( it will show the tables )
select * from your_table_name

your_table_name will be created automatically with table if you already have sent some data

to see normal dates in influx first send command
precision rfc3339

To see your table in Grafana first create the data source
Configuaration - Data Sources
URL http:/
/localhost:8086/
and again that user name, user password and DB name.
Then create the dashboard, add Table Panel and use the query like
select * from your_table_name

Hello @brocaar, first of all thanks for this integration I was looking for a way to do this and is great that is now included with App Server.

I have a question, it seems I’m not encoding correctly the return object since when I check influx I see this:

Connected to http://localhost:8086 version 1.6.4
InfluxDB shell version: 1.6.4

use loraserver
Using database loraserver
show measurements
name: measurements
name


device_uplink

this means the integration is working ok but the format I’m sending the output is not the correct one, could you please give an example of a payload with several variables from the same device?

I have temperature, humidity from 2 different sensors received on the same payload, how should I build the object so I can have the integration write on the database?

thanks in advance

Nevermind, I just wrote the json one variable after the other and it was enough, I was trying to build the object pushing pairs into a json object and it was not working that way.

thanks

i would like to get system metrics for the chirpstack docker container into my influxdb and grafana (we already have a TIG setup for logging all metrics for all our services like node, redis, mongodb, etc). the idea is to see how much resources each service is consuming. can this be achieved?