"Database" such as Hanting Hotel 20 million open room data 1.71g/bak,792m/csv

A number of hotel chains used a network company limited, the development of Hotel WiFi management, certification management system. Users in the hotel connected to open WiFi, Internet access will be required through the Web certification, fill in the relevant information. This authentication is not done in the hotel server, but in a company's authentication server, so this server is also taken for granted a hotel customer information, such as: Customer Name (two people, two will show Oh ~), Social Security number, open room date, mobile phone number, room number, etc. sensitive, private information.

Then, this information can be compromised for some reason.

Open Room Record Oh ~ ~

Little friends, check to see if you have a goddess.

Due to the particularity of welfare and privacy, the network has already started a large-scale ban! The welfare party risks releasing shares!

2000W data originally originated from: Security Monitoring Platform Cloud network, there are netizens have to pack all the data to share, 1.7G of compressed package, decompression will be nearly 8G bak backup files, need to use database software (such as: SQL Server) to restore the view!

For more information, please see Baidu Search, Keywords: such as home, hanting, such as a large number of hotel open room record leakage; 20 million open room data

Introduction to the vulnerability of cloud nets

A netizen has confirmed that he has found a three-year-old business trip to the open room record.

Data has been statistically compiled:

：

BAK format: Baidu Network disk extract code: 1RRN

Decompression Password: Sjisauisa is on the data 8 very comfortable good sjjss "scratch card"

CSV format: Baidu Network disk extract code: 3O1C

Decompression Password: Stranger leisile "Scratch card"

2000W Open Room Data opening tutorial

CSV format can be viewed by Excel! Not clear the best first Baidu CSV format

Also recommend a software to open the CSV, EmEditor

Official Downloads

Http://www.emeditor.com/pub/emed32_13.0.6.exe

Http://www.emeditor.com/pub/emed64_13.0.6.exe

Http://www.emeditor.com/pub/emed32_13.0.6_portable.zip

Csbz3-6gve2-wgrp6-tg37y-vf7eb This is the registration code available for the 13 series version

How to open a hotel 2000w.bak file, bak for the database backup file, need to restore the database, Bak open the Query method:

1). Download and install SQL 2012,:http://www.microsoft.com/zh-cn/download/details.aspx?id=29062, click Download, select Sqlexprwt_x86_ CHS (32-bit system) or SQLEXPRWT_X64_CHS (64-bit system), ready to install!

2). Open SQL Server Management Studio and import the file that downloaded the extracted hotel 2000W data: Shifenzheng.bak

--Here's how to import the data:

1. Right-click the Databases folder under the instance of SQL Server 2012. is the icon on the top level of the database, such as Master. Select "All Tasks", "Restore Database"

2. In "Revert to database", fill in the name of the database you wish to restore. The name should match the name of the database used in your source code.

3. In the popup dialog box, select "From Device"

4. Click "Select Device"

5. Click "Add"

6. Click on the "..." button to the right of the "file name" text box to select your ". BAK file, and click OK to return to the Select Restore Device dialog box.

7. Click OK to return to the Restore Database dialog box.

8. Click on the "Options" tab

9. Change all the paths under "move to physical file name" to the path you want to save the database file to after you restore it. If you don't want to change, you can click OK directly. Then the recovery was successful.

--Search data methods

1) Run SQL Server Management Studio, and expand the restored database.

2) Click "New Query" on the toolbar.

3) In the Query box, enter select * from Cdsgus; Then click on the Toolbar "! Execute button. You can see the 2000W data in a moment (the query time and speed is related to the hard disk).

4) Search by name: In the Query box, enter SELECT * from Cdsgus where name = ' name '; Then click on the Toolbar "! Execute button. It will output all records of that name.

5) According to the ID number query: In the Query box, enter SELECT * from Cdsgus where ctfid = ' ID number '; Then click on the Toolbar "! Execute button.

6) Search by phone number: In the Query box, enter SELECT * from Cdsgus where mobile = ' phone number '; then click on the toolbar! Execute button.

In addition can also be based on the address of God Horse query, but the above query method is very accurate, especially the use of ID and mobile phone number query results are particularly accurate. (Don't forget to copy the semicolon after the SQL statement)

It is important to note that the restored database size is more than 7G. Ordinary hard drive query will be very slow, we must have patience. There are solid-state drive queries will be very fast, conditional access to the server on the query is also good. Use a normal PC hard drive, you must be patient

Partner hotels are as follows:

Let's take a look at this home-like customer information:

One more double room:

Mom doesn't have to worry about me and the bad guys.

"Database" such as Hanting Hotel 20 million open room data 1.71g/bak,792m/csv