Duplicate DHCP Leases?



  • When attempting to reserve an IP in DHCP, I found that doing it from the Status / DHCP Leases menu enforces rules where the status lease has to be outside of the DHCP Scope.  On the other hand if I go to Services / DHCP Server / InterfaceName scroll down to the bottom hit add and add a Static mapping from there they work fine and I can delete them and it's not a problem.

    Here's my issue, I have three leases that I was able to create from Services / DHCP Server / InterfaceName but they have duplicates that I had attempted to create from the Status / DHCP Leases menu.

    Anyone run into this or seen it?

    ![DHCP Leases.JPG](/public/imported_attachments/1/DHCP Leases.JPG)
    ![DHCP Leases.JPG_thumb](/public/imported_attachments/1/DHCP Leases.JPG_thumb)


  • Banned

    You realize how absolutely useless is the censored screenshot, right?



  • What I was showing was there was no delete option for those entries the MAC address or host name is not necessary to see that. Try it from your installation the way I described and see what happens.


  • Banned

    For static entries, you delete them where you created them (DHCP Server). Not in Status / DHCP Leases.



  • The issue with that is those three entries I didn't create from (DHCP Server), I created them from Status / DHCP Leases.  So how do you create entries created from there?  Take any lease you want, hit the + blue + with the white background, and then try to create a static entry that is inside of your scope.  It will tell you it can't do that.  Even though you could from the DHCP server tab.  So if you try and let it create a reservation by using an IP from the pool aka leaving the IP blank and just filling in the host name and the MAC address it'll add a blank entry.  I haven't been able to delete that entry though.



  • Here's a few more screen captures. . . Anyone have any idea's how to remove DHCP reservations that were created from the DHCP - Status page versus the Services - DHCP page?

    ![Services - DHCP.JPG](/public/imported_attachments/1/Services - DHCP.JPG)
    ![Services - DHCP.JPG_thumb](/public/imported_attachments/1/Services - DHCP.JPG_thumb)
    ![DHCP Leases.JPG](/public/imported_attachments/1/DHCP Leases.JPG)
    ![DHCP Leases.JPG_thumb](/public/imported_attachments/1/DHCP Leases.JPG_thumb)


  • Banned

    Yay for more censored screenshots. Dude, you've already been told that this makes diagnosing your issue impossible.



  • Doktornotor, if you can't help me, maybe someone else can.  There is more then enough information for anyone to be able to replicate what I'm experiencing.  If you can't see that, maybe you aren't the person to help me.


  • Banned

    @wharris623:

    There is more then enough information

    Right. The white space making it impossible to find out what's in those leases and how they are different from the ones you can delete is excellent "information".

    @wharris623:

    If you can't see that, maybe you aren't the person to help me.

    Correct. And since there's a lot of other people answering on this thread already, I'm leaving it up to them to figure out the white space mystery.

    ;D ::)  ;D ::)  ;D ::)


  • Rebel Alliance Global Moderator

    With dok on this - WTF dude.. Do you want help, or do you want to hide that the names of your shit.. Did you name them after porn stars or something and are embarrassed..

    What exactly are you asking..  How to delete the Jami-PC stuff?  Those are static – so you go to the dhcp server, bottom of page will be static.. Deleted them there..  Worse case directly edit the conf file.  See the Trashcan icon -- click that it deletes it..

    Do you have dhcp running on more than 1 interface.. Check those for the ones that don't list an IP.




  • Hey Johnpoz, what I've posted is what I'm asking about.  The rest of the names of the machines and mac addresses on the network are irrelevant to the question being asked.

    What I'm asking is how do I delete the Jami-PC and the Jim-PC that don't have an IP address next to them.  Those are not listed under DHCP Server.  The only ones listed under DHCP Server are the ones with the IP addresses.

    I do have DHCP running on 4 interfaces but those DHCP Reservatrions that do not show an IP are not found on any of those.  Please see the updated picture.

    Thanks!

    ![DHCP Leases.JPG](/public/imported_attachments/1/DHCP Leases.JPG)
    ![DHCP Leases.JPG_thumb](/public/imported_attachments/1/DHCP Leases.JPG_thumb)


  • Banned

    Use the goddamn trashcan icon. On the proper DHCP server interface. Geeeeeeez.



  • You're not listening.  Those entries don't show up on any DHCP Interface


  • Banned

    Yeah, on any out of the censored one you keep showing us. Go edit config.xml and restore it. Enough time wasted here with your censored BS.



  • If they were showing up on any interface I would show them to you.  The point is, that it is possible with pfSense 2.3.2 release p1 that you can create a DHCP Reservation Entry from the DHCP Status Menu that you cannot delete from within pfSense.  I think that's a bug.  If you are talking about deleting those entries from

    /var/dhcpd/var/db/dhcpd.leases

    and

    /var/dhcpd/var/db/dhcpd.leases~

    I'm unable to find those two entries in there.

    I can find the entries that have IP's associated to them, but I'm not trying to delete the DHCP Reservations that have IP's.  I'm trying to delete the ones that are pulling from the pool aka the IP address field is blank as is shown by the arrows in the picture on the previous post.


  • Banned

    No, I am not. I am specifically talking about deleting them from config.xml.

    
    foreach ($config['dhcpd'] as $iface => $lease) {
    	print_r($lease['staticmap']);
    }
    
    

    There are all your static leases.


  • Rebel Alliance Global Moderator

    They clearly are showing up on an interface - since I pointed out the trashcan icon in one of your posts.

    If you create a reservation and do not give it an IP.. It will pull an address from the pool. It should still be listed in the dhcp server static listing on the bottom of the dhcp server page.  Look in all your dhcp servers running, or maybe check your ipv6 dhcp server?

    If still not showing up, as dok so eloquently put it.. (Oh its great to have you back dok!!)  You were missed when you were gone!  Your posts always make my day that much better!

    Download your xml, find the offending entry and delete from the xml and then restore that section of the xml.

    edit:  Oh my gawd.. I posted a mac address and a host name.. Oh the black helicopters are going to get me for sure now ;) heheheh

    Obfuscating clearly personal information like a public IP or fqdn that could point to your public IP, ok..  If your tinfoil hat is really tight - maybe the mac of wifi AP that could be on some wifi war driving database, ok..  But hiding rfc1918 space, or fqdn of something that is local or some hostname without a domain name, etc.  This just is frustrating for the person wanting to help because they don't have a full picture.  And as quite often on this board and the many others many of us here frequent.  The piece of the puzzle that solves the issues is quite often not given by the user, or they on purpose hide it because they think it is in some way private, etc.

    Have as much of the puzzle as possible makes it easier and faster for us to help you..




  • @doktornotor:

    No, I am not. I am specifically talking about deleting them from config.xml.

    
    foreach ($config['dhcpd'] as $iface => $lease) {
    	print_r($lease['staticmap']);
    }
    
    

    There are all your static leases.

    That's the first useful suggestion you've made this entire thread! Thank you!



  • @johnpoz:

    They clearly are showing up on an interface - since I pointed out the trashcan icon in one of your posts.

    If you create a reservation and do not give it an IP.. It will pull an address from the pool. It should still be listed in the dhcp server static listing on the bottom of the dhcp server page.  Look in all your dhcp servers running, or maybe check your ipv6 dhcp server?

    If still not showing up, as dok so eloquently put it.. (Oh its great to have you back dok!!)  You were missed when you were gone!  Your posts always make my day that much better!

    Download your xml, find the offending entry and delete from the xml and then restore that section of the xml.

    Johnpoz, I totally agree!  It should show up on the DHCP Server Static listings at the bottom of the various DHCP Server pages based upon what server is running on what interface.  I did check them all thanks to your suggest but still not finding them there.  I did also check the IPV6 DHCP server but since I'm not running IPV6 it's disabled.  Can you tell me how I can point out the "bug" of being able to create a DHCP Reservation from the DHCP Status page that you cannot delete from the GUI to the proper people?

    Thanks in advance!

    Wes


  • Banned

    If all you are going to provide is white boxes, then there's no need to bother with any bugs. What you are posting here does not reproduce on any sane box.



  • I can reproduce it on two different boxes.  So I'd dare say it's a bug.  If this wasn't a public forum I'd post the uncensored screen.  Since it is, it's getting censored.  My right to do so.  If you want to do a joinme or team viewer and look for yourself I'm down.


  • Rebel Alliance Global Moderator

    I could try and reproduce your issue I guess..  So you what created a static from your lease but did not give an IP?  And then you changed your mind and created another static while giving the IP?

    If I take a lease from the leases page and try and make it a static, while leaving the IP off - it gives me an error




  • Kind of.  What I did was created a static lease without giving it an IP from the DHCP Status screen using the blue + with the white back ground.  It was at that point that I found I wasn't able to delete it.  Creating a static lease from the DHCP Server works fine.

    Thanks for listening and trying Johnpoz


  • Rebel Alliance Global Moderator

    Like my attached screenshot in the previous post.. Yeah that creates an error and does not allow you to create..

    You can only create those without an IP in the dhcp server page..  From what I can tell. Even then doesn't seem like the name can match with an active lease or it gives you an error.  But I can create one with name that is close



  • Banned

    ZOMG. That is NOT the place to look for static leases! All configuration is stored in /cf/conf/config.xml.


  • Rebel Alliance Global Moderator

    If your saying you can reproduce it, then please post your steps so we can do the same on our systems.  If so we can create a redmine for the issue.. But without a way to reproduce what your seeing.  I points to PEBKAC or some very off the wall glitch that is unique to your setup??

    Even if some off the wall sort of fluke that can cause the problem - you can always edit any dhcp reservation in the xml directly to correct such problem.  If we can reproduce your problem then the devs might be able to put in check to prevent it from happening again.  But we need to know how to reproduce it..  I tried doing it from a lease in the leases section and it would not allow me to create the lease reservation without an IP.  Only in the dhcp server section can you do that.


  • Banned

    He still did not have a look at the config.xml for sure. Since there's no way the stuff would appear in the GUI unless it is in $config['dhcpd'][$if]['staticmap']

    https://github.com/pfsense/pfsense/blob/master/src/usr/local/www/services_dhcp.php#L131
    https://github.com/pfsense/pfsense/blob/master/src/usr/local/www/services_dhcp.php#L1338



  • I can do that.  If you hit the blue + with the white background from the DHCP Status screen which is what I initially did.  I wanted to create a static mapping with the IP being within the pool provided by that DHCP server.  I noticed that when you hit the + on either of these two boxes running at separate places is that at the top it says, "Services / DHCP Server /  / Edit Static Mapping".  It doesn't list the interface that it's adding the mapping to.  You can see this in the example below of "DHCP Status - No Interfaces" that I attached.

    On the other hand if you go to Services / DHCP Server / InterfaceName it shows the Interface name at the gray bar at the top.  As shown in "Services - DHCP - Interafce is listed" that I also attached.

    So back to how to repeat my steps.

    Go to status DHCP leases, chose a victim device and use the Blue + with the white background, chose save.  Apply the changes.  At that point you will now see a DHCP Static Mapping with no IP address listed. You cannot delete it, and it doesn't show up on any of the DHCP Servers running on any interface.

    Now if I go and create DHCP Static Mappings from Services / DHCP Server / InterfaceName it works fine and I can remove them from the same screen.

    To answer doktornotor's post, yes I looked in the config.xml and yes I can remove them from there, but it occurs to me that if you can add it from the GUI you should be able to remove it from the GUI.

    ![DHCP Status - No Interface.JPG](/public/imported_attachments/1/DHCP Status - No Interface.JPG)
    ![DHCP Status - No Interface.JPG_thumb](/public/imported_attachments/1/DHCP Status - No Interface.JPG_thumb)
    ![Services - DHCP - Interface is listed.JPG](/public/imported_attachments/1/Services - DHCP - Interface is listed.JPG)
    ![Services - DHCP - Interface is listed.JPG_thumb](/public/imported_attachments/1/Services - DHCP - Interface is listed.JPG_thumb)


  • Banned

    Screenshots censored to a new level!!! Lookie, now there's NOTHING shown, just the GUI menu and breadcrumbs. Are you dude kidding us? No idea what are you trying to illustrate, and as already noted above, noone can reproduce your problem. It either does not let you create the lease (presumably <=2.3.2), or redirects you to the DHCP server GUI and lets you create AND delete whatever you want, incl. a static lease with no IP specified (2.3.3+).



  • @doktornotor

    I'm showing you what I'm talking about.  No reason to show the entire screen if it's not relevant to the conversation.  If you aren't going to be helpful could you please go troll somewhere else?

    Anyone have any suggestions as to how to get a moderator involved here?  Besides hitting the report to moderator button?


  • Banned

    You are so paranoid that you are even censoring the interface names. Need more tinfoil? Could supply some, delivery guaranteed before Xmas.

    Dude, you have been confusing everyone with your censored, edited, whitespaced, photoshopped screens! Get PAID support if you do not wish to provide reasonable information on a PUBLIC forum.



  • @doktornotor I'm done responding to you.  You're not helpful, you're down right abusive.

    Huge props to JohnPoz for taking the time and listening and trying to help me.

    Thanks Johnpoz!


  • Banned

    So where the heck did your interface names go? The screenshots do not look like what you've shown on any normal system. There's interface name in the breadcrumbs. And interface name in the header below. What help you expect when  you actively sabotage providing even the absolutely basic info?



  • Rebel Alliance Global Moderator

    dude showing us dhcp edit static mappings menu list is not really showing us anything.. Can you show us the lease your clicking the add static button on.  So I deleted the existing lease I had with that same name for my other phone (just got a new one) Yes if I click into an existing lease to create a static it takes me me to the create static page - but you will notice its lists the dhcp server/interface that IP is in.. So my wlan is 192.168.2.0/24

    So when I create the lease to create a reservation off the leases page, it takes me to that dhcp server edit static pages.  So I then create the lease without giving an IP and it lists it there in the static leases for that dhcp server..  It will then not let me create another static lease with an IP for that same name.. Because a lease already exists with that name.

    Your screenshot is not showing you what interface your on???  So is this lease your trying to create the static from a dhcp server that your no longer running??  See my screenshots when I click to add static lease from the dhcp leases page it takes me to the dhcp server that IP belongs too.

    If I had to guess, you had an OLD lease that was for a dhcp server that was removed or disabled?  Not sure I would call that a bug??

    I would suggest you delete any old leases from dhcp servers that no longer on your system.  And the try and duplicate.. Your saying when you click a lease that is within a dhcp pool of your dhcp servers it takes you to a create static page that does not list your dhcp server??  See the highlighted sections of my pics

    BTW: Dok is a one of the good guys.. He is very helpful and very very knowledgeable not only with pfsense related but pretty much all things IT related.. His post can sometimes come off a bit gruff for those that have not been reading his posts for a long time ;)  But I love is fun loving easy going demeanor.. And while he was on a break from this board, he was for sure missed by many of us here.  And I for one am very glad he is back, and true to form posting in his straight to the point no holds bar blunt honest opinions that make it so refreshing than most of the drivel and pansy nonsense you read elsewhere. Most likely was tired of having to pull teeth for info, and tired of obfuscated nonsense like hiding a mac, or a rfc1918 address or a hostname when dealing directly with that sort of info ;)  I would take his posts to heart, read them in the fun loving way he intends and you will for sure come away with loads of valuable info!!





  • Banned

    This (Diagnostics => Command Prompt) provides a pretty readable overview of what's configured where

    
    foreach ($config['dhcpd'] as $iface => $leases) {
    	$ifname = convert_real_interface_to_friendly_interface_name($iface);
    	$ifname = convert_friendly_interface_to_friendly_descr($ifname);
       	echo "Static leases on $ifname ($iface):\n";
    	print_r($leases['staticmap']);
    }
    
    

    however since all this information is top secret classified stuff, we won't ever get the output anyway…


  • Rebel Alliance Global Moderator

    That is pretty slick dok!  And would be very informative to see that output.. But like you said its all top secret.. The black helicopters are most likely circling our houses now for even seeing the redacted output he did post ;) heheeh



  • After going back and looking at my upload, I captured the same screen shot twice and for that I apologize.  Please look at these two unedited screen captures.

    As for Dok, you can be the smartest guy on the planet but if you can't interface with people you aren't going to get anywhere.  Especially when you are trying to help.  I work in the customer support industry as do most of us on this forum I'm sure.  I have peers who can't relate nor talk to customers and then I have those peers who can.  Those who can communicate and discuss issues with customers/client get higher marks and survey results and are much more respected by their clients and management then those who can't.

    Not trying to slam you but just making an observation.  You can catch more flys with honey then you do with vinegar.

    ![Status - DHCP Server (Missing Interface).JPG](/public/imported_attachments/1/Status - DHCP Server (Missing Interface).JPG)
    ![Status - DHCP Server (Missing Interface).JPG_thumb](/public/imported_attachments/1/Status - DHCP Server (Missing Interface).JPG_thumb)
    ![Services - DHCP - Interface is listed.JPG](/public/imported_attachments/1/Services - DHCP - Interface is listed.JPG)
    ![Services - DHCP - Interface is listed.JPG_thumb](/public/imported_attachments/1/Services - DHCP - Interface is listed.JPG_thumb)


  • Banned

    What's up with that VLAN1_DBM_PC? It's not assigned, or what?



  • It is assigned.  What I was attempting to point out was the blank interface at the top.


  • Rebel Alliance Global Moderator

    Ok that is weird, how come its not showing the interface its on in the top menu?

    Don't you DARE try to change dok's style!!  I agree many of here most likely work in the tech sector and have to put up with customers.. And have to play all nicey nice, etc.  When most of the time you just want to scream through the phone listen up you F'ing Moron.. I can not make it any more clear.. Did you finish 3rd grade? ;)

    The nice thing about public forums - is you don't have to pretend your talking to a 13 year old girl on her first period.  You can be straight and to the point, and hopefully the other person is another techy person and gets it, etc..

    I find Dok's posts refreshing and fun to read, you can only slap so much perfume on a pile of shit.. Its still going to be a pile of shit.. So its nice to communicate and exchange information without all the freaking honey and perfume stinking up the place.  If its shit, then its shit - but atleast you know what your dealing with ;)