Sarg não gera relatório [RESOLVIDO]
-
Pessoal, quem puder me ajudar fico grato.
Tenho o PfSense 2.2.4 com Squid instalado. Tento gerar relatório e apresenta o seguinte erro: Error: Could not find report index file.
Check and save Sarg settings and try to force Sarg schedule. Rodei o comando sarg -x e apresentou o seguinte erro: cannot open squidguard config files: /usr/pbi/squidguard-i386/etc/squidguard/suidguard.conf. Alguém sabe como posso fazer para resolver esse problema? Já mexi em tudo e nada!
Grato. -
Boa tarde Amigo
Segue solução:
https://www.youtube.com/watch?v=LH5W1avBKgs
de uma olhadas nestes também, pode ser que agrege mais em seus conhecimentos
https://www.youtube.com/watch?v=qIhtOgTHJwQ
https://www.youtube.com/watch?v=l5p7Pe_cqj8
https://www.youtube.com/watch?v=udb32sl2CSEUm abraço.
-
1º - Exclui o diretório /usr/local/sarg-reports com o comando
rm -R /usr/local/sarg-reports
2º - Criei um link simbólico com o comando abaixo.
ln -s /usr/pbi/sarg-amd64/local/sarg-reports /usr/local/sarg-reports
(adapte se seu pfSense for 32Bits) -
Amigos, muito obrigado pela ajuda. Estou "quebrando a cabeça" para configurar esse Sarg. Meu problema parece ser algo simples e todos que vi que foram ajudados com essa solução resolveram o problema.
Exclui a pasta e criei esse link simbólico. Na pasta /usr/local/sarg-reports ele tá criando relatórios. Tem arquivos dentro da pasta. Se rodo o sarg -x ele reporta: SARG: Cannot set the locale LC_ALL to the environment variable.
Já fiz de tudo: já reinstalei o pacote do Sarg, já reiniciei o squid, já deixei tudo assinalado em "report option" e nada! Se clico em View Report aparece a mensagem: Error: Could not find report index file. Check and save Sarg settings and try to force Sarg schedule. -
Se realmente não precisa do Sarg, uma alternativa é o Lightsquid;
-
Tomas Waldow, eu tentei usar o Lightsquid, não gostei muito. Eu preciso de um que gere algo mais detalhado.
-
Tente então ver se na versão 64 bits funciona;
-
Também não funcionou em versão 64 bits. Aguardo possíveis sugestões dos colegas. Grato.
-
Entre no SSH (Opção 8) ou vá, na WebGui em Diagnóstico -> Prompt de comando
Execute a linha:export LC_ALL=C && sarg -x
Copie o retorno apresentado para um arquivo de texto. Volte e confira seus relatorios do Sarg (force a schedule se necessário. Se nao funcionar, poste essa saída do comando aqui.
-
Obrigado pela ajuda André. Fiz o que falou no WebGui do PFSense, forcei uma atualização e continua o mesmo erro. A saída do erro segue abaixo:
$ export LC_ALL=C && sarg -x
SARG: Init
SARG: Loading configuration from /usr/local/etc/sarg/sarg.conf
SARG: Loading exclude host file from: /usr/pbi/sarg-i386/etc/sarg/exclude_hosts.conf
SARG: Loading exclude file from: /usr/pbi/sarg-i386/etc/sarg/exclude_users.conf
SARG: Reading host alias file "/usr/pbi/sarg-i386/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-i386/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) = No
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: 1245813, reading: 0.00%
SARG: Records in file: 5000, reading: 0.40%
SARG: Records in file: 10000, reading: 0.80%
SARG: Records in file: 15000, reading: 1.20%
SARG: Records in file: 20000, reading: 1.61%
SARG: Records in file: 25000, reading: 2.01%
SARG: Records in file: 30000, reading: 2.41%
SARG: Records in file: 35000, reading: 2.81%
SARG: Records in file: 40000, reading: 3.21%
SARG: Records in file: 45000, reading: 3.61%
SARG: Records in file: 50000, reading: 4.01%
SARG: Records in file: 55000, reading: 4.41%
SARG: Records in file: 60000, reading: 4.82%
SARG: Records in file: 65000, reading: 5.22%
SARG: Records in file: 70000, reading: 5.62%
SARG: Records in file: 75000, reading: 6.02%
SARG: Records in file: 80000, reading: 6.42%
SARG: Records in file: 85000, reading: 6.82%
SARG: Records in file: 90000, reading: 7.22%
SARG: Records in file: 95000, reading: 7.63%
SARG: Records in file: 100000, reading: 8.03%
SARG: Records in file: 105000, reading: 8.43%
SARG: Records in file: 110000, reading: 8.83%
SARG: Records in file: 115000, reading: 9.23%
SARG: Records in file: 120000, reading: 9.63%
SARG: Records in file: 125000, reading: 10.03%
SARG: Records in file: 130000, reading: 10.43%
SARG: Records in file: 135000, reading: 10.84%
SARG: Records in file: 140000, reading: 11.24%
SARG: Records in file: 145000, reading: 11.64%
SARG: Records in file: 150000, reading: 12.04%
SARG: Records in file: 155000, reading: 12.44%
SARG: Records in file: 160000, reading: 12.84%
SARG: Records in file: 165000, reading: 13.24%
SARG: Records in file: 170000, reading: 13.65%
SARG: Records in file: 175000, reading: 14.05%
SARG: Records in file: 180000, reading: 14.45%
SARG: Records in file: 185000, reading: 14.85%
SARG: Records in file: 190000, reading: 15.25%
SARG: Records in file: 195000, reading: 15.65%
SARG: Records in file: 200000, reading: 16.05%
SARG: Records in file: 205000, reading: 16.46%
SARG: Records in file: 210000, reading: 16.86%
SARG: Records in file: 215000, reading: 17.26%
SARG: Records in file: 220000, reading: 17.66%
SARG: Records in file: 225000, reading: 18.06%
SARG: Records in file: 230000, reading: 18.46%
SARG: Records in file: 235000, reading: 18.86%
SARG: Records in file: 240000, reading: 19.26%
SARG: Records in file: 245000, reading: 19.67%
SARG: Records in file: 250000, reading: 20.07%
SARG: Records in file: 255000, reading: 20.47%
SARG: Records in file: 260000, reading: 20.87%
SARG: Records in file: 265000, reading: 21.27%
SARG: Records in file: 270000, reading: 21.67%
SARG: Records in file: 275000, reading: 22.07%
SARG: Records in file: 280000, reading: 22.48%
SARG: Records in file: 285000, reading: 22.88%
SARG: Records in file: 290000, reading: 23.28%
SARG: Records in file: 295000, reading: 23.68%
SARG: Records in file: 300000, reading: 24.08%
SARG: Records in file: 305000, reading: 24.48%
SARG: Records in file: 310000, reading: 24.88%
SARG: Records in file: 315000, reading: 25.28%
SARG: Records in file: 320000, reading: 25.69%
SARG: Records in file: 325000, reading: 26.09%
SARG: Records in file: 330000, reading: 26.49%
SARG: Records in file: 335000, reading: 26.89%
SARG: Records in file: 340000, reading: 27.29%
SARG: Records in file: 345000, reading: 27.69%
SARG: Records in file: 350000, reading: 28.09%
SARG: Records in file: 355000, reading: 28.50%
SARG: Records in file: 360000, reading: 28.90%
SARG: Records in file: 365000, reading: 29.30%
SARG: Records in file: 370000, reading: 29.70%
SARG: Records in file: 375000, reading: 30.10%
SARG: Records in file: 380000, reading: 30.50%
SARG: Records in file: 385000, reading: 30.90%
SARG: Records in file: 390000, reading: 31.30%
SARG: Records in file: 395000, reading: 31.71%
SARG: Records in file: 400000, reading: 32.11%
SARG: Records in file: 405000, reading: 32.51%
SARG: Records in file: 410000, reading: 32.91%
SARG: Records in file: 415000, reading: 33.31%
SARG: Records in file: 420000, reading: 33.71%
SARG: Records in file: 425000, reading: 34.11%
SARG: Records in file: 430000, reading: 34.52%
SARG: Records in file: 435000, reading: 34.92%
SARG: Records in file: 440000, reading: 35.32%
SARG: Records in file: 445000, reading: 35.72%
SARG: Records in file: 450000, reading: 36.12%
SARG: Records in file: 455000, reading: 36.52%
SARG: Records in file: 460000, reading: 36.92%
SARG: Records in file: 465000, reading: 37.33%
SARG: Records in file: 470000, reading: 37.73%
SARG: Records in file: 475000, reading: 38.13%
SARG: Records in file: 480000, reading: 38.53%
SARG: Records in file: 485000, reading: 38.93%
SARG: Records in file: 490000, reading: 39.33%
SARG: Records in file: 495000, reading: 39.73%
SARG: Records in file: 500000, reading: 40.13%
SARG: Records in file: 505000, reading: 40.54%
SARG: Records in file: 510000, reading: 40.94%
SARG: Records in file: 515000, reading: 41.34%
SARG: Records in file: 520000, reading: 41.74%
SARG: Records in file: 525000, reading: 42.14%
SARG: Records in file: 530000, reading: 42.54%
SARG: Records in file: 535000, reading: 42.94%
SARG: Records in file: 540000, reading: 43.35%
SARG: Records in file: 545000, reading: 43.75%
SARG: Records in file: 550000, reading: 44.15%
SARG: Records in file: 555000, reading: 44.55%
SARG: Records in file: 560000, reading: 44.95%
SARG: Records in file: 565000, reading: 45.35%
SARG: Records in file: 570000, reading: 45.75%
SARG: Records in file: 575000, reading: 46.15%
SARG: Records in file: 580000, reading: 46.56%
SARG: Records in file: 585000, reading: 46.96%
SARG: Records in file: 590000, reading: 47.36%
SARG: Records in file: 595000, reading: 47.76%
SARG: Records in file: 600000, reading: 48.16%
SARG: Records in file: 605000, reading: 48.56%
SARG: Records in file: 610000, reading: 48.96%
SARG: Records in file: 615000, reading: 49.37%
SARG: Records in file: 620000, reading: 49.77%
SARG: Records in file: 625000, reading: 50.17%
SARG: Records in file: 630000, reading: 50.57%
SARG: Records in file: 635000, reading: 50.97%
SARG: Records in file: 640000, reading: 51.37%
SARG: Records in file: 645000, reading: 51.77%
SARG: Records in file: 650000, reading: 52.17%
SARG: Records in file: 655000, reading: 52.58%
SARG: Records in file: 660000, reading: 52.98%
SARG: Records in file: 665000, reading: 53.38%
SARG: Records in file: 670000, reading: 53.78%
SARG: Records in file: 675000, reading: 54.18%
SARG: Records in file: 680000, reading: 54.58%
SARG: Records in file: 685000, reading: 54.98%
SARG: Records in file: 690000, reading: 55.39%
SARG: Records in file: 695000, reading: 55.79%
SARG: Records in file: 700000, reading: 56.19%
SARG: Records in file: 705000, reading: 56.59%
SARG: Records in file: 710000, reading: 56.99%
SARG: Records in file: 715000, reading: 57.39%
SARG: Records in file: 720000, reading: 57.79%
SARG: Records in file: 725000, reading: 58.19%
SARG: Records in file: 730000, reading: 58.60%
SARG: Records in file: 735000, reading: 59.00%
SARG: Records in file: 740000, reading: 59.40%
SARG: Records in file: 745000, reading: 59.80%
SARG: Records in file: 750000, reading: 60.20%
SARG: Records in file: 755000, reading: 60.60%
SARG: Records in file: 760000, reading: 61.00%
SARG: Records in file: 765000, reading: 61.41%
SARG: Records in file: 770000, reading: 61.81%
SARG: Records in file: 775000, reading: 62.21%
SARG: Records in file: 780000, reading: 62.61%
SARG: Records in file: 785000, reading: 63.01%
SARG: Records in file: 790000, reading: 63.41%
SARG: Records in file: 795000, reading: 63.81%
SARG: Records in file: 800000, reading: 64.22%
SARG: Records in file: 805000, reading: 64.62%
SARG: Records in file: 810000, reading: 65.02%
SARG: Records in file: 815000, reading: 65.42%
SARG: Records in file: 820000, reading: 65.82%
SARG: Records in file: 825000, reading: 66.22%
SARG: Records in file: 830000, reading: 66.62%
SARG: Records in file: 835000, reading: 67.02%
SARG: Records in file: 840000, reading: 67.43%
SARG: Records in file: 845000, reading: 67.83%
SARG: Records in file: 850000, reading: 68.23%
SARG: Records in file: 855000, reading: 68.63%
SARG: Records in file: 860000, reading: 69.03%
SARG: Records in file: 865000, reading: 69.43%
SARG: Records in file: 870000, reading: 69.83%
SARG: Records in file: 875000, reading: 70.24%
SARG: Records in file: 880000, reading: 70.64%
SARG: Records in file: 885000, reading: 71.04%
SARG: Records in file: 890000, reading: 71.44%
SARG: Records in file: 895000, reading: 71.84%
SARG: Records in file: 900000, reading: 72.24%
SARG: Records in file: 905000, reading: 72.64%
SARG: Records in file: 910000, reading: 73.04%
SARG: Records in file: 915000, reading: 73.45%
SARG: Records in file: 920000, reading: 73.85%
SARG: Records in file: 925000, reading: 74.25%
SARG: Records in file: 930000, reading: 74.65%
SARG: Records in file: 935000, reading: 75.05%
SARG: Records in file: 940000, reading: 75.45%
SARG: Records in file: 945000, reading: 75.85%
SARG: Records in file: 950000, reading: 76.26%
SARG: Records in file: 955000, reading: 76.66%
SARG: Records in file: 960000, reading: 77.06%
SARG: Records in file: 965000, reading: 77.46%
SARG: Records in file: 970000, reading: 77.86%
SARG: Records in file: 975000, reading: 78.26%
SARG: Records in file: 980000, reading: 78.66%
SARG: Records in file: 985000, reading: 79.06%
SARG: Records in file: 990000, reading: 79.47%
SARG: Records in file: 995000, reading: 79.87%
SARG: Records in file: 1000000, reading: 80.27%
SARG: Records in file: 1005000, reading: 80.67%
SARG: Records in file: 1010000, reading: 81.07%
SARG: Records in file: 1015000, reading: 81.47%
SARG: Records in file: 1020000, reading: 81.87%
SARG: Records in file: 1025000, reading: 82.28%
SARG: Records in file: 1030000, reading: 82.68%
SARG: Records in file: 1035000, reading: 83.08%
SARG: Records in file: 1040000, reading: 83.48%
SARG: Records in file: 1045000, reading: 83.88%
SARG: Records in file: 1050000, reading: 84.28%
SARG: Records in file: 1055000, reading: 84.68%
SARG: Records in file: 1060000, reading: 85.09%
SARG: Records in file: 1065000, reading: 85.49%
SARG: Records in file: 1070000, reading: 85.89%
SARG: Records in file: 1075000, reading: 86.29%
SARG: Records in file: 1080000, reading: 86.69%
SARG: Records in file: 1085000, reading: 87.09%
SARG: Records in file: 1090000, reading: 87.49%
SARG: Records in file: 1095000, reading: 87.89%
SARG: Records in file: 1100000, reading: 88.30%
SARG: Records in file: 1105000, reading: 88.70%
SARG: Records in file: 1110000, reading: 89.10%
SARG: Records in file: 1115000, reading: 89.50%
SARG: Records in file: 1120000, reading: 89.90%
SARG: Records in file: 1125000, reading: 90.30%
SARG: Records in file: 1130000, reading: 90.70%
SARG: Records in file: 1135000, reading: 91.11%
SARG: Records in file: 1140000, reading: 91.51%
SARG: Records in file: 1145000, reading: 91.91%
SARG: Records in file: 1150000, reading: 92.31%
SARG: Records in file: 1155000, reading: 92.71%
SARG: Records in file: 1160000, reading: 93.11%
SARG: Records in file: 1165000, reading: 93.51%
SARG: Records in file: 1170000, reading: 93.91%
SARG: Records in file: 1175000, reading: 94.32%
SARG: Records in file: 1180000, reading: 94.72%
SARG: Records in file: 1185000, reading: 95.12%
SARG: Records in file: 1190000, reading: 95.52%
SARG: Records in file: 1195000, reading: 95.92%
SARG: Records in file: 1200000, reading: 96.32%
SARG: Records in file: 1205000, reading: 96.72%
SARG: Records in file: 1210000, reading: 97.13%
SARG: Records in file: 1215000, reading: 97.53%
SARG: Records in file: 1220000, reading: 97.93%
SARG: Records in file: 1225000, reading: 98.33%
SARG: Records in file: 1230000, reading: 98.73%
SARG: Records in file: 1235000, reading: 99.13%
SARG: Records in file: 1240000, reading: 99.53%
SARG: Records in file: 1245000, reading: 99.93%
SARG: Records read: 1245814, written: 1245814, excluded: 0
SARG: Squid log format
SARG: Period: 05 Nov 2015-22 Nov 2015
SARG: Sorting log /tmp/sarg/192_168_0_3.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_3
SARG: Sorting log /tmp/sarg/192_168_0_177.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_177
SARG: Sorting log /tmp/sarg/192_168_0_250.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_250
SARG: Sorting log /tmp/sarg/192_168_0_125.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_125
SARG: Sorting log /tmp/sarg/192_168_0_173.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_173
SARG: Sorting log /tmp/sarg/192_168_0_198.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_198
SARG: Sorting log /tmp/sarg/192_168_0_185.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_185
SARG: Sorting log /tmp/sarg/192_168_0_100.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_100
SARG: Sorting log /tmp/sarg/192_168_0_102.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_102
SARG: Sorting log /tmp/sarg/192_168_0_124.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_124
SARG: Sorting log /tmp/sarg/192_168_0_165.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_165
SARG: Sorting log /tmp/sarg/192_168_0_187.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_187
SARG: Sorting log /tmp/sarg/192_168_0_189.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_189
SARG: Sorting log /tmp/sarg/192_168_0_142.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_142
SARG: Sorting log /tmp/sarg/192_168_0_193.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_193
SARG: Sorting log /tmp/sarg/192_168_0_113.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_113
SARG: Sorting log /tmp/sarg/192_168_0_131.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_131
SARG: Sorting log /tmp/sarg/192_168_0_176.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_176
SARG: Sorting log /tmp/sarg/192_168_0_202.user_unsort
SARG: Making file: /tmp/sarg/192_168_0_202
SARG: Sorting file: /tmp/sarg/192_168_0_3.utmp
SARG: Making report: 192.168.0.3
SARG: Sorting file: /tmp/sarg/192_168_0_177.utmp
SARG: Making report: 192.168.0.177
SARG: Sorting file: /tmp/sarg/192_168_0_250.utmp
SARG: Making report: 192.168.0.250
SARG: Sorting file: /tmp/sarg/192_168_0_125.utmp
SARG: Making report: 192.168.0.125
SARG: Sorting file: /tmp/sarg/192_168_0_173.utmp
SARG: Making report: 192.168.0.173
SARG: Sorting file: /tmp/sarg/192_168_0_198.utmp
SARG: Making report: 192.168.0.198
SARG: Sorting file: /tmp/sarg/192_168_0_185.utmp
SARG: Making report: 192.168.0.185
SARG: Sorting file: /tmp/sarg/192_168_0_100.utmp
SARG: Making report: 192.168.0.100
SARG: Sorting file: /tmp/sarg/192_168_0_102.utmp
SARG: Making report: 192.168.0.102
SARG: Sorting file: /tmp/sarg/192_168_0_124.utmp
SARG: Making report: 192.168.0.124
SARG: Sorting file: /tmp/sarg/192_168_0_165.utmp
SARG: Making report: 192.168.0.165
SARG: Sorting file: /tmp/sarg/192_168_0_187.utmp
SARG: Making report: 192.168.0.187
SARG: Sorting file: /tmp/sarg/192_168_0_189.utmp
SARG: Making report: 192.168.0.189
SARG: Sorting file: /tmp/sarg/192_168_0_142.utmp
SARG: Making report: 192.168.0.142
SARG: Sorting file: /tmp/sarg/192_168_0_193.utmp
SARG: Making report: 192.168.0.193
SARG: Sorting file: /tmp/sarg/192_168_0_113.utmp
SARG: Making report: 192.168.0.113
SARG: Sorting file: /tmp/sarg/192_168_0_131.utmp
SARG: Making report: 192.168.0.131
SARG: Sorting file: /tmp/sarg/192_168_0_176.utmp
SARG: Making report: 192.168.0.176
SARG: Sorting file: /tmp/sarg/192_168_0_202.utmp
SARG: Making report: 192.168.0.202
SARG: Making index.html
SARG: The directory "/usr/local/sarg-reports/sarg-reports" looks like a report directory but doesn't contain a sarg-date file. You should delete it
SARG: Successful report generated on /usr/local/sarg-reports/05Nov2015-22Nov2015
SARG: Purging temporary file sarg-general
SARG: End
SARG: Records in file: 1245813, reading: 100.00% -
Resolveu seu problema da variavel.
Agora siga minha outra dica aí em cima, por SSH ou Prompt de Comando na WebGui:
1º - Exclui o diretório /usr/local/sarg-reports com o comando
rm -R /usr/local/sarg-reports
2º - Criei um link simbólico com o comando abaixo.
ln -s /usr/pbi/sarg-i386/local/sarg-reports /usr/local/sarg-reports
-
Antares - sp
Deu certo aqui no meu, ele aparece agora de todos os dias normalmente
fiz essa config apenas e apenas ela está ativa. Segue.
 -
Funcionou sim. Obrigado pessoal!