home-monitor

Home monitor projects composed of several tools and script for my home automation

---

Power LDR

scripts located on power-ldr directory

• setup influxdb

docker pull hypriot/rpi-influxdb
docker run -d --restart always --name=influxdb --volume=/home/nonno/docker/influxdb:/data -v /etc/localtime:/etc/localtime:ro -p8086:8086 hypriot/rpi-influxdb

docker exec -it influxdb /usr/bin/influx

Connected to http://localhost:8086 version 1.2.2
InfluxDB shell version: 1.2.2
> CREATE DATABASE SCOSSA
> SHOW DATABASES
name: databases
name
----
_internal
SCOSSA

> use SCOSSA
Using database SCOSSA
> CREATE USER pippo WITH PASSWORD 'ugopassword' WITH ALL PRIVILEGES
> GRANT ALL PRIVILEGES ON SCOSSA TO pippo

• start get-scossa with sudo:

nohup sudo python3 get-scossa/main.py &

or use the systemd script inside get-scossa folder

• we'll use grafana for displaying it: let's create a grafana storage first

docker run -d -v ${HOME}/docker/grafana --name grafana-storage busybox:latest
docker run -d --restart always --net=host --name grafana -v /etc/localtime:/etc/localtime:ro --volumes-from grafana-storage fg2it/grafana-armhf:v4.1.2

• with grafana create a dashboard with a query like that:

SELECT sum("value") * 60 FROM "scossa_led" WHERE $timeFilter GROUP BY time(1m) fill(null)

---

Environmental

• setup influxdb

docker exec -it influxdb /usr/bin/influx

Connected to http://localhost:8086 version 1.2.2
InfluxDB shell version: 1.2.2
> CREATE DATABASE TEMPERATURE
> use TEMPERATURE
Using database TEMPERATURE
> GRANT ALL PRIVILEGES ON TEMPERATURE TO pippo

• start get-temperature with sudo:

nohup sudo python3 get-temperature/main.py &

or use the systemd script inside get-temperature folder

Another way of doing it is to use DHT11 sensor. Use get-environment/main.py script

---

Light timer

A raspberry pi that controls a relay board for switch light on and off