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.

Cursor definition and looping with MS SQL

In MSSQL, I needed to loop over a bunch of orders and execute a stored procedure, except in one case. This does that: Read More »
By halfgaar, 9 years ago, on September 30, 2013, at 14:09 | 2 comments

Upgrading PowerDNS from Debian Squeeze to Wheezy

As I mentioned here, I had to manually create a database schema when I installed PowerDNS on Debian Squeeze. Later versions apparently create one themselve. Read More »
By halfgaar, 9 years ago, on September 24, 2013, at 12:09 | Comments closed

Broken disk went undetected, but did corrupt data

I had a disk in one of my servers that was starting to give ATA errors in the syslog. Contrary to what you might think, ATA errors are fairly common, so I didn't immediately sound the alarm. However, this disk turned out to be corrupting data. During upgrading Debian 6 to 7, the file system became read-only. Rebooting gave me a recovery shell and e2fsck gave me millions of questions. Read More »
By halfgaar, 9 years ago, on September 06, 2013, at 15:09 | Comments closed

Blackberry links

Here are some blackberry links for me. Blackberry support forums Blackberry incident support Software Download for BlackBerry Enterprise Server & BlackBerry Enterprise Server Express Read More »
By halfgaar, 9 years ago, on July 25, 2013, at 12:07 | Comments closed

Areca RAID system password

I needed to configure an Areca RAID array to find out it was password protected. I could unlock it with: MNO974315743924. Read More »
By halfgaar, 9 years ago, on July 03, 2013, at 15:07 | Comments closed

3Ware 9650 SE drive compatibility list

Especially the addendum to the 3Ware 9650 SE RAID controller compatibility list is hard to find, so I'm making them easily available. Read More »
By halfgaar, 9 years ago, on July 03, 2013, at 14:07 | Comments closed

FreeIPA: Active Directory for Linux?

Note to self: explore FreeIPA. Someone on Serverfault suggested it and said it was what AD is for Windows. If it is, it would relieve me of LDAP hell. Too long for this blog post, but I spent about a week (or more) full-time to get an LDAP setup working, with all security measures in place. It involved diving into source code, discovering and reporting Ubuntu documentation bugs, etc. An experience I don't care to repeat. Read More »
By halfgaar, 9 years ago, on July 01, 2013, at 21:07 | Comments closed

Blackberry Enterprise Server issues

I've had some issues with my Blackberry Enterprise Server. Some users say their mail is not synced. Others are reporting calendars being messed up. Just jotting down some memory aids. Read More »
By halfgaar, 9 years ago, on June 19, 2013, at 15:06 | Comments closed

Checking SMART status on a 3Ware controller with smartctl

A RAID controller hides the physical disks from the operating system, so it's harder to query the SMART data. Luckily, smartctl has a way to do it: Read More »
By halfgaar, 9 years ago, on June 17, 2013, at 14:06 | Comments closed

Adding foreign key constraints to PowerDNS default schema

In an earlier post I made, I described how to manually create the SQL schema, because it didn't itself. When I installed Power DNS 3.1-4 on a Raspberry Pi, I noticed it had created the scheme itself this time. However, it did not make the foreign key constraints. This is dumb. I regularly need to remove domains from the DB and I don't want stale or incorrect references as a result. Read More »
By halfgaar, 9 years ago, on June 12, 2013, at 23:06 | 1 comment