NKCSS Logo

@LulzSec dumped Sony BMG data via SQL Injection Attack

@LulzSec is a group of jolly hackers, out for fame, attacking high profile targets such as American TV Station's Fox & PBS and now, for the second time, WorldWide HackerSport target Sony.

In this latest Sony hack, they released a dump of Sony BMG's database, including information of American, Dutch & Belgian users.

As you know, I love statistics, & I love programming, so when I saw this data dumped, I'd figure I'd see what some common used passwords & mail domains were. This is the result:

NKCSS Analysis of @LulzSec's #Sownage dump for Sony Pictures International file called 'BEAUTY_USERS'.
NKCSS Analysis of @LulzSec's #Sownage dump for Sony Pictures International file called 'DELBOCA_USERS'.
NKCSS Analysis of @LulzSec's #Sownage dump for Sony Pictures International file called 'AUTOTRADER_USERS'.

As you can see, the above is the results of some analysis. It's funny to see, that for the file that had the most info (address, date of birth, etc), the most common year of birth puts most of the users at 60+ years of age.

The dump also contained some weird data for the Dutch users (since I'm Dutch myself, this was one of the first things I checked). Allmost all of the mail addresses ended with '@', which leads me to believe there's something wrong with that dump. The rest of the data seems fine, only thing I can remark is that they used a weird sequence of columns to export the data.

I didn't want to spend too much time on the program, so I've set up some strict rules, which excludes about half of the file from being parsed (inconsistent columns in the export), but that shouldn't matter too much :)

Anyway, it's been fun to do, wondering what @LulzSec's next project will be.

More Articles

Popular in the last 7 days

Article   Last 7 Days Week Before Change Total
NumberLink Statistics 855 views 732 views +123 views (+17%) 1,985
@LulzSec dumped Sony BMG data via SQL Injection Attack Statistics 110 views 161 views -51 views (-32%) 11,579
LeaseWeb Server #1 Crash Statistics 104 views 106 views -2 views (-2%) 3,823
Fable: The Lost Chapters 4 CD to DVD Statistics 70 views 81 views -11 views (-14%) 2,827
Sak Noel - Loca People Statistics 70 views 73 views -3 views (-4%) 2,674
Detailed Information
Article ID 26
Written By Nick Kusters
Created 03-06-2011 (265 days ago)
Last Edited By Nick Kusters
Last Modified 03-06-2011
Revision 2
Page Views 11,579 (≈44 pageviews a day)
Back to the main Programming page
Sponsored Links
Want to share your opinion?
Leave a message! Comment

There are no comments yet.