{"id":419,"date":"2020-08-04T08:43:33","date_gmt":"2020-08-04T08:43:33","guid":{"rendered":"https:\/\/silviamarin.ro\/?p=419"},"modified":"2020-08-04T08:43:33","modified_gmt":"2020-08-04T08:43:33","slug":"instalare-influxdb","status":"publish","type":"post","link":"https:\/\/marinelvis.xyz\/index.php\/2020\/08\/04\/instalare-influxdb\/","title":{"rendered":"INSTALARE InfluxDB"},"content":{"rendered":"
wget -q https:\/\/repos.influxdata.com\/influxdata-archive_compat.key\ngpg --with-fingerprint --show-keys .\/influxdata-archive_compat.key<\/pre>\n
cat influxdata-archive_compat.key | gpg --dearmor | sudo tee \/etc\/apt\/trusted.gpg.d\/influxdata-archive_compat.gpg > \/dev\/null<\/pre>\n
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<\/pre>\n
sudo rm -f \/etc\/apt\/trusted.gpg.d\/influxdb.gpg\nsudo apt update && sudo apt install -y influxdb \nsudo systemctl unmask influxdb.service \nsudo systemctl start influxdb \nsudo systemctl enable influxdb.service \nsudo systemctl status influxdb.service<\/pre>\n
Se deschide InfluxDB<\/em> cu comanda:<\/p>\n
influx<\/pre>\n
Se creeaza utilizatorul elvis<\/em> si se aloca privilegiile:<\/p>\n
CREATE USER elvis WITH PASSWORD\u00a0'parola'<\/span> WITH ALL PRIVILEGES\nSHOW USERS<\/pre>\n
Output-ul este de forma:<\/p>\n
user admin<\/em>
\n–- ––<\/em>
\nelvis true<\/em><\/p><\/blockquote>\n
Se creeaza baza de date ambiental<\/em>:<\/p>\n
CREATE DATABASE ambiental\nSHOW DATABASES\nGRANT ALL PRIVILEGES ON ambiental TO elvis\nCREATE RETENTION POLICY \"un_an\" ON ambiental DURATION 365d REPLICATION 1 DEFAULT\nSHOW RETENTION POLICIES ON ambiental<\/pre>\n
Se creeaza baza de date atmosferic:<\/em><\/p>\n
CREATE DATABASE atmosferic\nSHOW DATABASES\nGRANT ALL PRIVILEGES ON atmosferic TO elvis\nCREATE RETENTION POLICY \"un_an\" ON atmosferic DURATION 365d REPLICATION 1 DEFAULT\nSHOW RETENTION POLICIES ON atmosferic<\/pre>\n
Comenzi InfluxDB<\/strong>
\nListeaza toate inregistrarile pentru measurement-ul HOL<\/p>\n
SELECT * FROM HOL<\/pre>\n
Sterge inregistrarile cu timestamp mai mic de 1596371314400780243 din measurement-ul HOL:<\/p>\n
DELETE FROM HOL WHERE time < 1596371314400780243<\/pre>\n
Introduce date in baza de date ambiental<\/em> cu measurement-urile HOL, MIHAI, DORMITOR si BUCATARIE<\/em>:<\/p>\n
USE ambiental\nINSERT HOL,senzor_id=XiaomiHOL,type=assembly temperatura=13.69,umiditate=58.17,baterie=57,tensiune=2935\nINSERT MIHAI,senzor_id=XiaomiMIHAI,type=assembly temperatura=14.88,umiditate=65.98,baterie=83,tensiune=2935\nINSERT DORMITOR,senzor_id=XiaomiDORMITOR,type=assembly temperatura=13.53,umiditate=67.51,baterie=77,tensiune=2935\nINSERT BUCATARIE,senzor_id=XiaomiBUCATARIE,type=assembly temperatura=14.23,umiditate=59.51,baterie=49,tensiune=2935\nINSERT SUFRAGERIE,senzor_id=XiaomiSUFRAGERIE,type=assembly temperatura=12.60,umiditate=65.00,baterie=100,tensiune=2935\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-419","post","type-post","status-publish","format-standard","hentry","category-fara-categorie"],"_links":{"self":[{"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/posts\/419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=419"}],"version-history":[{"count":0,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"wp:attachment":[{"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}