Skip to content
This repository has been archived by the owner on Jan 29, 2023. It is now read-only.

Latest commit

 

History

History
168 lines (145 loc) · 6.13 KB

README.md

File metadata and controls

168 lines (145 loc) · 6.13 KB

For Raspberry Pi:

Setup MySql Database

Execute the following commands to install MYSQL:

$ sudo apt install mariadb-server
$ sudo mysql_secure_installation

To access the database use:

$ sudo mysql -u root -p

First thing to do is to create a database and a user:

$ CREATE DATABASE sensors;
$ CREATE USER 'USER_NAME'@'localhost' IDENTIFIED BY 'PASSWORD';
$ GRANT ALL PRIVILEGES ON sensors.* TO 'USER_NAME'@'localhost';
$ FLUSH PRIVILEGES;

Note: This works only for users on the same device > Webserver must run on same device. Only way to change it, is to enable networking and Grant all devices access: On my raspberry pi nano: comment '# bind-address = 127.0.0.1' out in the file :

$ sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

$ CREATE USER 'USER_NAME'@'*' IDENTIFIED BY 'PASSWORD';
$ GRANT ALL PRIVILEGES ON sensors.* TO 'USER_NAME'@'*';
$ FLUSH PRIVILEGES;

Now we create two empty tables. Everything else can be managed later on with the web-interface:

$ USE sensors;
$ CREATE TABLE id(sensorID varchar(16) NOT NULL, sensorNick varchar(16), sensorTypeID int DEFAULT 0, CONSTRAINT PRIMARY KEY (sensorID));
$ CREATE TABLE types (sensorTypeID int NOT NULL AUTO_INCREMENT, sensorType varchar(16), unit varchar(5) DEFAULT 'dUnit', repetitions INT DEFAULT 10, sleepTime INT DEFAULT 200, CONSTRAINT PRIMARY KEY (sensorTypeID));
$ INSERT INTO types (sensorType, unit) VALUES ('default', 'dUnit');
$ UPDATE types SET sensorTypeID=0 WHERE sensorType='default';

Setup Sever:

Install Server

- ONLY FOR RASPBERRY NANO: wget https://nodejs.org/dist/latest-v11.x/node-v11.15.0-linux-armv6l.tar.gz
- ONLY FOR RASPBERRY 3B+ : //TODO
tar -xzf node-v11.15.0-linux-armv6l.tar.gz
cd node-v11.15.0-linux-armv6l/
sudo cp -R * /usr/local/
  • check if the installation worked correctly:
node -v
node -v
  • install git:
 $ sudo apt install git
  • clone or copy gitHub repo:
 $ sudo git clone https://github.com/lr101/REST_Server.git
  • install packages in the root folder of the Project:
 $ cd ./REST_Server/
 $ sudo npm install http fs ejs body-parser moment morgan express mysql util path dotenv
  • rename the file .env_sample to .env and fill in your username and psw of your db:
$ sudo mv .env_sample .env
$ sudo nano .env

Test if everything is working correctly by running the server (Cancel with Strg+C):

$ sudo node ./server/REST_Server.js
> webapp under: [your_ip]:3000/

Auto-run server and upload files:

install PM2 to auto run script in background:

 $ sudo npm install -g pm2
 $ sudo pm2 start ./server/REST_Server.js
 $ sudo pm2 startup systemd
  • copy generated command and execute
** different for everybody: 
$ sudo env PATH=$PATH:/usr/bin /usr/lib/node_modules/pm2/bin/pm2 startup systemd -u pi --hp /home/p
** save setting:
$ sudo pm2 save

Using the web-page

Sensors connected are supposed to add their ID with a default name to the database automatically. THis is done by sending a http POST request to the webserver on the following address: http://[ip]:3000/sensors/id/. Further documentation on the implemented REST-API and how to use it can be found under .REST-API.txt

The webpage displays every saved sensor. Navigate to /config/local-sensors or click the big '+' button to edit the displayed name and type.

To edit the name of a sensorType and its unit. Navigate to /config/sensor-types and.

Click on one of the square sensors or on the 'display sensors' button to view the current value as well as a graph with ranging values from 1 hour to 14 days.

Setup Thermometers:

Microcontroller NodeMCU V.3:

grafik

  • solder ds18b20 temperatur sensors to pins (blue = data, red = power, black = ground) with a 4.7K Ohm resistor
  • install drivers by checking the back of your Microcontroller. A driver install page should be printed there.
  • install Arduino IDE
  • to add this bord as supported bord go to: File → Preferences
  • enter in Additional Board Manager URLs; https://dl.espressif.com/dl/package_esp32_index.json
  • go to Tools → Board → Board Manager and search for ESP32 and install
  • go to Tools → Board → NodeMCU V1 (ESP-12E) and select
  • to interface with the ds18b20 sensors the One wire Library by Paul Stoffregen and Dallas Temperature library are needed. Install under Sketch → Include Library → Manage Library
  • open the file uploadESP8266_sample.ino in the Arduino IDE
  • connect your NodeMCU V3 via USB Cable to your PC
  • select the correct COM-Port under Tools → Port
  • fill in the TODO spots with your own data
  • press Upload to flash your Microcontroller

Raspberry Pi

grafik

  • solder as shown with r1 being a 4.7K Ohm resistor
  • run command and add to the bottom of the file : dtoverlay=w1-gpio
sudo nano /boot/config.txt
  • exit file reboot raspberry pi
sudo reboot

//TODO

  • check if everything is working correctly:
sudo modprobe w1-therm
  • copy or move the file uploadPi.py to your home directory
sudo mv uploadPi.py ~/
  • insert your own data in the given TODOs
  • add the file to your pm2 start list and save:
sudo pm2 start uploadPi.py
sudo pm2 save