Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Witam!
Niedawno poruszałem temat squida na Debianie, ale jeszcze tego problemu nie rozwiązałem. Mam zrobiony router na Debianie poprzez maskarade. Z racji tego że musze rejestrować połącznia uzytkownikow musiałem postawić squid'a. Problem polega na tym że w logach squid'a zamiast IP klienta pokazuje mi adres sieci 10.0.0.0, myślałem że SARG rozwiąże mi ten problem ale jednak się myliłem bo też pokazuje tylko 10.0.0.0. Adresy klientom przydzielam po adresach MAC w dhcp. Z góry dzięki.
Offline
A co ci pokazuje polecenie squidview?
Offline
listing z polecenia tail -f /var/log/squid/access.log
10.0.0.0 - - [14/Jul/2006:06:56:57 +0200] "GET http://forum.dug.net.pl/topics_anywhere.php? HTTP/1.1" 200 5508 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:56:58 +0200] "POST http://forum.dug.net.pl/login.php? HTTP/1.1" 302 875 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/msg_inbox.gif HTTP/1.1" 200 1023 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/msg_sentbox.gif HTTP/1.1" 200 948 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/msg_outbox.gif HTTP/1.1" 200 1054 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/msg_savebox.gif HTTP/1.1" 200 962 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/spacer.gif HTTP/1.1" 200 380 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/msg_newpost.gif HTTP/1.1" 200 1384 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/privmsg.php? HTTP/1.1" 200 19023 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:56:59 +0200] "GET http://forum.dug.net.pl/topics_anywhere.php? HTTP/1.1" 200 5253 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:18 +0200] "GET http://forum.dug.net.pl/index.php HTTP/1.1" 200 31349 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:18 +0200] "GET http://forum.dug.net.pl/shoutbox.php HTTP/1.1" 200 677 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:18 +0200] "GET http://forum.dug.net.pl/shoutbox_send.php HTTP/1.1" 200 1771 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:19 +0200] "GET http://forum.dug.net.pl/topics_anywhere.php? HTTP/1.1" 200 5253 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:19 +0200] "GET http://forum.dug.net.pl/shoutbox_view.php HTTP/1.1" 200 35010 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:20 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/post.gif HTTP/1.1" 200 1401 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:20 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder_new.gif HTTP/1.1" 200 674 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:20 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/icon_newest_reply.gif HTTP/1.1" 200 471 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:20 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder.gif HTTP/1.1" 200 682 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:21 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder_hot.gif HTTP/1.1" 200 1517 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:21 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/icon_minipost.gif HTTP/1.1" 200 459 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:22 +0200] "GET http://forum.dug.net.pl/viewforum.php? HTTP/1.1" 200 76713 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:22 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder_announce.gif HTTP/1.1" 200 645 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:22 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder_new_hot.gif HTTP/1.1" 200 1498 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:22 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder_sticky.gif HTTP/1.1" 200 682 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:22 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder_lock_new.gif HTTP/1.1" 200 797 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:22 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/folder_lock.gif HTTP/1.1" 200 671 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:23 +0200] "GET http://forum.dug.net.pl/topics_anywhere.php? HTTP/1.1" 200 5253 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/reply.gif HTTP/1.1" 200 1390 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_quote.gif HTTP/1.1" 200 946 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_edit.gif HTTP/1.1" 200 997 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_profile.gif HTTP/1.1" 200 906 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_online.gif HTTP/1.1" 200 1752 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_pm.gif HTTP/1.1" 200 958 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_email.gif HTTP/1.1" 200 928 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/user_agent/browser/firefox.gif HTTP/1.1" 200 1035 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/user_agent/os/winxp.gif HTTP/1.1" 200 807 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/grafa/r3.gif HTTP/1.1" 200 885 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_offline.gif HTTP/1.1" 200 1376 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/user_agent/browser/mozilla.gif HTTP/1.1" 200 1582 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/user_agent/os/debian.gif HTTP/1.1" 200 531 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/grafa/r5.gif HTTP/1.1" 200 753 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://biexi.dug.net.pl/pliki/graf/inne/netbsd.png HTTP/1.1" 200 6746 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/templates/subSilver/images/lang_polish/icon_www.gif HTTP/1.1" 200 908 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/user_agent/browser/konqueror.gif HTTP/1.1" 200 793 TCP_HIT:NONE
10.0.0.0 - - [14/Jul/2006:06:57:24 +0200] "GET http://forum.dug.net.pl/viewtopic.php? HTTP/1.1" 200 34121 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:25 +0200] "GET http://forum.dug.net.pl/topics_anywhere.php? HTTP/1.1" 200 5253 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:37 +0200] "GET http://forum.dug.net.pl/posting.php? HTTP/1.1" 200 29491 TCP_MISS:DIRECT
10.0.0.0 - - [14/Jul/2006:06:57:37 +0200] "GET http://forum.dug.net.pl/topics_anywhere.php? HTTP/1.1" 200 5253 TCP_MISS:DIRECT
Offline
czy to jest normalne przy uruchomieniu squida z lista adresow i takich tam do banowania:
2006/08/25 10:08:27| WARNING: 'astalavista.box.sk' is a subdomain of 'astalavista.box.sk'
2006/08/25 10:08:27| WARNING: because of this 'astalavista.box.sk' is ignored to keep splay tree searching predictable
2006/08/25 10:08:27| WARNING: You should probably remove 'astalavista.box.sk' from the ACL named 'zak_domeny'
Offline
Time (s) | Query |
---|---|
0.00010 | SET CHARSET latin2 |
0.00004 | SET NAMES latin2 |
0.00123 | 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='3.17.79.188' WHERE u.id=1 |
0.00062 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.17.79.188', 1733055473) |
0.00024 | SELECT * FROM punbb_online WHERE logged<1733055173 |
0.00075 | DELETE FROM punbb_online WHERE ident='85.208.96.208' |
0.00045 | SELECT topic_id FROM punbb_posts WHERE id=39556 |
0.00127 | SELECT id FROM punbb_posts WHERE topic_id=4492 ORDER BY posted |
0.00054 | 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=4492 AND t.moved_to IS NULL |
0.00005 | SELECT search_for, replace_with FROM punbb_censoring |
0.00074 | 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=4492 ORDER BY p.id LIMIT 0,25 |
0.00072 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=4492 |
Total query time: 0.00675 s |