After my second hard disk started failing, I really thought about moving my +11000 pictures to my young main hard disk, BUT, also keep all my favorites, tags, comments in F-spot.

F-Spot

So here's how I did it:
Read the rest of this entry »

There are many Apache log analyzers that you can now choose from, but it can be long or confusing to install most of them. I wanted to try and find a simple log analyzer that just does its work using cronjobs. Visitors seems to fit the needs!
We'll also use ip2host to resolve the IP addresses into domain names.
All of this will be run daily by a cronjob.

Screenshot of a report generated by Visitors

Read the rest of this entry »

Grep is a very useful tool in the Unix world. If you don't know it already, it is very much like a search tool. It can search for a text or pattern in one or multiple input files or data coming from (unix) pipes.

Most of the Linux distributions out there offer three ways to use Grep from the command-line (aka terminal): grep, fgrep, and egrep.
Read the rest of this entry »

I try to keep my VPS (Virtual Private Server) as light as possible. That's also why I don't have PHPMyAdmin installed and wouldn't want to install it. The only way of accessing MySQL and executing commands is through the mysql CLI (Command Line Interface), but I don't always remember the exact queries to create a user, database or to grant privileges.

I recently decided to look for some GUI (Graphical User Interface) tools to tweak and administrate a MySQL server. I found the quite well-known MySQL Administrator (and Query Browser).

MySQL Administrator

The problem is that by default (and for obvious security reasons), my MySQL server is not accessible from the internet (only accessible by localhost itself). This is where SSH tunnels enter the action!
Read the rest of this entry »