Certain SLAC services are blocked from offsite access. To use these services from home there are several choices.

Use VPN

This is easiest, since it gives access to all SLAC services, with no changes to the way the services are accessed. VPN software is available for windows, Mac OSX and Linux. However VPN is blocked at certain places, like GSFC.

Using SSH tunneling

On windows I use putty to set up ssh tunnels. For this example I will show how to use an ssh tunnel to connect to oracle or mysql databases at SLAC. Open putty and go to the connection/ssh/tunnels panel. Set up tunnels by specifying a source port and destination. I set up the following tunnels:

source port 3306 --> glastdb.slac.stanford.edu:3306
source port 1521 --> glast-oracle01.slac.stanford.edu:1521

Now use putty to log in to any node at SLAC (e.g noric) and the tunnels will be set up.

Now to access mysql or oracle you need to change the db urls to point to localhost instead of the normal database node, e.g

jdbc:oracle:thin:@localhost:1521:GLASTP

will connect you to oracle via the tunnel. Other ssh clients allows you to set up tunnels in a similar way.

#trackbackRdf ($trackbackUtils.getContentIdentifier($page) $page.title $trackbackUtils.getPingUrl($page))
  • No labels