SARG não sem link

1. SARG não sem link

Alexandre
allx631

(usa CentOS)

Enviado em 11/12/2014 - 10:44h

Pessoal bom dia!

Configurei o squid com o sarg,ele está funcionando mas porém quando acesso pelo localhost ou pelo endereço IP dele diz que não foi encontrado.Tenho que configurar algo no apache também ou é problema no squid?


Fico no aguardo.


  


2. Re: SARG não sem link

Perfil removido
removido

(usa Nenhuma)

Enviado em 11/12/2014 - 14:59h

Configure sarg para criar sua estrutura no DocumentRoot do apache.

Ex.:

# grep output_dir /etc/sarg/sarg.conf
# TAG:  output_dir
#output_dir /var/www/html/squid-reports
output_dir /var/lib/sarg


# cp /etc/sarg/sarg.conf{,.bkp}

# sed -i 's/\#output_dir/output_dir/' /etc/sarg/sarg.conf; sed -i 's/output_dir \/var\/lib\/sarg/\#output_dir \/var\/lig\/sarg/' /etc/sarg/sarg.conf

# grep output_dir /etc/sarg/sarg.conf
# TAG:  output_dir
output_dir /var/www/html/squid-reports
#output_dir /var/lig/sarg


# sarg -x

* Acessando o relatório

http://ipounomedoservidor/squid-reports


3. Re: SARG não sem link

Alexandre
allx631

(usa CentOS)

Enviado em 11/12/2014 - 16:39h

amarildosertorio escreveu:

Configure sarg para criar sua estrutura no DocumentRoot do apache.

Ex.:

# grep output_dir /etc/sarg/sarg.conf
# TAG:  output_dir
#output_dir /var/www/html/squid-reports
output_dir /var/lib/sarg


# cp /etc/sarg/sarg.conf{,.bkp}

# sed -i 's/\#output_dir/output_dir/' /etc/sarg/sarg.conf; sed -i 's/output_dir \/var\/lib\/sarg/\#output_dir \/var\/lig\/sarg/' /etc/sarg/sarg.conf

# grep output_dir /etc/sarg/sarg.conf
# TAG:  output_dir
output_dir /var/www/html/squid-reports
#output_dir /var/lig/sarg


# sarg -x

* Acessando o relatório

http://ipounomedoservidor/squid-reports



Fiz conforme foi solicitado mas o link continua inativo =/

Vou colar as configurações. ACho que posso ter feito algo errado.


# sarg.conf
#
# TAG: access_log file
# Where is the access.log file
# sarg -l file
#
access_log /var/logs/squid/access.log

# TAG: graphs yes|no
# Use graphics where is possible.
# graph_days_bytes_bar_color blue|green|yellow|orange|brown|red
#
graphs yes
graph_days_bytes_bar_color orange

# TAG: graph_font
# The full path to the TTF font file to use to create the graphs. It is required
# if graphs is set to yes.
#
graph_font /usr/share/fonts/truetype/ttf-dejavu/DejaVuSans.ttf

# TAG: title
# Especify the title for html page.
#
title "Relatório"

# TAG: font_face
# Especify the font for html page.
#
font_face Tahoma,Verdana,Arial

# TAG: header_color
# Especify the header color
#
header_color darkblue

# TAG: header_bgcolor
# Especify the header bgcolor
#
header_bgcolor blanchedalmond

# TAG: font_size
# Especify the text font size
#
font_size 9px

# TAG: header_font_size
# Especify the header font size
#
header_font_size 9px

# TAG: title_font_size
# Especify the title font size
#
title_font_size 11px

# TAG: background_color
# TAG: background_color
# Html page background color
#
background_color white

# TAG: text_color
# Html page text color
#
text_color #000000

# TAG: text_bgcolor
# Html page text background color
#
text_bgcolor lavender

# TAG: title_color
# Html page title color
#
title_color green

# TAG: logo_image
# Html page logo.
#
logo_image none

# TAG: logo_text
# Html page logo text.
#
#logo_text ""

# TAG: logo_text_color
# Html page logo texti color.
#
#logo_text_color #000000

# TAG: logo_image_size
# Html page logo image size.
# width height
#
#image_size 80 45

# TAG: background_image
# Html page background image



# TAG: background_image
# Html page background image
#
#background_image none

# TAG: password
# User password file used by Squid authentication scheme
# If used, generate reports just for that users.
#
#password none

# TAG: temporary_dir
# Temporary directory name for work files
# sarg -w dir
#
temporary_dir /tmp

# TAG: output_dir
# The reports will be saved in that directory
# sarg -o dir
#
#output_dir /var/lib/sarg
output_dir /var/www/html/sarg

# TAG: anonymous_output_files yes/no
# Use anonymous file and directory names in the report. If it is set to
# no (the default), the user id/ip/name is slightly mangled to create a
# suitable file name to store the report of the user but the user's
# identity can easily be guessed from the mangled name. If this option is
# set, any file or directory belonging to the user is replaced by a short
# number. The purpose is to hide the identity of the user when looking
# at the report file names but it may serve to shorten the path too.
#
#anonymous_output_files no


# TAG: output_email
# Email address to send the reports. If you use this tag, no html reports will be generated.
# sarg -e email
#
#output_email

# TAG: resolve_ip modulelist
# List the modules to use to convert IP addresses into names.
# Each named module is tried in sequence until one returns a result. Therefore
# the order of the modules is relevant.
# The modules must be listed on one line each separated from the previous one with
# a space.
#
# The possible modules are
# dns Use the DNS.
# exec Call an external program with the IP address as argument.
#
# For compatibility with previous versions, yes is a synonymous for dns and
# no does nothing.
# sarg -n forces the use of the dns module.
resolve_ip yes


# TAG: resolve_ip_exec command
# If resolve_ip selects the exec module, this is the command to run to
# resolve an IP address. The command must contain a placeholder where the
# IP address is inserted. The placeholder must be %IP in uppercases. The
# placeholder may be repeated multiple times if necessary.
#
# The command is expected to return the host name without frills on its
# standard output. If the command returns nothing, it is assumed that the
# command could not resolve the IP address and the next module in the
# chain is given a try with the same address.
#
# This option can only be used once. Therefore there is only one command
# available to resolve an IP address but the program can do anything it
# deems fit including attempting several strategies.
#
# Beware that running an external program is exceedingly slow. So you
# should try the DNS first and only call an external program if the DNS
# fails.
#resolve_ip_exec nmblookup -A %IP | sed -n -e 's/^ *\(.*\) *<00> - *B.*/\1/p'

# TAG: user_ip yes/no
# Use Ip Address instead userid in reports.
# sarg -p
user_ip no

# TAG: topuser_sort_field field normal/reverse
# Sort field for the Topuser Report.
# Allowed fields: USER CONNECT BYTES TIME
#
topuser_sort_field BYTES reverse

# TAG: user_sort_field field normal/reverse
# Sort field for the User Report.
# Allowed fields: SITE CONNECT BYTES TIME
#
user_sort_field BYTES reverse

# TAG: exclude_users file
# users within the file will be excluded from reports.
# you can use indexonly to have only index.html file.
#
#exclude_users /etc/sarg/exclude_users

# TAG: exclude_hosts file
# Hosts, domains or subnets will be excluded from reports.
#
# Eg.: 192.168.10.10 - exclude ip address only
# 192.168.10.0/24 - exclude full C class
# s1.acme.foo - exclude hostname only
# *.acme.foo - exclude full domain name
#
exclude_hosts /etc/sarg/exclude_hosts

# TAG: useragent_log file
# useragent.log file patch to generate useragent report.
#
#useragent_log none

# TAG: date_format
# Date format in reports: e (European=dd/mm/yy), u (American=mm/dd/yy), w (Weekly=yy.ww)
#
date_format e

# TAG: per_user_limit file MB
# Saves userid on file if download exceed n MB.
# This option allow you to disable user access if user exceed a download limit.
#
#per_user_limit none

# TAG: lastlog n
# How many reports files must be keept in reports directory.
# The oldest report file will be automatically removed.
# 0 - no limit.
#
lastlog 0


# TAG: remove_temp_files yes
# Remove temporary files: geral, usuarios, top, periodo from root report directory.
#
remove_temp_files yes

# TAG: index yes|no|only
# Generate the main index.html.
# only - generate only the main index.html
#
index yes

# TAG: index_tree date|file
# How to generate the index.
#
index_tree file

# TAG: index_fields
# The columns to show in the index of the reports
# Columns are: dirsize
#
#index_fields dirsize

# TAG: overwrite_report yes|no
# yes - if report date already exist then will be overwrited.
# no - if report date already exist then will be renamed to filename.n, filename.n+1
#
overwrite_report yes

# TAG: records_without_userid ignore|ip|everybody
# What can I do with records without user id (no authentication) in access.log file ?
#
# ignore - This record will be ignored.
# ip - Use ip address instead. (default)
# everybody - Use "everybody" instead.
#
records_without_userid ip

# TAG: use_comma no|yes
# Use comma instead point in reports.
# Eg.: use_comma yes => 23,450,110
# use_comma no => 23.450.110
#
use_comma yes

# TAG: mail_utility
# Mail command to use to send reports via SMTP. Sarg calls it like this:
# mail_utility -s "SARG report, date" "output_email" <"mail_content"
#
# Therefore, it is possible to add more arguments to the command by specifying them
# here.
#
# If you need too, you can use a shell script to process the content of /dev/stdin
# (/dev/stdin is the mail_content passed by sarg to the script) and call whatever
# command you like. It is not limited to mailing the report via SMTP.
#
# Don't forget to quote the command if necessary (i.e. if the path contains
# characters that must be quoted).
#
mail_utility mailx

# TAG: topsites_num n
# How many sites in topsites report.
#
topsites_num 200

# TAG: topsites_sort_order CONNECT|BYTES|TIME|USER A|D
# Sort for topsites report, where A=Ascendent, D=Descendent
#
topsites_sort_order CONNECT D

# TAG: index_sort_order A/D
# Sort for index.html, where A=Ascendent, D=Descendent
#
index_sort_order D

# TAG: exclude_codes file
# Ignore records with these codes. Eg.: NONE/400
# Write one code per line. Lines starting with a # are ignored.
# Only codes matching exactly one of the line is rejected. The
# comparison is not case sensitive.
#
exclude_codes /etc/sarg/exclude_codes

# TAG: replace_index string
# Replace "index.html" in the main index file with this string
# If null "index.html" is used
#
#replace_index <?php echo str_replace(".", "_", $REMOTE_ADDR); echo ".html"; ?>

# TAG: max_elapsed milliseconds
# If elapsed time is recorded in log is greater than max_elapsed use 0 for elapsed time.
# Use 0 for no checking
#
max_elapsed 28800000
# 8 Hours

# TAG: report_type type
# What kind of reports to generate.
# topusers - users, sites, times, bytes, connects, links to accessed sites, etc
# topsites - site, connect and bytes report
# sites_users - users and sites report
# users_sites - accessed sites by the user report
# date_time - bytes used per day and hour report
# denied - denied sites with full URL report
# auth_failures - autentication failures report
# site_user_time_date - sites, dates, times and bytes report
# downloads - downloads per user report
#
# Eg.: report_type topsites denied

#report_type topusers topsites sites_users users_sites date_time denied auth_failures site_user_time_date downloads

# TAG: usertab filename
# You can change the "userid" or the "ip address" to be a real user name on the reports.
# If resolve_ip is active, the ip address is resolved before being looked up into this
# file. That is, if you want to map the ip address, be sure to set resolv_ip to no or
# the resolved name will be looked into the file instead of the ip address. Note that
# it can be used to resolve any ip address known to the dns and then map the unresolved
# ip addresses to a name found in the usertab file.
# Table syntax:
# userid name or ip address name
# Eg:
# SirIsaac Isaac Newton
# vinci Leonardo da Vinci
# 192.168.10.1 Karol Wojtyla
#
# Each line must be terminated with '\n'
# If usertab have value "ldap" (case ignoring), user names
# will be taken from LDAP server. This method as approaches for reception
# of usernames from Active Didectory
#
usertab /etc/sarg/usertab

# TAG: LDAPHost hostname
# FQDN or IP address of host with LDAP service or AD DC
# default is '127.0.0.1'
#LDAPHost 127.0.0.1

# TAG: LDAPPort port
# LDAP service port number
# default is '389'
#LDAPPort 389

# TAG: LDAPBindDN CN=username,OU=group,DC=mydomain,DC=com
# DN of LDAP user, who is authorized to read user's names from LDAP base
# default is empty line
#LDAPBindDN cn=proxy,dc=mydomain,dc=local

# TAG: LDAPBindPW secret
# Password of DN, who is authorized to read user's names from LDAP base
# default is empty line
#LDAPBindPW secret

# TAG: LDAPBaseSearch OU=users,DC=mydomain,DC=com
# LDAP search base
# default is empty line
#LDAPBaseSearch ou=users,dc=mydomain,dc=local

# TAG: LDAPFilterSearch (uid=%s)
# User search filter by user's logins in LDAP
# First founded record will be used
# %s - will be changed to userlogins from access.log file
# filter string can have up to 5 '%s' tags
# default value is '(uid=%s)'
#LDAPFilterSearch (uid=%s)

# TAG: LDAPTargetAttr attributename
# Name of the attribute containing a name of the user
# default value is 'cn'
#LDAPTargetAttr cn

# TAG: long_url yes|no
# If yes, the full url is showed in report.
# If no, only the site will be showed
#
# YES option generate very big sort files and reports.
#
#long_url no

# TAG: date_time_by bytes|elap
# Date/Time reports show the downloaded volume or the elapsed time or both.
#
#date_time_by bytes

# TAG: charset name

# ISO 8859 is a full series of 10 standardized multilingual single-byte coded (8bit)
# graphic character sets for writing in alphabetic languages
# You can use the following charsets:
# Latin1 - West European
# Latin2 - East European
# Latin3 - South European
# Latin4 - North European
# Cyrillic
# Arabic
# Greek
# Hebrew
# Latin5 - Turkish
# Latin6
# Windows-1251
# Japan
# Koi8-r
# UTF-8
#
charset Latin1

# TAG: user_invalid_char "&/"
# Records that contain invalid characters in userid will be ignored by Sarg.
#
#user_invalid_char "&/"

# TAG: privacy yes|no
# privacy_string "***.***.***.***"
# privacy_string_color blue
# In some countries the sysadm cannot see the visited sites by a restrictive law.
# Using privacy yes the visited url will be changes by privacy_string and the link
# will be removed from reports.
#
#privacy no
#privacy_string "***.***.***.***"
#privacy_string_color blue

# TAG: include_users "user1:user2:...:usern"
# Reports will be generated only for listed users

#
#include_users none

# TAG: exclude_string "string1:string2:...:stringn"
# Records from access.log file that contain one of listed strings will be ignored.
#
#exclude_string none

# TAG: show_successful_message yes|no
# Shows "Successful report generated on dir" at end of process.
#
show_successful_message no

# TAG: show_read_statistics yes|no
# Shows some reading statistics.
#
show_read_statistics yes

# TAG: topuser_fields
# Which fields must be in Topuser report.
#
topuser_fields NUM DATE_TIME USERID CONNECT BYTES %BYTES IN-CACHE-OUT USED_TIME MILISEC %TIME TOTAL AVERAGE

# TAG: user_report_fields
# Which fields must be in User report.
#
user_report_fields CONNECT BYTES %BYTES IN-CACHE-OUT USED_TIME MILISEC %TIME TOTAL AVERAGE

# TAG: bytes_in_sites_users_report yes|no
# Bytes field must be in Site & Users Report ?
#
#bytes_in_sites_users_report no

# TAG: topuser_num n
# How many users in topsites report. 0 = no limit
#
#topuser_num 0

# TAG: datafile file
# Save the report results in a file to populate some database
#
#datafile none

# TAG: datafile_delimiter ";"
# ascii character to use as a field separator in datafile
#
#datafile_delimiter ";"

# TAG: datafile_fields all
# Which data fields must be in datafile
# user;date;time;url;connect;bytes;in_cache;out_cache;elapsed
#
#datafile_fields user;date;time;url;connect;bytes;in_cache;out_cache;elapsed

# TAG: datafile_url ip|name
# Saves the URL as ip or name in datafile
#
#datafile_url ip

# TAG: weekdays
# The weekdays to take into account ( Sunday->0, Saturday->6 )
# Example:
#weekdays 1-3,5
# Default:
#weekdays 0-6

# TAG: hours
# The hours to take into account
# Example:
#hours 7-12,14,16,18-20
# Default:
#hours 0-23

# TAG: dansguardian_conf file
# DansGuardian.conf file path

# Generate reports from DansGuardian logs.
# Use 'none' to disable it.
# dansguardian_conf /usr/dansguardian/dansguardian.conf
#
#dansguardian_conf none

# TAG: dansguardian_filter_out_date on|off
# This option replaces dansguardian_ignore_date whose name was not appropriate with respect to its action.
# Note the change of parameter value compared with the old option.
# 'off' use the record even if its date is outside of the range found in the input log file.
# 'on' use the record only if its date is in the range found in the input log file.
#
#dansguardian_filter_out_date on

# TAG: squidguard_conf file
# path to squidGuard.conf file
# Generate reports from SquidGuard logs.
# Use 'none' to disable.
# You can use sarg -L filename to use an alternate squidGuard log.
# squidguard_conf /usr/local/squidGuard/squidGuard.conf
#
#squidguard_conf none

# TAG: redirector_log file
# the location of the web proxy redirector log such as one created by squidGuard or Rejik. The option
# may be repeated up to 64 times to read multiple files.
# If this option is specified, it takes precedence over squidguard_conf.
# The command line option -L override this option.
#
#redirector_log /usr/local/squidGuard/var/logs/urls.log

# TAG: redirector_filter_out_date on|off
# This option replaces squidguard_ignore_date and redirector_ignore_date whose names were not
# appropriate with respect to their action.
# Note the change of parameter value compared with the old options.
# 'off' use the record even if its date is outside of the range found in the input log file.
# 'on' use the record only if its date is in the range found in the input log file.
#


Agora indo direto onde configurei.



# TAG: show_sarg_info yes|no
# shows sarg information and site path on each report bottom
#
show_sarg_info yes

# TAG: show_sarg_logo yes|no
# shows sarg logo
#
show_sarg_logo yes



# TAG: www_document_root dir
# Where is your Web DocumentRoot
# Sarg will create sarg-php directory with some PHP modules:
# - sarg-squidguard-block.php - add urls from user reports to squidGuard DB
#
#www_document_root /var/www/html

# TAG: block_it module_url
# This tag allow you to pass urls from user reports to a cgi or php module,
# to be blocked by some Squid acl
#
# Eg.: block_it /sarg-php/sarg-block-it.php
# sarg-block-it is a php that will append a url to a flat file.
# You must change /var/www/html/sarg-php/sarg-block-it to point to your file
# in $filename variable, and chown to a httpd owner.
#
# sarg will pass http://module_url?url=url
#
#block_it none


# TAG: realtime_access_log_lines num
# How many last lines to get from access.log file
#
realtime_access_log_lines 1000


#TAG: output_dir
output_dir /var/www/html/sarg
output_dir /var/lib/sarg

cp /etc/sarg/sarg.conf {.,bkp}
sed -i 's/\#output_dir/' /etc/sarg/sarg.conf; sed -i 's/output_dir \/var\/lib\/sarg/\ #output_dir \/var\/lib\/sarg/' /etc/sarg/sarg.conf
grep output_dir /etc/sarg/sarg.conf

output_dir /var/www/html/sarg

output_dir /var/lig/sarg



E é isso será que fiz certo ou errei gravemente em algo?








4. Re: SARG não sem link

Perfil removido
removido

(usa Nenhuma)

Enviado em 11/12/2014 - 16:53h

"output_dir /var/lig/sarg" deve está comentado.

É CentOS?
Quando você roda o "sarg -x" a estrutura é criada no diretório /var/www/html/sarg?
Quando você acessa "http://ipounomedoservidor/sarg" está dando erro ou acesso negado?

Caso esteja dando negado verifique o contexto SELinux dos arquivos gerado pelo sarg ou deixe em modo permissive.

* Verificando SELinux e contexto

# sestatus

# ls -lZ /var/www/html/sarg


5. Re: SARG não sem link

Alexandre
allx631

(usa CentOS)

Enviado em 11/12/2014 - 16:57h

Ele não chega a dar negado ele diz que não foi encontrado. O webmin está ok.


6. Re: SARG não sem link

Perfil removido
removido

(usa Nenhuma)

Enviado em 12/12/2014 - 10:04h

allx631 escreveu:

Ele não chega a dar negado ele diz que não foi encontrado. O webmin está ok.


Executa ai amigo. Posta o resultado.

# sarg -x
# ls -l /var/www/html/sarg






Patrocínio

Site hospedado pelo provedor RedeHost.
Linux banner

Destaques

Artigos

Dicas

Tópicos

Top 10 do mês

Scripts