4th week of the 2nd semester
Topics: Operatingsystems & Linux, Webserver og MySQL in the cloud
Day 1 (Tuesday): Linux in the cloud
We will look at how to set up a linux server on digitalocean, how to manage users on the machine, and how to navigate the server from the command prompt.
Readings:
- http://ryanstutorials.net/linuxtutorial/commandline.php
- http://ryanstutorials.net/linuxtutorial/cheatsheet.php
- Nano: http://www.howtogeek.com/howto/42980/the-beginners-guide-to-nano-the-linux-command-line-text-editor
- Nano: http://www.tutorialspoint.com/unix_commands/nano.htm
Day 2 (Wednesday): SSH & bash scripting
Using passwords to secure a server is considered insecure. Instead one use ssh-keys. Also, we will take a look at bash-scripting to automate things on linux. In particular we will automate setting up a linux server with users for your group.
Readings:
- Scripting: http://ryanstutorials.net/linuxtutorial/scripting.php
- Bash on Lynda.com: https://www.lynda.com/Bash-tutorials/Up-Running-Bash-Scripting/142989-2.html
- SSH on Lynda.com: https://www.lynda.com/Developer-Network-Administration-tutorials/Welcome/189066/365610-4.html
- SSH: https://www.youtube.com/watch?v=svRWcx7dT8g
- SSH: http://blakesmith.me/2010/02/08/understanding-public-key-private-key-concepts.html
- SSH & connecting to ubuntu: https://www.digitalocean.com/community/tutorials/understanding-the-ssh-encryption-and-connection-process
Day 3: MySQL in the cloud
We will setup MySQL on the ubunto server, set up users on MySQL with different rights, and work with SQL from the sql prompt. Also, we will connect to the server from MySQLWorkbench and from Java.
Readings:
- Installing MySQL: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-14-04
Day 4 - Studypoint exercise
- Full assignment - see study/studypointExercise.md