INSTALARE InfluxDB – TUTORIAL HOMESERVER

wget -q https://repos.influxdata.com/influxdata-archive_compat.key
gpg --with-fingerprint --show-keys ./influxdata-archive_compat.key

cat influxdata-archive_compat.key | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/influxdata-archive_compat.gpg > /dev/null

echo 'deb [signed-by=/etc/apt/trusted.gpg.d/influxdata-archive_compat.gpg] https://repos.influxdata.com/debian stable main' | sudo tee /etc/apt/sources.list.d/influxdata.list

sudo rm -f /etc/apt/trusted.gpg.d/influxdb.gpg
sudo apt update && sudo apt install -y influxdb 
sudo systemctl unmask influxdb.service 
sudo systemctl start influxdb 
sudo systemctl enable influxdb.service 
sudo systemctl status influxdb.service

Se deschide InfluxDB cu comanda:

influx

Se creeaza utilizatorul elvis si se aloca privilegiile:

CREATE USER elvis WITH PASSWORD 'parola' WITH ALL PRIVILEGES
SHOW USERS

Output-ul este de forma:

user admin
–- ––
elvis true

Se creeaza baza de date ambiental:

CREATE DATABASE ambiental
SHOW DATABASES
GRANT ALL PRIVILEGES ON ambiental TO elvis
CREATE RETENTION POLICY "un_an" ON ambiental DURATION 365d REPLICATION 1 DEFAULT
SHOW RETENTION POLICIES ON ambiental

Se creeaza baza de date atmosferic:

CREATE DATABASE atmosferic
SHOW DATABASES
GRANT ALL PRIVILEGES ON atmosferic TO elvis
CREATE RETENTION POLICY "un_an" ON atmosferic DURATION 365d REPLICATION 1 DEFAULT
SHOW RETENTION POLICIES ON atmosferic

Comenzi InfluxDB
Listeaza toate inregistrarile pentru measurement-ul HOL

SELECT * FROM HOL

Sterge inregistrarile cu timestamp mai mic de 1596371314400780243 din measurement-ul HOL:

DELETE FROM HOL WHERE time < 1596371314400780243

Introduce date in baza de date ambiental cu measurement-urile HOL, MIHAI, DORMITOR si BUCATARIE:

USE ambiental
INSERT HOL,senzor_id=XiaomiHOL,type=assembly temperatura=13.69,umiditate=58.17,baterie=57,tensiune=2935
INSERT MIHAI,senzor_id=XiaomiMIHAI,type=assembly temperatura=14.88,umiditate=65.98,baterie=83,tensiune=2935
INSERT DORMITOR,senzor_id=XiaomiDORMITOR,type=assembly temperatura=13.53,umiditate=67.51,baterie=77,tensiune=2935
INSERT BUCATARIE,senzor_id=XiaomiBUCATARIE,type=assembly temperatura=14.23,umiditate=59.51,baterie=49,tensiune=2935

INSTALARE SQLite