1. pull docker image

1. run docker image

1. install mysql client cli tools

1. Restore Empty DB

1. Restore DB with data

1. install packages

   $ sudo apt-get install mysql-server git vim -y

   Note	you’ll have to set a root password

2. Enable MySql Service

   $ systemctl enable mysql

3. Enable MySql to bind to anyIP

4. Start MySql Server

5. Add db User

   $ mysql -u root -p
   mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
   mysql>
   mysql>

6. Download git project

   Note	Assuming ssh-key was setup already and added to the repo

7. rename hostname

   $ sudo hostnamectl set-hostname sensordb.sd.spawar.navy.mil

8. update hosts file on each machine

   # echo '127.0.0.1 sensordb.sd.spawar.navy.mil' >> /etc/hosts

9. Create user

   $ sudo useradd -G adm,dialout,cdrom,sudo,audio,video,plugdev,games,users,input,netdev,spi,i2c,gpio jmarley

10. Generate ssh keys

    $ ssh-keygen -t rsa -f /Users/jasonmarley/projects/SPAWAR-Demo/keys/id_rsa_pi

11. Copy ssh keys

    $ ssh-copy-id -i keys/id_rsa_pi.pub [email protected]

12. Restrict ssh to keys only

    $ sudo vim /etc/ssh/sshd_config
       PermitRootLogin no
       PasswordAuthentication no
    $ sudo service ssh restart

php stuff

sudo pip install nmap sudo pip install requests

Bluetooth-discovery2.py code allows a Raspberry Pi 3 to detect devices with Bluetooth enabled. Devices will only be detected if they are on the Bluetooth screen.

Wifi-discovery.py code allows a Raspberry Pi 3 to detect a large number of devices through Wifi.

1. MySql Backup and Restore

2. MySql Server Configuration

3. https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql [Adding Users] .