Sarg package for pfsense

asterix

Get this error on reports tab

Warning: file_get_contents(/usr/local/www/sarg-reports/index.html): failed to open stream: No such file or directory in /usr/local/www/sarg_frame.php on line 41

And this in system logs

php: /pkg_edit.php: The command '/usr/local/bin/sarg ' returned exit code '1', the output was 'SARG: Records in file: 100, reading: 0.00%^MSARG: cannot open /usr/local/www/sarg-reports/2012/03/31/sarg-date for writing SARG:: No such file or directory SARG: Records in file: 100, reading: 100.00%'

dlawley

firefox and chrome show different pages/reports

marcelloc

@asterix:

Warning: file_get_contents(/usr/local/www/sarg-reports/index.html): failed to open stream: No such file or directory in /usr/local/www/sarg_frame.php on line 41

And this in system logs

php: /pkg_edit.php: The command '/usr/local/bin/sarg ' returned exit code '1', the output was 'SARG: Records in file: 100, reading: 0.00%^MSARG: cannot open /usr/local/www/sarg-reports/2012/03/31/sarg-date for writing SARG:: No such file or directory SARG: Records in file: 100, reading: 100.00%'

I've included a file check in report page. I'll do more tests before commit.

You may need to change folder permissions or empty sarg-reports folder before trying to run sarg again.

marcelloc

@Cino:

nothing is shown… I click on the button, it changes to running but nothing is displayed

Can you try to run this realtime page using firefox with firebug(network tab) enabled to see if there is any error on it.

I'm using current code on a test machine and it's showing realtime log without issues.

sarg_realtime.png_thumb

gwhynott

Hi Marcello,

Just wanted to report the latest update is working as expected on our system. Thanks again for your efforts.

I'll be watching for the email reports option. 8)

take care and have a great day,
greg

Cino

everything looks good, no errors and the page refreshes based on update frequency…. I'll keep testing..... Its probably just my box, begging for a fresh install of pfsense....lol

periko

Hi.

Does someone have test on nanobsd?

Thanks!!!

marcelloc

@periko:

Does someone have test on nanobsd?

Not yet.

periko

Went the nanobsd arrive I will help testing, thanks :)

marcelloc

@periko:

Went the nanobsd arrive I will help testing, thanks :)

squid 2.x does not log on nanobsd installs.

Are you running dansguardian?

periko

I enable logs in nanobsd and have been using sarg for a while with success, thanks!!!

marcelloc

great! :)

I'll commit squidguard functions to sarg until friday.

gwhynott

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

Cino

@gwhynott:

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.