Author: halfgaar

http://www.halfgaar.net/

Halfgaar is Wiebe. Wiebe is a contributing author on this weblog. He also has a lot of stuff (such as long, in-depth articles) on his personal website.

Wiebe works at YTEC, where he is a senior developer of customer-specific tailor-made software (“klantspecifieke maatwerk software“) for clients in a few select markets: wholesale, printing and healthcare.

Getting munin to run every 10 minutes

Munin is kind of inefficient and on my P4 2Ghz, it running every 5 minutes is too often, and the munin processes keep dying because locks already exist. You can't increase the munin-cron script to 10 minute intervals, because then rrdtool will generate gaps. Read More »
By halfgaar, 8 years ago, on December 18, 2012, at 16:12 | 3 comments

Adding a clock in screen to avoid your ssh’s from being killed

The world is filled with stupid routers, which kill all connections that have no activity for a while (even a very short while). I keep loosing my SSH sessions because of this. To fix it, I added a clock in my GNU screen bar: Read More »
By halfgaar, 8 years ago, on October 31, 2012, at 11:10 | 5 comments

Converting all tables in MySQL DB to InnoDB

#!/bin/bash exit 1 dbname="eorder" echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t echo 'SHOW TABLES;' | mysql $dbname | awk '!/^Tables_in_/ {print "ALTER TABLE `"$0"` ENGINE = InnoDB;"}' | column -t | mysql $dbname Read More »
By halfgaar, 8 years ago, on October 02, 2012, at 14:10 | 5 comments

Translating Dutch programming error messages

In .NET, you get Dutch errors when your Windows is in Dutch, which is hugely annoying. You can use this site to translate them, so that you can Google them. Read More »
By halfgaar, 8 years ago, on August 09, 2012, at 15:08 | 1 comment

My universal remote programming codes

Whenever this remote's battery is loose for a while, it forgets its programming. So, here it is: For computer, use the TV setting. Press 1 and 3 for a few seconds, then when the light turns on, enter 0677 as code. Read More »
By halfgaar, 8 years ago, on August 06, 2012, at 21:08 | Comments closed

Kart racing scores

I want to keep track of my kart racing scores: dateTrackRacerfastest Time 2012-07-24Long BeachWiebe55.95 2012-07-24Long BeachWiebe56.22 2012-07-24Long BeachWiebe58.84 Read More »
By halfgaar, 8 years ago, on July 25, 2012, at 15:07 | Comments closed

Apache mod_proxy configuration for The Pirate Bay

I found several apache mod_proxy configs for setting up a proxy for The Pirate Bay, but none worked fully. Read More »
By halfgaar, 8 years ago, on July 13, 2012, at 16:07 | 7 comments

Listing MySQL table sizes

This query lists the sizes of all tables in MySQL: SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), 'MB') DATA, CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), 'MB') FREE from information_schema.TABLES where TABLE_SCHEMA NOT IN ('information_schema','mysql', 'performance_schema'); Read More »
By halfgaar, 8 years ago, on July 12, 2012, at 13:07 | Comments closed

Generating an SSL CSR and key

To generate an SSL certificate signing request (CSR) with key you can do this: openssl req -nodes -newkey rsa:2048 -keyout bla.key -out bla.csr Read More »
By halfgaar, 8 years ago, on May 10, 2012, at 15:05 | Comments closed

Creating a drbd for an existing Xen domain

I needed some VMs to be available on a backup node, which I accomplished with the distributed remote block device, or DRBD. My host machine is Debian 6. Read More »
By halfgaar, 8 years ago, on May 01, 2012, at 18:05 | 1 comment