InfluxDB

Instal·lació d'InfluxDB

Un cop instal·lat:

influx
CREATE USER "admin" WITH PASSWORD "contrasenyaAdmin" WITH ALL PRIVILEGES
CREATE USER "usuari" WITH PASSWORD "contrasenyaUsuari"
GRANT ALL ON "baseDeDades" TO "usuari"
CREATE USER "convidat" WITH PASSWORD "contrasenyaConvidat"
GRANT READ ON "baseDeDades" TO "convidat"
show users
quit

sudo nano /etc/influxdb/influxdb.conf
[http]
 # Determines whether user authentication is enabled over HTTP/HTTPS.
   auth-enabled = true
sudo systemctl stop influxd
sudo systemctl start influxd
systemctl status influxd

influx -username usuari -password contrasenyaUsuari
show databases
create database baseDeDades
show databases
use baseDeDades
show measurements
insert mesura00 value=20.1
select * from mesura00
select MAX(*) from mesura00
delete from mesura00 where time=1558227957530517694