CIS Home


Apache, HTML, CGI and PHP
Microsoft SQL


SSH Tunnels

Accessing your DEVWEB/Q: directory from home
To edit and upload files to your DEVWEB space, you'll typically need a "SFTP" program which can transfer files between your computer at home and our servers in the department.

Direct your SFTP program to, to gain access to your files.

Some SFTP clients will unfortunately connect you to the root directory of cafe and not to your personal home directory. Your personal home directory will be of the form /home/student/first_letter_of_dsusername/dsusername e.g. a user with username pkb12345 will have a personal home directory of /home/student/p/pkb12345

In Windows there are a number of different SFTP clients you can use. See this web site for a helpful list.

Here's a list of SFTP clients for the Mac.

In Linux the file default file explorer will typlically support sftp. In the gnome file explorer (nautalis) you can use the "File" -> "Connect to server..." option.

Accessing MySQL, Oracle, PostgresQL, MongoDB, or CVS from home
If you have a program or application running at home that wants to make a connection to one of these services on devweb2019 then you need to use an SSH tunnel (aka SSH Port Forwarding). (See below for help on setting up a tunnel.)

After making the tunnel you should alter your application that makes the MySQL connection to connect to "localhost" and not "".

Port numbers
To create a tunnel to a service the first thing you need to know is the port number the service runs on. This table shows services and the port number they run on:
Service Port Number
Oracle 1521
CVS 2401
MySQL 3306
PostgresQL 5432
MongoDB 27017
Use the port number for the service you want to use in the guides below...

UNIX, Linux and MacOS X

  • Start a command line terminal
  • Run ssh -L
  • If prompted for a password then use your DS password

From Windows

You can download the command line putty client called plink from here. Run plink from a command prompt window (cmd). plink accepts the same arguments as the ssh command mentioned above in the UNIX, Linux and MacOS X section.

Or you can use PuTTY. You can download PuTTY here.

The way to create the tunnel is as follows:

  • Start PuTTY
  • Within the Host Name box enter ""
  • Check the Protocol selected is SSH
  • Enter something like "cafedevweb2019" into the Saved Sessions box
  • Choose "SSH -> Tunnels" from the Category list on the left
  • In the Source Port box enter the port number
  • In the Destination box enter ""
  • Click the Add button
  • Go back to the Session window and Save the named session (cafedevweb2019)

Now when you load the session and log in to cafe (using your DS password) you'll create a tunnel between your PC (local host) and cafe which will forward to devweb2019 on the port you specified.

back to top