Terror Watchlist "Crippled By Technical Flaws" 324
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; —?"
That's what happens when.... (Score:5, Insightful)
Why Would You Expect Otherwise? (Score:5, Insightful)
It's _not_ crippled by technical flaws. (Score:5, Insightful)
It's crippled by being a moronic concept in the first place ("You've got the wrong name and _maybe_ the wrong date of birth, and you're not flying.") and an absolutely arbitrary process of putting names on the list, and no way of ever getting a name off the list.
Fix those points first, and _then_ worry about technical details.
Number of tables, no Poorly indexed (Score:5, Insightful)
Re:Why Would You Expect Otherwise? (Score:2, Insightful)
I like the idea of having a fly at your own risk airline where you can just "risk it" and not have all these so called "protections". I bet it would put the airlines with the TSA out of business in a week.
Thinking of joining the air force?
Re:That's what happens when.... (Score:4, Insightful)
Considering the modus operandi of this administration, I'd be very surprised if this weren't a widespread practice.
Re:It's _not_ crippled by technical flaws. (Score:5, Insightful)
Re:Why Would You Expect Otherwise? (Score:5, Insightful)
It was outsourced. Near the bottom of TFA it says that some of the money was used to renovate a building owned by Boeing.
Its amazing just how many "government screwups" are actually caused by politicians outsourcing to their buddies in private industry (with little to no penalties for failing to deliver what was promised), and have nothing to do with the abilities of actual government employees.
There's actually quite a few smart IT folks in government, but they're not the ones who make decisions on who to outsource this stuff to. In fact, most of them would probably rather build a team and do it In-House, since that way you build up the knowledge internally and can more easily support it later.
So please don't blame government employees for something that Boeing screwed up.
Re:That's what happens when.... (Score:2, Insightful)
Re:It's _not_ crippled by technical flaws. (Score:3, Insightful)
Re:Number of tables, no Poorly indexed (Score:5, Insightful)
Wow, so create the indexes then. What's up with you all, this is elementary stuff...a few hours creating the required indexes.
Fixing or even working on, an application and database developed without proper indexes (and foreign keys) is a real pain in the butt, and fraught with 'danger'.
You lot are carrying on as if it's Y2K
Hey, Y2k was 'just' changing a two digit year to a four digit year. By what seems like your standards there shouldn't any 'work' behind that either. Just because it's easy to say, doesn't mean that it's easy to do.
Re:That's what happens when.... (Score:1, Insightful)
Do you think the next administration will change things?
I don't.
"Technical Flaws" (Score:3, Insightful)
I'm not sure you can call having names on the list matching 1/3 of the population of the earth a "technical flaw".
What they really need to do to make it useful is get it down to perhaps a couple thousand real concerns.
Re:Why Would You Expect Otherwise? (Score:5, Insightful)
C) Keep the terror level level artificially high.
http://www.dhs.gov/xinfoshare/programs/Copy_of_press_release_0046.shtm [dhs.gov]
The United States government's national threat level is Elevated, or Yellow.
The U.S. threat level is High, or Orange, for all domestic and international flights.
So for the rest of you its only Yellow, but if your flying, its Orange!
Re:It's _not_ crippled by technical flaws. (Score:3, Insightful)
If employees of the TSA can't sort out when someone, like a 6 year old boy, is not the right person named on the terror list, then WHAT THE FUCK ARE THEY GOING TO DO WITH A REAL TERRORIST?
Re:Why Would You Expect Otherwise? (Score:5, Insightful)
The Mythbusters disproved the "hole in the plane causes explosive decompression" myth.
From http://mythbustersresults.com/episode10 [mythbustersresults.com] :
So you could theoretically have armed people on the plane shooting at terrorists and not causing huge problems if they miss. (Well, except for passengers that get in the way.)
I think the best solution is to lock the pilot's door before boarding. Then the pilots are instructed to not open the door under any circumstances. If terrorists threaten to kill passengers, the pilots are to land the plane and won't be held accountable for any deaths that result. After all, giving into the demands to open the door and turn over control of the plane could mean the death of all on board as well as people on the ground. The pilot's door should also be bullet-proof (in case a weapon is smuggled on board).
El Al does this (in addition to other security measures) and they haven't had a single hijacking even though they're a huge target.
Re:is this "obvious news day" again? (Score:1, Insightful)
Mods mod this flamebait? Bad bad bad, parent is merely explaining the post of ggp. Valid mod options: Informative, Redundant.
Re:Why Would You Expect Otherwise? (Score:3, Insightful)
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?
Re:is this "obvious news day" again? (Score:5, Insightful)
-If you have the same name, initials or hair color as a felon, you're on the list.
-If you've ever lived withing a 5 mile radius of a felon, you're on the list.
Any thoughts?
It takes more than just being a felon.
I have a felony conviction (non-violent). I've flown 3 times since being discharged from parole and haven't run into any difficulties at the airports.
There are many different types of felonies. Many felons are, indeed, very very bad people. However, I personally know several convicted felons who I would trust to babysit my children, or loan money to. Most of the people I know in that category got their felony convictions as a result of substance abuse issues and have since cleaned up their act.
Just wanted to point out that having a felony conviction doesn't necessarily mean somebody is an evil person.
Terrorism measures and the TSA (Score:5, Insightful)
One could wonder whether the project was set up to adress terrorism OR it was setup to generate media-attention ?
I work at an airport, in administration, and trust me when I say this has very little to do with dark political conspiracies, and a lot to do with the government's haste to show they were "doing something" after 9/11. This project was quickly rushed into service, and has been widely reviled by airports and airport police departments across the country. And other similar measures... the current background check process for giving access to secured areas, and the very creation of TSA itself, were all measures to reassure the public that something was getting done. The problem is that government enterprises like these tend to become bipartisan boondoggles, with every state and major city wanting a piece of the political and funding action these things entail. Federal agencies tend to become monsters that need to justify their own existence by constant growth. TSA in particular is quickly becoming a large federal law enforcement agency, not just a baggage security team. When they were first set up, several of their nascent teams moved and basically tried to take control of several airports... I know of one major southern airport where they simply showed up one day, declared that a series of offices now belonged to them, and when the airport director came down to see what was going on, they tried to have him arrested by his own police force for "violating federal facilities". Anyone that works with AAAE members (airport execs group) knows what incident I'm talking about.
Did you know that TSA will now be issued police-like blue uniforms, with metal badges, just like cops? Airport police and the metropolitan police departments that supplement them just looooove that, and there's the inevitable talk of actually giving said TSA agents firearms. Unlike some other police departments, TSA agents are being encouraged to wear their uniforms and badges in their spare time, in order to enhance the agency's "visibility" to the public. There are already jokes that TSA SWAT teams are inevitable at airports. The problem is, the laughter doesn't last very long when we realize that the way things are going, that might not be a joke so much as a prediction of the future.
Re:That's what happens when.... (Score:3, Insightful)
As they say, "sh-t flows down-hill."
Nah. it much too often floats at the top.
Re:That's what happens when.... (Score:3, Insightful)
Oddly enough changing lackeys can in fact change things. For example whilst they might both be corrupt, the more intelligent group remains aware that you don't fuck up the system when attempting to extract as much money out of it for yourself otherwise the system collapses and there is a whole lot less money to be made.
The other group represents the ignorant pigs at the trough, idiot children in a candy store or basically the sociopaths. Those whose greed destroys the system they are pillaging as they show no restraint with regard to their actions.
So the real difference is whilst you might be employing lackeys, the lackeys you are employing are actually skilled at the job you a employing them for, rather the just idiotically corrupt placements where it is inevitably that they will fuck the job up, "Brownie, you did a heck of a job", forcing everybody to lie about the results.
Re:Number of tables (Score:3, Insightful)
What? So, we need the SSN or DL number of Osama bin Laden now?
Name searching, as weird as it may sound to some DB people, is one of the most reliable ways to match record to person. Sure, you *want* to have additional information to know that you have the correct Sammy Smith, but you have to start with the name.
Of course, this is aside the fact that DNFL was a stupid idea. An idea brought as a *reaction* to 9/11 so politicians could point at it and say how much they are protecting the public. A list that in fact would do nothing to prevent 9/11 in the first place.
Re:Terrorism measures and the TSA (Score:3, Insightful)
I work at an airport, in administration, and trust me when I say this has very little to do with dark political conspiracies, and a lot to do with the government's haste to show they were "doing something" after 9/11.
I didn't need an airport administrator to tell me that this is all just Security Theater, but thanks for the confirmation just the same.
Did you know that TSA will now be issued police-like blue uniforms, with metal badges, just like cops? Airport police and the metropolitan police departments that supplement them just looooove that, and there's the inevitable talk of actually giving said TSA agents firearms. Unlike some other police departments, TSA agents are being encouraged to wear their uniforms and badges in their spare time, in order to enhance the agency's "visibility" to the public.
Oh goody, we can have our very own Security Theater Troupe performing for us, only with non-voluntary audience participation!
Re:Large Systems are Hard (Score:3, Insightful)
Maybe (Score:2, Insightful)
they should stop using MSAccess.
So, it doesn't work... (Score:3, Insightful)
...and yet despite it's failure to protect us, we have not been attacked.
Perhaps, just perhaps, this is evidence that it is not necessary?
Re:That's what happens when.... (Score:4, Insightful)
Cynicism is cute and all, but don't let it impair perceiving the world. Regarding the hiring policies for non-political-appointees at justice, previous administrations (of both parties) did NOT in fact do what this one did.
Sure, politicians in general, suck. But don't let your depression about this prevent you from noticing when some of them suck considerably harder.