sarg issue while generating reports for squid

[mail4vij]

I installed sarg from sarg rpm and i am facing issue while generating sarg reports and getting this time different error below

sarg -l /var/log/squid/access.log
SARG: Records in file: 242332, reading: 0.00%
SARG: Records in file: 242332, reading: 2.06%
SARG: Records in file: 242332, reading: 4.13%
SARG: Records in file: 242332, reading: 6.19%
SARG: Records in file: 242332, reading: 8.25%
SARG: Records in file: 242332, reading: 10.32%
SARG: Records in file: 242332, reading: 12.38%
SARG: Records in file: 242332, reading: 14.44%
SARG: Records in file: 242332, reading: 16.51%
SARG: Records in file: 242332, reading: 18.57%
SARG: Records in file: 242332, reading: 20.63%
SARG: Records in file: 242332, reading: 22.70%
SARG: Records in file: 242332, reading: 24.76%
SARG: Records in file: 242332, reading: 26.82%
SARG: Records in file: 242332, reading: 28.89%
SARG: Records in file: 242332, reading: 30.95%
SARG: Records in file: 242332, reading: 33.01%
SARG: Records in file: 242332, reading: 35.08%
SARG: Records in file: 242332, reading: 37.14%
SARG: Records in file: 242332, reading: 39.20%
SARG: Records in file: 242332, reading: 41.27%
SARG: Records in file: 242332, reading: 43.33%
SARG: Records in file: 242332, reading: 45.39%
SARG: Records in file: 242332, reading: 47.46%
SARG: Records in file: 242332, reading: 49.52%
SARG: Records in file: 242332, reading: 51.58%
SARG: Records in file: 242332, reading: 53.65%
SARG: Records in file: 242332, reading: 55.71%
SARG: Records in file: 242332, reading: 57.77%
SARG: Records in file: 242332, reading: 59.84%
SARG: Records in file: 242332, reading: 61.90%
SARG: Records in file: 242332, reading: 63.96%
SARG: Records in file: 242332, reading: 66.03%
SARG: Records in file: 242332, reading: 68.09%
SARG: Records in file: 242332, reading: 70.15%
SARG: Records in file: 242332, reading: 72.21%
SARG: Records in file: 242332, reading: 74.28%
SARG: Records in file: 242332, reading: 76.34%
SARG: Records in file: 242332, reading: 78.40%
SARG: Records in file: 242332, reading: 80.47%
SARG: Records in file: 242332, reading: 82.53%
SARG: Records in file: 242332, reading: 84.59%
SARG: Records in file: 242332, reading: 86.66%
SARG: Records in file: 242332, reading: 88.72%
SARG: Records in file: 242332, reading: 90.78%
SARG: Records in file: 242332, reading: 92.85%
SARG: Records in file: 242332, reading: 94.91%
SARG: Records in file: 242332, reading: 96.97%
SARG: Records in file: 242332, reading: 99.04%
SARG: (download) Cannot open file: /var/www/sarg/ONE-SHOT/2009Dec20-2009Dec29/period
SARG: Records in file: 242332, reading: 100.00%
.. Sarg failed! See the output above for details.

Any suggestion / help would be greatly appreciated.

[peter]

Does the file and path to the file exist? If the file exists, does it have the correct ownership and permissions for sarg to read the file?

/var/www/sarg/ONE-SHOT/2009Dec20-2009Dec29/period

[mail4vij]

Thanks for the reply Peter,

I have setup this sarg dir for squid users as below.

cd /var/www/sarg
> ls -l
total 24
drwxrwsr-x 4 root squid 4096 Dec 29 21:27 ONE-SHOT
drwxrwsr-x 2 root squid 4096 Aug 25 2007 daily
-rwxrwsr-x 1 root squid 1305 Aug 25 2007 index.html
drwxrwsr-x 2 root squid 4096 Aug 25 2007 monthly
-rwxrwsr-x 1 root squid 2398 Dec 23 2006 sarg.css
drwxrwsr-x 2 root squid 4096 Aug 25 2007 weekly

but still getting same error ,What else i need to change?

[peter]

Was the 2009Dec20-2009Dec29/period directory created?
Are you running selinux? What does the /var/log/messages errorlog file show?

[mail4vij]

I am running CentOS 5.4 64 bits i have installed sarg 64 bits rpm and when i run sarg -l /var/log/squid/access.log through command line it shows me above error but generated that directory with name. and when i go to browser it shows me page but when i clicked on the dir generated with dates it wont show anything and i think b'z of missing index.html file into that dir.

I do not see anything in /var/log/messages

[peter]

Then it could be an apache setting. There is a way to configure apache to list files in a directory if there is no index.html

<Directory /usr/your/directory/here>
        Options Indexes
</Directory>

[mail4vij]

I checked that sarg rpm automatically setup sarg.conf fiel in /etc/httpd/conf.d dir and even i tried with webmin squid report generate tool i can brose that dir but when i click on any file inside the dates dir , it shows me error file not found , as i think report not properly generated .??

[peter]

Are the files actually in the directories? What does the error log message say in /var/log/messages? Is there a separate error log file for sarg? I'd also set logging to /var/log/messages to debug so that you get everything logged. There is a howto on syslog on this site.

[mail4vij]

Ok i think my sarg logs are not properly configured for this i will check howto syslog and will set up for sarg and will check the error and come back to forum if find anything

Thanks for all your help and Happy New Year!

[mail4vij]

i read the how to syslog but unable to understand how to setup for sarg. could you please give me brief hint how to setup logging for sarg so that i can check in /var/log/messages

Thanks