Slashdot Mirror


MySql.com Hacked With Sql Injection

iceco2 writes "MySql.com and associated sites were hacked today. Among other items some simple passwords were recovered and private emails were revealed. Ironically the attack was performed using a blind sql injection attack."

28 of 288 comments (clear)

  1. Incoming botswarm by symbolset · · Score: 5, Funny

    Microsoft web serving products? How dumb can can a bot get? Turing fail.

    --
    Help stamp out iliturcy.
  2. Re:Another report by AsmCoder8088 · · Score: 3, Interesting

    Okayyyyyyyy... MS astroturfing, anyone?

  3. USE BIND VARIABLES by MoNsTeR · · Score: 4, Interesting

    Jesus fuck, people. It's not rocket surgery.

    If you use bind variables, you CANNOT be SQL-injected.

    If you don't, you can be.

    It's that fucking simple. Do The Right Thing.

    1. Re:USE BIND VARIABLES by Dunbal · · Score: 4, Funny

      Jesus fuck, people. It's not rocket surgery.

      Apparently it's brain science.

      --
      Seven puppies were harmed during the making of this post.
    2. Re:USE BIND VARIABLES by Just+Some+Guy · · Score: 5, Insightful

      SQL = """
      SELECT make, model
      FROM vehicle
      WHERE vin IN (%s)
      """ % ', '.join(["%s"] * len(VINs))

      My eyes, they bleed! Write that like:

      VINs = ("1M8GDM9A_KP042788", "1M8GDM9A_KP042789")
      SQL = """
      SELECT make, model
      FROM vehicle
      WHERE vin = ANY(%(vin)s)"""
      dbconn.execute(SQL, {'vin': VINs})

      Or even better:

      vehicles = session.query(Vehicle).filter(Vehicle.vin.in_(VINs))

      Voila. Those work, they're not hideous, and they prevent injection. To repeat the earlier idea: there's no need to write unsafe code. If you are, you're in the wrong line of work.

      --
      Dewey, what part of this looks like authorities should be involved?
    3. Re:USE BIND VARIABLES by JustinRLynn · · Score: 4, Informative

      You know, I could be a smart arse and say this rules out most people that choose to use PHP, but I think my karma would burn. Oh wait....

  4. Re:Another report by symbolset · · Score: 4, Informative

    180 words, under 1 minute by the timestamp. It was actually under 30 seconds. Bot. A prepared response to any article containing "hacked" and "mysql"

    --
    Help stamp out iliturcy.
  5. Yo Dawg by mrstrano · · Score: 5, Funny

    I herd you like Sql, so we injected Sql in your Sql so you can have Sql while you code MySql

    1. Re:Yo Dawg by MarkRose · · Score: 5, Funny

      An SQL statement walks into a bar and sees two tables and says, "Hello, may I join you?"

      --
      Be relentless!
    2. Re:Yo Dawg by Sparks23 · · Score: 4, Funny

      Honestly, "YourSQL" seems more accurate than "MySQL" given that apparently even the developers can't keep control of their own database. ;P

      --
      --Rachel
    3. Re:Yo Dawg by MarkRose · · Score: 3, Funny

      Pardon the grammatical gaff, but don't you mean YourSOL? :-)

      --
      Be relentless!
  6. Re:Another report by Dunbal · · Score: 3

    Not trusting the user input is rule #1 of programming - from way before the internet era. I'm only a programmer by hobby and even I know that. What do they teach these kids at school?

    --
    Seven puppies were harmed during the making of this post.
  7. The work of a lonely developer by danielcolchete · · Score: 4, Insightful

    Even inside a big team of a big company it is amazing how so many people are working by themselves. That's the kind of error that a simple code review by an experienced programmer would have avoided (use bind variables/prepared statements).

  8. Re:That's Not Ironic by 6031769 · · Score: 4, Insightful

    Ironic is when one's words say one thing and one's actions another that contradict it.

    No, that's hypocrisy, not irony. Try again.

    --
    Burns: We're building a casino!
    McAllister: Arrr. Give me 5 minutes.
  9. Yes it is by pavon · · Score: 4, Informative

    Ironic is when one's words say one thing and one's actions another that contradict it.

    No, that is hypocritical. Situational Irony is where the outcome is has a humorous incongruity or discrepancy from what one would expect, or from what would normally be implied by the situation. The fact that the company which produces and sells MySQL wasn't using SQL correctly is indeed ironic.

  10. Re:That's Not Ironic by Anonymous Coward · · Score: 3, Funny

    You would expect a person correcting the summary's definition of irony to be aware that there are multiple definitions of irony. The grandparent was clearly ignorant of this fact, thus making the comment meta-ironic.

  11. Does xkcd explain it? by Anonymous Coward · · Score: 3, Funny
    1. Re:Does xkcd explain it? by Tridus · · Score: 3, Insightful

      I have that comic taped to my door. Any programmer who walks by, reads it, and doesn't laugh is someone I watch VERY carefully when they write any code that touches a database.

      --
      -- "So they told me that using the download page to download something was not something they anticipated." - Bill Gates
  12. Re:Too bad by KiloByte · · Score: 5, Insightful

    Let's think if Oracle has something to gain from intentionally tarnishing the reputation of a product they want to kill.

    I'm not saying it's foul play for sure, just pointing out they do have an incentive to do so.

    --
    The creatures outside looked from Alt-Right to Antifa; but already it was impossible to say which was which.
  13. Re:Another report by PopeRatzo · · Score: 5, Insightful

    Note the parent's comment.

    Does anyone still want to challenge my assertion that Slashdot is under an ongoing escalated attack from organized astroturfers of the New Media Strategies and Reputation Defender variety? I'm betting the MS is using in-house talent for this purpose, but it's quite possible that they are using New Media Strategies or another such company to keep the activity at arm's length to provide deniability. I wouldn't be surprised if 100,000 or more of the accounts with UIDs over 1500000 belong to employees of these companies or departments. Slashdot is a good target for them because so many of us are in influential or decision-making positions at our companies or are opinion-drivers due to our reputation as "computer nerds". A Slashdot story with an energetic discussion which is negative on say, AT&T can have an out-sized influence on opinion regarding that company, due to both word of mouth and search engine results.

    One only has to watch any story that is critical of a major US company to see this behavior, which usually shows up as ignorant "frosty piss" trolling followed by >2000000 UID comments (often densely written) followed by a string of sockpuppet "bumping". The tactic is to disrupt the discussion to the point where serious opinion is abandoned. It can work because many don't have java-script enabled so you can't even collapse the offending thread.

    --
    You are welcome on my lawn.
  14. Re:That's Not Ironic by LordLucless · · Score: 4, Funny

    Ironically, the OP correcting someone else for not using ironic correctly is both hypocritical and ironic.

    --
    Just because you're paranoid doesn't mean there isn't an invisible demon about to eat your face
  15. Re:That's Not Ironic by MarkRose · · Score: 4, Funny

    Screwing up irony is the only thing that unleashes the linguists with such ferrousity.

    --
    Be relentless!
  16. Re:That's Not Ironic by MarkRose · · Score: 4, Funny

    Like Oracle not seeing it coming?

    --
    Be relentless!
  17. Re:What year is it? by Software+Geek · · Score: 3, Funny

    When interviewing people for QA positions, I routinely ask "Do you know what an SQL injection attack is?"
    I have never yet interviewed a candidate who answered yes.
    So, then I explain what an SQL injection attack is, and ask how they would test for vulnerability to one.
    Almost without exception, the answer is "I guess I would try entering some special characters and keywords into the GUI, and see what happens."

  18. Re:That's Not Ironic by dr2chase · · Score: 4, Funny

    I think your pun detector is a little rusty.

  19. Re:Password hashing + salt? by BCoates · · Score: 3, Informative

    The salt isn't a second secret, it's there to prevent the use of a pre-constructed rainbow table for the standard hash functions. Without a rainbow table, you can still do dictionary attacks of weak passwords--and there is no way to prevent this short of not using passwords for authentication. This only harms people who use guessable passwords and re-use passwords between sites.

  20. Re:What year is it? by discord5 · · Score: 3, Insightful

    When interviewing people for QA positions, I routinely ask "Do you know what an SQL injection attack is?"

    Hahaha, reminds me of what I used to do to interns. We used to get a bunch of interns every year, and every year we'd have them develop small web applications for internal use. They'd work on their project and after a few weeks we'd come in and evaluate their work, steer them in the right direction (if that wasn't necessary earlier) and do a few tests.

    The first thing I always asked was "Do you have a backup?" and after the inevitable googling of the mysqldump command I'd be an utter bastard and sneak in a DROP TABLE, or DELETE FROM statement in the URL bar, right after id=x, and surely enough most of the times it would work.

    "It looks really great, but I think there's a problem with it. Maybe you want to check the logfiles to see what happened." to see if they'd see what was the problem, and if they didn't I would explain an SQL injection attack to them. Few of them managed to find the solution on google, but most immediately suggested such things as "I'll check for ; in the string" which inevitably led to me trashing their tables about 10 minutes later. I have to say, once they had their tables dropped twice they became real careful of permissions and handling SQL statements.

    In a way I hope they learned something from having a complete bastard as a mentor, although I'm sure that a few of them have already forgotten about that one time a single statement ruined their database. Oh well...

  21. Re:Another report by hairyfeet · · Score: 4, Interesting

    Which is why I have a question: WTF is up with the MS Shill brigade on /. lately? I've only noticed it for about the past three weeks or so, but damned the shit is getting thick. Look at the one that posted on the Nook hack, the very first post is "I Wish Microsoft would have released the Courier" complete with link for those that don't know what that bullshit vaporware was in the first place. I mean did they get a deal on that HB Gary software or what? And why are they so insecure? I mean sure WinPhone is dead last but Windows 7 is nice, and the X360 is doing well. So what is up with the rampant MSFT shilling? Do they fire your ass if you don't post X number of shill posts or something?

    As for TFA, garbage in, garbage out. I don't care if you code in VB 6 or Brainfuck if you write sloppy code it WILL come back to bite you in the ass. But trying to blame this on the language, to use a /. car analogy, would be like trying to blame Ford because someone got drunk and hit a kid with their Mustang. A tool is only as good as the person using it, full stop. I've seen clean code and lousy shit in just about every language. It ain't the tool that's the problem it is PEBKAC. But they should get extra points for the sheer irony factor. I mean a site promoting SQL falling for the oldest trick in the book? Bobby Drop Tables anyone?

    --
    ACs don't waste your time replying, your posts are never seen by me.