Installing InfluxDB on Raspberry Pi (2023)

In this Raspberry Pi InfluxDB tutorial, we will show you how to configure and install InfluxDB for the Raspbian operating system.

We'll also show you how to enable authentication on your InfluxDB server to improve its security, and we'll show you how to interact with the database from the command line.

For those who wonderwhat is influxdb, is a database system based on time series. This means that every data point in the database contains a timestamp.

Because it is based on time series, InfluxDB is one of the best databases for monitoring metrics and events. You can easily use InfluxDB to store information like the temperature in a room or the CPU usage of a system.

InfluxDB is the perfect database software that together withpopular Grafana visualization tool🇧🇷 Grafana has built-in support for displaying data from an InfluxDB database.

gear

Below you will find all the equipment needed to set up InfluxDB on your Raspberry Pi.

recommended

• Raspberry Pi
• micro sd card
• power supply
• cabo de ethernetoW-LAN

Optional

• usb keyboard
• USB-Maus
• cabo HDMI

Installing InfluxDB on Raspberry Pi

1.The first thing we need to do before installing InfluxDB on the Raspberry Pi is to ensure that all currently installed packages are up to date.

We can update all installed packages by running the following two commands.

sudo apt-updatesudo apt-update

2.With everything updated, we can now move on to installing InfluxDB on the Raspberry Pi.

Our next step is to add the InfluxDB repository key to our Raspberry Pi.

Adding the key allows the package manager in Raspbian to browse the repository and check for installed packages.

We can add the InfluxDB key by running the following command.

curl https://repos.influxdata.com/influxdb.key | gpg --dearmor | sudo tee /usr/share/keyrings/influxdb-archive-keyring.gpg >/dev/null

This command downloads the key with curl and passes it directly to "gpg"Programming with a Pipe"|🇧🇷 Once the keyfob has been disarmed, it will appear in the "/usr/share/keychains/"Directory.

3.Now that we have installed the InfluxDB repository key on our Raspberry Pi, we need to go ahead and add your repository to the sources list.

Now enter the following command to add the InfluxDB repository to the source list. Make sure you choose the correct command for the version of Raspbian you are running.

Most users performing fresh installs of Raspbian will likely do so.executar Raspbian Buster.

Raspbian/Raspberry Pi operating system

echo "deb [firmado por=/usr/share/keyrings/influxdb-archive-keyring.gpg] https://repos.influxdata.com/debian $(lsb_release -cs) estable" | sudo tee /etc/apt/sources.list.d/influxdb.list

Ubuntu (or Ubuntu Mate)

echo "deb [firmado por=/usr/share/keyrings/influxdb-archive.keyring.gpg] https://repos.influxdata.com/ubuntu $(lsb_release -cs) estable" | sudo tee /etc/apt/sources.list.d/influxdb.list

4.With the repository added, we now need to update the package list again.

We need to do this so that the apt package manager looks for packages in the repository we just added. The operating system does not do this automatically.

Run the following command on your Raspberry Pi to update the package list.

update sudo apt

5.Now that we have the repository set up, we can proceed with installing the InfluxDB software.

To install InfluxDB on our Raspberry Pi, just run the following command.

sudo apt install influxdb

6.Now that InfluxDB is installed on our Raspberry Pi, let's get started at boot time.

We can do this by using the systemctl service manager to enable our InfluxDB service file.

Run the following two commands to allow InfluxDB to start at boot time on your Raspberry Pi.

sudo systemctl unmask influxdbsudo systemctl enable influxdb

The first command we use unmasks the influxdb service file. Unmasking the service ensures that we can enable and start the service, as a masked service cannot start.

Our second command enables the influxdb service. This command tells the service manager to watch "influxdb.service” and configure the service based on its content.

7.With everything set up, we can now start InfluxDB on our Raspberry Pi.

To start the InfluxDB server, we must run the following command. The service manager starts the service and starts monitoring.

sudo systemctl start influxdb

Using InfluxDB on your Raspberry Pi

1.Now that we have InfluxDB installed, we can talk to the database.

To do this, we need to launch the Influx command line tool by running the following command.

You don't have to worry about specifying an address to connect to, as the tool will automatically detect your local InfluxDB installation.

By default, InfluxDB has no user settings. In our next section, we'll explore how to create an admin user to block access to your InfluxDB. For now though, we'll quickly explore InfluxDB.

affluence

2.InfluxDB doesn't come with any default database, so our first task is to create one.

Creating a database is easy in InfluxDB and can be done with "CREATE DATABASE <DBNAME>“.

For our example, we will create a database called "pimylifeuptemperatur“.

CREATE DATABASE pimylifeuptemperature

3.Before we can start modifying our new database, we need to tell the CLI: "to use"es.

Using a database is as simple as running the following command.

USA pimylifeuptemperature

4.Our next step is to write some data to our newly created InfluxDB database.

To do this, we must first gain a basic understanding of the InfluxDB datastore.

Data in InfluxDB is sorted by "time sequences🇧🇷 These "time series" can contain any number or few data points. Each of these data points represents a single sample of that metric.

A data point consists of thetempo, oneMeasurementNames like "Temperature" and at least oneto set up🇧🇷 you can also usekey wordsIt is indexed data consisting only of a string of characters. Tags are essential for optimizing database queries.

If you are familiar with the general layout of an SQL table, you cantempo” as a primary index,Measurementsuch as the table name and thekey wordsyFelderlike column names.

You do not need to specify the timestamp unless you want to specify a specific date and time for the data point.

Below we include the basic format of an InfluxDB data point.

<measure>[,<tag key>=<tag value>...] <field key>=<field value>[,<field key2>=<field value2>...] [unix -nano timestamp]

If you want to learn more about InfluxDB line syntax, see theInfluxDB official documentation.

5.Now that we have a basic understanding of the data in InfluxDB, we can move on to adding our first data point to our database.

For this example database, we will measure the "At temperature"from differentLocationsaround a house

Therefore, we add data points with the measurement name "At temperature' and a tag key of 'era", and a field key of "Wert“.

For our first sampling point, we say that the location of the "living room", and the value is "20” .

INSERT temperature, location = room value = 20

6.To make the data more interesting, to "pick" the data in InfluxDB, let's go ahead and add more random data.

Enter the following commands to insert some additional data into our database. These are just variations of what was said above."INSERTION“command, but with adjusted value and location.

INSERT temperature, location = room value = 10 INSERT temperature, location = room value = 34 INSERT temperature, location = room value = 23

7.Now that we have some sample data, we'll show you how to use that data with "CHOOSE“.

First, you can get all the data for a measurement using a command like the following. This command fetches all fields and keys for the specified measure.

SELECT * OFF Temperature

Using this command with our sample data should give output like the following.

name: temperature time location value -------- ----- 1574055049844513350 room 201574055196564029842 room 101574055196576516557 room 341574055197188117724 room 23

8.Let's say you just want to get the room temperature right now. You can do this by typing the "OS”statement next to a”CHOOSE" Expression.

We also specify the name of the tags/fields we want to get the values ​​from.

When querying tag fields, remember that all tags are treated as strings. This means that we must enclose the value we are looking for in single quotes.

SELECT value FROM temperature WHERE location = 'Schlafzimmer'

With this command, you should get the following dataset, which only shows the temperature reading in the room.

What should it be in the case of our sample data34y23.

name: temperature time location value -------- ----- 1574055049844513350 room 201574055196564029842 room 101574055196576516557 room 341574055197188117724 room 23

9.At this point, you should have a basic understanding of InfluxDB and how its data works.

Add Authentication to InfluxDB

1.The next step is to add additional authentication to our installation of InfluxDB on the Raspberry Pi. Without authentication, anyone can interact with your database.

To get started, we first need to create a user to act as our admin.

To create this user, we first need to load the InfluxDB CLI tool by running the following command.

affluence

2.Within this interface we can create a user who has full access to the database. This user acts as our admin account.

To create this admin user, run the following command in the InfluxDB CLI tool.

be sure to replace<password>with a secure password of your choice.

CREATE admin USER WITH PASSWORD '<password>' WITH ALL PRIVILEGES

This command creates a new user called "Administrator' with your chosen password and grant all privileges.

3.After that you can exit InfluxDB by typing "salidaand pressureLOG IN.

4.Our next task is to modify the InfluxDB configuration file to enable authentication.

We can start editing the file using the following command.

sudo nano /etc/influxdb/influxdb.conf

5.Use inside this fileTO CONTROL+Cto find them[HTTP]Section and add the following options in this section.

Meet

[HTTP]

add below

auth-enabled=truepprof-enabled=truepprof-auth-enabled=trueping-auth-enabled=true

6.After adding the file, save it by pressingTO CONTROL+x, laterY, followed byLOG IN.

7.Now that we've made changes to the InfluxDB configuration, we need to go ahead and restart the service with the following command.

Restarting the service will ensure our configuration changes are read.

sudo systemctl restart influxdb

8.Now that we've enabled InfluxDB authentication, we need to enter our username and password before we can use the InfluxDB CLI tool.

You can use the..."authentication” in the tool or enter the username and password in the command line as below.

Type -admin username -password<password>

Hopefully at this point you have successfully configured InfluxDB on your Raspberry Pi. You should now have a basic understanding of InfluxDB and enable authentication mode.

You can easily see how using this database model facilitates data storage.of sensorsand other very useful sources.

If you had problems getting a Raspberry Pi InfluxDB to work, you can leave a comment below.