Sarg package for pfsense

marcelloc

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

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

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

@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

@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

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

saxonbeta

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

marcelloc

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

@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

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

dlawley

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

@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

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

@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

@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

dlawley

@marcelloc:

@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.

Sorry not to mention that , but it is a full install (not nano)

dlawley

@marcelloc:

@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.

I dunno. Still not showing the service as "running" , but I am finally starting to see some data. I just pulled another reinstall, not sure if that helped.

marcelloc

Sarg service will only show as running only on report updates, It's run by cron.

Better if I remove it from service list.

marcelloc

Dlawley,

Can you try to run sarg on console/ssh and post the response?

dlawley

@marcelloc:

Dlawley,

Can you try to run sarg on console/ssh and post the response?


[2.0.1-RELEASE][root@pfsense.localdomain]/root(3): sarg
SARG: Records in file: 10434, reading: 100.00%
SARG: Successful report generated on /usr/local/www/sarg-reports/2012/03/31
[2.0.1-RELEASE][root@pfsense.localdomain]/root(4):

Had to make the "after action" command to rotate and restart to get more data..

Since I seem to be getting some data of various degrees I think I may flush out sarg report directory and let things restart. I can't say for sure what I'm seeing is results from any of my changed settings.


[2.0.1-RELEASE][root@pfsense.localdomain]/root(6): sarg -z
SARG: TAG: access_log /var/squid/logs/access.log
SARG: TAG: graphs yes
SARG: TAG: output_dir /usr/local/www/sarg-reports
SARG: TAG: anonymous_output_files no
SARG: TAG: resolve_ip no
SARG: TAG: user_ip no
SARG: TAG: topuser_sort_field BYTES NORMAL
SARG: TAG: user_sort_field BYTES NORMAL
SARG: TAG: exclude_users /usr/local/etc/sarg/exclude_users.conf
SARG: TAG: exclude_hosts /usr/local/etc/sarg/exclude_hosts.conf
SARG: TAG: remove_temp_files yes
SARG: TAG: index yes
SARG: TAG: index_tree date
SARG: TAG: overwrite_report no
SARG: TAG: use_comma yes
SARG: TAG: exclude_codes /usr/local/etc/sarg/exclude_codes
SARG: TAG: report_type topusers topsites sites_users users_sites date_time denied auth_failures site_user_time_date downloads
SARG: TAG: usertab
SARG: TAG: long_url no
SARG: TAG: charset UTF-8
SARG: TAG: privacy no
SARG: TAG: dansguardian_conf
SARG: TAG: squidguard_conf
SARG: TAG: show_sarg_info no
SARG: TAG: show_sarg_logo no
SARG: TAG: www_document_root /usr/local/www
SARG: TAG: realtime_refresh_time 0
SARG: TAG: realtime_types GET,PUT,CONNECT
SARG: TAG: realtime_unauthenticated_records show
SARG: Records in file: 10490, reading: 100.00%
SARG: (info) date=31/03/2012
SARG: (info) period=2012 Mar 31
SARG: (info) outdirname=/usr/local/www/sarg-reports/2012/03/31
SARG: (info) Dansguardian report not produced because no dansguardian configuration file was provided
SARG: (info) No redirector logs provided to produce that kind of report
SARG: (info) Denied report not produced because it is empty
SARG: (info) Authentication failures report not produced because it is empty
SARG: (info) Redirector report not generated because it is empty
SARG: Successful report generated on /usr/local/www/sarg-reports/2012/03/31
[2.0.1-RELEASE][root@pfsense.localdomain]/root(7):