Slashdot Mirror


Terror Watchlist "Crippled By Technical Flaws"

I Don't Believe in Imaginary Property writes "The database used by the government to generate lists like the No-Fly List is 'crippled by technical flaws,' according to the chairman of a House technology oversight subcommittee. And the upgrade may be worse than the original. Rep. Brad Miller (D-NC) says that 'if actually deployed, [the upgrade] will leave our country more vulnerable than the existing yet flawed system in operation today.' It seems that the current database doesn't have any easy way to do plain-text matching, forcing users to enter SQL queries. That might not sound so bad until you learn that the database contains 463 poorly indexed tables. How long until there's a terrorist named Robert'); DROP DATABASE; —?"

32 of 324 comments (clear)

  1. Robert'); DROP DATABASE; â" by Hyppy · · Score: 2, Funny

    Oh yes. Little Bobby Datas, we call him.

    xkcd. Always relevant.

    1. Re:Robert'); DROP DATABASE; â" by Joe+the+Lesser · · Score: 4, Funny

      I think you mean Little Ahmed Tables.

      --
      "I only speak the truth"
      Karma: null(Mostly affected by an unassigned variable)
    2. Re:Robert'); DROP DATABASE; â" by MadKeithV · · Score: 3, Funny

      Pronounced Aay - See - Phlegm......

    3. Re:Robert'); DROP DATABASE; â" by Joe+the+Lesser · · Score: 2, Funny

      Silence!

      I kill you!

      --
      "I only speak the truth"
      Karma: null(Mostly affected by an unassigned variable)
  2. It'll all work itself out ... by daveime · · Score: 5, Funny

    The amount of people they want to include on their "t3rr0rz l1zt" it'll only be a matter of time before we have

    Osama Bin CREATE INDEX;

    and

    Saddam OPTIMIZE TABLE;

    Then everything will be hunk dory again.

    1. Re:It'll all work itself out ... by DoofusOfDeath · · Score: 4, Funny

      Saddam OPTIMIZE TABLE

      Actually, I think the SQL 2012 standard only supports the short form, "SADDAMIZE TABLE".

    2. Re:It'll all work itself out ... by Per+Wigren · · Score: 4, Funny

      Saddam OPTIMIZE TABLE

      Actually, I think the SQL 2012 standard only supports the short form, "SADDAMIZE TABLE".

      Not to be confused with the more penetrative command SOD... nevermind.

      --
      My other account has a 3-digit UID.
  3. the first person by nimbius · · Score: 5, Funny

    to code an exploit that automatically populates tables in the watchlist with entries from the TSA employee database wins.

    --
    Good people go to bed earlier.
    1. Re:the first person by LiquidCoooled · · Score: 4, Funny

      Are you sure thats possible, I thought Microsoft Access Databases were invulnerable?

      --
      liqbase :: faster than paper
    2. Re:the first person by Anonymous Coward · · Score: 2, Funny

      invulnerable and inaccessible go hand in hand yes.

  4. Re:is this "obvious news day" again? by PC+and+Sony+Fanboy · · Score: 4, Funny

    Because theres' nothing a non-USian can learn in such a "story", except that US-ians are teh morons.

    Hold on, that's not true! In this story, we learn that the terrorist watch list is not only a bad idea, but it is poorly implemented!

  5. Re:That's what happens when.... by Anonymous Coward · · Score: 5, Funny

    I heard they douse you in Holy Water. If it tastes like burning, you're hired on the spot.

  6. Re:is this "obvious news day" again? by damn_registrars · · Score: 1, Funny

    Because theres' nothing a non-USian can learn in such a "story", except that US-ians are teh morons.

    Hold on, that's not true! In this story, we learn that the terrorist watch list is not only a bad idea, but it is poorly implemented!

    I think he may have been trying to indicate that we already knew that. Even more so, that pretty much everyone in the world already knew that.

    --
    Damn_registrars has no butt-hole. Damn_registrars has no use for a butt-hole.
  7. Re:It's _not_ crippled by technical flaws. by elrous0 · · Score: 5, Funny

    Actually, I'd be pretty cool with banning 5-year-olds from planes.

    --
    SJW: Someone who has run out of real oppression, and has to fake it.
  8. Re:That's what happens when.... by fastest+fascist · · Score: 4, Funny

    Don't knock it. This is proof a poor process CAN lead to good results. Those responsible for this should be generously rewarded.

  9. Re:It's _not_ crippled by technical flaws. by samweber · · Score: 5, Funny

    But hey, it's not that bad! After all, since all terrorists use their real names when flying, it is sure to catch them all.

    Ever wonder why no suicide bomber has been able to strike twice? It's because of the no-fly-list, I tell you!

  10. Re:is this "obvious news day" again? by sheldon · · Score: 5, Funny

    I just put you on the list.

  11. Re:It's _not_ crippled by technical flaws. by clickety6 · · Score: 5, Funny

    Apparently Nelson Mandela was on the list, until the fact was embarrasingly publicized and he was finally removed.

    So, easy solution - if you don't want to be bothered by the no fly list then change your name to Nelson Mandela...

    --
    ----------------------------------- My Other Sig Is Hilarious -----------------------------------
  12. Are these names on the list... by clickety6 · · Score: 4, Funny

    http://video.aol.com/video-detail/snl-funny-terrorist-names/4040669571

    "M'balz es-Hari"
    "Haid D'Salaami"
    "Mustaf Herod Apyur Poupr"
    "Usuqa M'diq"
    "Hous bin Phartin"
    "I'zheet m'drawrz"

    --
    ----------------------------------- My Other Sig Is Hilarious -----------------------------------
  13. Re:Robert'); DROP DATABASE; by kalirion · · Score: 4, Funny

    I wonder if I'm the only SQL noob who had to look up the "drop database" command to see that indeed it is valid?

    Why look it up when you can test it out for yourself?

  14. Re:It's _not_ crippled by technical flaws. by kalirion · · Score: 2, Funny

    So do you wear diapers on transatlantic flights too? You know, in case of accidents.

  15. Re:Why Would You Expect Otherwise? by Abcd1234 · · Score: 4, Funny

    Really. So, all private industry is automatically good, or would you care to qualify that statement? The free market has failure modes, you know. Perhaps you've heard of natural monopoly, imbalance of information, and externalities?

    Hear that noise? It's the sound of thousands of libertarians plugging their ears and yelling "LA LA LA" as loud as they can.

  16. Re:Why Would You Expect Otherwise? by ColdWetDog · · Score: 2, Funny

    No need, give every able adult a weapon upon boarding, they'll have plenty of incentive to deal with any problems.

    No need to go that far. Two Marine Staff Sargent's would keep everyone in their place. Maybe three or four for the larger planes.

    'Maggot! Sit down and shut up! Now!'

    --
    Faster! Faster! Faster would be better!
  17. Re:is this "obvious news day" again? by TravisO · · Score: 3, Funny

    So I'm guessing their Access database just looks like this:

    ID | First | Last

    I guess they just took KISS way too far.

  18. Popular Front for the Liberation of Palestine? by BancBoy · · Score: 2, Funny

    Splitters!

    --
    [UID-HeinzIntel]
  19. Re:is this "obvious news day" again? by SQL+Error · · Score: 2, Funny

    I'm sure he'll not be missed.

  20. Re:is this "obvious news day" again? by PC+and+Sony+Fanboy · · Score: 4, Funny

    Just wanted to point out that having a felony conviction doesn't necessarily mean somebody is an evil person.

    ... nah, it just means that they didn't have a very good lawyer.

  21. Re:is this "obvious news day" again? by sjames · · Score: 2, Funny

    They also thought there was a comma and that it was hiring advice: "Keep it simple, stupid".

  22. Re:Why Would You Expect Otherwise? by Random+BedHead+Ed · · Score: 5, Funny

    This airline is sounding better and better. Kill switches to blow it up in midair, marines to put passengers in their place. I can see someone running with this idea and making a fortune, and to think we were part of the thread that first hatched the idea.

    My addition to this would be that to ensure the safety of people on the ground the planes in this hypothetical airline shouldn't be allowed to actually take off, but should instead hug the ground throughout the flight, perhaps on some sort of stabilizing rail, or a magnetic hover track. We might even build a system for running these planes across North America.

  23. Re:is this "obvious news day" again? by mounthood · · Score: 2, Funny

    I just put you on the list.

    Yea, but did you add his name to all 463 tables?

    --
    tomorrow who's gonna fuss
  24. Re:That's what happens when.... by slarrg · · Score: 4, Funny

    Typical government pork. Do we really need to waste a bullet after they've drowned?

  25. Re:Why Would You Expect Otherwise? by Jay+L · · Score: 2, Funny

    So for the rest of you its only Yellow, but if your flying, its Orange!

    Well, duh. The sky is blue, and when you're flying, you're closer to the sky. yellow + blue = orange.

    [For you armchair optical physicists: I'm talking about color mixing at high altitude. Your classroom yellow + blue = brown doesn't work up there, because of sunspots.]