This is an old revision of the document!
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 [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
-
- 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 guava(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);
Goals
- Setup Server
Meeting
- Tuesday, Thursday: 1:00-3:30pm