NR+influxdb+grafana

[Martin10]

Hi, i try to connect NR+influxdb+grafana (in order to store sensor data), but when i get to grafana dashboard I can't get any data from my sensors to the dashboard, what this error could mean ?
I think i completed all requirements, like URL, user, pass, etc...
Any help?

[ghayne]

Can you show us your flow?

[Martin10]

[TotallyInformation]

You will need to show us the structure of your data and the actual grafana query as well.

[Martin10]

Is this the info you ask for?

[ghayne]

It looks like your Grafana queries are not returning any data.

Can you from the command line do the following and show the results as in you first photo:

influx
>use TEMPERATURES
>show MEASUREMENTS
>use HUMIDITY
>show MEASUREMENTS

And then show the details of your Grafana queries.

[Martin10]

Did i not already shown the Grafana queries, or i have to show something else?

[ghayne]

Martin, your measurement structure is confusing, is this the first time you have used NR + InfluxDB + Grafana?

[Martin10]

Yes, this the first time i use NR + InfluxDB + Grafana.

[ghayne]

I suggest yo have a look at some InfluxDB tutorials, to get a better understanding of the structure, here is a good start:

Influxdb Tutorial

You will need an understanding of the SELECT statement to write your Grafana queries properly.

[Martin10]

I thought that influxdb have to use DB from NR, is it correct or not?
Did exist any GUI platform, by which we can create DB for influxdb?

[Colin]

That is correct, but it is up to you to decide on the design of the database. So you have to decide what are the Databases, Measurements, Fields and Tags that you want to use. If you don't know what those are or how to use them then you need to do some research.

[Martin10]

Can i create them with NR?
Can something like this help?
https://flows.nodered.org/flow/56e2df61fbab7bb9c8b20b114ce1ccd3

Did exist any GUI platform, by which we can create DB for influxdb?

[ghayne]

The tutorial I posted above shows you how to create a database. It is easy to do from the command prompt using influx:

create database mydb

Also the InfluxDB node documentation has examples showing how to write to the database:

node-red-contrib-influxdb

[Martin10]

I have some problem:

pi@raspberrypi:~ $ sudo service influxdb start
pi@raspberrypi:~ $ influx
Failed to connect to http://localhost:8086: Get http://localhost:8086/ping: dial tcp [::1]:8086: connect: connection refused
Please check your connection settings and ensure 'influxd' is running.
pi@raspberrypi:~ $ 

[ghayne]

How did you install InfluxDB? Previously you were connecting using influx!

[Martin10]

I don't have problem until i delete one of the DBs

wget -qO- https://repos.influxdata.com/influxdb.key | sudo apt-key add -
source /etc/os-release
echo "deb https://repos.influxdata.com/debian $(lsb_release -cs) stable" | 
sudo tee /etc/apt/sources.list.d/influxdb.list

[UnborN]

just to put a small note on this topic,

you should check if the problems you have with Graphana dashboard are because you are using Chromium browser direcly on the Raspberry pi .. there are several other posts of people having issues with Chromium and Internet explorer.

Can you check your Graphana dashboard from another computer (using you Pi ip) running latest versions of Chrome or Firefox ?

[ghayne]

Martin, we are now way off topic here. This is not really a node-red problem.

You need to read up on the links I posted and also get your InfluxDB installation sorted out, I would suggest starting out from the beginning if possible. A clean install of everything.

Then you should do the following:

1. Understand the principles of InfluxDB and how to create a database that meets your needs.

2. Learn how to query the database to access the data. This is important for setting up Grafana to display the data.

[Martin10]

I can see my DB, i just can't do the connection with grafana