Table of Contents

Description

Requires kerberos ticket (or shared key)

then create tunnel

...

The following instructions describe setting up a secure tunnel via SSH to the internal UCONN database's. There are multiple connection methods described below. Please follow the method best suited for your operating system and configuration. 

MAC OS X ("Mountain" Lion 10.8 or Higher)

...

Configure SSH Access:

Terminal Method:

• (one time, make sure that ssh_config is configured for kerberos)
• Get a kerberos ticket by either using the terminal  or the ticket viewer GUI
• If you want to connect to pre-production databases (DEV, TST, SUP) type:
  
  • ssh -fNL 1521:dbserver02.uits.uconn.edu:1521 <yournetid>@gateway.uits.uconn.edu
• or if you want to connect to production databases (PRD, UAT) type:
  • ssh -fNL 1521:dbserver01.uits.uconn.edu:1521 <yournetid>@gateway.uits.uconn.edu

FUGU method

• (one time, make sure that ssh_config is configured for kerberos)
• Get a kerberos ticket by either using the terminal  or the ticket viewer GUI
• Open Fugu
• select the ssh menue, and click "New SSH Tunnel"
• Fill in the following menue as follows:
  
  • Create Tunnel to: dbserver02.uits.uconn.edu (if Test database) or dbserver01.uits.uconn.edu (if Production database)
  • Service or Port: 1521
  • Local Port: 1521
  • Tunnel Host: gateway.uits.uconn.edu
  • Username: <your netid>
  click the 'start tunnel' button

Enable kerberos ssh

...