InfluxDB is a time series database. The build is robust and straightforward but first lets start with what didn’t work:
- I could not get Raspbian Buster image to work for the RPi Zero, I reverted to Raspbian Stretch image. Get the image from the Raspberry Pi Archives. Grafana also showed issues on Buster so avoid the headache for now.
wget -qO- https://repos.influxdata.com/influxdb.key | sudo apt-key add - source /etc/os-release test $VERSION_ID = "9" && echo "deb https://repos.influxdata.com/debian stretch stable" | sudo tee /etc/apt/sources.list.d/influxdb.list sudo apt-get update sudo apt-get install influxdb sudo service influxdb start influxd -config /etc/influxdb/influxdb.conf echo $INFLUXDB_CONFIG_PATH /etc/influxdb/influxdb.conf influxd sudo service influxdb restart
Open the file /etc/influxdb/influxdb.conf and ensure the [http] section looks like the below:
sudo nano /etc/influxdb/influxdb.conf
[http] # Determines whether HTTP endpoint is enabled. enabled = true # Determines whether the Flux query endpoint is enabled. # flux-enabled = false # Determines whether the Flux query logging is enabled. # flux-log-enabled = false # The bind address used by the HTTP service. bind-address = ":8086" # Determines whether user authentication is enabled over HTTP/HTTPS. auth-enabled = false
InfluxDB is setup and running now but we have no data stored. First we must create a database in InfluxDB, then we can insert data:
influx create database rpi_01 INSERT system_status,system=RPI-01 cpu_usage=10
We can then view the contents of the database by:
use rpi_01 select * from system_status
You should see and entry like the below in your terminal:
name: system_status time cpu_usage system ---- --------- ------ 1573332238034530963 10 RPI-01
We are now successfully manually writing to the database, in the next tutorial we will write a script to log the CPU & GPU temperatures of the Raspberry Pi and also the CPU Usage in %.