Project TTN Daten in InfluxDB für Grafana: Difference between revisions

From JoBaPedia
Jump to navigation Jump to search
No edit summary
Line 5: Line 5:
Finally it shows how to create a Grafana dashboard to display the data from the InfluxDB.
Finally it shows how to create a Grafana dashboard to display the data from the InfluxDB.


== Installing InfluxDB ==
== InfluxDB ==
 
=== Installing InfluxDB ===


Here is the [https://portal.influxdata.com/downloads/ Download Portal]
Here is the [https://portal.influxdata.com/downloads/ Download Portal]
Line 11: Line 13:


  wget https://dl.influxdata.com/influxdb/releases/influxdb-1.7.9.x86_64.rpm
  wget https://dl.influxdata.com/influxdb/releases/influxdb-1.7.9.x86_64.rpm
  zypper install influxdb-1.7.9.x86_64.rpm
  sudo zypper install influxdb-1.7.9.x86_64.rpm


It warns about missing package shadow-util. On openSuse this is named shadow and is installed -> ignore.
It warns about missing package shadow-util. On openSuse this is named shadow and is installed -> ignore.
Line 17: Line 19:
To use systemd for managing the database service, copy the service file
To use systemd for managing the database service, copy the service file


  cp -av /usr/lib/influxdb/scripts/influxdb.service /etc/systemd/system/
  sudo cp -av /usr/lib/influxdb/scripts/influxdb.service /etc/systemd/system/


For later versions of openSuse, [https://docs.influxdata.com/influxdb/v1.7/introduction/installation/# Influx Installation Documentation] suggests using a repository - should have the same results:
For later versions of openSuse, [https://docs.influxdata.com/influxdb/v1.7/introduction/installation/# Influx Installation Documentation] suggests using a repository - should have the same results:


  zypper ar -f obs://devel:languages:go/ go
  sudo zypper ar -f obs://devel:languages:go/ go
  zypper in influxdb
  sudo zypper in influxdb
 
=== Configure InfluxDB ===
 
sudo vi /etc/influxdb/influxdb.conf
 
=== Start InfluxDB ===
 
sudo systemctl daemon-reload
sudo systemctl enable influxdb
sudo systemctl start influxdb
sudo systemctl status influxdb
 
== Grafana ==


== Configure InfluxDB ==
=== Install Grafana ===


vi /etc/influxdb/influxdb.conf
Here are the [https://grafana.com/grafana/download installation instructions]. Basically just do


== Start InfluxDB ==
wget https://dl.grafana.com/oss/release/grafana-6.5.2-1.x86_64.rpm
sudo zypper install grafana-6.5.2-1.x86_64.rpm


systemctl daemon-reload
It complains about missing urw-fonts, but they are not really required -> ignore
systemctl enable influxdb
Also accept there is no signing key
systemctl start influxdb
systemctl status influxdb

Revision as of 15:23, 18 December 2019

Flexible Visualization of TTN Data

This page describes installing Grafana and InfluxDB on openSuse 42.2. It also describes how to configure apache 2.4 to recieve data from a Things Network applications HTTP integration and store it in an InfluxDB database. Finally it shows how to create a Grafana dashboard to display the data from the InfluxDB.

InfluxDB

Installing InfluxDB

Here is the Download Portal Currently, it tells me to

wget https://dl.influxdata.com/influxdb/releases/influxdb-1.7.9.x86_64.rpm
sudo zypper install influxdb-1.7.9.x86_64.rpm

It warns about missing package shadow-util. On openSuse this is named shadow and is installed -> ignore.

To use systemd for managing the database service, copy the service file

sudo cp -av /usr/lib/influxdb/scripts/influxdb.service /etc/systemd/system/

For later versions of openSuse, Influx Installation Documentation suggests using a repository - should have the same results:

sudo zypper ar -f obs://devel:languages:go/ go
sudo zypper in influxdb

Configure InfluxDB

sudo vi /etc/influxdb/influxdb.conf

Start InfluxDB

sudo systemctl daemon-reload
sudo systemctl enable influxdb
sudo systemctl start influxdb
sudo systemctl status influxdb

Grafana

Install Grafana

Here are the installation instructions. Basically just do

wget https://dl.grafana.com/oss/release/grafana-6.5.2-1.x86_64.rpm 
sudo zypper install grafana-6.5.2-1.x86_64.rpm 

It complains about missing urw-fonts, but they are not really required -> ignore Also accept there is no signing key