Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. =====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 ust/meeting_minutes_october_4_6_2022.txt Last modified: 2022/10/14 00:37by jchang