To connect to the Database Server, we ssh tunnel through the Web Server to get around the firewall.
  1. Log into the Web Server as a super user
  2. Create user
    1. sudo adduser [new user]
    2. sudo usermod -aG sudo,ubuntu,web_editors [new user]
  3. Need to set up user directory
    1. cd to [new user] home directory
    2. mkdir .ssh
    3. touch .ssh/authorized_keys
  4. Add in private key
    1. vi .ssh/authorized_keys
    2. Should look like "ssh-rsa [lots of text]== [new user]"
  5. Set up Putty
    1. Host name [new user]@www.woccu.org:22
    2. Connection->SSH->Auth
      1. Allow Agent Forwarding
      2. Add Private Key
    3. Connections->SSH->Tunnels
      1. Source Port: 5432
      2. Destination: [AWS server]:5432
    4. Save and Open
  6. Set up Sql Manager
    1. Host: localhost:5432
    2. Username: [Postgres User]
    3. Password: [Postgres Pass]
    4. Database: woccu_dev
    5. Uncheck "Refresh objects"