Fixing the SQLite DB for a Trac Instance

August 20, 2009

’bout time I add some sysadmin content here. If you ever have a trac instance go boom with an error like “DatabaseError: database disk image is malformed” you can often fix the problem by doing an sqlite dump/reload: $ cd /path/to/trac-sqlite-db-directory # find the trac.db file $ su www-data # switch to the owner of [...]

Read the full article →

PMotD: Text::Balanced

July 31, 2009

If you’ve read Jeffrey Friedl’s Mastering Regular Expressions1 you’ll recall that one of the things that is a lot harder than it looks to get right using regexps is extracting the content from within some text-delimited string, especially when there are opening and closing delimiters2. Text::Balanced originally by Damian Conway and now maintained by Adam [...]

Read the full article →

PMotD: Devel::Deprecate

July 27, 2009

Today’s interesting Perl module of the Day:  Devel::Deprecate by Curtis “Ovid” Poe. Back in 2000, I started teaching a class called “Perl Saves the Day: Writing Small Perl Programs to Get Out of Big SysAdmin Pinches” which was essentially a class about Perl hacks and how to use them responsibly in System Administration. One of my [...]

Read the full article →

And We Have a Winner!

July 13, 2009

Kudos goes to Thomas Leyer of Germany for finding the very first typo in the printed version of the book. Books like these have an amazing amount of detail so it is not uncommon for a few small things to slip through (in this case it was a single missing dash). I’m very thankful when [...]

Read the full article →

Welcome Back, Otter

June 15, 2009
Thumbnail image for Welcome Back, Otter

I’m thrilled and delighted to announce that Automating System Administration with Perl, the second edition of the semi-famed Otter Book (the book formerly known as Perl for System Administration) has been published by O’Reilly Media. The Otter Book is available now in paper and electronic form. Be sure to get your copy now!

Read the full article →