Category Archives: work

Using Net::DNS to write your own recursor.

Here’s a bit of code I wrote for work that I thought was kind of neat; it uses a recursive function and Net::DNS to recurse DNS. #!/usr/bin/perl use strict; use warnings; use Net::DNS; my $domain = ‘schwer.us’; my $sonicrns= ‘ns2.sonic.net’; … Continue reading

Posted in work | 1 Comment

PowerDNS MySQL INT limit reached.

The very non-descriptive error below indicates that you have reached the maximum value for the MySQL INT Data Type. Communicator thread died because of error: Failed to execute mysql_query, perhaps connection died? Err=-1: Duplicate entry ’2147483647′ for key 1 What … Continue reading

Posted in General, work | Tagged | 1 Comment

Feed Twitter an RSS feed with Perl.

Here’s a more concise script to feed Twitter an RSS feed; in this case the latest post to the Sonic.net MOTD Blog. The following code grabs the latest entry in an RSS feed, pulls out the URL and as much … Continue reading

Posted in General, work | Tagged | Leave a comment

Sonic.net updates via Twitter

Get updates about your favorite ISP from Twitter; just send “follow sonicnet” from your favorite Twitter device. You can check out the sonicnet page to see what you’ll be getting. The code for this is made possible by the Net::Twitter … Continue reading

Posted in General, work | Tagged | 3 Comments

Perl , $SIG{CHLD} = ‘IGNORE’ , system() and you.

Note: This has been in my drafts for a while, but I think it’s ready for publishing.. At first blush you probably would not expect the following to print “-1″; as you probably expect “system” to execute and return the … Continue reading

Posted in General, work | Tagged | 1 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 … Continue reading

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

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

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 … Continue reading

Posted in General, work | Tagged , | 1 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 … Continue reading

Posted in General, work | 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 … Continue reading

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 … Continue reading

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

Allow your program to bind to an address that doesn’t exist yet.

This is so cool: http://www.linuxguruz.com/iptables/howto/2.4routing-13.html /proc/sys/net/ipv4/ip_nonlocal_bind Set this if you want your applications to be able to bind to an address which doesn’t belong to a device on your system. This can be useful when your machine is on a … Continue reading

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

MySQL Replication – Creating Additional Slaves.

So you have MySQL Replication setup and working and now you want to create more slaves to your existing deployment; these are the steps that have worked for me: Here Slave One is the slave that is currently in production … Continue reading

Posted in General, work | Tagged , | 1 Comment

Replay DNS traffic – dnsreplay.pl

The following is a handy little script for replaying DNS traffic and thus verifying that a Name Server will answer as you expect it to. Updated: Tue Apr 15 16:12:59 PDT 2008. #!/usr/bin/perl # Augie Schwer # dnsreplay.pl – replay … Continue reading

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

MySQL purge master logs.

MySQL 5.0 Reference Manual :: 13.6.1.1 PURGE MASTER LOGS Syntax There’s a neat little trick in the comments section about how to purge the binary MySQL logs after 30 days: PURGE MASTER LOGS BEFORE DATE_SUB( NOW(), INTERVAL 31 DAY);

Posted in General, work | Tagged | Comments Off

Extending Mailman list invitation expiration

http://mail.python.org/pipermail/mailman-users/2005-April/043999.html in mm_cfg.py # Default length of time a pending request is live before it is evicted from # the pending database. PENDING_REQUEST_LIFE = days(3) By default after three days Mailman will trash the invitations you have sent people to … Continue reading

Posted in General, work | Tagged | Leave a comment