Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re^2: put dhcp leases into database

by varalaxmibbnl (Acolyte)
on Jan 17, 2014 at 12:19 UTC ( #1070941=note: print w/replies, xml ) Need Help??

in reply to Re: put dhcp leases into database
in thread put dhcp leases into database

Thanks for the reply

my script works for but some times it repeats the data in database... i just don't want to repeat the data in soon as the lease is created i want it to be written it into database...

Replies are listed 'Best First'.
Re^3: put dhcp leases into database
by karlgoethebier (Monsignor) on Jan 17, 2014 at 12:56 UTC
    " repeats the data in database..."

    Does that mean the same data is written twice or more to your database?

    If so, i guess a bit :-( Can't you remember the mtime of dhcpd.leases and write the data only to your DB if dhcpd.leases was updated?

    But this might get a little bit more complicated:

    "...Every time a lease is acquired, renewed or released, its new value is recorded at the end of the lease file. So if more than one declaration appears for a given lease, the last one in the file is the current one..."


    "...In order to prevent the lease database from growing without bound, the file is rewritten from time to time. First, a temporary lease database is created and all known leases are dumped to it. Then, the old lease database is renamed /var/lib/dhcpd/dhcpd.leases~. Finally, the newly written lease database is moved into place..."

    See also dhcpd.leases.

    Update: Net::ISC::DHCPd::Leases might be interesting. I didn't use it but perhaps it's worth to take a look at.

    Regards, Karl

    «The Crux of the Biscuit is the Apostrophe»

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1070941]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others taking refuge in the Monastery: (9)
As of 2018-06-21 15:13 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (118 votes). Check out past polls.