Sarg package for pfsense

[KOM]

I must have been looking at my 2.1.5 box.

[marcelloc]

The only manual fix I had to do on my 2.2 labs was the manual symlink to fix pbi mess.

[A Former User]

@KOM:

OK, making progress.  Sarg seems to be one of the more fragile packages.  If you happen to select the wrong report options or report to generate, it won't work.  Here is what I use and it seems to work OK:

Hi, I can't get Sarg to produce any report, not even with these settings. Any idea ?
Realtime works fine thought

I got one Report in the list, which is broken, from last year when I tried it once. How can I delete this report and strat over new ?

[marcelloc]

@Satras:

I got one Report in the list, which is broken, from last year when I tried it once. How can I delete this report and strat over new ?

Did you tried to remove old reports via console/ssh ?

[tux]

I've been digging sarg codes these past days. I tried hacking the template which overrides any changes on the sarg.conf file.  I hope we can point the directory of squid rather than have it fixed directory

[marcelloc]

@tux:

rather than have it fixed directory

Do you mean /usr/local/sarg-reports ?

Sarg package needs this to "jail" report access permissions on pfsense gui.

[tux]

No, I mean the sarg.template file. Since whenever there is a change in the config(on the webconfig) it is overridden by the template.  So I changed the access log path.  Then I also tried creating a folder on a separate drive and symlinked to the default sarg-reports folder but it was a fail. Hope we can configure the path of the access log and same for where to store sarg reports.

[spiritbreaker]

Hi marcelloc,

i figured out that my sarg dont rotate access.log file. I got a 21GB logfile and wonder why my reports takes so long  ;D.

Log: php: /pkg_edit.php: Sarg: force refresh now with -d date +%d/%m/%Y args, compress(on) and rotate action after sarg finish.

But i saw only cache.log seams to be rotated.

If i use the rotation settings on proxy server tab it works…..but then i have no sarg reports over long period ()eg. 30 days).

Versions:

PfSense 2.1.5 (i386)

squid3 3.1.20 pkg 2.1.2
squidguard 1.4_4 pkg v.1.9.6
havp 0.91_1 pkg v1.05
sarg 2.3.6_2 pkg v.0.6.3
Lightsquid  1.8.2 pkg v.2.33

thanks

PS: maybe lightsquid prevent sarg from rotating...so i temporary disabled automatic reports in lightsquid.

[marcelloc]

thanks for the feedback, I'll take a look on rotate call done by sarg.

what pfsense version are you using?

[spiritbreaker]

hi,

what pfsense version are you using?

PfSense 2.1.5 (i386)

[djpeach310]

Hi I am new to pfsense and i was able to figure out IP sec vpn but i can not get the reports to work nor can I get the realtime to show any dans names.
Can any one help me?
I am running the latest version of pfsense.

[marcelloc]

@djpeach310:

Hi I am new to pfsense and i was able to figure out IP sec vpn but i can not get the reports to work nor can I get the realtime to show any dans names.
Can any one help me?
I am running the latest version of pfsense.

Maybe you forgot to enable logging on squid settings.

[worldfirst]

Hi,

My goal with Sarg is to create Squid's daily reports. I have logging and logging rotation both enabled on Squid. My question is why Sarg doesn't show any reports for the previous day (with -d date -v-1d +%d/%m/%Y extra args) even though I definitely have yesterday's reports in /var/squid/logs. Is it because of Squid's own logging rotation feature? Do I need to turn it off? Or is it because of 60 minutes restriction on "Find Limit" option? I'm asking this because Sarg easily creates daily reports with -d date +%d/%m/%Y extra args.

I'm using pfSense 2.2-RELEASE (amd64) with Sarg package 2.3.9 pkg v.0.6.4. Enabled Sarg report options are: 1, 5-10, 13-16.

Thank you!

[Nachtfalke]

I had a look in the sarg.conf file when I was looking for somthing other and I found that the configuration there only points to the actual access.log file.

access_log /var/log/squid/access.log

So I assume when squid rotates your logs then sarg cannot analyze the logs form access.log.1.
I did some research and found out that since some newer version of sarg (2.3?) - which is installed on pfsense - there is the possibility to set a "*" so sarg analyzes more logfiles.

access_log /var/log/squid/access.log*

Source:
http://sourceforge.net/p/sarg/discussion/363374/thread/e2e10ffb/

[worldfirst]

Thanks for your reply!

I modified access_log string in sarg.conf and after that I got "file not found" error (Cannot get the modification time of input log file /var/squid/logs/access.log* (No such file or directory)). So the current version doesn't support this feature.

[tux]

@worldfirst You can not directly edit the sarg.conf since it will be changed backed to its original configuration using the template which is the sarg.template file

[worldfirst]

Yes, I noticed that.

[Taras_]

pfSense 2.2 (i386)
Squid 3 + Sarg

Can't get report, error message:

Error: Could not find report index file.
Check and save sarg settings and try to force sarg schedule.

Interesting thing with 2 almost same commands in console:
1. Don't work. No report in destination directory after run, i.e. dir is empty.

sarg -x -f /usr/pbi/sarg-i386/etc/sarg/sarg.conf -o /usr/local/sarg-reports/

2. Works fine. Generates report in destination directory and after linking this dir to /usr/local/sarg-reports i can see reports via pfsense's GUI.

sarg -x -f /usr/pbi/sarg-i386/etc/sarg/sarg.conf -o /sarg-reports/

So, sarg works for 1st level directory but don't work for 3rd level subdir.

Any ideas how to solve problem?

[zoro_2009]

I confirm the problem !  :(

[KOM]

Try this from the shell:

rm -r /usr/local/sarg-reports
ln -s /usr/pbi/sarg-i386/local/sarg-reports /usr/local/sarg-reports

Use ln -s /usr/pbi/sarg-amd64/local/sarg-reports /usr/local/sarg-reports if you have 64-bit build.