Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Sarg Could not find report index file

    Cache/Proxy
    6
    9
    3.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • P
      Poenskop
      last edited by

      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
      A 1 Reply Last reply Reply Quote 0
      • KOMK
        KOM
        last edited by

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

        sarg.png
        sarg.png_thumb

        1 Reply Last reply Reply Quote 0
        • P
          Poenskop
          last edited by

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

          1 Reply Last reply Reply Quote 0
          • P
            Poenskop
            last edited by

            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

            1 Reply Last reply Reply Quote 0
            • D
              doktornotor Banned
              last edited by

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

              1 Reply Last reply Reply Quote 0
              • T
                Topper727
                last edited by

                [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

                Dell 2950 g3 server
                Intel(R) Xeon(R) CPU E5430 @ 2.66GHz
                Current: 2000 MHz, Max: 2667 MHz
                8 CPUs: 2 package(s) x 4 core(s)
                8152 MiB and 600meg 10k drive
                Pfsense 2.4 .. Hoping to get the phpvirtualbox going again.

                1 Reply Last reply Reply Quote 0
                • D
                  doktornotor Banned
                  last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • M
                    mgumiero9
                    last edited by

                    @KOM:

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

                    This worked for me too.

                    1 Reply Last reply Reply Quote 0
                    • A
                      arymec @Poenskop
                      last edited by

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

                      1 Reply Last reply Reply Quote 0
                      • First post
                        Last post
                      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.