Sarg package for pfsense

marcelloc · Mar 29, 2012, 8:40 PM

Sorry cino, I've updated an old file and now template file is missing :P

Just wait the 15 minutes to reinstall.

periko · Mar 29, 2012, 10:25 PM

yeaaaaa, thanks man I will tested, I have been use this package for a while but my install is manually, love it.
How difficult is to download the info in excel,cvs form?

One client ask about before.

Thanks!!!

marcelloc · Mar 30, 2012, 4:18 AM

@periko:

How difficult is to download the info in excel,cvs form?

If it's a built in sarg feature can be done but I saw only html, email or sql like reports.

marcelloc · Mar 30, 2012, 6:49 AM

Sarg 0.2 is out.

Sarg exclude lists options
bug fixes
gui improvements

jimp · Mar 30, 2012, 4:27 PM

You should add some screenshots of sample reports to the first post on the thread. Might help people decide if this is right for them (vs lightsquid).

marcelloc · Mar 30, 2012, 5:22 PM

@jimp:

You should add some screenshots of sample reports to the first post on the thread. Might help people decide if this is right for them (vs lightsquid).

done :) Thanks Jimp!

jimp · Mar 30, 2012, 5:31 PM

Nice :-)

Is that in an iframe? I had problems trying to make lightsquid do that, it was cached very aggressively and the data would never update even when I refreshed, I had to clear the cache to get some pages to reload, so I abandoned doing it that way.

saxonbeta · Mar 30, 2012, 6:44 PM

I was having problems to view the report page. Always I clicked View report tab i got a 404 error, as you can see in the next image.

So I decided to look in the code of "sarg_reports.php" and I found this line:

<iframe src="/sarg-reports/" frameborder="0" width="100%" height="600"></iframe>

and I changed to

<iframe src="/sarg-reports/index.html" frameborder="0" width="100%" height="600"></iframe>

And now every works fine!

Thank you for this excellent package!!

marcelloc · Mar 31, 2012, 4:25 AM

@jimp:

Is that in an iframe? I had problems trying to make lightsquid do that, it was cached very aggressively and the data would never update even when I refreshed, I had to clear the cache to get some pages to reload, so I abandoned doing it that way.

The realtime is ajax but report is iframed. I'll check if this cache issue is happening, If so I'll do some ajax with replaces to keep it on gui.

marcelloc · Mar 30, 2012, 7:03 PM

@saxonbeta:

So I decided to look in the code of "sarg_reports.php" and I found this line:
<iframe src="/sarg-reports/" frameborder="0" width="100%" height="600"></iframe>
and I changed to
<iframe src="/sarg-reports/index.html" frameborder="0" width="100%" height="600"></iframe>
And now every works fine!

Thanks saxonbeta for your feedback, I'll test it and also the cache issue today.

marcelloc · Mar 30, 2012, 10:56 PM

updated sarg to 0.2.1 with report tab without cache(as well as I've tested). ;)

saxonbeta · Mar 31, 2012, 12:19 AM

I have tested the latest version and the cache problem persists. I have to manually update the frame to get the last report. :(

marcelloc · Mar 31, 2012, 12:27 AM

The frame src should be a sarg_frame.php instead of sarg-reports.

Can you check if you got these changes?

What you mean by manual update? File edit or browser refresh?

saxonbeta · Mar 31, 2012, 12:41 AM

@marcelloc:

The frame src should be a sarg_frame.php instead of sarg-reports.

Can you check if you got these changes?

That's right, the frame source is sarg_frame.php

@marcelloc:

What you mean by manual update? File edit or browser refresh?

It is a browser refresh, using the context menu>reload frame

marcelloc · Mar 31, 2012, 12:48 AM

On my tests everytime I click on report I get the latest index.html ???

dlawley · Mar 31, 2012, 4:03 PM

just a note, with the pkg that was available this am. glad to see this one back.

Looks like it can create the directory etc. This is from the system log

php: /pkg_edit.php: The command '/usr/local/bin/sarg ' returned exit code '1', the output was 'SARG: Records in file: 174, 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: 174, reading: 100.00%'

Followup, access via gui give this;

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

Sarg Realtime appears to be working ok

Cino · Mar 31, 2012, 4:42 PM

@dlawley:

Sarg Realtime appears to be working ok

i can't seem to get any data to show in realtime.. only when using the original sarg-realtime.php does it work for me..

marcelloc · Mar 31, 2012, 4:46 PM

Cino,

What do you get on realtime? Just the headers from sarg?

The sarg-realtime.php is just a sarg -r frontend.

Maybe a stupid question but it shows the running info on button?

marcelloc · Mar 31, 2012, 4:49 PM

@dlawley:

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

Sarg Realtime appears to be working ok

Are you running full or nanobsd install?

I'll check folder creation code.

Cino · Mar 31, 2012, 5:58 PM

@marcelloc:

Cino,

What do you get on realtime? Just the headers from sarg?

The sarg-realtime.php is just a sarg -r frontend.

Maybe a stupid question but it shows the running info on button?

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