Jess Robinson’s SQL-Translator CPAN module translates and parses SQL statements. The SQLfairy project has some nice binaries that, among other things, use GraphViz or GD to draw pseudo-ER diagrams from SQL CREATE statements. Drawing a diagram of an SQL schema is as easy as sqlt-diagram --db=MySQL …

I spend a fair amount of my time debugging network and service problems on a few racks of Linux servers. Of course, they’re located in a data center (yes, just downstairs, but still not quite as comfortable as my office), and they’re all command-line only - no sense in …

I spent a good part of the weekend auditing the security of my infrastructure at home, since I haven’t given it much attention lately. One of my first steps was doing a port scan with nmap of my public IPs from a remote host, both to make sure there …

I’m running a Vyatta vyatta router at home - in my opinion it’s pretty near “enterprise grade”, and I’m running the Community/Core (read: no-cost and almost all Free) on commodity hardware with great performance. Granted, I’m still on the older version (5 as opposed to the …

I’ve had the need to find out the actual username of someone logged in and working as root (via sudo su -) to put it into a subversion commit message. This quick little bash script does the trick, and just echos the username.

#!/bin/bash

PID=$$ # get PID of current …

So today I started to implement a number of complex regex-based rules and templates to get rsyslog to parse ISC DHCPd logs in realtime. Unfortunately one of my templates must have been wrong, because I started seeing some errors about a field that cannot be blank in /var/log/messages …

At work, I use synergy to control two computers with the same mouse and keyboard. My main desktop (skynet) has two monitors - generally one for Firefox and one for my terminals - and my secondary machine (mithrandir), a third monitor on my desk, handles email and IM. The only real problem …

Yes, I know I haven’t posted anything useful in a while. I’ve been quite busy at work, and hopefully I’ll post some of my DHCP stuff. In the meantime…

I’m starting a project for the ambulance corps migrating two Linux boxes to a single new server …

Recently I’ve been making some changes to a relatively complex ePCR (electronic patient care report) program that I wrote for the ambulance corps. It’s a web application (available only on our LAN, of course) written in PHP, with a relatively large chunk of custom javascript to provide Ajax …

Well, I’ve spend the better part of the last week or so debugging a problem with out new Xen VMs (on one host) not getting DHCP leases. Since our DHCP servers (ISC DHCPd 3.0.6) are using Brian Masney’s LDAP patch (which has recently been included in …