Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
ust:meeting_minutes_october_4_6_2022 [2022/10/06 23:21] jchang |
ust:meeting_minutes_october_4_6_2022 [2022/10/14 00:36] jchang |
||
|---|---|---|---|
| Line 20: | Line 20: | ||
| * Changed settings so server doesn't sleep --> disabled suspend and hibernation | * Changed settings so server doesn't sleep --> disabled suspend and hibernation | ||
| * ssh into new server using '[email protected]' | * ssh into new server using '[email protected]' | ||
| - | * Opened ports 80 and 443 for new server | + | * Opened ports 80 and 443 for server web traffic |
| * Continued to setup server | * Continued to setup server | ||
| * [[http://server.scel-hawaii.org/]] | * [[http://server.scel-hawaii.org/]] | ||
| * Default welcome page used to test the correct operation of the Apache2 server after installation on Debian systems | * 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 | * 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 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 === | == Goals === | ||