Installing Alfresco 4.2 on Debian 6

Installing Alfresco 4.2 on Debian 6 is not so hard. Just make sure you install the necessary libraries for LibreOffice and pdf2swf, otherwise the thumbnails and previews won't work properly.

We need the packages listed at but also a few others:

apt-get install libice6 libsm6 libxt6 libxrender1 libfontconfig1
apt-get install libgif4 libjpeg62 libpng12-0 libstdc++5 libxinerama1

After that, you can simply run the binary installer:

chmod +x alfresco-community-4.2.b-installer-linux-x64.bin

SQL: year of an ISO week

In MS-SQL you can get the ISO 8601 week date easily by using something like:

SELECT DATEPART(isoww, '2012-01-01')

This will tell you that January 1st of 2012 belongs to week 52. But it doesn't tell you that it belongs to year 2011! The shortest way to get the correct year is:

SELECT YEAR(DATEADD(day, 26 - DATEPART(isoww, '2012-01-01'), '2012-01-01'))

This will add some days to the date if it belongs to a week with a low number. It will subtract some days if it belongs to a week with a high number. The year of that date will always be the correct "ISO week year".

Tweet tweet!

Integrating my website with my @JoeriCapens twitter account.

Versio CloudBox

This website is hosted on a Virtual Machine provided by Versio.


  • very cheap - only € 9.99 for a machine with 1 CPU, 1 GB ram and 100 GB storage
  • nearly complete control over the machine - root access, remote console
  • very fast - I didn't do any measurements but it's definitely faster than my old PriorWeb shared hosting


  • poor uptime - less than 99.9% according to my Pingdom reports: stats
  • machine templates - it is not possible to do a fresh install from an ISO file (but luckily there are lots of good templates)
  • formatting a disk manually instead of using the CloudBox manager is not recommended, you won't be able to backup an ext4 filesystem for example 3.0

This is the third version of my website. The first one was a hand-written PHP website and the second one a Drupal 6 website which got messed up after blindly upgrading to Drupal 7.

I now have a lot more experience with Drupal so I decided to start over with a fresh installation.


Subscribe to RSS