Sponsored Content
Top Forums UNIX for Dummies Questions & Answers remove duplicate entries from dhcp.lease Post 302575618 by bitspradp on Tuesday 22nd of November 2011 08:05:39 AM
Old 11-22-2011
remove duplicate entries from dhcp.lease

Hi,

I have to parse the dhcp.lease file and have to keep the most recent entry and remove the rest and also the number of lines between any two leases might not always be the same.

eg:


lease 5.5.5.252 {
starts Wed Jul 27 09:48:39 2011
ends Wed Jul 27 21:48:39 2011
tstp Wed Jul 27 21:48:39 2011
binding state active;
next binding state free;
hardware ethernet 00:25:90:0a:95:e1;
uid "\001\000%\220\012\225\341";
}
lease 5.5.5.253 {
starts Wed Jul 27 11:18:04 2011
ends Wed Jul 27 23:18:04 2011
binding state active;
next binding state free;
hardware ethernet 00:1b:54:c9:e9:fd;
uid "\001\000\033T\311\351\375";
}
lease 5.5.5.252 {
starts Wed Jul 27 11:23:32 2011
ends Wed Jul 27 23:23:32 2011
binding state active;
next binding state free;
hardware ethernet 00:25:90:0a:95:e1;
uid "\001\000%\220\012\225\341";
}
lease 5.5.5.253 {
starts Wed Jul 27 11:24:35 2011
ends Wed Jul 27 23:24:35 2011
tstp Wed Jul 27 23:18:04 2011
binding state active;
next binding state free;
hardware ethernet 00:1b:54:c9:e9:fd;
uid "\001\000\033T\311\351\375";
}
lease 5.5.5.253 {
starts Wed Jul 27 11:27:56 2011
ends Wed Jul 27 23:27:56 2011
binding state active;
next binding state free;
hardware ethernet 00:1b:54:c9:e9:fd;
uid "\001\000\033T\311\351\375";
}



should give

lease 5.5.5.252 {
starts Wed Jul 27 11:23:32 2011
ends Wed Jul 27 23:23:32 2011
binding state active;
next binding state free;
hardware ethernet 00:25:90:0a:95:e1;
uid "\001\000%\220\012\225\341";
}

lease 5.5.5.253 {
starts Wed Jul 27 11:27:56 2011
ends Wed Jul 27 23:27:56 2011
binding state active;
next binding state free;
hardware ethernet 00:1b:54:c9:e9:fd;
uid "\001\000\033T\311\351\375";
}

as the output. Please help

---------- Post updated at 08:05 AM ---------- Previous update was at 08:02 AM ----------

The most recent entry is always the last occurence. I tried an earlier post on this forum but was not able to change it to suite my requirements. Any help is sincerely appreciated
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove duplicate

i have a text its contain many record, but its written in one line, i want to remove from that line the duplicate record, not record have fixed width ex: width = 4 inputfile test.txt =abc cdf abc abc cdf fgh fgh abc abc i want the outputfile =abc cdf fgh only those records can any one help... (4 Replies)
Discussion started by: kazanoova2
4 Replies

2. Shell Programming and Scripting

Need to delete duplicate lease entry

Hi *, I need to delete duplicate lease entries in file according to MAC/IP. I'm having tempfile which contains many lease info and need to have one entry for each IP(not more than that), if it contains more than one entry for same set, need to be deleted that entry... EX: lease... (4 Replies)
Discussion started by: SMNK
4 Replies

3. UNIX for Advanced & Expert Users

DHCP lease under SuSE is not working. Why?

Hi, I got a strange issue here: We are using ISC DHCP v4 which is default in Open SuSE 11.4. These two options 'default-lease-time' and 'max-lease-time' are set in all subnets, with values between 43200 (12 hours) to 518400 (144 hours). See partial dhcpd.conf below please. Now the lease time... (0 Replies)
Discussion started by: aixlover
0 Replies

4. IP Networking

DHCP lease under SuSE is not working., limited at 10 minutes

Hi, I got a strange issue here: We are using ISC DHCP v4 which is default in Open SuSE 11.4. These two options 'default-lease-time' and 'max-lease-time' are set in all subnets, with values between 43200 (12 hours) to 518400 (144 hours). See partial dhcpd.conf below please. Now the lease... (5 Replies)
Discussion started by: aixlover
5 Replies

5. Red Hat

DHCP lease problem

Hi frnds I am testing DHCP server on vmware.I have two REDHAT 9 vmware machine.DHCP is installed on one machine and second machine is using as a client .I have configured DHCP with Ip Address ,Mask and Gateway.But client machine is not getting ip address.When i type ifconfig command on client it... (6 Replies)
Discussion started by: Vaibhav.T
6 Replies

6. Shell Programming and Scripting

Request to check:remove entries with duplicate numbers in first row

Hi I have a file 1 xyz 456 1 xyz 456 1 xyz 456 2 abc 8459 3 gfd 657 4 ghf 658 4 ghf 658 I want the output 1 xyz 456 2 abc 8459 3 gfd 657 4 ghf 658 (3 Replies)
Discussion started by: manigrover
3 Replies

7. Solaris

Solaris 10- DHCP lease time increase

HI Admins, can anyone tell me how can I increase the lease time in Solaris 10. I want to use that dhcp address for 4 weeks. (2 Replies)
Discussion started by: snchaudhari2
2 Replies

8. Shell Programming and Scripting

Remove duplicate entries from the same line

Hello, I have a file which have several duplicate entries on the same line: File ID source 1 GM GF GM 2 GM GF GM GF GM GF GM GF GM GF 3 GM GF GM SF GM GF GM SF 4 FF FF FF FF 5 FF GM FF ... (2 Replies)
Discussion started by: nans
2 Replies

9. Shell Programming and Scripting

Remove duplicate entries based on the range

I have file like this: chr start end chr15 99874874 99875874 chr15 99875173 99876173 aa1 chr15 99874923 99875923 chr15 99875173 99876173 aa1 chr15 99874962 99875962 chr15 99875173 99876173 aa1 chr1 ... (7 Replies)
Discussion started by: raj_k
7 Replies

10. Shell Programming and Scripting

Remove columns with duplicate entries

I have a 13gb file. It has the following columns: The 3rd column is basically correlation values. I want to delete those rows which are repeated between the columns: A B 0.04 B C 0.56 B B 1 A A 1 C D 1 C C 1 Desired Output: (preferably in a .csv format A,B,0.04 B,C,0.56 C,D,1... (3 Replies)
Discussion started by: Sanchari
3 Replies
omshell(1)						      General Commands Manual							omshell(1)

NAME
omshell - OMAPI Command Shell SYNOPSIS
omshell DESCRIPTION
The OMAPI Command Shell, omshell, provides an interactive way to connect to, query, and possibly change, the ISC DHCP Server's state via OMAPI, the Object Management API. By using OMAPI and omshell, you do not have to stop, make changes, and then restart the DHCP server, but can make the changes while the server is running. Omshell provides a way of accessing OMAPI. OMAPI is simply a communications mechanism that allows you to manipulate objects. In order to actually use omshell, you must understand what objects are available and how to use them. Documentation for OMAPI objects can be found in the documentation for the server that pro- vides them - for example, in the dhcpd(1) manual page and the dhclient(1) manual page. CONTRIBUTIONS
This software is free software. At various times its development has been underwritten by various organizations, including the ISC and Vixie Enterprises. The development of 3.0 has been funded almost entirely by Nominum, Inc. At this point development is being shepherded by Ted Lemon, and hosted by the ISC, but the future of this project depends on you. If you have features you want, please consider implementing them. LOCAL AND REMOTE OBJECTS
Throughout this document, there are references to local and remote objects. Local objects are ones created in omshell with the new com- mand. Remote objects are ones on the server: leases, hosts, and groups that the DHCP server knows about. Local and remote objects are associated together to enable viewing and modification of object attributes. Also, new remote objects can be created to match local objects. OPENING A CONNECTION
omshell is started from the command line. Once omshell is started, there are several commands that can be issued: server address where address is the IP address of the DHCP server to connect to. If this is not specified, the default server is 127.0.0.1 (local- host). port number where number is the port that OMAPI listens on. By default, this is 7911. key name secret This specifies the TSIG key to use to authenticate the OMAPI transactions. name is the name of a key defined in dhcpd.conf with the omapi-key statement. The secret is the secret key generated from dnssec-keygen or another key generation program. connect This starts the OMAPI connection to the server as specified by the server statement. CREATING LOCAL OBJECTS
Any object defined in OMAPI can be created, queried, and/or modified. The object types available to OMAPI are defined in dhcpd(8) and dhclient(8). When using omshell, objects are first defined locally, manipulated as desired, and then associated with an object on the server. Only one object can be manipulated at a time. To create a local object, use new object-type object-type is one of group, host, or lease. At this point, you now have an object that you can set properties on. For example, if a new lease object was created with new lease, any of a lease's attributes can be set as follows: set attribute-name = value Attribute names are defined in dhcpd(8) and dhclient(8). Values should be quoted if they are strings. So, to set a lease's IP address, you would do the following: set ip-address = 192.168.4.50 ASSOCIATING LOCAL AND REMOTE OBJECTS
At this point, you can query the server for information about this lease, by open Now, the local lease object you created and set the IP address for is associated with the corresponding lease object on the DHCP server. All of the lease attributes from the DHCP server are now also the attributes on the local object, and will be shown in omshell. VIEWING A REMOTE OBJECT
To query a lease of address 192.168.4.50, and find out its attributes, after connecting to the server, take the following steps: new lease This creates a new local lease object. set ip-address = 192.168.4.50 This sets the local object's IP address to be 192.168.4.50 open Now, if a lease with that IP address exists, you will see all the information the DHCP server has about that particular lease. Any data that isn't readily printable text will show up in colon-separated hexadecimal values. In this example, output back from the server for the entire transaction might look like this: > new "lease" obj: lease > set ip-address = 192.168.4.50 obj: lease ip-address = c0:a8:04:32 > open obj: lease ip-address = c0:a8:04:32 state = 00:00:00:02 dhcp-client-identifier = 01:00:10:a4:b2:36:2c client-hostname = "wendelina" subnet = 00:00:00:06 pool = 00:00:00:07 hardware-address = 00:10:a4:b2:36:2c hardware-type = 00:00:00:01 ends = dc:d9:0d:3b starts = 5c:9f:04:3b tstp = 00:00:00:00 tsfp = 00:00:00:00 cltt = 00:00:00:00 As you can see here, the IP address is represented in hexadecimal, as are the starting and ending times of the lease. MODIFYING A REMOTE OBJECT
Attributes of remote objects are updated by using the set command as before, and then issuing an update command. The set command sets the attributes on the current local object, and the update command pushes those changes out to the server. Continuing with the previous example, if a set client-hostname = "something-else" was issued, followed by an update command, the output would look about like this: > set client-hostname = "something-else" obj: lease ip-address = c0:a8:04:32 state = 00:00:00:02 dhcp-client-identifier = 01:00:10:a4:b2:36:2c client-hostname = "something-else" subnet = 00:00:00:06 pool = 00:00:00:07 hardware-address = 00:10:a4:b2:36:2c hardware-type = 00:00:00:01 ends = dc:d9:0d:3b starts = 5c:9f:04:3b tstp = 00:00:00:00 tsfp = 00:00:00:00 cltt = 00:00:00:00 > update obj: lease ip-address = c0:a8:04:32 state = 00:00:00:02 dhcp-client-identifier = 01:00:10:a4:b2:36:2c client-hostname = "something-else" subnet = 00:00:00:06 pool = 00:00:00:07 hardware-address = 00:10:a4:b2:36:2c hardware-type = 00:00:00:01 ends = dc:d9:0d:3b starts = 5c:9f:04:3b tstp = 00:00:00:00 tsfp = 00:00:00:00 cltt = 00:00:00:00 NEW REMOTE OBJECTS
New remote objects are created much in the same way that existing server objects are modified. Create a local object using new, set the attributes as you'd wish them to be, and then create the remote object with the same properties by using create Now a new object exists on the DHCP server which matches the properties that you gave your local object. Objects created via OMAPI are saved into the dhcpd.leases file. For example, if a new host with the IP address of 192.168.4.40 needs to be created it would be done as follows: > new host obj: host > set name = "some-host" obj: host name = "some-host" > set hardware-address = 00:80:c7:84:b1:94 obj: host name = "some-host" hardware-address = 00:80:c7:84:b1:94 > set hardware-type = 1 obj: host name = "some-host" hardware-address = 00:80:c7:84:b1:94 hardware-type = 1 > set ip-address = 192.168.4.40 obj: host name = "some-host" hardware-address = 00:80:c7:84:b1:94 hardware-type = 1 ip-address = c0:a8:04:28 > create obj: host name = "some-host" hardware-address = 00:80:c7:84:b1:94 hardware-type = 00:00:00:01 ip-address = c0:a8:04:28 > Your dhcpd.leases file would then have an entry like this in it: host some-host { dynamic; hardware ethernet 00:80:c7:84:b1:94; fixed-address 192.168.4.40; } The dynamic; line is to denote that this host entry did not come from dhcpd.conf, but was created dynamically via OMAPI. RESETTING ATTRIBUTES
If you want to remove an attribute from an object, you can do this with the unset command. Once you have unset an attribute, you must use the update command to update the remote object. So, if the host "some-host" from the previous example will not have a static IP address anymore, the commands in omshell would look like this: obj: host name = "some-host" hardware-address = 00:80:c7:84:b1:94 hardware-type = 00:00:00:01 ip-address = c0:a8:04:28 > unset ip-address obj: host name = "some-host" hardware-address = 00:80:c7:84:b1:94 hardware-type = 00:00:00:01 ip-address = <null> > REFRESHING OBJECTS
A local object may be refreshed with the current remote object properties using the refresh command. This is useful for object that change periodically, like leases, to see if they have been updated. This isn't particularly useful for hosts. DELETING OBJECTS
Any remote object that can be created can also be destroyed. This is done by creating a new local object, setting attributes, associating the local and remote object using open, and then using the remove command. If the host "some-host" from before was created in error, this could be corrected as follows: obj: host name = "some-host" hardware-address = 00:80:c7:84:b1:94 hardware-type = 00:00:00:01 ip-address = c0:a8:04:28 > remove obj: <null> > HELP
The help command will print out all of the commands available in omshell, with some syntax pointers. SEE ALSO
dhcpctl(3), omapi(3), dhcpd(8), dhclient(8), dhcpd.conf(5), dhclient.conf(5). AUTHOR
omshell was written by Ted Lemon of Nominum, Inc. Information about Nominum can be found at http://www.nominum.com. This preliminary doc- umentation was written by Wendy Verschoor of Nominum, Inc., while she was testing omshell. omshell(1)
All times are GMT -4. The time now is 08:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy