Tracking historical lease information

Blake Griffin blake at
Thu Jan 20 15:30:38 UTC 2011

Someone recommended Gluff and another option for me.  I chose the second option.  I am not sure if this is the most efficient way as much of this was new to me, but it works. I will give a quick synopsis for you.

-Running ubuntu
-Installed mysql-server, mysql-query-browser, phpMyAdmin, rsyslog-mysql
-In dhcpd.conf, log custom statements to a log file that includes my required data on commit, expiry, and release (IP, MAC, Option 82 info, etc).
-Use rsyslog-mysql to push that to a sql database that can then be viewed, queried, and exported by phpMyAdmin.
-Cron job is then set up to start a  save existing DB to another DB for archive purposes and clear the DB to start new every month.


-----Original Message-----
From: at [ at] On Behalf Of David Carlin
Sent: Wednesday, January 19, 2011 5:05 PM
To: dhcp-users at
Subject: Tracking historical lease information

I'm looking for a way to track historical lease information.  For
example, I want to be able to query a specific IP and time stamp and
be returned the MAC address which has a lease for that IP at that
point in time.

I've come across the following logging/tracking solutions searching
the list archives:

Gluff -
FindHosts -
DHCPStatus - -
LanLord -

DHCPStatus, and Lanlord seem to be geared toward
reporting on the status of current leases.  Only FindHosts and Gluff
appear to have facilities to support historical use.  Gluff seems the
most promising, but I'm not in control of the DHCP servers to upgrade
them to 4.1.0+.

Anyone else have any other recommendations before I go the roll your own route?

dhcp-users mailing list
dhcp-users at

More information about the dhcp-users mailing list