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 »

Evolution is a complete solution for mail, calendar, tasks, contact lists, but it uses a lot of resources, and I'm not using all of those features.
Last week I was looking at multiple mail clients (aka mail user agents). I was really interested in Claws-Mail, a fork of Sylpheed. It is very lightweight, and has a bunch of features, not as much as evolution, but it can compete pretty well.
Memory-wise, I switched from 30mb used by Evolution to ~14mb (maximum, but usually ~10mb) used by Claws-mail.

The only problem I was facing is setting it up with Gmail. Here's how I figured it out after a couple days.
Read the rest of this entry »

Note that in Karmic Koala 9.10, the sound is working by default!

I had problems having any sound working on jaunty pre-releases (beta and release candidates). I have a HP Mini 1000 1120NR. This workaround should also work for other models.

This is related to this bug report. There is no official fixes yet.

Here's my workaround:

Read the rest of this entry »

This workaround was used because of a bug BUT it has been FIXED (#355376 and #354226).

DO NOT USE THIS POST unless you know what you are doing.

To install a CLI system on my hp mini 1000, I used the MID Live lpia iso, and when it gets into the graphical interface, I pushed ctrl+alt+f2 to switch to another TTY. And then I installed using cdebootstrap. This is quite an expert installation and it is very long and hard to do.

Read the rest of this entry »