Differences

This shows you the differences between two versions of the page.

--- ust:meeting_minutes_october_4_6_2022 [2022/10/05 01:12]
jchang
+++ ust:meeting_minutes_october_4_6_2022 [2022/10/14 00:37] (current)
jchang
@@ Line 10: / Line 10: @@
     * 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
+      * 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**
-  *
+  * 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
 == Goals ===