Sarg Could not find report index file

Poenskop · Dec 3, 2015, 1:45 PM

Hello, please help! :)

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

I am using:

Version 2.2.5-RELEASE (amd64)
built on Wed Nov 04 15:49:37 CST 2015
FreeBSD 10.1-RELEASE-p24
You are on the latest version.
Sarg 0.6.8
squid3 0.4.6

I have tried:

the symbolic link and deleting that directory people go on about.
forcing a sync.

sarg:

SARG: Records in file: 1187, reading: 100.00%
SARG: (repday) Cannot open log file /usr/local/sarg-reports/03Dec2015-03Dec2015/10_0_0_70/d10_0_0_70.html

sarg -x

SARG: Init
SARG: Loading configuration from /usr/local/etc/sarg/sarg.conf
SARG: Chaining IP resolving module "dns"
SARG: Loading exclude host file from: /usr/pbi/sarg-amd64/etc/sarg/exclude_hosts.conf
SARG: Loading exclude file from: /usr/pbi/sarg-amd64/etc/sarg/exclude_users.conf
SARG: Reading host alias file "/usr/pbi/sarg-amd64/etc/sarg/hostalias"
SARG: List of host names to alias:
SARG: Deleting temporary directory "/tmp/sarg"
SARG: Parameters:
SARG:           Hostname or IP address (-a) =
SARG:                    Useragent log (-b) =
SARG:                     Exclude file (-c) = /usr/pbi/sarg-amd64/etc/sarg/exclude_hosts.conf
SARG:                  Date from-until (-d) =
SARG:    Email address to send reports (-e) =
SARG:                      Config file (-f) = /usr/local/etc/sarg/sarg.conf
SARG:                      Date format (-g) = Europe (dd/mm/yyyy)
SARG:                        IP report (-i) = No
SARG:             Keep temporary files (-k) = No
SARG:                        Input log (-l) = /var/squid/logs/access.log
SARG:               Resolve IP Address (-n) = Yes
SARG:                       Output dir (-o) = /usr/local/sarg-reports/
SARG: Use Ip Address instead of userid (-p) = No
SARG:                    Accessed site (-s) =
SARG:                             Time (-t) =
SARG:                             User (-u) =
SARG:                    Temporary dir (-w) = /tmp/sarg
SARG:                   Debug messages (-x) = Yes
SARG:                 Process messages (-z) = No
SARG:  Previous reports to keep (--lastlog) = 0
SARG:
SARG: sarg version: 2.3.9 Sep-21-2014
SARG: Reading access log file: /var/squid/logs/access.log
SARG: Records in file: 1188, reading: 100.00%
SARG:    Records read: 1188, written: 1188, excluded: 0
SARG: Squid log format
SARG: Period: 03 Dec 2015
SARG: Sorting log /tmp/sarg/10_0_0_55.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_55
SARG: Sorting log /tmp/sarg/10_0_0_69.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_69
SARG: Sorting log /tmp/sarg/10_0_0_254.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_254
SARG: Sorting log /tmp/sarg/10_0_0_75.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_75
SARG: Sorting log /tmp/sarg/10_0_0_70.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_70
SARG: Sorting log /tmp/sarg/10_0_0_71.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_71
SARG: Sorting log /tmp/sarg/10_0_0_62.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_62
SARG: Sorting log /tmp/sarg/10_0_0_54.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_54
SARG: Sorting log /tmp/sarg/10_0_0_61.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_61
SARG: Sorting log /tmp/sarg/10_0_0_99.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_99
SARG: Sorting log /tmp/sarg/10_0_0_63.user_unsort
SARG: Making file: /tmp/sarg/10_0_0_63
SARG: (repday) Cannot open log file /usr/local/sarg-reports/03Dec2015-03Dec2015/10_0_0_70/d10_0_0_70.html

KOM · Dec 3, 2015, 3:58 PM

Sarg can be finicky if you select the wrong report options. These work for me:

Poenskop · Dec 4, 2015, 5:58 AM

Thanks KOM, however I have just tried selecting your options, however it is still not working.

Poenskop · Dec 4, 2015, 6:22 AM

Okay so I ran sarg and sarg -x again.
Output said successful.

Then I ran the 3 commands found here:
https://forum.pfsense.org/index.php?topic=99643.msg555194#msg555194

Now it works.

Thanks KOM! ;D

doktornotor · Dec 4, 2015, 10:42 AM

@Poenskop:

Then I ran the 3 commands found here:
https://forum.pfsense.org/index.php?topic=99643.msg555194#msg555194

Now it works.

Thanks KOM! ;D

I think it really should be done the other way round, instead of moving the reports to a directory that gets removed on every package reinstall.

So… https://github.com/pfsense/pfsense-packages/pull/1205

(Oh, and the horrible log rotate/restart something "feature" is going to /dev/null).

Topper727 · Dec 8, 2015, 1:53 AM

[2.2.5-RELEASE][admin@firewall.wholesale-florida.com]/root: sarg -x
SARG: Init
SARG: Loading configuration from /usr/local/etc/sarg/sarg.conf
SARG: Chaining IP resolving module "dns"
SARG: Loading exclude host file from: /usr/pbi/sarg-amd64/etc/sarg/exclude_hosts.conf
SARG: Loading exclude file from: /usr/pbi/sarg-amd64/etc/sarg/exclude_users.conf
SARG: Reading host alias file "/usr/pbi/sarg-amd64/etc/sarg/hostalias"
SARG: List of host names to alias:
SARG: Parameters:
SARG: Hostname or IP address (-a) =
SARG: Useragent log (-b) =
SARG: Exclude file (-c) = /usr/pbi/sarg-amd64/etc/sarg/exclude_hosts.conf
SARG: Date from-until (-d) =
SARG: Email address to send reports (-e) =
SARG: Config file (-f) = /usr/local/etc/sarg/sarg.conf
SARG: Date format (-g) = USA (mm/dd/yyyy)
SARG: IP report (-i) = No
SARG: Keep temporary files (-k) = No
SARG: Input log (-l) = /var/squid/logs/access.log
SARG: Resolve IP Address (-n) = Yes
SARG: Output dir (-o) = /usr/local/sarg-reports/
SARG: Use Ip Address instead of userid (-p) = Yes
SARG: Accessed site (-s) =
SARG: Time (-t) =
SARG: User (-u) =
SARG: Temporary dir (-w) = /tmp/sarg
SARG: Debug messages (-x) = Yes
SARG: Process messages (-z) = No
SARG: Previous reports to keep (–lastlog) = 0
SARG:
SARG: sarg version: 2.3.9 Sep-21-2014
SARG: Reading access log file: /var/squid/logs/access.log
SARG: Records in file: 584, reading: 100.00%
SARG: Records read: 584, written: 584, excluded: 0
SARG: Squid log format
SARG: Period: 2015 Dec 07
SARG: File /usr/local/sarg-reports/2015/12/07 already exists, moved to /usr/local/sarg-reports/2015/12/07.16
SARG: cannot open /usr/local/sarg-reports/2015/12/07/sarg-date for writing
SARG:: No such file or directory
[2.2.5-RELEASE][admin@firewall.wholesale-florida.com]/root: ls -l /usr/local/sarg-reports
lrwxr-xr-x 1 root wheel 38 Dec 7 01:28 /usr/local/sarg-reports -> /usr/pbi/sarg-amd64/local/sarg-reports

doktornotor · Dec 8, 2015, 9:00 AM

And, what exactly are you trying to tell us? The PR has not been merged yet, so yeah… it is broken.

mgumiero9 · Jul 6, 2016, 6:38 PM

@KOM:

Sarg can be finicky if you select the wrong report options. These work for me:

This worked for me too.

arymec · Mar 11, 2019, 8:30 PM

@poenskop Para solucionar el error
Could not find report index file. Check and save sarg settings and try to force sarg schedule.

Lo que hice fue cambiar el directorio de salida del reporte de sarg en el archivo sarg.conf para que quedara de la siguiente manera:

Output dir (-o) = /usr/local/www/html/

después de esto en la consola crear un enlace simbólico hacia ese directorio

ln -s /usr/local/www/html /usr/local/sarg-reports

con esto se soluciono el problema ya pude ver el reporte y desapareció el mensaje

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