DHCP Logging

[dhottinger at harrisonburg.k12.va.us]

I inherited a solution that works well.  I have a syslog server that  
my dhcp server sends its log files to.  The data gets put in a mysql  
database using an outdated opensource software called msyslog.  If a  
mac address appears that hasnt been on the network before I get an  
email from the server.  The entire thing is sort of complicated but  
works well.  I could send you some info if you like.   I have to run  
an older 2.4 kernel on my syslog server, but it still works well.

ddh


Quoting Blake Griffin <blake at ccfargo.com>:

> I am trying to do detailed logging of DHCP and keep it in a standard
> format so that it can be sent to a mysql database with entries for type
> (set-top box or data), addy, mac, host-name, AID, CID, and event type
> (commit, release, expiry).  I have multiple scenarios in which portions
> of this data is available.  The scenarios are:
>
>
>
> -set-top-box, no host-name, AID, no CID
>
> -set-top-box, no host-name, AID, CID
>
> -data, host-name, AID, CID
>
> -data, host-name, AID, no CID
>
> -data, no host-name, AID, CID
>
> -data, no host-name, AID, no CID
>
>
>
> I know this can be accomplished via combinations of if statements, etc.
> With the various scenarios, it can get very lengthy and convoluted.  Im
> looking for a more elegant way to accomplish this.
>
>
>
> So that I can just use one set of statements for on commit, on expiry,
> on release -  is there a way so that when the CID or host-name does not
> exist, to set those options within the dhcpd.conf file to a specific
> text string to log (i.e. null or ----) .  Also can you define variables
> within dhcpd.conf to be used within the log statements (i.e. - if option
> vendor-class-identifier = "STRING" TYPE = "STB OR DATA").
>
>
>
> Thanks,
>
> Blake
>
>



-- 
Dwayne Hottinger
Network Administrator
Harrisonburg City Public Schools

"Everything should be made as simple as possible, but not simpler."
-- Albert Einstein

"The hottest places in Hell are reserved for those who, in times of moral
crisis, preserved their neutrality."
-- Dante