Community discussions

MikroTik App
 
ejansson
Member
Member
Topic Author
Posts: 300
Joined: Fri Oct 21, 2005 4:09 pm
Location: Manitoba, Canada

Tracking DHCP users/addresses

Sat Nov 03, 2007 5:06 pm

We have a growing MT wireless network and need to identify what customer has a particular address given out by our dhcp server. What is the best and fastest way to do this?

Thanks
 
EulerTourist1969
just joined
Posts: 7
Joined: Wed Oct 31, 2007 3:34 am
Location: Sydney
Contact:

Re: Tracking DHCP users/addresses

Mon Nov 05, 2007 12:47 am

I build a spreadsheet/DB of Radio MAC addresses before the install. I put output from the GPS into "radio name" also.
However, you can view IP leases via: "ip dhcp-server lease> print"

HInt: Get alerted to rogue DHCP servers via: "ip dhcp-server alert>/log print"

GPS:
[admin@MikroTik] system gps> monitor
date-and-time: jul/23/2003 12:25:00
longitude: "E 24 8' 17''"
latitude: "N 56 59' 22''"
altitude: "-127.406400m"
speed: "0.001600 km/h" <-- a bit fast for my liking
valid: yes
 
ejansson
Member
Member
Topic Author
Posts: 300
Joined: Fri Oct 21, 2005 4:09 pm
Location: Manitoba, Canada

Re: Tracking DHCP users/addresses

Mon Nov 05, 2007 6:08 pm

The issue is with the customers PC not the radios. I too have a list of customer address and use fixed address for our equipment. Our customers receive a public address for their computers and we use private blocks for our equipment. As we can't track the customer MAC I was hoping there was a way to see what ap and cpe were passing the ip/mac.

Erik
 
EulerTourist1969
just joined
Posts: 7
Joined: Wed Oct 31, 2007 3:34 am
Location: Sydney
Contact:

Re: Tracking DHCP users/addresses

Tue Nov 06, 2007 12:57 am

So, "ip dhcp-server lease> print" won't do it?
Let me understand... my brain only has 4MB of RAM... you have a pool of public addresses you want to issue to customer's hosts. You're using a private address group (172.16/12 or 192.168/16) for infrastructure down to the CPE. You want to know what addresses were issued to hosts and what CPE they sit under?
 
User avatar
tgrand
Long time Member
Long time Member
Posts: 667
Joined: Mon Aug 21, 2006 2:57 am
Location: Winnipeg, Manitoba, Canada

Re: Tracking DHCP users/addresses

Tue Nov 06, 2007 2:37 pm

EulerTourist1969,

You through some dandy clues in that one......
 
ejansson
Member
Member
Topic Author
Posts: 300
Joined: Fri Oct 21, 2005 4:09 pm
Location: Manitoba, Canada

Re: Tracking DHCP users/addresses

Tue Nov 06, 2007 5:39 pm

Right ... cpe's etc have 172.16.x.x and we have a public pool for customer pc's/equipment that is attached to the network. Simple enough to know what as been used in the pool, many things can be monitored and controlled through the radio, but their seems to be no simple way to match up the customer with the used address in the pool.


Erik
 
EulerTourist1969
just joined
Posts: 7
Joined: Wed Oct 31, 2007 3:34 am
Location: Sydney
Contact:

Re: Tracking DHCP users/addresses

Wed Nov 07, 2007 2:52 am

Erik;
I'm thinking "Heirarchical Addressing" but I've not done any work with this. The IP Pool get's smaller the further you go down the tree but the complete tree represents the complete pool, no overlap. (search "CIDR") Then each AP does DHCP Relay from the master DHCP server. ...I'm getting out of my depth here.
I'm curious though: normally a customer would have only one public IP natted to a private set internally. Why do you want public IP to each host, isn't that the motivation for NAT?

tgrand;
dandy clues??

ET'69
 
User avatar
znet
Member Candidate
Member Candidate
Posts: 131
Joined: Mon Jul 24, 2006 8:07 pm
Location: Houston, Texas

Re: Tracking DHCP users/addresses

Thu Nov 08, 2007 7:27 pm

Seems like the boat passed this dock already.

If you DHCP the customers, isnt the customer's CPE, and therefore MAC, being issued a public IP? That would give you exactly what you are asking for right in the DHCP leases table. IMHO, it is in your interest to make those new leases static, so you can maintain consistency. I add a comment with pertinent customer info like account number, name, phone#, etc.

Then all you have to do is keep track of your equipment. If for some reason you cant do that method, does your CPE provide you with an arp or bridge table? If it does, eventually you will compile a complete list of MACs and IPs.

Dont know if this helps, but have only too much experience with this problem, and this method has made things simple....
 
User avatar
marlow
Member Candidate
Member Candidate
Posts: 159
Joined: Thu Mar 16, 2006 6:59 pm
Location: Ireland

Re: Tracking DHCP users/addresses

Thu Nov 08, 2007 7:48 pm

If the CPE is in bridge mode, the client get's IP's directly of the base-station.

Hotspot could be one way of identifying and limiting customers: http://forum.mikrotik.com/viewtopic.php?f=7&t=19727. You could even combine it with a central radios server, which then will tell you, what CPE MAC-address got assigned what ip's from hotspot.

For the non-public ip's used by the CPE, create that pool as a backup-pool to the public address pool and give each CPE a fixed lease in the DHCP-server.

/Martin