Page 1 of 1

Webproxy log with users MAC address?

Posted: Sun Dec 08, 2013 12:12 pm
by sula
It is possible to log user web access by MAC address instead log by IP address from hotspot DHCP?

My webproxy log currently look like this:
06-12-2013 22:38:05 daemon.info MikroTik WEB_PROXY->: 10.10.63.111 cached 28959 http://platform.twitter.com/widgets/fol ... 94725.html
06-12-2013 22:38:05 daemon.info MikroTik WEB_PROXY->: 10.10.63.111 cached 261680 http://upw-prod-images.global.ssl.fastl ... hire-b.png
06-12-2013 22:38:06 daemon.info MikroTik WEB_PROXY->: 10.10.63.111 cached 252968 http://upw-prod-images.global.ssl.fastl ... do.png.png

Thanks for possible suggestions!

Re: Webproxy log with users MAC address?

Posted: Mon Dec 09, 2013 4:44 pm
by sergejs
No, proxy accounts IP addresses.
You may copy /ip arp table and get mac address for the appropriate IP address.

Re: Webproxy log with users MAC address?

Posted: Mon Dec 09, 2013 8:27 pm
by sula
Hm, ok but is there some way to do that automatically on daily basis? Export those MAC addresses.

Why I'm asking this? Here in Croatia there is some kind of law which says that if you provide public hotspot internet access (either free or billing) you are obliged to keep hotspot users records (MAC address, date/time and DNS name or IP address of website which was accessed). All that in case if someone commit some 'Internet crime' during session on hotspot. Frankly, I don't know what police can do with someones MAC address (especially in case of spoofed MAC address) but hey, they are the law.

Is there any way to achieve this?

Re: Webproxy log with users MAC address?

Posted: Tue Dec 10, 2013 3:40 pm
by sergejs
There is no option how to get mac-address visited page from RouterOS, but RouterOS can send
- a, log with IP address and visited page;
- b, arp table with all IP to MAC bindings.
You need to make few scripts on syslog server that translates IP to MAC, and then view/represent logs with MAC/visited page.

Re: Webproxy log with users MAC address?

Posted: Tue Dec 31, 2013 11:59 am
by kraker
I should possible with firewall rule like ---- time---mac address--local ip---destination ip..

Re: Webproxy log with users MAC address?

Posted: Tue Feb 02, 2016 9:48 pm
by Etza
Hm, ok but is there some way to do that automatically on daily basis? Export those MAC addresses.

Why I'm asking this? Here in Croatia there is some kind of law which says that if you provide public hotspot internet access (either free or billing) you are obliged to keep hotspot users records (MAC address, date/time and DNS name or IP address of website which was accessed). All that in case if someone commit some 'Internet crime' during session on hotspot. Frankly, I don't know what police can do with someones MAC address (especially in case of spoofed MAC address) but hey, they are the law.

Is there any way to achieve this?

hi,
do you find any solution ???