Installing InfluxDB on OrangePI Zero (OPI)
-
Below is a small tutorial on how to install InfluxDB on the OrangePI Zero.
The image used is Armbian 5.36 (Jesse)___ ____ _ _____ / _ \ _ __ __ _ _ __ __ _ ___ | _ \(_) |__ /___ _ __ ___ | | | | '__/ _` | '_ \ / _` |/ _ \ | |_) | | / // _ \ '__/ _ \ | |_| | | | (_| | | | | (_| | __/ | __/| | / /| __/ | | (_) | \___/|_| \__,_|_| |_|\__, |\___| |_| |_| /____\___|_| \___/ |___/ Welcome to ARMBIAN 5.36 user-built Debian GNU/Linux 8 (jessie) 3.4.113-sun8i System load: 0.40 0.37 0.32 Up time: 10 days Memory usage: 65 % of 494MB IP: xxx.xxx.xxx.xxx CPU temp: 55°C Usage of /: 12% of 15G storage/: 4% of 7.5G [ 0 security updates available, 8 updates total: apt upgrade ] Last check: 2017-12-06 00:00 [ General system configuration (beta): armbian-config ] root@orangepizero:~# uname -a Linux orangepizero 3.4.113-sun8i #4 SMP PREEMPT Wed Nov 22 13:45:28 CET 2017 armv7l GNU/Linux root@orangepizero:~# cat /etc/issue Debian GNU/Linux 8 \n \lStep 1:
Add the InfluxDB repository to the the OS:curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add - source /etc/os-releaseand:
sudo echo "deb https://repos.influxdata.com/debian jessie stable" | sudo tee /etc/apt/sources.list.d/influxdb.listStep 2:
Install the influxDB databasesudo apt-get updateAnd get InfluxDB installed:
apt-get install influxdbIf all is successfull you should see similar output like this:
Reading package lists... Done Building dependency tree Reading state information... Done The following NEW packages will be installed: influxdb 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 19.1 MB of archives. After this operation, 57.1 MB of additional disk space will be used. Get:1 https://repos.influxdata.com/debian/ jessie/stable influxdb armhf 1.4.2-1 [19.1 MB] Fetched 19.1 MB in 6s (3,071 kB/s) Selecting previously unselected package influxdb. (Reading database ... 44212 files and directories currently installed.) Preparing to unpack .../influxdb_1.4.2-1_armhf.deb ... Unpacking influxdb (1.4.2-1) ... Processing triggers for man-db (2.7.0.2-5) ... Setting up influxdb (1.4.2-1) ... Created symlink from /etc/systemd/system/influxd.service to /lib/systemd/system/influxdb.service. Created symlink from /etc/systemd/system/multi-user.target.wants/influxdb.service to /lib/systemd/system/influxdb.service. root@orangepizero:~#Step 3:
Start InfluxDBservice influxdb startand test if you are able to connect to the database:
root@orangepizero:~# influx Connected to http://localhost:8086 version 1.4.2 InfluxDB shell version: 1.4.2 >The 'TICK' stack also contains other parts which can be used incombination with InfluxDB like:
- Telegraf (Agent for collecting and reporting metrics and events)
- InfluxDB (Time series database)
- Chronograf (Complete interface to the TICK stack)
- Kapacitor (Realtime streaming data processing engine)
This page was a great help to get influxdb installed
Howto create a database
Logon with the influx shell,orangepizero:~# influx Connected to http://localhost:8086 version 1.4.2 InfluxDB shell version: 1.4.2 >Then first see what databases already exist with the command "SHOW DATABASES". for a new installation only "_internal" should be there. Then pick a name that is not in use, in my case i used "mysensors"
> CREATE DATABASE mysensors > show databases name: databases name ---- _internal mysensorsAfter the DB is successfully created, it needs to be "used"
> USE mysensors Using database mydb >more info here
How to create a user account in influxdb
Connect to the influx shellorangepizero:/mnt/usb-disk/influxdb# influx Connected to http://localhost:8086 version 1.4.2 InfluxDB shell version: 1.4.2 >Then create a user with the command:
CREATE USER <username> WITH PASSWORD '<password>' WITH ALL PRIVILEGESThis will create a secondary admin user
See this link for more info