Log consolidation

Well, my nice DNS service with two secondaries and a primary is all well and good, but my logs are now scattered across three machines. If I want to play with the stats or diagnose a problem or see when something went wrong, I now have to grep around on three different machines.

Obviously I could consolidate the logs using syslog. That's what it's designed for, so why don't I do that. Let's see what I have to do to make that work properly:

  1. Set up rsyslogd on flapjack to properly stash the DNS messages

  2. Set up DNS on flapjack to log to syslog

  3. Set up the rsyslogd service on flapjack to receive syslog messages over the network

  4. Set up rsyslog on waffle to forward dns log messages to flapjack

  5. Set up rsyslog on pancake to forward dns log messages to flapjack

  6. Set up the DNS secondary configurations to use syslog instead of local logs

  7. Distribute the updates and restart the secondaries

  8. Test everything

A side benefit of using syslog to accumulate my dns logs is that they'll now be timestamped so I can do more sophisticated data analysis if I ever get a Round Tuit.

Here's the architecture of the setup I'm going to pursue:


So the first step is to set up the primary DNS server on flapjack to write to syslog.  This has several parts:

  • Declare a "facility" in syslog that DNS can write to.  For historical reasons (Hi, Eric!) syslog has a limited number of separate facilities that can accumulate logs.  The configuration file links sources to facilities, allowing the configuration master to do various clever filtering of the log messages that come in.

  • Tell DNS to log to the "facility"

  • Restart both bind9 and rsyslogd to get everything working.

The logging for Bind9 is specified in a file called at /etc/bind/named.conf.local.  The default setup involves appending log records to a file named /var/log/named/query.log.

We'll keep using that file for our logs going forward, since some other housekeeping knows about that location and no one else is intent on interfering with it.

The old logging stanza was:
logging {
channel query.log {
file "/var/log/named/query.log";
severity debug 3;
category queries { query.log; };

What I want will be this:
logging {
channel query.log {
syslog local6;
severity debug 3;
category queries { query.log; };

Because I have decided to use the facility named local6 for DNS.

In order to make the rsyslogd daemon on flapjack listen to messages from DNS, I have to declare the facility active.

The syslog service on flapjack is provided by a server called rsyslogd.  It's an alternative to the other two main stream syslog products - syslog-ng and sysklogd.  I picked rsyslogd because it comes as the standard logging service on Ubuntu 12.04 and 14.04, the distros I am using in my house.  You might call me lazy, you might call me pragmatic, but don't call me late for happy hour.

In order to make rsyslogd do what I need, I have to take control of the management of two configuration files: /etc/rsyslog.conf and /etc/rsyslog.d/50-default.conf.  As is my wont, I do this by creating a project directory ~/projects/r/rsyslog/ with a Makefile and the editable versions of the two files under RCS control.  Here's the Makefile:
cat Makefile
# rsyslog setup file
# As of 2014-08-01 syslog host is flapjack
# $Id: Makefile,v 1.4 2014/08/02 12:11:52 marc Exp $

TARGETS = /etc/rsyslog.conf /etc/rsyslog.d/50-default.conf

FILES = Makefile rsyslog.conf 50-default.conf

help: ${FORCE}
cat Makefile

# sudo
/etc/rsyslog.conf: rsyslog.conf
cp $< $@

/etc/rsyslog.d/50-default.conf: 50-default.conf
cp $< $@

# sudo
push: ${TARGETS}

# sudo
restart: ${FORCE}
service rsyslog restart

verify: ${FORCE}
rsyslogd -c5 -N1

compare: ${FORCE}
diff /etc/rsyslog.conf rsyslog.conf
diff /etc/rsyslog.d/50-default.conf 50-default.conf

checkin: ${FORCE}
ci -l ${FILES}


Actually, this Makefile ends up in ~/projects/r/rsyslog/flapjack, since waffle and pancake will end up with different rsyslogd configurations and I separate the different control directories this way.

In order to log using syslog I need to define a facility, local6, in the 50-default.conf file. The new assertion looks like this:
local6.*	-/var/log/named/query.log

With a restart of each of the appropriate daemons, we're off to the races and the new logs appear in the log file. I needed to change the ownership of the /var/log/named/query.log from bind to syslog in order for the new writer to be able to write, but that was the work of a moment.

Now comes the task of making the logs from the two secondary DNS servers go across the network to flapjack. This involved a lot of little bits and pieces.

First of all, I had to tell the rsyslogd daemon on flapjack to listen to the rsyslog UDP port. I could have turned on the more reliable TCP logging facility or the even more reliable queueing facility, but let's get real. These are DNS query logs we're talking about. I don't really care if some of them fall on the floor. And anyway, the traffic levels on donner.lan are so low that I'd be very surprised if the loss rate is significant anyway.

To turn on UDP listening on flapjack all I had to do was uncomment two lines in the /etc/rsyslog.conf file:
# provides UDP syslog reception
$ModLoad imudp
$UDPServerRun 514

One more restart of rsyslogd on flapjack and we're good to go.

The next step is to make the DNS name service on waffle and pancake send their logs to the local6 facility. In addition, I had to set up rsyslog on waffle and flapjack with a local6 facility, though this time the facility has to know to send the logs across to flapjack by UDP rather than writing locally.

The change to the named.conf.local file for waffle and pancake's DNS secondary service was identical to the change to flapjack's primary service, so kudos to the designers of bind9 and syslogd for good modularization.

To make waffle and pancake forward their logs over to flapjack required that the /etc/rsyslog.d/50-default.conf file define local6 in this way:
local6.*	@syslog

Notice that the @ tells rsyslogd to forward logs to local6 via UDP. I could have put the IP address of flapjack right after the @ or I could have put in flapjack. Instead, I created a DNS listing for a service host named syslog ... it happens to have the same IP address as flapjack, but it gives me a level of indirection if I should desire to relocate the syslog service to another host.

With a restart of rsyslogd and bind9 on both waffle and pancake, we are up and running. All DNS logs are now consolidated on a single host, namely flapjack.


Popular posts from this blog

Quora Greatest Hits - What are common stages that PhD student researchers go through with their thesis project?

Toy Data Center update

HP 35 calculator 200 trick