It’s a Schwer Christmas.

It’s a Schwer Christmas.

Originally uploaded by Augie Schwer.

Merry Christmas everyone; here are some Christmas photos from the Schwers:

http://flickr.com/photos/augie/sets/72157603608425815/

Posted in family, General | Tagged | Leave a comment

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.

Posted in General, work | Tagged , , , | 2 Comments

Sonic.net Holiday Party 2007

Gin & Tonic

Originally uploaded by Augie Schwer.

Sonic.net had it’s Holiday Party this last Friday; the full set can be found here:

http://flickr.com/photos/augie/sets/72157603462438856/

Posted in General, work | Tagged | Leave a comment

Thanksgiving in Tennessee

Augie’s got a gun

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:

http://flickr.com/photos/augie/sets/72157603358116483/

Posted in family, General | Tagged | Leave a comment

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. :)

Posted in General, work | Tagged | Leave a comment

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. :)

Posted in General | Leave a comment

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.

Posted in General | Leave a comment

Peek-a-boo I see you.

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:

http://www.flickr.com/photos/augie/sets/72157602933913429/

Posted in family, General | Tagged | Leave a comment

Pumpkin Carving

IMG_3977

Originally uploaded by Augie Schwer.

We let Davis have at the Pumpkins with a toy knife.

The full set can be found here:

http://www.flickr.com/photos/augie/sets/72157602821717352/

Posted in family, General | Tagged | Leave a comment

My little pumpkin.

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.

Click here to view the full set.

Posted in family, General | Tagged | 1 Comment

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.

Posted in General | 2 Comments

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].

Posted in General, work | Tagged | Leave a comment

axfr2rbldnsd – Converting Bind (or anything really) to rbldnsd.

I could not find a script to do this anywhere, so I wrote one; it was meant to convert Bind style zone files to Rbldnsd style zone files, but since it first does an AXFR, it can be used to generate rbldnsd zones from any source that supports DNS transfers.

Here is a direct link to the file, feel free to download it: http://schwer.us/files/axfr2rbldnsd.pl; and here’s the code:


#!/usr/bin/perl

# Author: Augie Schwer
# $Id: axfr2rbldnsd.pl 1274 2007-09-23 20:30:17Z augie $
# Purpose: Convert a transfered zone files to rbldnsd style and
# prints to STDOUT.

use strict;

unless ( defined $ARGV[0] ) { print “USAGE : $0 zone_to_transfer (host)\n”; exit; }

my $zone = $ARGV[0];
my $host = $ARGV[1] || ‘localhost’;
my $time = time();
my $tmp_file = “/tmp/$zone.$time”;
my $found_ns = 0;
my $found_soa = 0;

`dig \@$host axfr $zone > $tmp_file`;

open FILE , “$tmp_file” or die “Could not open $tmp_file : $!”;

while ()
{
# Ignore comments
next if /^;/;

# remove everything in front of SOA, but keep the TTL.
if (!$found_soa) # we only need one SOA.
{
if ( /(\d+)\s+IN\s+SOA\s+(.+)$/ )
{
print “\$SOA $1 $2″;
$found_soa = 1;
next;
}
}

# remove everything in front of NS, but keep the TTL.
# concat all NS records together.
if (!$found_ns and /(\d+)\s+IN\s+NS\s+(.+)$/)
{
print “\n\$NS $1 $2 “;
$found_ns = 1;
next;
}
if ( /IN\s+NS\s+(.+)$/ ) { print “$1 “; next; }

# anything that’s not a sub-domain gets an ‘@’ in
# front followed by the type and record.
if ( /^$zone\.\s+(\d+)\s+IN\s+(A|MX)\s+(.+)$/ ) { print “\n@ $1 $2 $3\n”; next; }
# print the rest of the A records.
if ( /^(.+)\.$zone\.\s+(\d+)\s+IN\s+A\s+(.+)$/ ) { print “$1 $2 IN A $3\n”; next; }
}

# clean up after myself.
`rm -f $tmp_file`;

Posted in General, work | Tagged , | 1 Comment

My new Internet Addictions

I am hooked on DI.fm and SKY.fm; both offering Internet Radio for free with commercials and premium services sans the commercials and at a higher sound quality. The House music is great background music for work, and Angela and I have a ton of fun with the 80′s channel. Other favorites are: Roots Reggae, DaTempo Lounge, and Classic Rap.

My other Internet Addiction these days is Twitter; an Internet SMS (Text Message) Gateway. I subscribe to friends feeds and get updates via my phone though out the day; I also let people who are subscribed to my feed know what I am up to. Mostly I’ve been using it to organize lunch and coffee runs, but my hope is that at some point I can send something like “At Oktoberfest.” and have group of people show up and hang out that normally would be hard to gather up.

Posted in General | Tagged | Leave a comment

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.

Posted in General, work | Tagged , | Leave a comment

Happy Birthday Davis

Cake Time

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/

Posted in family, General | Tagged , | Leave a comment

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].

Posted in General, work | Tagged , | Leave a comment

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.

Posted in General, work | Tagged , | Leave a comment

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.

Posted in General, work | Tagged , | Leave a comment