Tracking historical lease information

[Blake Griffin]

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.

Blake


-----Original Message-----
From: dhcp-users-bounces+blake=ccfargo.com at lists.isc.org [mailto:dhcp-users-bounces+blake=ccfargo.com at lists.isc.org] On Behalf Of David Carlin
Sent: Wednesday, January 19, 2011 5:05 PM
To: dhcp-users at lists.isc.org
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 - http://hans.liss.pp.se/software/gluff
FindHosts - http://wormhole.anchorageak.net/FindHosts/
DHCPStatus - http://dhcpstatus.sourceforge.net/
reportdhcp.pl - http://www.omar.org/opensource/reportdhcp/
LanLord - http://lanlord.sourceforge.net/

DHCPStatus, reportdhcp.pl 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?

David
_______________________________________________
dhcp-users mailing list
dhcp-users at lists.isc.org
https://lists.isc.org/mailman/listinfo/dhcp-users