Tracking historical lease information
blake at ccfargo.com
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.
-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.
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?
dhcp-users mailing list
dhcp-users at lists.isc.org
More information about the dhcp-users