====== Temperature Verification System for CPD (Raspi) ======

====== Initial Raspberry Pi Setup ======

See chapter on Initial Raspberry Pi Setup

==== OS for RPI ====

Download the Raspbian/Lite image from https://www.raspberrypi.org/downloads/raspbian/

Download the Win32 Disk Imager program from http://sourceforge.net/projects/win32diskimager/

Start Win32 Disk Imager and select the downloaded Raspbian image (.img file) with the "Image File" selector. Choose the drive letter where the SD card is and click "Write".

Imager will ask for confirmation to overwrite. Select "Yes". Wait for the confirmation and click "OK", then close Disk Imager and remove the SD card.

==== Basic Raspberry Pi Setup ====

Insert the SD card into the Raspberry Pi (connect the keyboard and display before connecting the power).

The Raspberry Pi will boot and ask for a username and password.

By default, they are:

username: **pi**

password: **raspberry**

After booting, you can enter the configuration with:

<code bash>sudo raspi-config</code> 

In the configuration:

   - Change password/username if needed
   - Configure boot to console, smb option 1, console.
   - Adjust/check time/language/keyboard settings.
   - In the interfacing options, select P2 - SSH enable
   - Open advanced options -> Expand filesystem
  
Finally, go to "Finish" and reboot the Raspberry Pi with:

<code bash>sudo reboot</code>

==== PC Connection (SSH) ====

From Windows, you can use PuTTY: http://www.chiark.greenend.org.uk/~sgtatham/putty....

To find the Raspberry Pi's IP, you can use:

<code>ifconfig</code>

==== Sensor Wiring ====

{{ :raspberry_pi:projects:raspberrypi-gpio-connection-sensor-dht22-am2302.png?300 |}}

==== Install DHT22 Libraries ====

Update the Raspberry Pi:

<code bash>sudo apt-get update

sudo apt-get upgrade</code>

Install Adafruit Python code, necessary for reading the DHT22 sensor. It also allows checking if everything is set up correctly.

First, install the compiler and Python library:

<code bash>sudo apt-get install build-essential python-dev python-openssl</code>

Navigate to the directory where you want to install the Adafruit code, by default /home/.

<code bash>cd /home/pi</code>

You may need to install Git if it's not included by default:

<code bash>sudo apt-get install git</code>

Clone the git repository:

<code bash>git clone https://github.com/adafruit/Adafruit_Python_DHT.g...</code>

Go to the corresponding directory:

<code bash>cd Adafruit_Python_DHT</code>

And finally, install the Adafruit library. Type the following and press enter:

<code bash>sudo python setup.py install</code>

==== DHT22 Test ====

Navigate to the Adafruit_Python_DHT directory and then to the examples directory. Enter the following and press enter.

<code bash>cd /home/pi/Adafruit_Python_DHT/examples</code>

Test the operation with:

<code bash>sudo ./AdafruitDHT.py sensortype GPIO</code>

In the case of the wiring from the text:

<code bash>sudo ./AdafruitDHT.py 22 4</code>

If everything is correct, the sensor reading will appear.

==== MySQL Configuration for Storing Temperature Data ====

Install MySQL/MariaDB and the necessary plugins:

<code>sudo apt-get install mysql-server python-mysqldb</code>

Enter the SQL console:

<code>sudo mysql -u root -p -h localhost</code>

Press Enter for the password (empty), and we will enter the MariaDB console.

On the console:

First, create a database called temperatures:

<code sql>CREATE DATABASE temperatures;</code>

Select the created database:

<code sql>USE temperatures;</code>

Create a user and grant access to the database to this user:

<code sql>CREATE USER 'logger'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON temperatures.* TO 'logger'@'localhost';

FLUSH PRIVILEGES;</code>

The user/privileges are created. Now, you can switch from the root user to this new user:

<code sql>quit</code>

Reconnect with the new user:

<code>sudo mysql -u logger -p -h localhost</code>

Enter the password created earlier.

Create two tables: `temperaturedata` to store the sensor data (date/time, sensor, temperature, humidity) and `mailsendlog` with information about emails triggered by temperature limits.

To create the tables:

<code sql>USE temperatures;</code>

Create the first table with columns for date/time, sensor, temperature, and humidity:

<code sql>CREATE TABLE temperaturedata (dateandtime DATETIME, sensor VARCHAR(32), temperature DOUBLE, humidity DOUBLE);</code>

Create the second table with columns for date/time, triggered sensor, triggered limit, and last temperature:

<code sql>CREATE TABLE mailsendlog (mailsendtime DATETIME, triggedsensor VARCHAR(32), triggedlimit VARCHAR(10), lasttemperature VARCHAR(10));</code>

You can confirm that the empty tables were created with:

<code sql>SELECT * FROM mailsendlog;
SELECT * FROM temperaturedata;</code>

If the tables exist, you will see: "Empty Set (0.00 sec)"

The database is configured, and you can exit MySQL:

<code>quit</code>

Restart MySQL to apply the changes:

<code>sudo /etc/init.d/mysql restart</code>

==== Temperature Logger Code ====

Make sure you are in the directory where you want to install the DHT22-TemperatureLogger, by default /home/pi/:

<code bash>cd /home/pi</code>

Clone the git repository:

<code bash>git clone https://github.com/jjpFin/DHT22-TemperatureLogger</code>

Go to the DHT22-TemperatureLogger directory:

<code bash>cd /home/pi/DHT22-TemperatureLogger</code>

Open `config.json` in an editor:

<code bash>sudo nano config.json</code>

Configuration list:

<code python>
#mysql: Database configuration.

#sensors: Configuration for the sensors connected to the RPI.

#name: sensor name and GPIO where it is connected.

#SensorType: 22 for a DHT22.

#Temperature low and high limits to trigger alert emails.

#Humidity limits similarly for humidity.

#Threshold: activation threshold for warnings.

#mailInfo: Email information.

#Senderaddress: Email sender address.

#Receiveraddress: Email receiver address.

#Username: email username.

#Password: email password.

#subjectMessage: Email subject.

#subjectWarning: Reason for the email.

#sqlBackupDump: backup dump configuration.

#BackupDumpEnabled y/n indicates if SQL backup is enabled.

#backupDay: day for the backup. 1-7 (Monday to Sunday) 0 daily.

#backupHour: hour of the dump - 0-24

#backupDumpPath: path where the dump is saved. By default, the Backups folder.

#weeklyAverages: Define if weekly averages are sent.

#weeklyAveragesSendingEnabled: y means enabled.

#weekDayForSendingAverages: day of the week for averages. 1-7 (Monday to Sunday).

#hourOfTheDayForSendingAverages: hour of the day 0-24.

#useFahrenheits: y enabled, n disabled.

#mailSendingTimeoutInFullHours: 0-x

#To reduce spam. At 0, logger sends mail for each warning. Higher values limit the emails to one per hour. Used to prevent inbox from being flooded with alerts.

#adafruitPath: path for Adafruit_Python_DHT, by default /home/pi/Adafruit_Python_DHT/ Script AdafruitDHT.py.
</code>

Once the configurations are done, press Ctrl+x and save with "Y". Test the DHT22-TemperatureLogger:

<code bash>python DHT22logger.py</code>

If everything is correct, the program will write to the database. To verify, enter the database:

<code bash>sudo mysql -u logger -p -h localhost</code>

Enter the corresponding password. In the MySQL console:

<code sql>use temperatures;

select * from temperaturedata;</code>

Verify that the readings are written to the database. To exit:

<code sql>quit</code>

==== Automatic Sensor Reading ====

Add a cron task:

<code>crontab -e</code>

Select the /bin/nano option, and the crontab will open.

Add the task to the crontab (for example, every 15 minutes):

<code>*/15 * * * * python /home/pi/DHT22-TemperatureLogger/DHT22logger.py</code>

Exit and save with Ctrl+x, selecting "Y" when asked.

==== Configure Static IP for Raspbian ====

To configure a static IP in Raspbian, you need to edit the file `/etc/dhcpcd.conf`:

<code>sudo nano /etc/dhcpcd.conf</code>

If you look at the content, you will see commented lines (starting with '#') that provide an example of static IP configuration:

<code>
# Example static IP configuration:
#interface eth0
#static ip_address=192.168.0.10/24
#static ip6_address=fd51:42f8:caae:d92e::ff/64
#static routers=192.168.0.1
#static domain_name_servers=192.168.0.1 8.8.8.8 fd51:42f8:caae:d92e::1
</code>

==== ThinkSpeak ====

==== ThingSpeak Account Configuration ==== 

Register at https://thingspeak.com. 
If you don't have a previous account with MathWorks, ThingSpeak will redirect you, with the option to use the same email to register at: https://www.mathworks.com.

Create a new channel in your profile and add two field charts (Temperature and Humidity).
Get the "Write API Key" for the created channel, which will be used to configure the ThingSpeak connection script and data submission.

==== Python Script for Sending Data to ThingSpeak ts.py ==== 

<code python>
    import sys
    import urllib2
    import RPi.GPIO as GPIO
    import Adafruit_DHT
    # Write API Key ThingSpeak.com
    miWriteAPIKey = "XXXXXXXXXXXXXXXX"
    # GPIO number for DHT22 sensor connection to RaspberryPi
    raspiNumGPIO = "X"
    def getSensorData():
       RH, T = Adafruit_DHT.read_retry(Adafruit_DHT.DHT22, raspiNumGPIO)
       return (str(RH), str(T))
    def main():
       print 'Starting...'
       baseURL = 'https://api.thingspeak.com/update?api_key=%s' % miWriteAPIKey
       while True:
           try:
               RH, T = getSensorData()
               f = urllib2.urlopen(baseURL + "&field1=%s&field2=%s" % (RH, T))
               print f.read()
               f.close()
               sleep(5)
           except:
               print 'Done.'
               break
    if __name__ == '__main__':
    main()
</code>

==== Changes to the Basic Code ==== 

In `miWriteAPIKey`, input the Write API Key for the corresponding account at thingspeak.

<code>miWriteAPIKey = "XXXXXXXXXXXXXXXX"</code>

Change:

<code>f = urllib2.urlopen(baseURL + "&field2=%s&field1=%s" % (RH, T))</code>

The order has been switched so the temperature appears first, as it is the most important data.

==== Automate Data Sending ==== 

Add a cron task:

<code bash>crontab -e</code>

Select the /bin/nano option, and the crontab will open.

Add the task to the crontab (for example, every 15 minutes):

<code>*/15 * * * * python /home/pi/Adafruit_Python_DHT/DHT22-TemperatureLogger/ts.py</code>

Exit and save with Ctrl+x, selecting "Y" when asked.

==== ThingSpeak Channels ==== 

  * [[https://thingspeak.com/channels/1285244/charts/1?bgcolor=%23ffffff&color=%23d62020&dynamic=true&results=60&type=line&update=15]]
  * [[https://thingspeak.com/channels/1285244/charts/2?bgcolor=%23ffffff&color=%23d62020&dynamic=true&results=60&type=line&update=15]]

==== Sending Alert Emails with ThingSpeak ==== 

==== MATLAB Analysis to Send Emails ==== 

  * Obtain an "alert API key" from Accounts>My profile. The alert APIs start with "TAK".
  * Create a new MATLAB Analysis in Apps>MATLAB Analysis. Click "new" at the top and choose the blank template, then write or paste the following code:

<code>
alert_body = 'This is the text that will be emailed';
alert_subject = 'This will be the subject of the email';
alert_api_key = 'YOUR_API_KEY_FROM_STEP_1';
alert_url= "https://api.thingspeak.com/alerts/send";
jsonmessage = sprintf(['{"subject": "%s", "body": "%s"}'], alert_subject,alert_body);
options = weboptions("HeaderFields", {'Thingspeak-Alerts-API-Key', alert_api_key; 'Content-Type','application/json'});
result = webwrite(alert_url, jsonmessage, options);
</code>

  * Adjust the alert body, subject, and the alert API key.
  * Click "save and Run", and an email will be received in a few moments.
  * Connect the MATLAB Analysis to TimeControl or React depending on the channel value you are interested in.

{{:fidmag:projectes:temperatures:mail.jpg?400|}}

==== React App ==== 

React works with MATLAB® Analysis to take actions when the channel data meets certain conditions.

==== Define Reactions to Channel Data ==== 

Select Apps>React

  - Click "New React"
  - Select Options
{{:fidmag:projectes:temperatures:react.jpg?400|}}

  * React name: Name the alert
  * Condition Type: Choose if the condition is a string, numeric, etc., in our case numeric
  * Test Frequency: The frequency when the React should check
  * React to Data in this channel: choose channel
  * Input condition: define the value that triggers the alert.

The data that meets the conditions triggers a callback, either an HTTP request or an email.

==== History of Alerts ==== 

After running the app, go to the Dashboard>Activity. It will show the last sent emails or actions that have been triggered.

==== Definir Reaccions a les dades del canal====

Seleccionar Apps>React

  - Click a "New React"
  - Seleccionar Opcions
{{:fidmag:projectes:temperatures:react.jpg?400|}}

  * React name: Nom que es vol donar a la alerta
  * Condition Type: Es pot seleccionar si la condicio es un string, numeric..etc en el nostre cas numeric
  * Test Frecuency: Frequencia amb la que es vol comprobar la reaccio per exemple on data insertion ; cada cop que s´introduieix dades...
  * Condition:
  * If channel : canal de Thingspeak a analitzar
  * Field : camp que vol analitzar exemple Field 1 temperatura
  * Is greather than: es mes gran, es poden seleccionar altres condicions
  * 27: Valor de llindar
  * Action: en el nostre cas MathLab Analisys
  * Code to execute: El nom donat al script anterior de enviament de E-mail
  * Options: Seleccionar si es vol executar l´script cada cop que es compleix la condicio o nomes la primera vegada
  * Save React: Guardar el módul React corresponent.


**condition no Data Check**

Al apartat condition hi ha la posibilitat de activar no data check, condicio per reaccionar en cas de que no es rebin dades procedents del sensor.Es pot configurar que si es compleix aquesta condicio s´activi el modul react corresponent.




 

==== sql====
<code sql>
CREATE TABLE temperaturedata (dateandtime DATETIME, sensor VARCHAR(32), temperature DOUBLE, humidity DOUBLE);
CREATE TABLE mailsendlog (mailsendtime DATETIME, triggedsensor VARCHAR(32), triggedlimit VARCHAR(10), lasttemperature VARCHAR(10));
</code>

==== referencies====
  * https://www.instructables.com/Raspberry-PI-and-DHT22-temperature-and-humidity-lo/
  * https://www.zonasystem.com/2019/05/raspberrypi-adafruit-temperatura-humedad-sensor-dht22-am2302-enviar-datos-thingspeak.html