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 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

• Setup Server

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

Contributing authors:

Created by jchang on 2022/10/04 23:05.