统计APACHE ACCESS.LOG IP访问记录
上一篇 / 下一篇 2010-07-20 10:54:22 / 个人分类:其它
xcopy 哥哥的!
详解:下面是一个例子:51Testing软件测试网;h(e GD(_
51Testing软件测试网!j ~B)z1Wbjjcat 是读取这个文件。
7T8j*q,{?m3t051Testing软件测试网 b`"HP4KkR1147753394.079 2 220.139.141.61 TCP_DENIED/403 1354 CONNECT 222.124.24.93:25 - NONE/- text/html51Testing软件测试网6v2rx pN`b2p$Z0W
1147753395.652 0 61.228.130.169 TCP_DENIED/403 1352 CONNECT 203.84.195.1:25 - NONE/- text/html51Testing软件测试网
C_ t HdP4qe0V)o
1147753395.754 0 61.228.135.187 TCP_DENIED/403 1350 CONNECT 203.86.1.30:25 - NONE/- text/html
,O.j5IP4x5_;P01147753398.042 3 61.228.131.15 TCP_DENIED/403 1354 CONNECT 81.169.162.54:25 - NONE/- text/html
0]UW2h2Gcb~zO M2X0
r'}\9]P4|wg0
op$GiW6Y0s051Testing软件测试网Fwi,Nl
awk '{print $3}' 是了日志的第三个字段
!f mfeR051Testing软件测试网2L@DF2I!@v } Y220.139.141.6151Testing软件测试网 Ric!M&[ZY
61.228.130.16951Testing软件测试网x:j8U-^%N.E)^p E-r
61.228.135.187
#MMn nrtU:D&w}061.228.131.15
%j
s%[q o,k@rJZ-M051Testing软件测试网&WW;Gr'i\
k X5M
irBcIk)H,j d+u0[root@localhost~]# cat access.log | awk '{print $3}'51Testing软件测试网U9|Jo/@"H
220.139.141.6151Testing软件测试网5h[wt!G
61.228.130.169
i@e4Lu+O061.228.135.187
5huQ2|o tFE
_-k&Q061.228.131.1551Testing软件测试网Y:?Nv9P{7v
61.228.130.18751Testing软件测试网zy#rG:s
61.228.134.106
"Ftyt&ZL
[061.228.134.106
z4Tjg3ND,n*H061.228.134.106
?s RMx-Y&{6p061.228.134.106
+B [uH%m2MHU"`#Y061.228.134.9951Testing软件测试网4lkB,Y+xV
61.228.130.18751Testing软件测试网
l5m'mU5v,J0o!]
220.139.141.6151Testing软件测试网b B;n;Q
oZ R H
61.228.130.16951Testing软件测试网6D]*pe5?2l:Yp
61.228.135.18751Testing软件测试网V)k]{/O]N
61.228.131.1551Testing软件测试网~}{/|/_ i+L
61.228.130.187
f/Rp0O.O v4V?061.228.134.10651Testing软件测试网DEbkP0fZ$S
61.228.134.106
d!?B3]!| iLWt061.228.134.106
;BY#qPT
Lg4A061.228.134.106
Z(Vf']3h
P061.228.134.99
]+S*T-F2s]061.228.130.18751Testing软件测试网5[5]J+i$S3uK,Z
220.139.141.61
;l/VdwF g061.228.130.16951Testing软件测试网 u3a6|!m#G6p
61.228.135.187
)K:nL%zrQV({2d061.228.131.15
2D~r|&Y$G061.228.130.18751Testing软件测试网@x+X5k8_]._G1C"uJ
61.228.134.10651Testing软件测试网#S+Y'u/Mk#d
61.228.134.106
-DM%SS%e
It'mj061.228.134.106
h0]*}X#n/Lu061.228.134.10651Testing软件测试网dK.[3H9O#S
61.228.134.9951Testing软件测试网:s-i5g2s7xY5i
220.139.141.6151Testing软件测试网 m;u1bS$T
61.228.130.16951Testing软件测试网7x
P0P8sx|we4J
}.U
61.228.135.18751Testing软件测试网[mr qiq6Ejn-];Z
61.228.131.1551Testing软件测试网:Ak`N![:~
61.228.130.187
k"Z3{R)d&qb{061.228.134.106
/c{ eNh [%P1c061.228.134.106
F$uF/pL8h{%]4m:Q061.228.134.106
?&{p!cI {h%Af061.228.134.106
]3B
vBSY,t061.228.134.9951Testing软件测试网s?g4^*W ^$[%R"qMM
61.228.130.18751Testing软件测试网R
o-RMp9L8D
220.139.141.6151Testing软件测试网hcBq'_%}lzD
61.228.130.16951Testing软件测试网2v\cs:P
x
61.228.135.187
's@AV8qH_061.228.131.1551Testing软件测试网Ru.E;t.v2~n
61.228.130.18751Testing软件测试网s]W9~MJ$u
61.228.134.10651Testing软件测试网'qW/X6S-^%m%E
61.228.134.10651Testing软件测试网-C:m1s ypa#R
61.228.134.106
.VrO&R(S0xR&OY2s1z#L061.228.134.106
(Agi9]8S.XI6W&H061.228.134.99
jJu5OO1ZsX061.228.130.18751Testing软件测试网3g#^\ nY*j
220.139.141.61
L.I&g_N#C&Mi?061.228.130.16951Testing软件测试网i`6ZM)O[nv
61.228.135.18751Testing软件测试网%mp6@
j"q m&E*`+u
61.228.131.1551Testing软件测试网t&x
SVV
61.228.130.187
b]6du
['`8SCS _
I061.228.134.106
'Jbq*F}d;r061.228.134.10651Testing软件测试网fG1A
S\
] iqP
61.228.134.106
;Y:~%FL~q G061.228.134.10651Testing软件测试网7h0@+U\AI$b
61.228.134.9951Testing软件测试网/h`R yUh h
61.228.130.187
J0vSv:D Y0sort是排序,51Testing软件测试网J9S]W+q
%KJz
ba{0[root@localhost~]# cat access.log | awk '{print $3}'|sort
_ A&Y+}"DH8D0220.139.141.6151Testing软件测试网 Hy|'~4s,T.YA*mK
220.139.141.6151Testing软件测试网1\a_V/F*}
220.139.141.6151Testing软件测试网(n)y/i,k1J y8[$X\
220.139.141.6151Testing软件测试网vf1{WfQ2{|4^u
220.139.141.6151Testing软件测试网3~i;^,U)A8SB;M
220.139.141.61
'ABb
O.U061.228.130.169
Z5z'L^
~
eoy}061.228.130.169
b&XNs1_&Y061.228.130.169
_XH8`9Q T'?*R
_061.228.130.169
DSx u~x6iDy061.228.130.16951Testing软件测试网]Al-L
c,}a
61.228.130.169
E*cTm8|
i5C061.228.130.18751Testing软件测试网7S!qz/B(b}
@d
61.228.130.18751Testing软件测试网9X1e} a"C
61.228.130.18751Testing软件测试网9DgX'Yi8Ou
61.228.130.187
;o"sI/`7b9W3s2g$V061.228.130.187
hy7O5B%E6|8l,C^061.228.130.187
(k-g,sB,~7i`9u3o061.228.130.18751Testing软件测试网F:N;Q%r-N`
61.228.130.18751Testing软件测试网 O|2o@;X.WX NwI&v
61.228.130.18751Testing软件测试网5ekG_$l-T`k
61.228.130.18751Testing软件测试网ow!l6\^c!Vm/U
61.228.130.187
,tK9LH3g8uD061.228.130.18751Testing软件测试网Tt%r7R*w*seg
61.228.131.1551Testing软件测试网l_h.I e,n
61.228.131.15
U4F*h2j|.n061.228.131.1551Testing软件测试网
HM(j*C/p
61.228.131.15
I"G&A6@7u@061.228.131.15
FDQK7P$l9eNr5y061.228.131.1551Testing软件测试网(q+]${%hO;V ~*T#C)S
61.228.134.10651Testing软件测试网)?cKBr&qY6@#j
61.228.134.106
_"[X)C,c6w$k~061.228.134.106
CxfZ JG*Vp6|/U9X061.228.134.106
t
e-d1qH|0B:Pm7a061.228.134.10651Testing软件测试网4l3fs,R
`3Pf!F7B.boj
61.228.134.106
cHUc1s$x'Pc]%L1t8i061.228.134.10651Testing软件测试网7^3DPeK |g(X/z
61.228.134.106
+Vk}4dI;Ry1OA9Qh061.228.134.106
E(xK-n v\3T061.228.134.10651Testing软件测试网Ib*toU]
61.228.134.10651Testing软件测试网4F$s4Vk+I ?m
61.228.134.106
kn e
Vl |R
GC061.228.134.106
0u5B1wO
^Kd|WAW061.228.134.106
b%}&DO"Gled061.228.134.10651Testing软件测试网&b-C%@5m o4al
61.228.134.106
I |r!?1pYE0e1^061.228.134.106
(_h DrfX\!U2}061.228.134.106
q4sz-y;vV;j)?061.228.134.10651Testing软件测试网$h,qp;uAP
61.228.134.106
4\-l(o/l6g5A;YNj061.228.134.10651Testing软件测试网3J/v @(U&Xv,Q
61.228.134.10651Testing软件测试网
S}9@/qnK
61.228.134.10651Testing软件测试网^.ix,WR?#n/e
61.228.134.106
Yc$^ A&r6L9C061.228.134.99
*pW9X`8w061.228.134.9951Testing软件测试网` X7[-?L
61.228.134.9951Testing软件测试网ny1N%Q6|j'z
61.228.134.99
"]gU\)E2F061.228.134.99
`-`#q
]n
e+S061.228.134.99
:Sc"Pb5ESH4R061.228.135.18751Testing软件测试网6YO,U {N8Zvr
61.228.135.18751Testing软件测试网j:E;wl^@*\9|,N r*z7v
61.228.135.18751Testing软件测试网1uK6[9?-GZ1t@K
61.228.135.187
e[Z Cd5v
txW061.228.135.18751Testing软件测试网4j0x M\TPW ED
61.228.135.18751Testing软件测试网b6l\8W2pQ5h$c5t
jO1Lfc1t'd/U0uniq -c 打印每一重复行出现的次数。51Testing软件测试网ZM^ P7[&WX)`e by4U
0t
QmQ){|0[root@localhost~]# cat access.log | awk '{print $3}'|sort|uniq -c
]xFya6y0 6 220.139.141.6151Testing软件测试网%U
Xq |u
6 61.228.130.169
/c+I
w,jUk-@3L0 12 61.228.130.187
Wp\NoF0 6 61.228.131.15
0n1|0D
~;h0 24 61.228.134.10651Testing软件测试网1k3[|GA4G7v
6 61.228.134.99
0U Kc
uay4{B pD0 6 61.228.135.18751Testing软件测试网vZ8|YOI/L-Wf4E
J UI/~ q3H,}Q+L0sort -rn 对排序求逆,n为域号,使用此域号开始分类。
e'f5FBy[Y.Y0A\z2{6Pe6B;a#?R2qW3zM0[root@localhost~]# cat access.log | awk '{print $3}'|sort|uniq -c|sort -rn
)zz*DDg"W*nV J.N0 24 61.228.134.10651Testing软件测试网5XD4Wrh*n
12 61.228.130.187