Sequel Pro, a free MySQL GUI for Mac OS X

Published by:

For my own projects I use Virtualbox on OS X to run a Centos 6 Linux VM to develop on. That VM runs the LAMP stack, and I used to work on the MySQL part of the project with the MySQL command line tools, or with PHPMyAdmin.
A few weeks ago I somehow bumped into Sequel Pro, and it had me wondering why I didn’t read about this before, so I thought I’d blog about it to get more people to notice it.
Sequel Pro is a free and very full featured MySQL GUI application for OS X, with a lot of nice features. I found the ‘SSH tunnel connection (including private keys)’ feature the nicest so need to open up firewalls for MySQL anymore as long as you have an SSH connection.

Dovecot with MBOX, IMAP and subfolders, or “Target mailbox doesn’t allow inferior mailboxes”

Published by:

When using IMAP with Dovecot, and Dovecot using MBOX to store the mails, working with subfolders can be awkward to say the least.
As there isn’t much to be found in one place about this, I thought I’d write a small blog about it.

The MBOX format limits your clients to creating subfolders that can either store folders, or emails, not both. When creating a folder, you differentiate between a folder for storing folders or for storing emails by adding or leaving out a forward slash at the end of the folder name: A folder name like ‘withsubfolders/’ will be able to store folders, a folder name like ‘onlyemails’ will only be able to store emails. If you try to create a subfolder in a folder that has been created without the forward slash you will get the nice error “Target mailbox doesn’t allow inferior mailboxes”.

A nice problem this limitation causes is when deleting folders in Microsoft Outlook you encounter the problem that the ‘removed items’ folder has been created to store only mails, so it will not be able to store deleted folders. You will get the ‘inferior mailboxes’ error from the previous paragraph. You can however work around this by pressing shift when trying to delete a folder, which will delete it immediately.

Moving your code from CVS to Git

Published by:

This post is a short one, mostly compiled from bits and pieces I found on, but I thought it might make a useful how-to for some people.

The goal is to move the code that you have in CVS to Git, whilst keeping the whole revision history.

I’m assuming you’re doing this on a unix-like environment.

First copy the whole CVS dir from the remote host to the local machine. I’m doing this as I could not find an easy way to use the ssh method of CVS with git import..:

rsync -avz -e ssh username@cvshost:/somedir/cvsroot/ /somedir/cvs/

The whole remote CVS repository is now on your local machine in the /somedir/cvs directory

Then import the first project (module as CVS calls it), ‘foo’:

git cvsimport -p -x -v -d :local:/somedir/cvs/ foo

You know have a foo git repository on your local machine, and you can use it as any Git repository.

Creating a test certificate in CentOS / RHEL

Published by:

This is very easy, and the only reason I’m posting it is because it is not found in enough places, most people explain it using all the seperate tools/steps:

cd /etc/pki/tls/certs
make testcert
service httpd restart

This would put the certificate in /etc/pki/tls/certs/ and the key in /etc/pki/tls/private/, which is useful to know if you have a self compiled Apache.