Hello. I’m a newbie in Mikrotik, so I’m trying to resolve some questions.
So, I need to have an ability to make some traffic used and sites visited graphs of my users for example once in a month. As I understood, I need to use Web Proxy function (or, may be, there is another way to do it - please, tell me that). And the moment that I didn’t find is how and where can I see an access log my Web Proxy making. Is there a possibility of analyzing log’s in Mikrotik or should I transfer log files to another machine, windows I suppose, and analyze logs there? Please, can you tell some ways (and software) for doing this? Thanks a lot.
You can use Proxilizer
http://wiki.mikrotik.com/wiki/Proxylizer/Introduction
Yes, but Proxylizer is working under Linux only, and I need a Windows based analyzer. The VmWare image doesn’t work too - it’s recieving information using syslog, but it doesn’t makes reports, and as I saw in a propriate topic - not only me have such a problem. So is there any other way to recieve information from proxy log using Mikrotik or any other soft? I can’t believe that in such powerful system there is no availability to get proxy log statistic…
Find some Windows analyzer that can read from syslog. There’s Windows syslog clients, and the RouteOS web proxy (as per the Wiki posted above) can send log entries via syslog.
Yes, I found Kiwi syslog..
Here it’s told, that I can configure Mikrotik to send logs, for example, to Kiwi syslog. So I get the file with such information in it:
2009-10-16 22:13:43 Local7.Debug 192.168.1.5 web-proxy,account 192.168.1.3 GET http://www.google.com.by/csi?v=3&s=web&action=&tran=undefined&e=17259,21554,21766,22107,22217,22267&ei=5cXYSoXqPIaTsAbbjqDjBg&rt=prt.424,xjs.523,ol.2191 action=allow cache=MISS
2009-10-16 22:14:00 Local7.Debug 192.168.1.5 web-proxy,account 192.168.1.3 GET http://torrents.ru/forum/index.php action=allow cache=MISS
2009-10-16 22:14:01 Local7.Debug 192.168.1.5 web-proxy,account 192.168.1.3 GET http://static.torrents.ru/templates/default/css/main.css?v=18 action=allow cache=MISS (after validation)
2009-10-16 22:14:02 Local7.Debug 192.168.1.5 web-proxy,account 192.168.1.3 GET http://counter.yadro.ru/hit?t16.2;r;s1280*800*32;0.874752007502091 action=allow cache=MISS
So, I have all information (exсept traffic size - but proxy server counts it too, so I should have this information too I think). And how can I now translate this information into user statistic report? Kiwi syslog doesn’t have such analyzer, and I can’t find windows program that will do it:( I don’t believe, there is no way to do this. Otherwise, what was this topic about???