Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
ust:meeting_minutes_october_4_6_2022 [2022/10/05 01:12] jchang |
ust:meeting_minutes_october_4_6_2022 [2022/10/07 01:25] jchang |
||
---|---|---|---|
Line 10: | Line 10: | ||
* Test out each mac address that appeared | * Test out each mac address that appeared | ||
* Tested first address by inputting it into netgear | * Tested first address by inputting it into netgear | ||
- | * test if a member can ssh using "ssh [email protected] -p 11124" on own environment | + | * 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 | + | * 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 | + | * 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 | + | * Add kenny's ssh to gateway and watched kenny do his magic |
- | * installed docker | + | * Installed docker |
- | * clone the infrastructure repository --> able to run the automation | + | * Clone the infrastructure repository --> able to run the automation |
- | * | + | |
**October 6, 2022** | **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 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) | ||
+ | |||
+ | * 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 === | == Goals === |