Attended: Jaeden, Jon, Lyon

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 [email protected] -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 '[email protected]'
• 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 [email protected] -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 (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 dragonfruit(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, press_pa INTEGER, temp_c INTEGER, humidity_centi_pct INTEGER, apogee_w_m2 FLOAT);
  • 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)

• Setup Server

• Tuesday, Thursday: 1:00-3:30pm