CS 383

Lab 1

Today's lab is very simple.

Confirm that your ID card gets you into the lab -- Park 230 and Park 231.
Log into a CS department lab machine using your UNIX login. If you did not already have a login, you should have received an email from ddiaz1 with login information
Log in to the class database server and check your database access. You will do this twice because you have 2 database accounts, one that is identical to your UNIX login and the other that is your UNIX login plus "_123". Both are linked to the same personal database for you. (Which is currently empty). The first you will use when entering commands directly into psql; the second you will use when accessing the database using a program.
1. ssh YOURUNIXLOGIN@165.106.10.133
  This should result in your being logged in to a machine named "loin"
2. At a unix prompt enter
```
psql
```
  This should get you logged into the command prompt of the database under your unix login.
3. At the database prompt, enter "\c rocket"
4. At the database prompt select count(*) from site;
5. At the database command prompt exit
6. At a unix prompt enter
```
                psql -h 127.0.0.1 -U YOURUNIXLOGIN_123 -d rocket
            
```
  Where "YOURUNIXLOGIN_123" is your unix login name followed by "_123". For instance, for me this would be "gtowell_123"
7. When prompted, give the password 12345678
8. At the database prompt select count(*) from site;
9. At the database command prompt exit

If the initial unix login fails, contact David Diaz for help (ddiaz1@brynmawr.edu). If either of the two database logins fail, contact me.
Send email to gtowell@brynmawr.edu with two pictures (these can be together or separate):

picture of your screen after logging in to 165.106.10.133 and doing one or both of the database tests.
A selfie (to help me learn your name).