Bug 38879 - UMC-Module: Manage DHCP leases
UMC-Module: Manage DHCP leases
Status: REOPENED
Product: UCS
Classification: Unclassified
Component: UMC - DHCP
UCS 4.4
Other Linux
: P5 enhancement with 9 votes (vote)
: ---
Assigned To: UMC maintainers
:
: 35965 50223 50225 (view as bug list)
Depends on: 44125
Blocks:
  Show dependency treegraph
 
Reported: 2015-07-10 08:13 CEST by Stefan Gohmann
Modified: 2019-09-18 18:53 CEST (History)
16 users (show)

See Also:
What kind of report is it?: Feature Request
What type of bug is this?: ---
Who will be affected by this bug?: ---
How will those affected feel about the bug?: ---
User Pain:
Enterprise Customer affected?: Yes
School Customer affected?: Yes
ISV affected?:
Waiting Support:
Ticket number: 2017020321000054, 2017041021000153, 2017062721000341, 2018112821000293
Bug group (optional): External feedback, Release Goal, Usability
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Gohmann univentionstaff 2015-07-10 08:13:55 CEST
It should be possible to see in UMC which leases have been requested and given. And it should be possible to create computer objects or DHCP entries of these objects.
Comment 1 Stefan Gohmann univentionstaff 2015-09-23 12:10:09 CEST
This feature has been dropped from the UCS 4.1 roadmap.
Comment 2 Stefan Gohmann univentionstaff 2015-10-08 09:01:57 CEST
*** Bug 35965 has been marked as a duplicate of this bug. ***
Comment 3 Stephan Luft univentionstaff 2015-10-12 13:19:50 CEST
This was requested from a partner for a customer interested in UCS
Comment 4 Jens Thorp-Hansen univentionstaff 2015-12-07 14:04:47 CET
Requested here (second question): http://forum.univention.de/viewtopic.php?f=48&t=4640&p=17902
Comment 5 Daniel Tröder univentionstaff 2016-10-04 07:40:15 CEST
Requested again: http://forum.univention.de/viewtopic.php?t=3102&p=22532#p22532
Comment 6 Stefan Gohmann univentionstaff 2016-12-13 08:10:47 CET
The Enterprise Customer affected flag is set but neither a Ticket number is referenced nor a Customer ID is set. Please set a Ticket number or a Customer ID. Otherwise the Enterprise Customer affected flag will be reset.
Comment 7 Christina Scheinig univentionstaff 2017-02-03 10:36:45 CET
It would be easier to debug such problems in a customer environment. This Ticket#2017020321000054 could be solved much easier/faster.
Comment 8 Philipp Hahn univentionstaff 2017-02-03 11:35:11 CET
isc-dhcp from 4.3 will ship ~phahn/src/extern/dhcp/contrib/dhcp-lease-list.pl to parse /var/lib/dhcp/dhcpd.leases

Maybe "omshell" can be used to query the lease DB (my quick search didn't find anything useful).

The dhcpd.leases file is supposed to be fully re-written each
  34 #define LEASE_REWRITE_PERIOD 3600
seconds = 1h
Comment 9 Stephan Luft univentionstaff 2017-03-23 16:23:01 CET
wurde auf der CeBIT auf dieses Feature angesprochen, geht um einen neuen Partner, der UCS aktuell für einen Kunden evaluiert
Comment 10 Philipp Hahn univentionstaff 2017-03-29 16:21:48 CEST
(In reply to Philipp Hahn from comment #8)
> isc-dhcp from 4.3 will ship
> ~phahn/src/extern/dhcp/contrib/dhcp-lease-list.pl to parse
> /var/lib/dhcp/dhcpd.leases

It's included with isc-dhcp-server_4.3.1-6+deb8u2A~4.2.0.201703161319, but broken due to Bug #44125 (includes patch)

Please note that static leases are not tracked in /var/lib/dhcp/dhcpd.leases.
There is a thing called "RESERVED LEASES" (man 5 dhcpd.conf): <https://lists.isc.org/pipermail/dhcp-users/2009-July/009875.html>

> Maybe "omshell" can be used to query the lease DB (my quick search didn't
> find anything useful).

Please note that this might be complicated further when multiple dhcp servers are used, as each one has a separate lease database.
Comment 11 Jens Thorp-Hansen univentionstaff 2017-07-03 13:07:19 CEST
requested again (see ticketlist)
Comment 12 Thomas Stather 2017-07-03 13:14:39 CEST
I also requested this for our environment as it would be really useful (Ticket #2017062721000341)
Comment 13 Thomas Stather 2017-07-03 13:15:30 CEST
In case its a duplicate, please ignore (cannot delete/modify any comments) :(
Comment 14 Christian Völker univentionstaff 2018-03-09 07:56:56 CET
And again:
https://help.univention.com/t/dhcp-leases-in-der-umc-anzeigen/2430/18

"[...]jeder dumme Router für Endkunden kann das.[...]"
Comment 15 B. Vogel 2018-07-07 14:10:15 CEST
Instead of "me too" or "+1" comments, please vote for this issue.
Comment 16 Stefan Gohmann univentionstaff 2019-01-03 07:20:18 CET
This issue has been filled against UCS 4.1. The maintenance with bug and security fixes for UCS 4.1 has ended on 5st of April 2018.

Customers still on UCS 4.1 are encouraged to update to UCS 4.3. Please contact
your partner or Univention for any questions.

If this issue still occurs in newer UCS versions, please use "Clone this bug" or simply reopen the issue. In this case please provide detailed information on how this issue is affecting you.
Comment 17 Valentin Heidelberger univentionstaff 2019-01-03 14:07:36 CET
This feature does not exist yet
Comment 18 Philipp Hahn univentionstaff 2019-09-18 18:50:53 CEST
*** Bug 50223 has been marked as a duplicate of this bug. ***
Comment 19 Philipp Hahn univentionstaff 2019-09-18 18:53:04 CEST
*** Bug 50225 has been marked as a duplicate of this bug. ***