Forum Debian Users Gang

adams12 · 2007-05-16 13:52:41

Witam mam taki problem (debian stable etch), mam skonfigurowanego sqida jak podłączam jako program pomocniczy squidguarda to cały system wariuje (wiesza sie 100% wykorzystuje procesor i produkuje jakieś pliki /var/tmp ze nawet po godzinie pracy 2 GB ) i nie wiem co jest grane wcześniej dobrze działało??

Proszę o pomoc

konfiguracja squida

#porty
http_port 8080
icp_port 3128

#dolne ograniczenie pamieci dla squida
cache_mem 16 MB

#100 oznacza ze squid uzyje 100MB przestrzeni dyskowej
cache_dir ufs /var/spool/squid 250 16 256

cache_log /var/log/squid/cache.log
cache_access_log /var/log/squid/access.log
cache_store_log /var/log/squid/store.log
cache_swap_log /var/log/squid/swap.log
#ile razy rotowac logi przed usunieciem
logfile_rotate 10

redirect_rewrites_host_header off
cache_replacement_policy GDSF
acl localnet src 192.168.0.0/255.255.255.0
acl localhost src 192.168.0.0/255.255.255.255
acl Safe_ports port 80 442 210 119 70 20 21 1025-65535
acl CONNECT method CONNECT
acl all src 0.0.0.0/0.0.0.0
http_access allow localnet
http_access allow localhost
http_access deny !Safe_ports
http_access deny CONNECT
http_access deny all
maximum_object_size 3000 KB
store_avg_object_size 50 KB

redirect_program /usr/bin/squidGuard -c /etc/squid/squidGuard.conf

Konfiguracja sguidguard

dbhome /var/lib/squidguard/db
logdir /var/log/squid

dest ads {
domainlist ads/domains
urllist ads/urls
}
dest aggressive {
domainlist aggressive/domains
urllist aggressive/urls
}
dest audio-video {
domainlist audio-video/domains
urllist audio-video/urls
}
dest drugs {
domainlist drugs/domains
urllist drugs/urls
}
dest gambling {
domainlist gambling/domains
urllist gambling/urls
}
dest hacking {
domainlist hacking/domains
urllist hacking/urls
}
dest mail {
domainlist mail/domains
}
dest porn {
domainlist porn/domains
urllist porn/urls
expressionlist porn/expressions
log anonymous porn.log
}
dest proxy {
domainlist proxy/domains
urllist proxy/urls
}
dest violence {
domainlist violence/domains
urllist violence/urls
expressionlist violence/expressions
}

src admin_pc {
ip 192.168.0.18
ip 192.168.0.17
ip 192.168.0.100
}

#acl {
# default {
# pass !ads none
# }
#}

#GLOWNA sekcja filtrowania ruchu
acl {

default {
pass !ads !porn !drugs !gambling !aggressive !audio-video !hacking any
redirect http://localhost/sgblock.php?clientaddr=%a&clientname=%n&clientuser=%i&clientgroup=%s&targetgroup=general_blocking&url=%u
log squidGuardStrony.log

}
admin_pc {
pass all
}

}

kayo · 2007-05-22 18:21:00

squidguard indeksuje sobie bazę danych URLi. Czas indeksacji jest uzależniony od wielkości blacklisty i oczywiście sprzętu. W czasie tego procesu jest wykorzystywana pełna moc procesora, a caly system sprawia wrażenie jakby wisiał. Po pewnym czasie jest już wszystko ok.

Time (s)	Query
0.00013	SET CHARSET latin2
0.00005	SET NAMES latin2
0.00127	SELECT u., g., o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='18.224.29.201' WHERE u.id=1
0.00097	UPDATE punbb_online SET logged=1716166011 WHERE ident='18.224.29.201'
0.00058	SELECT * FROM punbb_online WHERE logged<1716165711
0.00060	SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=7991 AND t.moved_to IS NULL
0.00006	SELECT search_for, replace_with FROM punbb_censoring
0.00110	SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=7991 ORDER BY p.id LIMIT 0,25
0.00099	UPDATE punbb_topics SET num_views=num_views+1 WHERE id=7991
Total query time: 0.00575 s

Forum Debian Users Gang

Ogłoszenie

#1 2007-05-16 13:52:41

adams12 - Użytkownik

squid i squidguard POMOCY

#2 2007-05-22 18:21:00

kayo - Członek DUG

Re: squid i squidguard POMOCY

Stopka forum

Informacje debugowania