Squid reporting

RouterOS General
1

Hi all,

Has anyone successfully logged and graphed individual users on a Mikrotik PC based ?
It would be great to have a built in version.

The way I ended up doing it is by sending squid logs from the MT to a remote syslog syrver, then parsing those files with SARG, which generated the reports. but it was very ugly and not very reliable.
Does anyone have a better way ?

2

I expect that the most flexible way to do is, by enabling transparent proxy and ‘web-proxy,!debug’ logs and sending them to remote syslog server or Dude server.
As MikroTik RouterOS is program for router, not separate syslog server, that’s why local router log facility is not to advanced.

3

Mikrotik sends out the logs in syslog format, SARG needs to read in squid log format, hence the ugly and unreliable result.
It would be wonderful if Mikrotik folks could change that!

4

That would greatly help yes !

5

Well, I was wandering a long time ago this.
Is creating a pcq queue tree, AND a simple queue ( with no limit) for each user a reliable way to graph each ip traffic ?

Meaning, exactly:

  • does simple queue, if no speed/total_traffic limit is applied, interfere with pcq example from the manual, and wiki ?
  • is this a reliable way of graphing each individual ip, having on x86 hardware a queue for each ip routed by the MT box ?

So, share bandwidth with pcq, and to see and graph each ip ( make them static, or dhcp - static ), make a simple queue with no limit at all, based on ip of customer. This should of course catch proxy traffic.
Am I correct ?

Sergejs ? Anybody ?

Thank you in advance.