Hauptmenü öffnen
Zuletzt geändert am 20. Juli 2018 um 21:04

InfluxDB: Unterschied zwischen den Versionen

(Die Seite wurde neu angelegt: „ == Installation == curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -<br> echo "deb https://repos.influxdata.com/debian stretch stab…“)
 
(→‎Command Line)
 
(7 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
 +
Hoch effiziente in Go geschriebene Opensource-Datenbank für Zeitreihen wie IoT-Sensordaten und Echtzeitanalysen
  
 
== Installation ==
 
== Installation ==
  
−
   curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -<br>
+
   curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -
−
   echo "deb https://repos.influxdata.com/debian stretch stable" | sudo tee /etc/apt/sources.list.d/influxdb.list<br>
+
   echo "deb https://repos.influxdata.com/debian stretch stable" | sudo tee /etc/apt/sources.list.d/influxdb.list
−
   sudo apt update<br>
+
   sudo apt update
−
   sudo apt install influxdb telegraf<br>
+
   sudo apt install influxdb telegraf
−
   sudo systemctl enable influxdb<br>
+
   sudo systemctl enable influxdb
 
   sudo systemctl start influxdb
 
   sudo systemctl start influxdb
 +
 +
== Konfigurieren ==
 +
 +
  influx
 +
 
 +
  > CREATE DATABASE openhab_db
 +
  > CREATE USER admin WITH PASSWORD '<passwort>' WITH ALL PRIVILEGES
 +
  > CREATE USER openhab WITH PASSWORD '<passwort>'
 +
  > CREATE USER grafana WITH PASSWORD '<passwort>'
 +
  > GRANT ALL ON openhab_db TO openhab
 +
  > GRANT READ ON openhab_db TO grafana
 +
  > exit
 +
 +
Authentifizierung für http in Konfigurationsdatei /etc/influxdb/influxdb.conf eintragen
 +
 +
  [http] 
 +
  enabled = true 
 +
  bind-address = ":8086"
 +
  auth-enabled = true
 +
 +
Service neu starten
 +
  sudo systemctl restart influxdb.service
 +
 +
Testen ob es geht
 +
  influx -username grafana -password <passwort> -host localhost
 +
  use openhab_db
 +
 +
== Command Line ==
 +
 +
  influx -username grafana -password <passwort>
 +
  show databases
 +
  use openhab_db
 +
  show measurements // tables
 +
  select * from cpu_temp
 +
  select * from cpu_temp limit 3
 +
 
 +
  name: cpu_temp
 +
  time                value
 +
  ----                -----
 +
  1531852226992000000 50.5
 +
  1531852230885000000 49.9
 +
  1531852234905000000 49.4
 +
 +
Um die Zeit lesbar zu machen
 +
 +
  precision rfc3339
 +
 +
  select * from cpu_temp limit 3
 +
  name: cpu_temp
 +
  time                    value
 +
  ----                    -----
 +
  2018-07-17T18:30:26.992Z 50.5
 +
  2018-07-17T18:30:30.885Z 49.9
 +
  2018-07-17T18:30:34.905Z 49.4

Aktuelle Version vom 20. Juli 2018, 21:04 Uhr

Hoch effiziente in Go geschriebene Opensource-Datenbank für Zeitreihen wie IoT-Sensordaten und Echtzeitanalysen

Installation

 curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -
 echo "deb https://repos.influxdata.com/debian stretch stable" | sudo tee /etc/apt/sources.list.d/influxdb.list
 sudo apt update
 sudo apt install influxdb telegraf
 sudo systemctl enable influxdb
 sudo systemctl start influxdb

Konfigurieren

 influx
 
 > CREATE DATABASE openhab_db
 > CREATE USER admin WITH PASSWORD '<passwort>' WITH ALL PRIVILEGES
 > CREATE USER openhab WITH PASSWORD '<passwort>'
 > CREATE USER grafana WITH PASSWORD '<passwort>'
 > GRANT ALL ON openhab_db TO openhab
 > GRANT READ ON openhab_db TO grafana
 > exit

Authentifizierung für http in Konfigurationsdatei /etc/influxdb/influxdb.conf eintragen 

 [http]  
 enabled = true  
 bind-address = ":8086"
 auth-enabled = true

Service neu starten 

 sudo systemctl restart influxdb.service

Testen ob es geht 

 influx -username grafana -password <passwort> -host localhost
 use openhab_db

Command Line

 influx -username grafana -password <passwort>
 show databases
 use openhab_db
 show measurements // tables
 select * from cpu_temp
 select * from cpu_temp limit 3
 
 name: cpu_temp
 time                value
 ----                -----
 1531852226992000000 50.5
 1531852230885000000 49.9
 1531852234905000000 49.4

Um die Zeit lesbar zu machen 

 precision rfc3339

 select * from cpu_temp limit 3
 name: cpu_temp
 time                     value
 ----                     -----
 2018-07-17T18:30:26.992Z 50.5
 2018-07-17T18:30:30.885Z 49.9
 2018-07-17T18:30:34.905Z 49.4