INSTALARE GRAFANA – TUTORIAL HOMESERVER

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
a2enmod rewrite

In https://freedns.afraid.org/subdomain/ se adauga subdomeniul grafana.silviamarin.ro

mkdir -p /var/www/silviamarin.ro/grafana 
cp /var/www/html/index.html /var/www/silviamarin.ro/grafana 
chown -R www-data:www-data /var/www

Se genereaza fisierul de configurare grafana.silviamarin.ro.conf:

nano /etc/apache2/sites-available/grafana.silviamarin.ro.conf

si se introduce urmatorul continut (de preferat in Webmin):

<VirtualHost *:80>
ServerName grafana.silviamarin.ro
ServerAdmin spetru32@yahoo.com
RewriteEngine On
RewriteRule ^(.*)$ https://%{HTTP_HOST}$1 [redirect=301]
</VirtualHost>

<IfModule mod_ssl.c>
<VirtualHost *:443>
ServerName grafana.silviamarin.ro
ServerAdmin spetru32@yahoo.com
# Use HTTP Strict Transport Security to force client to use secure connections only.
Header always set Strict-Transport-Security „max-age=31536000; includeSubDomains; preload”
# Referer logging is used to allow websites and web servers to identify where people are visiting them from, for promotional or statistical purposes.
Header always set Referrer-Policy „no-referrer”

SSLCertificateFile /etc/letsencrypt/live/silviamarin.ro/fullchain.pem
SSLCertificateKeyFile /etc/letsencrypt/live/silviamarin.ro/privkey.pem

SSLEngine on
SSLProtocol all -TLSv1 -TLSv1.1 -SSLv2 -SSLv3
SSLHonorCipherOrder on
SSLCompression off
SSLOptions +StrictRequire
SSLCipherSuite 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

ProxyPreserveHost On
ProxyPass / http://127.0.0.1:3000/
ProxyPassReverse / http://127.0.0.1:3000/
</VirtualHost>
</IfModule>

Se activeaza site-ul:

a2ensite grafana.silviamarin.ro.conf
systemctl restart apache2.service

Accesul se face la adresa https://grafana.silviamarin.ro cu admin/admin.

Setari Grafana:
La prima logare se solicita modificarea parolei. Apoi se selecteaza Configurations:
Preferences -> Timezone -> Europe/Bucharest
Datasource -> Add Datasources -> InfluxDB
Name: InfluxDB_ambiental
URL: http://localhost:8086 (sau http://marinmihai.go.ro:8086)
database: ambiental
User: elvis
Password: parola
Se salveaza si se testeaza baza de date. Similar se adauga si bazele de date ambiental si telegraf
Se selecteaza Dashboard -> Manage -> Add dashboard -> DORMITOR -> Save
Se selecteaza Panel title -> Edit
La Query 1 se selecteaza InfluxDB_ambiental
La A:
FROM -> select measurement -> DORMITOR
SELECT -> field(value) -> temperatura
GROUP BY -> time(value) -> 15 min
GROUP BY -> fill ->(linear)
ALIAS BY -> TEMPERATURA DORMITOR
Se poate adauga inca un grafic adaugand un nou query.
In dreapta
Settings
Panel -> Panel title -> TEMPERATURA
Visualization -> Graph
Display
Lines -> Activ
Line width -> 2
Area fill -> 3
Fill gradient -> 10
Axes
Left Y
Show -> Activ
Legend
Values
Min -> Activ
Max -> Activ
Current -> Activ
Sus se seteaza data de cand incepe graficul apoi Apply.

INSTALARE InfluxDB