Book Conservation Chamber Using Raspberry Pi

Configuring the SD card

1. Download the latest Raspberry Pi OS.
2. Download Win32 Disk Imager.
3. Format the SD card using SD Card Formatter or a similar program.
4. Write the Raspberry Pi OS on the SD card using Win32 Disk Imager
5. Go to the SD card directory and open cmdline.txt.
   Add ‘ip=169.254.10.1’ at the end of the line.
   Save the file.
   Create a file named ‘ssh’ without content or extentions.
6. Put the SD card in the Raspberry Pi and connect to your computer using the LAN port and an ethernet cable.
7. Connect the power to the Raspberry Pi.

Configure the RPi

Use Putty software to configure the Raspberry Pi.

Connect to the pi using ip address 169.254.10.1 and port 22 with connection type SSH.
Login with the starter information -> User: pi & Password: raspberry
It is recommended to change this as soon as possible -> here is a guide to do this https://www.raspberrypi.org/documentation/linux/usage/users.md

Raspi-config

First we will have to enable different interfaces and to do that we have to type the following code:

sudo raspi-config 

Enable following interfaces:

Connect to WIFI

First, type the following command to become root

sudo -i 

Once you’re root, use the following command: (Replace SSID with your network name and password with your network password)

 wpa_passphrase "ssid" "password" >> /etc/wpa_supplicant/wpa_supplicant.conf 

Check if this is correct using

nano /etc/wpa_supplicant/wpa_supplicant.conf 

Now that the network is added, let’s enter the WPA client interface

wpa_cli 

Select your interface

interface wlan0 

Reload the file

reconfigure 

And finally check if you are connected:

ip a

Updating the RPi + installing software

Update the RPi

sudo apt-get update
sudo apt-get upgrade

Now that the Pi is updated, install Apache

sudo apt install apache2 -y

Install MariaDB

sudo apt install mariadb-server mariadb-client -y

Install python packages

pip3 install flask-cors
pip3 install flask-socketio
pip3 install mysql-connector-python
pip3 install gevent
pip3 install gevent-websocket

Now that this is all done reboot the Pi.

Setup the database

Now that everything is installed, we will setup the database. Simply follow this guide https://pimylifeup.com/raspberry-pi-mysql/