Need help creating a script based on log event.

RouterOS Scripting
1

Hi there,
I’ve found an issue with my hotspot system which seems to occur under the following condition:
User logged in > router restarts > User unable to visit any page, including hotspot page.
User is unable to ping any site or the router (ip or DNS).


So I’ve found the issues which this appears in the logs:

hotspot,debug hotspot1: failed to add dynamic host 00:08:A1:93:0D:6C/10.5.50.253, ip 10.5.50.253: to-address is already used.

On that above event I need to do the following inorder to get the user’s pc working:

system,info hotspot ip binding rule removed by Admin
dhcp,info Hotspot-DHCP deassigned 10.5.50.253 from 00:08:A1:93:0D:6C
system,info dhcp lease removed by Admin

Can anyone think of away of doing this

2

I would try to figure out why the hotspot is trying to issue an address that is already assigned. Please post
/ip dhcp-server lease
/ip hotspot ip-binding
/ip hotspot host

3

Hi

Its not issues addresses that its done already - its simply creating a mis-match if the client (hotspot user) does not refresh their ip. And once this cycle starts, it doesn’t stop.

/ip dhcp-server lease> print
Flags: X - disabled, R - radius, D - dynamic, B - blocked 
 #   ADDRESS                MAC-ADDRESS       HOST... SERVER     RATE... STATUS 
 0 D 10.5.50.253            00:08:A1:93:0D:6C IBM1-PC Hotspot...         bound  

/ip hotspot ip-binding> print
Flags: X - disabled, P - bypassed, B - blocked 
 #   MAC-ADDRESS       ADDRESS                         TO-ADDRESS      SERVER   

/ip hotspot host> print
Flags: S - static, H - DHCP, D - dynamic, A - authorized, P - bypassed 
 #    MAC-ADDRESS       ADDRESS         TO-ADDRESS      SERVER      IDLE-TIMEOUT
 0 H  00:08:A1:93:0D:6C 10.5.50.253     10.5.50.253     hotspot1    20m
4

I tried your situation, and I cannot create that log message, or the connection problem. How do your clients connect to the router? Do they have CPE equipment, or connected directly to the router? Wired or wireless?

5

Hiya,

They are clients plugged directly into the router.

Simply log the client (running windows 7) in to the hotspot and then restart the router. The client will keep the ip address and the router should product that message.

6

It must be related to Windows 7. I tried WinXP, Linux, and my Blackberry. I can’t reproduce it. Maybe someone else that uses Windows 7 can add something here.

7

I’d be really interested to find out if you found your problem, bigguns. I’m having the same problem on one section of my wireless network.
i.e. failed to add dynamic host 00:27:22:08:0C:D8/172.23.0.82, ip 172.23.0.82: to-address is already used.

Network layout is like this:

MT Hotspot (433AH v4.6) >> RB532 (v4.5) >> Ubiquiti Station + Ubiquiti AP >> Client

It doesn’t matter if the client is a laptop, phone or ubiquiti device, the error will occur at least once a day and to anyone connected to the Ubiquiti AP.
The other strange thing, is that the MAC address of the Ubiquiti station (00:27:22:08:0C:D8) appears in hotspot hosts as the MAC of the client, but in DHCP leases the Active MAC Address is the actual MAC address of the client.