DHCP dynamic lease export

RouterOS General
1

Hi,

I have been trying to export dynamic lease without any sucess.

Here is what I have tried:
[admin@big-tower-164-1] ip dhcp-server lease> export

jan/01/2000 06:19:35 by RouterOS 2.9.34

software id = xxxxxxx

/ ip dhcp-server lease
add address=10.1.181.191 mac-address=00:13:10:64:E4:3D client-id="1:0:13:10:64:e4:3d" server=dhcp6 comment="Janis Wimberley #7750" disabled=no
add address=10.1.181.188 mac-address=00:18:39:5C:EE:E5 client-id="1:0:18:39:5c:ee:e5" server=dhcp6 comment="Nicole Duarte #7768" disabled=no
add address=10.1.165.101 mac-address=00:0D:0B:FB:5A:CC client-id="1:0:d:b:fb:5a:cc" server=dhcp3 always-broadcast=yes comment="David Watson AO
design" disabled=no
[admin@big-tower-164-1] ip dhcp-server lease>

I tried this :


[admin@big-tower-164-1] ip dhcp-server lease> export from=0,100
item number too large
[admin@big-tower-164-1] ip dhcp-server lease>

Can somebody please help how we can transfer the lease from old router to new.

back up and restore gets all the leases. Only problem is when we to restore it looses all the ether info, and one has to go manually and assign all ip to correct interface.

We can't make static and transfer.

Since backup is able to get the lease there has to be a way to get dynamic lease

I tried doing print. can the values store by print can be imported ?

Tushar

2

make them static, then export. it’s nonsense - export something dynamic… dynamic means ‘created on the fly, not in config’ =)

3

Good point. But when you do backup on the router it does take all the dynamic lease too. Since the back up script is able to take the dynamic enery there has to be a way to collect those dynamic enetry.

4

yep, you may backup dynamic leases (moreover, dynamic leases are saved after normal reboot). but you cannot create them - so import is only via backup restore, not CLI

p.s. why do you need to restore dynamic leases? O_o

5

The reason we wanted to restore dynamic leases is, when we change router we want to keep the down time minimum and not have ip conflict too.
so If I back up and restore, restore does not put correct ip address on corrrect interface. so one has to go on CLI and configuer all the ports and DHCP server etc. In our case we have 9 port router and each port doing it own DHCP. So total of 8 DHCP server and on each port we have about 50 leases.

Oh well we will have to do it.

6

but DHCP server checks, whether that IP is busy, and will not lease used IPs

7

The DHCP server checks with a ping. Windows Firewall blocks pings and causes problems in this area.

When a customer requests to renew their IP they will request the same IP that the lease held on the PC has. This fact may solve your problem.

I would strongly suggest making any leases you need to stay the same static so it stays with the config. Depending on the situation I find it best to remove any ip pools from the DHCP server and use static only. This may be what you’re after.

8

just tested. one computer with firewall (no ping) and static address. second computer with dhcp active. in ROS log:

12:38:31 dhcp,error,warning,info,debug etherxxx radius: failed to assign ip yyy.yyy.yyy.yyy: already in use

second computer did not obtained that address and appropriate ‘busy’ lease in DHCP Server leases appeared

it seems like it’s ARP ping =)

9

Is there a way to export the current dhcp leases. I am trying to make a record of ip addresses that have been assigned to client devices. I have it setup on DHCP to streamline new devices, then just go back and make it static-dhcp. I would like to transfer the lease information out of the MTK and into something like notepad or excel. Thanks.

10 
/ip dhcp-server leases print detail file=leases.txt

Then copy the file off the router.
Or maybe

/ip dhcp-server export file=leaseConfiguration.txt

to get the current static configuration into an exported file.