Hello,
I'm thinking about to setup internet sharing using mikrotik hotspot, and allow login using pppoe.
I will setup my router using these instructions: http://www.youtube.com/watch?v=rBDJ24VQfQw

But how I can track user activity? For example, how I can log visited sites and accessed ip addresses? User may perform something illegal or not allowed I want to know that (or I will need to show these logs to police)...
I know that this can be done with transparent proxy (squid), but I need something better. Any idea?

Some kind of session logging is needed for you. Out of box I haven't found a way of doing it, but I am interested in that kind of functionality too.

Install proxy server on routerboard, no caching. Then use system logging to create a remote log rule using syslog

Install syslog on remote server with mysql logging and job done. Will require lots of disk space

If you somehow manage to achieve what you want, you're probably going to end up with very large log file at the end of the first day. Depends on the number of users though. And you need to keep logs for some time I suppose..
Also seems like you need to track everything, not only http?
And remember that not all the requests are user requested, there are lots of stuff going behind the curtains: updates, status checks, anonymous reports, etc.

IMHO, the best way is to hand out every user with unique public IP and keep logging who is getting wich. That way if one of your users are performing some illegal activity, his ip addr will be logged, and you'll know who to give away. You'll need a public subnet for that of course..

Consider using ntop and traffic flow.

http://www.ntop.org/
http://www.mikrotik.com/testdocs/ros/2. ... c-flow.php

I don't know did I miss something, but this with traffic flow isn't best solution. With this I can track what's going on on entire interface but I can track user activity.

If you use RADIUS or static IP addresses for users, then you can track users as well.

Hi,
please give me tutorial how to do this, or some documentation or at leasts basic steps that I need to do.

I made several attempts to do this with several applications but nothing

use LAN Spy Monitor, it can be helpful http://www.qqmonitor.com/lan-spy-monitor.htm

http://forum.mikrotik.com/viewtopic.php?f=2&t=72139

use it and don't forget add karma :=))...

Hi. i think may be this link will be helpful for everyone:

http://www.wifitech.com.pk/create-user- ... -activity/

This is very useful link which we people are looking for, provided by Mikrotik. but unfortunately Mikrotik discontinued providing support for this feature

http://wiki.mikrotik.com/wiki/Proxylizer

Hi. i think may be this link will be helpful for everyone:

http://www.wifitech.com.pk/create-user- ... -activity/

This trick is not working anymore, tried with version 5.2

This is very useful link which we people are looking for, provided by Mikrotik. but unfortunately Mikrotik discontinued providing support for this feature

http://wiki.mikrotik.com/wiki/Proxylizer

This is also not working anymore, seems mikrotik ended proxylizer , download links are not found.

any other way to track user actvity?