=====Firmware Team Meeting - October 4, 6, 2022=====
**Attended: Jaeden, Jon, Lyon**\\

=====Updates=====
**October 4, 2022**
  * Port forwarding issue
    * Find mac address using ifconfig
      * Issue: ifconfig doesn't exist
      * Solution: use "ip a"
    * Test out each mac address that appeared
      * Tested first address by inputting it into netgear
      * Test if a member can ssh using "ssh user@server.scel-hawaii.org -p 11124" on own environment
    * Ran "ssh localhost" or "$ nc -w 1 localhost 22SSH-2.0-OpenSSH_8.4p1 Debian-5+deb11u1" to check if daemon is listening
    * Make sure ip address of the machine matches the ip address on the portforwarding page
    * Add kenny's ssh to gateway and watched kenny do his magic
      * Installed docker
      * Clone the infrastructure repository --> able to run the automation 
 
**October 6, 2022**
  * Changed settings so server doesn't sleep --> disabled suspend and hibernation
  * ssh into new server using 'user@147.182.235.114'
  * Opened ports 80 and 443 for server web traffic 
  * Continued to setup server
    * [[http://server.scel-hawaii.org/]]
      * Default welcome page used to test the correct operation of the Apache2 server after installation on Debian systems
      * If you can read this page, it means that the Apache HTTP server installed at this site is working properly
  * Gateway open for users to ssh into server remotely using "ssh USER@server.scel-hawaii.org -p 11124"
  * Postgresql through command line
    * Updated schema for control-tower: [[https://github.com/scel-hawaii/control-tower/blob/master/db/multi-table.sql]]
    * checked version: psql --version --> psql (PostgreSQL) 13.8 (Debian 13.8-0+debllu1)
    * created a user called "psql"

  * Commands ran to make database(can tell something is happening based on changing between =# and -#)
    * set role postgres;
    * create role gateway superuser;
    * set role gateway;
    * create database weatherbox;
    * set search_path to public;
    * create table apple(time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,press_pa INTEGER,temp_c INTEGER,humidity_centi_pct INTEGER,apogee_w_m2 FLOAT);  
    * CREATE TABLE cranberry (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,apogee_w_m2 FLOAT,temp_cK INTEGER,humidity_pct INTEGER,press_pa INTEGER);
    * CREATE TABLE dragonfruit (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,apogee_w_m2 FLOAT,temp_cK INTEGER,humidity_pct INTEGER,press_pa INTEGER);
    * CREATE TABLE heartbeat (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER);
    * \d public.apple (shows apple table)
    * \dt public.* (shows all tables using public schema)
    * To switch between databases: psql -d DATABASE

  * Testing to see if database files are found or if we need to find database files and write it into the code
    * source env/bin/activate
    * sudo chmod 666 PORT (starts with /dev)
    * Need to find tables after running production, since collects data but then errors

REMINDER FOR NEXT WEEK
  * git clone repository 
    * need to make a general scel git account 
    * key gen 

== Goals ===
  * Setup Server

=== Meeting ===
  * Tuesday, Thursday: 1:00-3:30pm