Добрый день!
Никак не могу найти причину, не отображается сттатистика по пользователям в sams, вообще нет никакой статистики. Я так понимаю в базе данных squidlog, в таблицах должны бвть записи по логам, но все таблицы пустые.
В web-панеле sams используется nsca авторизация.
Конфиг squid.conf
# created by SAMS _sams_ 2010-10-27 14:26:20
auth_param basic program /usr/lib/squid/ncsa_auth /etc/squid/ncsa.sams
auth_param basic children 5
auth_param basic realm Squid proxy-caching web server
auth_param basic credentialsttl 2 hours
acl all src all
acl manager proto cache_object
acl localhost src 127.0.0.1/32
acl to_localhost dst 127.0.0.0/8
acl main proxy_auth REQUIRED
acl SSL_ports port 443 # https
acl SSL_ports port 563 # snews
acl SSL_ports port 873 # rsync
acl SSL_ports port 8000 # mmk Samohin
acl SSL_ports port 22 # SSH
acl Safe_ports port 80 # http
acl Safe_ports port 21 # ftp
acl Safe_ports port 22 # SSH
acl Safe_ports port 443 # https
acl Safe_ports port 70 # gopher
acl Safe_ports port 210 # wais
acl Safe_ports port 1025-65535 # unregistered ports
acl Safe_ports port 280 # http-mgmt
acl Safe_ports port 488 # gss-http
acl Safe_ports port 591 # filemaker
acl Safe_ports port 777 # multiling http
acl Safe_ports port 631 # cups
acl Safe_ports port 873 # rsync
acl Safe_ports port 901 # SWAT
acl Safe_ports port 8000 # mmk (Samohin)
acl purge method PURGE
acl CONNECT method CONNECT
http_access allow manager localhost
http_access deny manager
http_access allow purge localhost
http_access deny purge
http_access deny !Safe_ports
http_access deny CONNECT !SSL_ports
http_access allow localhost
http_access allow main
http_access deny all
icp_access deny all
http_port 192.168.0.2:3128
hierarchy_stoplist cgi-bin ?
cache_mem 64 MB
cache_dir ufs /var/spool/squid 2048 16 256
minimum_object_size 0 KB
maximum_object_size 4096 KB
access_log /var/log/squid/access.log squid
refresh_pattern ^ftp: 1440 20% 10080
refresh_pattern ^gopher: 1440 0% 1440
refresh_pattern -i (/cgi-bin/|?) 0 0% 0
refresh_pattern (Release|Package(.gz)*)$ 0 20% 2880
refresh_pattern . 0 20% 4320
acl shoutcast rep_header X-HTTP09-First-Line ^ICYs[0-9]
upgrade_http0.9 deny shoutcast
acl apache rep_header Server ^Apache
broken_vary_encoding allow apache
extension_methods REPORT MERGE MKACTIVITY CHECKOUT
visible_hostname localproxy
hosts_file /etc/hosts
coredump_dir /var/spool/squid
Конфиг sams.conf
[client]
SQUID_DB=squidlog
SAMS_DB=squidctrl
MYSQLHOSTNAME=localhost
MYSQLUSER=sams
MYSQLPASSWORD=qwerty
MYSQLVERSION=4.0
SQUIDCACHEFILE=access.log
SQUIDROOTDIR=/etc/squid
SQUIDLOGDIR=/var/log/squid
SQUIDCACHEDIR=/var/spool/squid
SAMSPATH=/usr
SQUIDPATH=/usr/sbin
SQUIDGUARDLOGPATH=/var/log
SQUIDGUARDDBPATH=/etc/squid
RECODECOMMAND=iconv -f KOI8-R -t 866 %finp > %fout
LDAPSERVER=servername_or_ipadress
LDAPBASEDN=your.domain
LDAPUSER=DomainAdministrator
LDAPUSERPASSWD=passwd
LDAPUSERSGROUP=Users
REJIKPATH=/usr/local/rejik
SHUTDOWNCOMMAND=shutdown -h now
CACHENUM=0
Лог /var/log/squid/cache.log
2010/10/27 15:04:47| Reconfiguring Squid Cache (version 2.7.STABLE6)...
2010/10/27 15:04:47| FD 19 Closing HTTP connection
2010/10/27 15:04:47| FD 20 Closing ICP connection
2010/10/27 15:04:47| Closing unlinkd pipe on FD 17
2010/10/27 15:04:47| logfileClose: closing log /var/log/squid/store.log
2010/10/27 15:04:47| logfileClose: closing log /var/log/squid/access.log
2010/10/27 15:04:47| Including Configuration File: /etc/squid/squid.conf (depth 0)
2010/10/27 15:04:47| Cache dir '/var/spool/squid' size remains unchanged at 2097152 KB
2010/10/27 15:04:47| logfileOpen: opening log /var/log/squid/access.log
2010/10/27 15:04:47| logfileOpen: opening log /var/log/squid/store.log
2010/10/27 15:04:47| User-Agent logging is disabled.
2010/10/27 15:04:47| Referer logging is disabled.
2010/10/27 15:04:47| DNS Socket created at 0.0.0.0, port 42102, FD 9
2010/10/27 15:04:47| Adding nameserver 62.165.33.250 from /etc/resolv.conf
2010/10/27 15:04:47| Adding nameserver 62.165.32.250 from /etc/resolv.conf
2010/10/27 15:04:47| helperOpenServers: Starting 5 'ncsa_auth' processes
2010/10/27 15:04:47| Unlinkd pipe opened on FD 18
2010/10/27 15:04:47| Accepting proxy HTTP connections at 192.168.0.2, port 3128, FD 16.
2010/10/27 15:04:47| Accepting ICP messages at 0.0.0.0, port 3130, FD 17.
2010/10/27 15:04:47| HTCP Disabled.
2010/10/27 15:04:47| WCCP Disabled.
2010/10/27 15:04:47| Loaded Icons.
2010/10/27 15:04:47| Ready to serve requests.
Пользователь решил продолжить мысль 27 Октября 2010, 13:45:49:
Если кто может, скиньте конфиг squid.conf с минимальными настроками для работы с sams
Тема: Sams не отображается статистика (Прочитано 1778 раз)
