...
- Download the latest version of PUTTY for Windows
- Choose the version "A Windows Installer for everything except PuttyTel" (you will need the PuttyGen tool)
SSH shared keys / Putty Method:
http://www.howtoforge.com/ssh_key_based_logins_putty
- Download Putty: http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe and save it to somewhere where you can access it
- Download PuttyGen: http://the.earth.li/~sgtatham/putty/latest/x86/puttygen.exe and save it to somewhere you can access it
- Run PuttyGen.exe
- click the 'Generate' button
- move the mouse around in the window until the progress bar is complete (puttygen uses this to make the key random, this isn't a joke)
- click the 'Save public key' button, and ignore the warning about the keyphrase (what do we click to ignore it?) save the file somewhere handy, name it 'public'
- click the 'Save private key' button, save the file in the same location as the private key, name it 'private'
- Send an email to Mitch and Jim with the subject 'putty public key' and attach the 'public' file that we saved two steps prior
- close 'PuttyGen.exe'
- open 'Putty.exe'
- type 'gateway.uits.uconn.edu' into the hostname field
- select the SSH -> Data from the categories on the left hand side
- type your netid (is this true for the gateway server?) into the 'Auto login user' field
- select SSH -> Auth from the categories on the left hand side
- click the 'Browse' button to the right of the 'Private key file for authentication' field
- Select the file named private that was saved in one of the previous steps
- <SET UP THE TUNNEL>
- Select the Sessions category from the left hand side
- Type a meaningful name such as 'gateway server' into the saved sessions text field
- click the save button
<SET UP THE TUNNEL> Putty
...
- in putty select tunnel from the category list from the left hand side "Connection -> SSH -> Tunnels"
- In source port type 1521
- in Destination type:
- dbserver02.uits.uconn.edu:1521 (For non-production)
- dbserver01.uits.uconn.edu:1521 (For production)
- click the 'add' button