For the practical assignments, you are supposed to use a dedicated machine running some server software. The machine is tricolor.students.cs.uu.nl.
To be able to work on this machine and thus work on the assignments you need a CS-login. If you don't have one yet (because you enrolled as a non-Computer Science student, for instance), please get one now from our Helpdesk.
The tricolor server lies within the students network. You can login to this machine using your usual student login name/password combination. If you cannot, this is because you can not login to the student network at all. Visit the Balie in BBL to obtain an account on our network. However, only rarely will you ever need to really go to the tricolor machine: most things can be handled via a special directory on your student account.
If you make a directory called public_html in your home directory (normally mounted as the H: drive), it will be automatically visible on the tricolor. You can view the website by browsing to http://tricolor.students.cs.uu.nl/~studentname. Do not forget to set the access rights of the public_html directory (executable for everybody, readable and writable for yourself) and make sure the files in that directory are readable for everybody. One thing you very likely must take care of, is to also make your home directory executable for everybody. Otherwise, the server can not access your public_html directory. More information in the next paragraph.
A drawback of the public_html set-up is that everyone can cd to your home directory. However, they can not list that directory (unless you give read rights as well, which you should not). If they know what files your directory contains, they can access these files without you knowing. This is why you might want to explictly deny other people all rights to your account, except those rights which are really needed by the webserver to access the website. A way to do this is to execute the following from a Unix terminal (do not do this directly from Windows).
chmod 701 ~ ; chmod -R 705 ~/public_html
What it does, is to retract all access by people in your group and 'other's
to all files and directories on your account to nothing,
except for the necessary execute access to your home directory and
the public_html directory and of course the necessary read and execute
rights for anything within the public_html directory. Generally, this will work fine.
Note however though that if you create new files on your account, that
you may have to set the read rights of others off, because most
programs turn these on by default when you create a new file.
It is possible to avoid this by setting a
If you want that, look up the details yourself.
You can obtain a Unix terminal by doing ssh to a machine such
shell.students.cs.uu.nl (if you have the proper things set up).
Learn more about SSH and other services at Computer Science right here.
<?php phpinfo(); ?>Again, make sure that you change file permissions according to the instructions below or your file will not be accessible! (See last tip.) Direct your browser to the following url (again replacing the user name with your own).
http://tricolor.students.cs.uu.nl/~yourusername/test.phpYou should now see a page that provides information about the PHP environment (version, php.ini settings, extensions, etc.). No, we cannot change the php.ini setting for your application :-).
psql -h prestige.students.cs.uu.nlYou should now get a prompt from the PostgreSQL interactive terminal. Issue the following command to set your database password.
\password yourusernameor with
ALTER USER yourusername PASSWORD 'yourpassword';
Don't forget the semicolon and do press enter!. Both commands lead to the same result.
Use a password that is different from your windows/unix password!
From now on, you can connect to PostgreSQL with this new password.
Exit the PostgreSQL interactive terminal by issuing \q at the prompt. Exit the ssh connection by issuing exit at the unix prompt.
You may download and install phpPgAdmin into your own webspace. Installing and using phpPgAdmin is easy, but you should specify your database name (CS-login) as defaultdb and prestige.students.cs.uu.nl as server address in the config file (phpPgAdmin-4.2.2\conf\config.inc.php). Furthermore, you should insert the following line of code to phpPgAdmin-4.2.2\classes\database\Postgres82.php, above line 93 ($sql = ...):
$where .= " AND pdb.datname = '".$server_info['defaultdb']."'";
If you prefer, you may also use the command line based PostgreSQL interactive terminal psql to manage your database and issue SQL statements from the shell server. You can also use the PostgreSQL interactive terminal if you connect to the shell server from home, using ssh.
chmod 701 ~ ; chmod -R 705 ~/public_htmlThis, fortunately, also denies other students access to your code in general for the purpose of 'peer review' :-).
We do not really care where you really work to make your assignments, but one of the prerequisites is that they should (eventually) work on the tricolor. It is not possible to directly access the tricolor from outside. To gain remote access to tricolor, you should use SSH in combination with our proxy service.
Technical documentation on SSH in combination with our proxy service is available, but note that the documentation can only be accessed from a machine within the cs.uu.nl domain.
Setting up remote access may be a bit of a hassle, but it will be useful to you throughout your studies. ;-)
Note that if you are busy with this anyway, you might as well setup VPN too to get remote access to other services of the Department as well.
If you're tired of exchanging new versions of certain files of your assignment with your co-worker by e-mail, you might consider using Subversion. See the subversion page from our Helpdesk for more information.