这篇文章介绍了当WordPress开启错误记录以后,根据error_log来发现SQL注入攻击的思路。" m% y6 g" \$ L: g
2 H% p% k# ]4 f5 E9 N/ q* O; o吸引Cocoa的是这个博客其实是TrustWave公司下属的一个叫Spiderlab团队的官方博客,貌似比较有意思。例如它提到了Honeypot Alert这个标签里的文章都是分析他们一个Web蜜罐的Apache access_log日志的。0 M8 I% j' L7 c7 W
# j; T y) ^ f, o6 d0 L3 \" |
简单介绍一下这篇文章吧。 & H. N* \& }% s, P% k0 L) L d5 u8 f7 q- d8 J1 e开启WP错误记录功能+ L9 {8 D6 }. s
只需要修改wp-config.php的如下几行:. `8 n! {! m- y4 }- Z
' u* z. A# |' `( D" N1 n
@ini_set('log_errors','On'); @ini_set('display_errors','Off'); @ini_set('error_log','/home/example.com/logs/php_error.log');SQL 注入扫描5 b6 V% c3 C6 a
' p1 m1 K- k# J: ?3 v; K" h* M$ i[07-Dec-2012 02:40:49] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = -1\'' at line 1 for query SELECT text, author_id, date FROM WHERE id = -1\' : |) r1 {7 I. q" Q3 z[07-Dec-2012 02:40:50] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = 999999.9 UNION ALL SELECT 0x31303235343830303536--' at line 1 for query SELECT text, author_id, date FROM WHERE id = 999999.9 UNION ALL SELECT 0x31303235343830303536--! i) w. |8 L( [
[07-Dec-2012 02:40:53] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = 999999.9 UNION ALL SELECT 0x31303235343830303536,0x313032353438303035' at line 1 for query SELECT text, author_id, date FROM WHERE id = 999999.9 UNION ALL SELECT 0x31303235343830303536,0x31303235343830303536--/ G2 Y8 E! f5 L9 X
上面的日志就是在暴力猜解表的列数,那个巨大的十六进制值会被解析成null。 7 O+ c' V7 r# O# }; o
SQL盲注扫描. }4 Z; Q# ], J( T4 m
攻击者使用了类似"waitfor delay"和"benchmark"这样的函数来盲注。 5 m# o# l4 @ o/ n* L/ ?" u6 z4 [0 ?* g3 |
[07-Dec-2012 02:43:21] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = -1; if (1=1) waitfor delay \'00:00:05\'--' at line 1 for query SELECT text, author_id, date FROM WHERE id = -1; if (1=1) waitfor delay \'00:00:05\'-- ; ?. k8 m/ g% Z6 {+ o& J! ?( K% Z[07-Dec-2012 02:43:27] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE id = -1 and if(1=1,BENCHMARK(8623333,MD5(0x41)),0)' at line 1 for query SELECT text, author_id, date FROM WHERE id = -1 and if(1=1,BENCHMARK(8623333,MD5(0x41)),0)" t: C' w H- F4 u+ n7 f
Google一下大规模扫描. {' Y& Z0 S$ Q: `+ ]& Q4 g, X. G
" b: L3 `) R8 V* ~
# m) w9 w/ h" W
[attach]163[/attach]/ r0 k" g1 f j5 I7 F8 f9 z
8 o+ E, b/ v1 |6 ?. Y+ d) v4 ~
" g s, H$ Z( u) P7 w+ I$ G& Q* @# N. X1 X3 c+ l! S! C
僵尸网络控制着可能使用被感染主机来识别潜在的目标。下面是该公司的蜜罐捕获到的一个RFI(远程文件包含)攻击代码里的片段:
sub google() { my @list; my $key = $_[0]; for (my $i=0; $i<=400; $i+=10){ my $search = ("http://www.google.com/search?q=".&key($key)."&num=100&filter=0&start=".$i); my $res = &search_engine_query($search); while ($res =~ m/<a href="\"?http:\/\/([^">\"]*)\//g) { if ($1 !~ /google/){ my $link = $1; my @grep = &links($link); push(@list,@grep); } } } return @list; - f) j' Y- X& @) p. [4 J/ a% J7 f
& L3 b! I" {8 Z2 f' e9 @9 w" y
Cocoa总结:文章比较简单,但是从日志来检测攻击貌似是目前流行的一个方向。- j3 D$ T( C- g* k