Originally uploaded by Augie Schwer.
Merry Christmas everyone; here are some Christmas photos from the Schwers:
Author Archives: augie
Perl CPAN PowerDNS modules released.
I have released several PowerDNS modules to CPAN:
http://search.cpan.org/~augie/
PowerDNS::Backend::MySQL Provides an interface to manipulate PowerDNS data in the MySQL Backend.
PowerDNS::Control::Client Provides an interface to control the PowerDNS daemon.
PowerDNS::Control::Server Provides an interface to control the PowerDNS daemon.
The MySQL interface is based on code I have in production, but currently is not what I have running, yet.
The Client/Server Control code I do have running in production; although they currently only implement the features I needed to deploy.
Sonic.net Holiday Party 2007
Originally uploaded by Augie Schwer.
Sonic.net had it’s Holiday Party this last Friday; the full set can be found here:
Thanksgiving in Tennessee
Originally uploaded by Augie Schwer.
The Schwers went to Tennessee for Thanksgiving this year. From this photo you can tell I did some shooting while we were there.
The full set can be found here:
File::Rotate::Backup
File::Rotate::Backup is a handy Perl module for backing up directories/files and archiving and rotating them. It’s even more handy after I contributed a patch to add the ‘no_archive’ option.
Good to know.
If you are traveling this Holiday week, and you are thinking of bringing some “liquid” gifts, then here are a few good links for you:
Baggage Chart – Frontier Airlines
TSA: Permitted and Prohibited Items
From the Frontier Airlines’ website on their Alcohol restrictions: “Limit: 5 liters per passenger“; it’s a good thing we got Davis his own seat.
The joys of Costco.

The joys of Costco.
Originally uploaded by Augie Schwer.
24 pack of Sierra Nevada Celebration Ale and 1.75L of Bombay Saphire Gin for around $40.
Peek-a-boo I see you.
Originally uploaded by Augie Schwer.
We dressed Davis up as a Monkey this year. The full set can be found here:
Pumpkin Carving
Originally uploaded by Augie Schwer.
We let Davis have at the Pumpkins with a toy knife.
The full set can be found here:
My little pumpkin.
Originally uploaded by Augie Schwer.
The Schwers headed to the Petaluma Pumpkin Patch this last weekend. Davis found a few pumpkins he liked and ran around looking at all the animals and pumpkins.
Cotati Oktoberfest is coming!
http://events.pressdemo.com/cotati-ca/events/show/80470681-cotati-oktoberfest
Summary:
Get out your lederhosen and practice your yodeling for the upcoming Cotati Oktoberfest. Wunderbar food, beer & root beer on tap, & oom-pah-pah bands, Bavarian singers and danc
More Information:
Specially brewed Oktoberfest Ale by Lagunitas Brewing Co., draft root beer by Thomas Kemper, plus weisswurst, bratwurst or roast chicken, apple strudel, pretzels & more!
Update: Pretty disappointing; we arrived an hour after it opened and it was already sold out; which turned out to be a blessing as it didn’t really look like it was worth the $20 a head. For $20 it looks like you got to cram into a tent and listen to music and drink beer, so unless it’s all you can eat and drink for $20, then I have to say “no way Jose” next year. Hey Cotati, make your Oktoberfest worth the money or make it cheaper.
MySQL Replication Presentation
Last night I gave a talk about MySQL Replication to the Sonoma County System Administrators group; in case you missed it, here is the presentation in PDF:
MySQL Replication [pdf].
innobackup and MySQL Replication
When using InnoDB‘s Hot Backup code to take a snapshot of your production database and use that snapshot to populate a new slave you may run into an error about not being able to drop the ibbackup_binlog_marker table and all replication bombs out.
The problem is that the innobackup tool deletes the temporary table ibbackup_binlog_marker but the .frm file does not get removed, so your new slave sees the ibbackup_binlog_marker.frm and thinks the table should exist, but the binary log says you are trying to replay says it’s already been deleted; the result is an inconsistent state that causes MySQL replication to fail.
The solution is to remove the ibbackup_binlog_marker.frm file in the mysql data directory; after that is done, then slave replication should continue as expected.
Happy Birthday Davis
Originally uploaded by Augie Schwer.
Davis had his One Year Birthday this last weekend; we spent it with friends at the SF Zoo; for the full set follow this link: http://www.flickr.com/photos/augie/sets/72157601844616634/
Procmail Tips: How to not forward DSNs to Gmail.
You know that looping your mail is a bad idea; that is forwarding your email to Gmail and then forwarding that back to yourself, ad infinitum, you get the idea. It’s equally a bad idea to forward DSNs or bounce messages to Gmail (or anywhere really); as it causes the same sort of loop and the same kind of aggravation for your System Administrator. The following is a procmail recipe that works for me.
PMDIR=$HOME/.procmail
LOGFILE=$PMDIR/procmail.log
VERBOSE=yes
SENDMAIL=/usr/sbin/sendmail
FORMAIL=/usr/bin/formail
SUBJECT=`$FORMAIL -xSubject:`
:0
* ^X-Loop: Your_Email_Address@sonic.net
/dev/null
:0E
* ^TO_Your_Email_Address\+0x96rds@sonic\.net
$DEFAULT
:0cE
| $FORMAIL -A “X-Loop: Your_Email_Address@sonic.net” | $SENDMAIL -f Your_Email_Address+0x96rds@sonic.net -oi Your_Email_Address@gmail.com
PowerDNS Presentation
I recently gave the same talk about PowerDNS to both the Sonoma County System Administrators group and the North Bay Linux Users Group; in case you missed it, here is the presentation in PDF format:
The PowerDNS Name Server[pdf].
Official developer for the “mon” monitoring project.
I have been doing quite a bit of work with mon, an Open Source software project that is used to monitor the health of the services and systems on your network; which is a very handy thing when you are in charge of hundreds of machines that all need to offer different levels of service. I started submitting quite a few updates to the software for our own internal use and ended up getting on the CVS commiter’s list; which makes me an official developer of the mon project; which is pretty cool in a nerdy kind of way.
Positive Feedback for me! – Fwd: [Pdns-dev] Now is the time to test the 2.9.21 snapshots + release notes. ]
PowerDNS is Open Source software that I have been helping bug fix and develop, and the other day I received a nice little public thank you on the various PowerDNS public mailing lists. I’ve trimmed the message a bit; the original can be found here:
http://mailman.powerdns.com/pipermail/pdns-dev/2007-April/000590.html
———- Forwarded message ———-
From: bert hubert
Date: Apr 9, 2007 5:39 AM
Subject: [Pdns-dev] Now is the time to test the 2.9.21 snapshots +
release notes.
To: pdns-users@mailman.powerdns.com,
pdns-announce@mailman.powerdns.com, pdns-dev@mailman.powerdns.com
Hi everybody,
Somewhere in the coming 2 weeks, we will release the PowerDNS Authoritative
Server version 2.9.21.
…
This release would not have been possible without large amounts of help
and support from the PowerDNS Community. We specifically want to thank
Massimo Bandinelli of Italy’s Register.it, Dave Aaldering of Aaldering
ICT, True BV, XS4ALL, Daniel Bilik of Neosystem, EasyDNS, Augie Schwer,
Mark Bergsma, Marcus Rueckert of OpenSUSE, Andre Muraro of Locaweb, Antony
Lesuisse, Norbert Sendetzky, Marco Chiavacci, and Ruben Kerkhof.
…
Merry Christmas 2006

Postcard Photo
Originally uploaded by Augie Schwer.
Davis’s first Christmas; lots of fun, lots of toys, lots of things for Dad to put together.
Getting More Out of Your Rechargeable Batteries.
Being a parent means building lots of toys and being the “some assembly required” on the side of a lot of boxes; and all those toys, swings, and bouncers need batteries, so obviously after you go through your first sixteen packs of AA batteries you start to think there has to be a better way. Rechargeable batteries are the solution and to get more out of my batteries I use these neat little sleeves that can turn my AAs in to Ds; one AA battery fits into a single D sleeve, and can give dual purpose to your single purpose AA.







