{"id":424,"date":"2020-08-04T09:01:43","date_gmt":"2020-08-04T09:01:43","guid":{"rendered":"https:\/\/silviamarin.ro\/?p=424"},"modified":"2020-08-04T09:01:43","modified_gmt":"2020-08-04T09:01:43","slug":"instalare-grafana","status":"publish","type":"post","link":"https:\/\/marinelvis.xyz\/index.php\/2020\/08\/04\/instalare-grafana\/","title":{"rendered":"INSTALARE GRAFANA"},"content":{"rendered":"

Ca root:<\/p>\n

wget -q -O - https:\/\/packages.grafana.com\/gpg.key | apt-key add -\necho \"deb https:\/\/packages.grafana.com\/oss\/deb stable main\" | sudo tee \/etc\/apt\/sources.list\napt update\napt install -y grafana<\/pre>\n
Se activeaza serviciul grafana-server<\/em>:<\/p>\n
systemctl unmask grafana-server.service\nsystemctl enable grafana-server.service\nsystemctl start grafana-server<\/pre>\n
Securizare Grafana<\/strong>
\nSe activeaza urmatoarele module in Apache2:<\/p>\n
a2enmod proxy\na2enmod proxy_http\na2enmod proxy_html\na2enmod headers\na2enmod rewrite<\/pre>\n
In https:\/\/freedns.afraid.org\/subdomain\/<\/em><\/a> se adauga subdomeniul grafana.silviamarin.ro<\/em><\/p>\n
mkdir -p \/var\/www\/silviamarin.ro<\/span>\/grafana \ncp \/var\/www\/html\/index.html \/var\/www\/silviamarin.ro<\/span>\/grafana \nchown -R www-data:www-data \/var\/www<\/pre>\n
Se genereaza fisierul de configurare grafana.silviamarin.ro<\/span>.conf<\/em>:<\/p>\n
nano \/etc\/apache2\/sites-available\/grafana.silviamarin.ro<\/span>.conf<\/pre>\n
si se introduce urmatorul continut (de preferat in Webmin):<\/p>\n
<VirtualHost *:80><\/em>
\nServerName grafana.silviamarin.ro<\/span><\/em>
\nServerAdmin spetru32@yahoo.com<\/em>
\nRewriteEngine On<\/em>
\nRewriteRule ^(.*)$ https:\/\/%{HTTP_HOST}$1 [redirect=301]<\/em>
\n<\/VirtualHost><\/em><\/p>\n
<IfModule mod_ssl.c><\/em>
\n<VirtualHost *:443><\/em>
\nServerName grafana.silviamarin.ro<\/span><\/em>
\nServerAdmin spetru32@yahoo.com<\/em>
\n# Use HTTP Strict Transport Security to force client to use secure connections only.<\/em>
\nHeader always set Strict-Transport-Security „max-age=31536000; includeSubDomains; preload”<\/em>
\n# Referer logging is used to allow websites and web servers to identify where people are visiting them from, for promotional or statistical purposes.<\/em>
\nHeader always set Referrer-Policy „no-referrer” <\/em><\/p>\n
SSLCertificateFile \/etc\/letsencrypt\/live\/silviamarin.ro<\/span>\/fullchain.pem<\/em>
\nSSLCertificateKeyFile \/etc\/letsencrypt\/live\/silviamarin.ro<\/span>\/privkey.pem<\/em><\/p>\n
SSLEngine on<\/em>
\nSSLProtocol all -TLSv1 -TLSv1.1 -SSLv2 -SSLv3<\/em>
\nSSLHonorCipherOrder on<\/em>
\nSSLCompression off<\/em>
\nSSLOptions +StrictRequire<\/em>
\nSSLCipherSuite ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256<\/em><\/p>\n
ProxyPreserveHost On <\/em>
\nProxyPass \/ http:\/\/127.0.0.1:3000\/<\/em>
\nProxyPassReverse \/ http:\/\/127.0.0.1:3000\/<\/em>
\n<\/VirtualHost><\/em>
\n<\/IfModule><\/em><\/p><\/blockquote>\n
Se activeaza site-ul:<\/p>\n
a2ensite grafana.silviamarin.ro<\/span>.conf\nsystemctl restart apache2.service<\/pre>\n
Accesul se face la adresa https:\/\/grafana.silviamarin.ro <\/span><\/em>cu admin\/admin.<\/p>\n
Setari Grafana:
\nLa prima logare se solicita modificarea parolei. Apoi se selecteaza Configurations<\/strong>:
\nPreferences -> Timezone -> Europe\/Bucharest<\/em>
\nDatasource -> Add Datasources -> InfluxDB<\/em>
\nName: InfluxDB_ambiental
\nURL: http:\/\/localhost:8086<\/em> (sau http:\/\/marinmihai.go.ro:8086)<\/em>
\ndatabase: ambiental<\/em>
\nUser: elvis<\/em>
\nPassword: parola<\/span><\/em>
\nSe salveaza si se testeaza baza de date. Similar se adauga si bazele de date ambiental<\/em> si telegraf<\/em>
\nSe selecteaza Dashboard<\/strong> -> Manage -> Add dashboard -> DORMITOR -> Save
\nSe selecteaza Panel title<\/strong> -> Edit
\nLa Query 1<\/em> se selecteaza InfluxDB_ambiental<\/em>
\nLa A:
\nFROM -> select measurement -> DORMITOR
\nSELECT -> field(value) -> temperatura
\nGROUP BY -> time(value) -> 15 min
\nGROUP BY -> fill ->(linear)
\nALIAS BY -> TEMPERATURA DORMITOR
\nSe poate adauga inca un grafic adaugand un nou query.
\nIn dreapta
\nSettings<\/strong>
\nPanel -> Panel title -> TEMPERATURA
\nVisualization<\/strong> -> Graph
\nDisplay<\/strong>
\nLines -> Activ
\nLine width -> 2
\nArea fill -> 3
\nFill gradient -> 10
\nAxes<\/strong>
\nLeft Y
\nShow -> Activ
\nLegend<\/strong>
\nValues
\nMin -> Activ
\nMax -> Activ
\nCurrent -> Activ
\nSus se seteaza data de cand incepe graficul apoi Apply.<\/p>\n
SQLite in Grafana<\/strong><\/p>\n
grafana-cli plugins install frser-sqlite-datasource\nsystemctl stop grafana\nsystemctl start grafana\nsystemctl status grafana<\/pre>\n
In Grafana: Configuration -> Add datasource – SQLite<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
Ca root: wget -q -O – https:\/\/packages.grafana.com\/gpg.key | apt-key add – echo „deb https:\/\/packages.grafana.com\/oss\/deb stable main” | sudo tee \/etc\/apt\/sources.list apt update apt install -y grafana Se activeaza serviciul grafana-server: systemctl unmask grafana-server.service systemctl enable grafana-server.service systemctl start grafana-server Securizare Grafana Se activeaza urmatoarele module in Apache2: a2enmod proxy a2enmod proxy_http a2enmod proxy_html a2enmod headers […]<\/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-424","post","type-post","status-publish","format-standard","hentry","category-fara-categorie"],"_links":{"self":[{"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/posts\/424","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=424"}],"version-history":[{"count":0,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/posts\/424\/revisions"}],"wp:attachment":[{"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/categories?post=424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marinelvis.xyz\/index.php\/wp-json\/wp\/v2\/tags?post=424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}