Accessing comprehensive web hosting

This document describes how to access the files in your comprehensive web hosting site and how to manage your databases. Please also read our notes on the access node, note the SSH Host keys for this server and the notes on the local quota restrictions.

Expand All

SSH/SFTP clients

To access the files within your site, you will need to login to the server using an SSH or SFTP client.

There are a number of options for free clients, if you do not already have an SSH or SFTP client installed.

The below is not an exhaustive list, and there are other clients (both free and commercial) available.

For security reasons, we restrict logins to the server to those from known, static IP addresses. Please contact UPST to inform us of any changes of your static IP address.

To login you need a username and password; the username will be either the same as your SSO username (e.g abcd1234 ) or provided to you by NSMS if you are external to the University (and generally have the form nsmsXXXX). For University members, the password is your NSMS password, which can be reset by visiting the password reset page. Please note, you will first need to authenticate yourself using your SSO username and password, after which you will be able to update your NSMS account password. Your account will expire in line with your University card. People external to the University will need to provide UPST with their public SSH key, e.g. ~/.ssh/

Once logged in you should find the following directories:


where <SITE> is the name of your site. Note that if you have multiple virtual hosts being served by one contract then this will be the primary name of your site.

In the <SITE>/htdocs is the document root of the webserver, and <SITE>/logs contains a (read only) copy of the log files. The <SITE>/home contains space for files you wish to store outside of the document root of your site - e.g. backup copies of files.

The database credentials will be in a file named after the database, in a directory under the home directory of the web site (i.e. in the example above this would be <SITE>/home/database_details); it will contain the following information:

  • database name
  • database server
  • database user name
  • database password

We would advise you to use the database server name rather than looking up the IP address of the server.

For MySQL users the command line tool is mysql and can be run on using:

  •   mysql -h <database server> -u <username> -p

To back up the database, use mysqldump, e.g.

  •   mysqldump -u siteXXXX_YYYY -h database-server-goes-here -p database-name-goes-here > path-to-store/name-of-file.dump

We recommend storing database dumps in the site home directory rather than within the htdocs directory (unless protected by a suitable .htaccess file), as attackers routinely try to download likely backup file names.

If you prefer to use a GUI tool for database access then you can use port forwarding, e.g. from your desktop:

  • Mac or Linux users can tunnel over SSH:


  ssh -L 3306:<database-server-name>:3306 <your-sso>


  ssh -L

You could then run e.g. mysql-workbench, and connect to localhost which will be port-forwarded to the actual database host. Closing the ssh session will terminate the port forwarding.

Windows users can tunnel using PuTTY:

  1. Install putty from
  2. The download is called e.g. putty-X.YZ-installer.msi. Install it, accepting the default options is fine
  3. Run PuTTY from the start menu
  4. In the "Host Name (or IP address)" box, type
  5. On the left menu, under "Connection" click "Data"
  6. In the "Auto-login username" box, type your NSMS AD username, which is the same as your SSO username if you have one
  7. On the left of the putty window, click the "+" next to "SSH" then click "Tunnels"
  8. In the "Source port" box, type 3306 
  9. (if you are running a mysql / mariadb server on your desktop then port 3306 might not be available, in which case you'd need to pick another port)
  10. In the "Destination" box type the full name of your database server, followed by ":3306", e.g.: 3306
  11. Leave "Local" and "Auto" selected, and click "Add".
  12. The text box should then display something like: 
  13. L3306 3306
  14. Scroll the left menu back to the top, then click "Session". 
  15. In the "Saved Sessions" box give it a name, e.g. access-nsms
  16. Click "Save"
  17. Now that the connection details are saved, you can load them by clicking the name you gave, then clicking "Load"
  18. Click "Open"
  19. If you get a popup "PuTTY Security Alert", then check that the fingerprint given matches the one given in the SSH/SFTP FINGERPRINTS section below.
  20. If it does, click Yes
  21. Enter your NSMS AD password
  22. Run your choice of desktop SQL program, e.g. mysql-workbench or heidisql
  23. When creating a connection, use "localhost" or "" (they're the same) for the database hostname, *instead* of the actual database hostname e.g.
  24. Use the database username and password that you were given when the site was set up

Closing the PuTTY session will terminate the port forwarding, so close your database program first.

For PostgreSQL users the command line tool is psql and can be run using:

psql -h <database server>

If you prefer to use a GUI tool then you can use port forwarding, e.g. from your desktop:

ssh -L 5432:<database-server-name>:5432 <your-sso>

You could then run e.g. pgadmin3, and connect to localhost which will be port-forwarded to the actual database host. Closing the ssh session will terminate the port forwarding.

You should be aware that is not the server that your site runs on, it is only a way of accessing your files and databases.

For customers running Drupal we have the drush utility installed; there should be a current version of drush in in your path. We also maintain older versions of drush under /opt/drush but you would have to change your path in order to use these.

Please note that files on are not backed up, as this server is just designed to give you the ability to get to your files. Your website and database however are backed up.

On 2016-03-03 we upgraded the server and as a result the SSH host keys changed; the fingerprints are:

DSA c0:bd:3d:c2:a0:c1:e5:15:1c:08:7a:7a:ea:04:ab:94

ECDSA  5e:ea:11:06:ef:da:5f:9d:fc:6c:4f:48:fe:25:17:27

ED25519 d8:bc:f1:d9:8f:6f:3e:0a:50:0e:32:9e:b6:95:7b:8f

RSA 69:a8:be:25:13:16:14:b3:e3:e9:37:14:9b:bd:4d:b2

As the server is shared amongst all our clients, we have set a local quota for the amount of storage you can use on This is so that resources can be fairly distributed amongst everybody. This does not affect the storage used for your web sites.

Currently the local quota is set to 1GB. You can view your current usage using the Linux quota command.

Get support

Local IT support provide your first line of on-the-spot help



Common requests and fault reports can be logged using self-service




The central Service Desk is available 24x7 on +44 1865 6 12345


If you do not have an SSO account you can use this form to contact the Service Desk