Sarg package for pfsense

Cino

Hi Marcello,

will you (or is there) include a method to sort the reports? For example, when viewing "top sites", it sorts the list by amount of 'hits' by default, I'd like to sort by amount of data transferred if possible.

with the proliferation of web apps, hits don't really mean as much as they once did in these types of reports. as an example I've seen one user generate over 20k hits on teamviewer.com in one day.

thanks again,
greg

@marcelloc there is a way to sort that is built in, kinda… check the default conf file for 'TAG: sorttable path'. Javascript sorttable.js would need to be added, from http://www.kryogenix.org/code/browser/sorttable/.

marcelloc

Thanks cino.

I'm merging a contribution for squidguard reports from ccesario and then I'll take a look on it.

bitskiller

report on firefox no work!!! ??? fine on google chrome ;D

marcelloc

@bitskiller:

report on firefox no work!!! ??? fine on google chrome ;D

What version of firefox? I'm using it on firefox11 and chrome without issues.

marcelloc

@Cino:

@marcelloc there is a way to sort that is built in, kinda… check the default conf file for 'TAG: sorttable path'. Javascript sorttable.js would need to be added, from http://www.kryogenix.org/code/browser/sorttable/.

I'll try to include this javascript to enable sort change on reports but did you saw user sort field on sarg settings?

Exolon

I've managed to get Sarg Realtime working but when I try and "View Reports", I get a blank page:

Sarg_Realtime.png_thumb

Sarg_ViewReports.png_thumb

marcelloc

Try to generate another report after selecting indextree on sarg settings.

marcelloc

sarg 0.3 is out with date report format ,sortable reports and squidguard. :)

Thanks to cino and ccesario.

bitskiller

@marcelloc:

@bitskiller:

report on firefox no work!!! ??? fine on google chrome ;D

What version of firefox? I'm using it on firefox11 and chrome without issues.

I'm using firefox 11 and does not display my report, if it works well with chrome

marcelloc

bitskiller,

did you tried to refresh the report frame using right-click -> this frame -> reload?

Exolon

@marcelloc:

Try to generate another report after selecting indextree on sarg settings.

Thanks, that did it, I now have reports showing.

Donny

I really interesting SARG but until now I could not find any e-mail option to use it for system log report.

Thank u

marcelloc

It's not implemented yet.

Mail option will need a mailer daemon running on pfsense like postfix forwarder.

Donny

@marcelloc:

It's not implemented yet.

Mail option will need a mailer daemon running on pfsense like postfix forwarder.

I have tested SARG many time with Squid-reverse. This is my step
1. I have installed Squid-reverse.
2. I have installed SARG and after that I got some error: Sarg config error:log file () does not exits. I want to know what is wrong?.
3. I tried to change the "userid" or the "ip address" to be a real user name on the reports like this: "172.31.21.22 Donny Van Cooper" but in the "View report and realtime"tab it does not show a real user name. Where can I resolve any ip address on pfSense or I have to resolve any ip address on Domain Controller (Windows Server 2008)
4. I use Firefox web browser also Google Chrome for config SARG and at the "view report" tab dat you said to do is "This frame > reload frame" but some time it does not work I have to do again and again or I have to wait a few second and then report appear.
5. Do I have only to select interface "LAN" or I have to select both "LAN and loopback on Squid-reverse.

Thank u very much

SargError1.png_thumb

RealName.png_thumb

ViewReport.png_thumb

marcelloc

@Donny:

2. I have installed SARG and after that I got some error: Sarg config error:log file () does not exits. I want to know what is wrong?.

This maybe a first install bug, I'll check it.

@Donny:

3. I tries to change the "userid" or the "ip address" to be a real user name on the reports like this: "172.31.21.22 Donny Van Cooper" but in the "View report and realtime"tab it does not show a real user name. Where can I resolve any ip address on pfSense or I have to resolve any ip address on Domain Controller (Windows Server 2008)
4. I use Firefox web browser also Google Chrome for config SARG and at the "view report" tab dat you said to do is "This frame > reload frame" but some time it does not work I have to do again and again or I have to wait a few second and then report appear.

did you created any schedule on sarg to create reports?

@Donny:

5. Do I have only to select interface "LAN" or I have to select both "LAN and loopback on Squid-reverse.

Just lan for normal use.

Donny

@marcelloc:

@Donny:

2. I have installed SARG and after that I got some error: Sarg config error:log file () does not exits. I want to know what is wrong?.

This maybe a first install bug, I'll check it.

@Donny:

3. I tries to change the "userid" or the "ip address" to be a real user name on the reports like this: "172.31.21.22 Donny Van Cooper" but in the "View report and realtime"tab it does not show a real user name. Where can I resolve any ip address on pfSense or I have to resolve any ip address on Domain Controller (Windows Server 2008)
4. I use Firefox web browser also Google Chrome for config SARG and at the "view report" tab dat you said to do is "This frame > reload frame" but some time it does not work I have to do again and again or I have to wait a few second and then report appear.

did you created any schedule on sarg to create reports?

@Donny:

5. Do I have only to select interface "LAN" or I have to select both "LAN and loopback on Squid-reverse.

Just lan for normal use.

Yes, Marcelloc. I have created schedule on sarg to create reports. you can see my screenshot pictures that I post its here but a real user name is still not work.
Thank a lot for your help

ScheduleSarg.png_thumb

SargSettings.png_thumb