To use databases in Linux it is easiest to use mysql which can be installed using:
sudo apt-get install mysql
To configure the setup go to /etc/mysql/ and open my.cnf. As default only local access are allowed to the databases. This is specified as bind-adress = 127.0.0.1 in the my.cnf file.
To launch mysql simply type sudo mysql. Some basic commands you can use:
Netstat is used to check which ports are open on the local system. There is also a tool called nmap which scans a remote system for open ports. For example
nmap hostaddress -p0-65535
checks all the possible ports on the specified address.
Tcpdump is a tool that sniffs data from the network traffic. To record data from a specific host type:
tcpdump dst host <hostaddress>
You can also filter out specific protocols like http:
tcpdump tcp port http.
To be able to schedule activities to run in intervals is a important part in the administration of a Linux system. The system that handles scheduling is called cron and makes it possible to set the interval from years to minutes. The scheduling is configured in so called crontab files which are placed in the /etc directory. An example on how to run a script every 5:th minute:
First make the script executeable using chmod +x scriptname.
Launch crontab as a local user using crontab -e.
To make the script run every 5:th minut input:
*/5 * * * * ~/path/to/scriptfile
When logged in into a Linux system you get access to a shell where applications and commands can be executed. When an application is called by its name the system searches for it in the current folder and the directories specified in “PATH”. To list all the environment variables and their values type env l less.
The shell provides us with some tricks to make working with it a little easier:
- Tab completion: Type a char, like “a” and double-press tab. Then a list of all the possible alternatives beginning with a shows up.
- ./ Lists the files in the current catalog
- ~ Is the shortcut for the home directory.
- To launch an application and use another application as input use the
characters. For example: echo
date will write out what date produces.
Users and access levels
The user with the highest level of access is called root and is able to control every process and access every file on the system. Other users can also be given root privileges but this should be done with care.
To create a new user with the name testuser, create a home directory and assign a password:
useradd -m testuser
passwd testuser <insert password>
You can change to the newly created user by using, ask the system who is the current user and return using:
To delete the user and the home directory type:
EventBus is a open-source library which simplifies communication between components in Android applications.
Project code on GitHub
To create a WordPress theme, two basic files are needed: index.php and style.css. The stylesheet has to contain some basic information about the theme:
Theme Name: evinja theme
Theme URI: http://www.evinja.se
Author URI: http://evinja.se
To make the theme suitable for viewing on different screen sizes , e.g. responsive, the theme uses media queries to modify the layout depending on the screen width:
This is an Android client to the optimized scheduling system Hazel and is a part of my groups bachelor thesis at Gothenburg University & Chalmers.
Menu for administrators
List of tasks
This is a simple counter application which can increase and decrease using different coded NFC-tags. If the application reads a NFC-tag which contains the data “plussa” then the counter will increase.
This project was created in Eclipse, a new version will be made in Android Studio.
Repository on GitHub