Sarg não agrega os hostalias



  • Olá.
    Tenho um pfSense 2.2.2 com squid e squidguard. Gero os relatórios do sarg pelos logs do squid. Tudo funciona ok, nenhum erro é apresentado! Entretanto nos relatórios não é feita a agregação de urls configurada no hostalias do sarg!
    Gostaria de um help de v6 para regularizar essa questão.
    Segue a saída do comando sarg com o debug ativado:

    
    [2.2.2-RELEASE][root@pfSense]/root: sarg -f /usr/pbi/sarg-amd64/etc/sarg/sarg.conf -x
    SARG: Init
    SARG: Loading configuration from /usr/pbi/sarg-amd64/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:   *webmail.kinghost.com.br => *Webmail
    SARG:   *webmail.kinghost.com.br:443 => *Webmail
    SARG:   *.google.com => *Google
    SARG:   *.google.com:443 => *Google
    SARG:   *.google.com.br => *Google
    SARG:   *.google.com.br:443 => *Google
    SARG:   *.gstatic.com => *Google
    SARG:   *.gstatic.com:443 => *Google
    SARG:   *.ytimg.com => *Google
    SARG:   *.ytimg.com:443 => *Google
    SARG:   *.googleadservices.com => *Google
    SARG:   *.googleadservices.com:443 => *Google
    SARG:   *.google-analytics.com => *Google
    SARG:   *.google-analytics.com:443 => *Google
    SARG:   *.facebook.com => *Facebook
    SARG:   *.facebook.com:443 => *Facebook
    SARG:   *.facebook.net => *Facebook
    SARG:   *.facebook.net:443 => *Facebook
    SARG:   *.microsoft.com => *Microsoft
    SARG:   *.microsoft.com:443 => *Microsoft
    SARG:   *.caixa.gov.br => *Caixa_Economica
    SARG:   *.caixa.gov.br:443 => *Caixa_Economica
    SARG:   *.bradesco.com.br => *Bradesco
    SARG:   *.bradesco.com.br:443 => *Bradesco
    SARG:   *.itau.com.br => *Itau
    SARG:   *.itau.com.br:443 => *Itau
    SARG:   *.bb.com.br => *Banco_Brasil
    SARG:   *.bb.com.br:443 => *Banco_Brasil
    SARG:   *.bancobrasil.com.br => *Banco_Brasil
    SARG:   *.bancobrasil.com.br:443 => *Banco_Brasil
    SARG:   *.globo.com => *Glogo
    SARG:   *.globo.com:443 => *Glogo
    SARG:   *.globo.com.br => *Globo
    SARG:   *.globo.com.br:443 => *Globo
    SARG:   *.g1.com => *Globo
    SARG:   *.g1.com:443 => *Globo
    SARG:   *.g1.com.br => *Globo
    SARG:   *.g1.com.br:443 => *Globo
    SARG:   *.glbimg.com => *Globo
    SARG:   *.glbimg.com:443 => *Globo
    SARG:   *.upx.net.br => **.upx.net.br
    SARG:   *.suafranquia.com => **.suafranquia.com
    SARG:   *.mozilla.net => *Mozilla
    SARG:   *.mozilla.net:443 => *Mozilla
    SARG:   *.mozilla.org => *Mozilla
    SARG:   *.mozilla.org:443 => *Mozilla
    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/pbi/sarg-amd64/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) = 30
    SARG:
    SARG: sarg version: 2.3.9 Sep-21-2014
    SARG: Reading access log file: /var/squid/logs/access.log
    SARG: Records in file: 9868242, reading: 100.00%
    SARG:    Records read: 9869876, written: 9869876, excluded: 0
    SARG: Squid log format
    SARG: Period: 28 May 2015-25 Jun 2015
    SARG: Sorting log /tmp/sarg/192_168_25_2.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_2
    SARG: Sorting log /tmp/sarg/suporte.user_unsort
    SARG: Making file: /tmp/sarg/suporte
    SARG: Sorting log /tmp/sarg/teste.user_unsort
    SARG: Making file: /tmp/sarg/teste
    SARG: Sorting log /tmp/sarg/192_168_25_14.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_14
    SARG: Sorting log /tmp/sarg/192_168_25_100.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_100
    SARG: Sorting log /tmp/sarg/camila.user_unsort
    SARG: Making file: /tmp/sarg/camila
    SARG: Sorting log /tmp/sarg/hebert.user_unsort
    SARG: Making file: /tmp/sarg/hebert
    SARG: Sorting log /tmp/sarg/marcio.user_unsort
    SARG: Making file: /tmp/sarg/marcio
    SARG: Sorting log /tmp/sarg/clodoaldo.user_unsort
    SARG: Making file: /tmp/sarg/clodoaldo
    SARG: Sorting log /tmp/sarg/valdiney.user_unsort
    SARG: Making file: /tmp/sarg/valdiney
    SARG: Sorting log /tmp/sarg/simone.user_unsort
    SARG: Making file: /tmp/sarg/simone
    SARG: Sorting log /tmp/sarg/andrey.user_unsort
    SARG: Making file: /tmp/sarg/andrey
    SARG: Sorting log /tmp/sarg/henrique.user_unsort
    SARG: Making file: /tmp/sarg/henrique
    SARG: Sorting log /tmp/sarg/192_168_25_18.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_18
    SARG: Sorting log /tmp/sarg/camil.user_unsort
    SARG: Making file: /tmp/sarg/camil
    SARG: Sorting log /tmp/sarg/192_168_25_20.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_20
    SARG: Sorting log /tmp/sarg/192_168_25_17.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_17
    SARG: Sorting log /tmp/sarg/ventura.user_unsort
    SARG: Making file: /tmp/sarg/ventura
    SARG: Sorting log /tmp/sarg/marcio_safe.user_unsort
    SARG: Making file: /tmp/sarg/marcio_safe
    SARG: Sorting log /tmp/sarg/mar.user_unsort
    SARG: Making file: /tmp/sarg/mar
    SARG: Sorting log /tmp/sarg/192_168_25_21.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_21
    SARG: Sorting log /tmp/sarg/192_168_25_23.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_23
    SARG: Sorting log /tmp/sarg/192_168_25_24.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_24
    SARG: Sorting log /tmp/sarg/192_168_25_110.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_110
    SARG: Sorting log /tmp/sarg/glauber.user_unsort
    SARG: Making file: /tmp/sarg/glauber
    SARG: Sorting log /tmp/sarg/192_168_25_25.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_25
    SARG: Sorting log /tmp/sarg/192_168_25_26.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_26
    SARG: Sorting log /tmp/sarg/none.user_unsort
    SARG: Making file: /tmp/sarg/none
    SARG: Sorting log /tmp/sarg/192_168_25_27.user_unsort
    SARG: Making file: /tmp/sarg/192_168_25_27
    SARG: Sorting file: /tmp/sarg/teste.utmp
    SARG: Making report: teste
    SARG: Sorting file: /tmp/sarg/192_168_25_14.utmp
    SARG: Making report: 192.168.25.14
    SARG: Sorting file: /tmp/sarg/192_168_25_100.utmp
    SARG: Making report: 192.168.25.100
    SARG: Sorting file: /tmp/sarg/camila.utmp
    SARG: Making report: camila
    SARG: Sorting file: /tmp/sarg/hebert.utmp
    SARG: Making report: hebert
    SARG: Sorting file: /tmp/sarg/marcio.utmp
    SARG: Making report: marcio
    SARG: Sorting file: /tmp/sarg/clodoaldo.utmp
    SARG: Making report: clodoaldo
    SARG: Sorting file: /tmp/sarg/valdiney.utmp
    SARG: Making report: valdiney
    SARG: Sorting file: /tmp/sarg/simone.utmp
    SARG: Making report: simone
    SARG: Sorting file: /tmp/sarg/andrey.utmp
    SARG: Making report: andrey
    SARG: Sorting file: /tmp/sarg/henrique.utmp
    SARG: Making report: henrique
    SARG: Sorting file: /tmp/sarg/192_168_25_18.utmp
    SARG: Making report: 192.168.25.18
    SARG: Sorting file: /tmp/sarg/192_168_25_20.utmp
    SARG: Making report: 192.168.25.20
    SARG: Sorting file: /tmp/sarg/192_168_25_17.utmp
    SARG: Making report: 192.168.25.17
    SARG: Sorting file: /tmp/sarg/192_168_25_21.utmp
    SARG: Making report: 192.168.25.21
    SARG: Sorting file: /tmp/sarg/192_168_25_110.utmp
    SARG: Making report: 192.168.25.110
    SARG: Sorting file: /tmp/sarg/glauber.utmp
    SARG: Making report: glauber
    SARG: Sorting file: /tmp/sarg/192_168_25_26.utmp
    SARG: Making report: 192.168.25.26
    SARG: Sorting file: /tmp/sarg/192_168_25_27.utmp
    SARG: Making report: 192.168.25.27
    SARG: No old reports to delete as only 15 reports currently exists
    SARG: Making index.html
    SARG: Successful report generated on /usr/local/sarg-reports/28May2015-25Jun2015
    SARG: Purging temporary file sarg-general
    SARG: End
    
    

Log in to reply