I need to parse dhcpd.leases to store data in mysql

[George C. Kaplan]

Simon Hobson wrote:
> Brent L. Bates wrote:
> 
>>     Could the syslog output be of any help for the person trying to log
>>everything to his MySQL data base?  He could have all this output sent to its
>>own log file.  I know the default output doesn't have all the information he
>>needs.  However, are there any `ifdefs' that might turn this information on
>>and log it?  If not, how difficult would it be to modify the source to do so?
>> Just some ideas.
> 
> A good point. Another option would be to use the "on <action> ..." 
> external links, eg "on commit <call code to add record to database>". 
> Though care needs to be taken when using these not to introduce too 
> much latency into the server.

To avoid problems with latency, it's very easy to use "on commit {log
...}" to generate a syslog entry (with client MAC, IP, lease duration)
every time a lease is issued or renewed.  The syslog entries are much
easier to parse for database processing, and it's strictly serialized;
you don't have to deal with the daemon rewriting the leases file
periodically.

-- 
George C. Kaplan                            gckaplan at ack.berkeley.edu
Communication & Network Services            510-643-0496
University of California at Berkeley