Digital-Inputs-Logger-Pi

Log inputs status on a Raspberry Pi and plot graphs of your data. Its been verified to work with a raspberry pi with simple 13 inputs module (Included in PCB folder). By changing the inputspins.yml file and making a corresponding GPIO inputs relation.

Requirements

Hardware

Raspberry Pi B+
13 inputs module (Included in PCB folder) or other module DIY

Software

Raspbian or dietpi
Python 3.4 and PIP3
RPi.GPIO
InfluxDB
Grafana

Installation

Install InfluxDB*

Step-by-step instructions

Add the InfluxData repository

$ curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -
$ source /etc/os-release
$ test $VERSION_ID = "10" && echo "deb https://repos.influxdata.com/debian buster stable" | sudo tee /etc/apt/sources.list.d/influxdb.list

Download and install

$ sudo apt-get update && sudo apt-get install influxdb

Start the influxdb service
```
$ sudo service influxdb start
```
Create the database with data retention of 6 months (if you want more increase the value of weeks or delete it).
```
$ influx
CREATE DATABASE db_inputs WITH DURATION 24w
exit
```

*source

Install Grafana*

Step-by-step instructions

Add APT Repository

$ echo "deb https://packages.grafana.com/oss/deb stable main" | sudo tee -a /etc/apt/sources.list.d/grafana.list

Add Bintray key

$ curl https://packages.grafana.com/gpg.key | sudo apt-key add -

Now install

$ sudo apt-get update && sudo apt-get install grafana

Start the service using systemd:

$ sudo systemctl daemon-reload
$ sudo systemctl start grafana-server
$ systemctl status grafana-server

Enable the systemd service so that Grafana starts at boot.
```
$ sudo systemctl enable grafana-server.service
```
Go to http://localhost:3000 and login using admin / admin (remember to change password) *source

Install Digital-Inputs-Logger-Pi:

Download and install from Github and install pip3

$ sudo apt-get install git
$ git clone https://github.com/GuillermoElectrico/Digital-Inputs-Logger-Pi.git
$ sudo apt-get install python3-pip

Run setup script (must be executed as root (sudo) if the application needs to be started from rc.local, see below)
```
$ cd Digital-Inputs-Logger-Pi
$ sudo python3 setup.py install
```
Make script file executable
```
$ chmod 777 read_input_raspberry.py
```
Edit inputs.yml to match your configuration and influx_config.yml

Test the configuration by running:

./read_input_raspberry.py
./read_input_raspberry.py --help # Shows you all available parameters

If the error appears:

 /usr/bin/env: ‘python3\r’: No such file or directory

Use dos2unix to fix it.

 $ sudo apt install dos2unix
 $ dos2unix /PATH/TO/YOUR/FILE

To run the python script at system startup. Add to following lines to the end of /etc/rc.local but before exit:
```
# Start Inputs Logger
/home/pi/Digital-Inputs-Logger-Pi/read_input_raspberry.py > /var/log/inputs-logger.log &
```
Log with potential errors are found in /var/log/inputs-logger.log

Optional, Install and Configure RTC DS3231

In the case of not having internet in the installation where you have the meter with the raspberry pi, you can install an RTC DS3231 module to be able to correctly register the date and time in the database and grafana.

Step-by-step instructions

First connect the RTC module Connect to the corresponding pins +3.3V, SDA1 (GPIO2), SCL1 (GPIO3) and GND of the raspberry pi (depending on the model, in google there are examples).
Enable I2C port vía raspi-config*
```
$ sudo raspi-config
```
Reboot after enabled.

*If you use orange pi or similar, consult documentation.

Install i2c-tools and verify that the i2c bus and the RTC module are working (Optional)

$ sudo apt-get install i2c-tools
$ sudo i2cdetect -y 1
    0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f
00:          -- -- -- -- -- -- -- -- -- -- -- -- --
10: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
20: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
30: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
40: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
50: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
60: -- -- -- -- -- -- -- -- 68 -- -- -- -- -- -- --
70: -- -- -- -- -- -- -- --

Now check the time of the module, and if it is the case, update the date and time.

Enable RTC module:
```
 $ sudo bash
 $ echo ds1307 0x68 > /sys/class/i2c-adapter/i2c-1/new_device
 $ exit
```
With this the time is read from the RTC:
```
 $ sudo hwclock -r --rtc /dev/rtc0
```
*If you get an error or can not find /dev/rtc0, check the name of the rtc with:
```
 $ ls /dev/rtc?
```
The system time can be seen with:
```
$ date
jue may  5 23:02:46 CLST 2016
```
To set the system time, this command is used:
```
$ sudo date -s "may 5 2016 23:09:40 CLST"
jue may  5 23:09:40 CLST 2016
```
Now as the system clock is fine, you can set the time in the RTC as:
```
 $ sudo hwclock -w --rtc /dev/rtc0
```
To set the date from the rtc each time the system is started Add to following lines to the end of /etc/rc.local but before exit:
```
$ sudo nano /etc/rc.local
```
```
 echo ds1307 0x68 > /sys/class/i2c-adapter/i2c-1/new_device
 sleep 1
 hwclock -s --rtc /dev/rtc0
```