Live data from Hacker News

Bypassing airport security via SQL injection

ian.sh

401–410 of 459 posts

Re: Bypassing airport security via SQL injection

#401
post #367
post #16

Earlier quoted context omitted.

Does anyone remember Bruce Schneier and his faked boarding passes? The TSA scribble used to be the weak point of the entire system.

I don't https://www.schneier.com/crypto-gram/archives/2003/0815.html... https://www.schneier.com/essays/archives/2006/11/the_boardin...

Thanks for posting the links. I looked for 5 minutes but couldn't get Google to give me what I wanted, so I gave up and hoped for a kind internet stranger to help. Today you were that hero!

Re: Bypassing airport security via SQL injection

#402

Earlier quoted context omitted.

It’s very hard for management, even IT managers, to fully understand what such things mean. I’ve seen huge issues, like exposed keys, being treated as a small issue. While an outdated js library, or lack of ip6 support being escalated. I’m sure TSA and their partners wants to downplay potential exposure, I’m also sure it’s hard for a lot of their managers to fully understand what the vulnerability entails (most likel…

This is the Transportation SECURITY Agency. If the managers involved here can't understand why this is a huge deal, they're exceptionally unqualified for their jobs. Edit: Fixed a double negative (previously: This is the Transportation SECURITY Agency. If the managers involved here can't understand why this is a huge deal, they're not exceptionally unqualified for their jobs.)

> If the managers involved here can't understand why this is a huge deal

Was it a huge deal though?

Re: Bypassing airport security via SQL injection

#403
post #192

Earlier quoted context omitted.

I once got called into jury duty and sat through jury selection. On that day, protesters were outside the courthouse calling awareness to jury nullification, so the judge brought it up. He said something like: "jury nullification is a constitutional right, but you waive those rights when you take the oath of a juror. It is not an option to you." I really wanted to say "but that constitutional right is not my right, i…

> But it still bothers me that the judge was so glib about "waiving" the constitutional rights of the defendant. Around here, people are clamoring for a judge to be recalled because she is on top of rights for defendants. A recent one I watched on Zoom was a prosecution motion to revoke bail: Prosecutor: "Because blah blah blah, and in addition the defendant shows no signs of taking responsibility for his actions, we…

People want that judge to be recalled? So not only are people opposed to trial by jury, they also want the judge to be biased towards the prosecution? Why? Just the usual "tough on crime" dogwhistles?

Re: Bypassing airport security via SQL injection

#404
post #212

Earlier quoted context omitted.

Well Guantanamo Bay still exists. From https://en.m.wikipedia.org/wiki/Guantanamo_Bay_detention_cam... : > As of August 2024, at least 780 persons from 48 countries have been detained at the camp since its creation, of whom 740 had been transferred elsewhere, 9 died in custody, and 30 remain; only 16 detainees have ever been charged by the U.S. with criminal offenses. Given what we do know about the secretive and ill…

780 persons - 740 persons transferred - 9 persons dead = 31 persons that should remain. Oh wiki.

[deleted]

Re: Bypassing airport security via SQL injection

#405
post #307

Earlier quoted context omitted.

This used to be a question on the Triplebyte interview almost verbatim, and a huge percentage of (even quite good) engineers got it wrong. I'd say probably <20% both salted and used a cryptographically-secure hash; MD5 specifically came up all the time. And keep in mind that we filtered substantially before this interview, so the baseline is even worse than that!

Damn. Using salts and avoiding MD5 in favour of SHA-1 was well known even around 2005. Rainbow tables were a thing even then.

Using pure SHA for passwords is almost equally bad as MD5, because the biggest problem with these algorithms is their speed (MD5 is completely broken when it comes to collision resistance, of course, but that's not the main concern with passwords). Instead, you should use functions like bcrypt or PBKDF2, which are purposefully built for passwords.

Re: Bypassing airport security via SQL injection

#406
Meanwhile, my wife just had a beautiful ameythyst she bought as a birthday gift for my son stolen by security in Mexico because it "could be used as a weapon". I say stolen because they wouldn't throw it away and just smirked the whole time at her.

It is sadly an all-too-common occurence when you give uneducated dimwits police-level power with no oversight and no recourse for anyone affected. I assume flexing government power is the real objective here since everybody knows that security is not.

Re: Bypassing airport security via SQL injection

#407
post #92

Earlier quoted context omitted.

It’s also just one of those hard things to prove: is TSA actually stopping attacks like 9/11? The simple presence of them might be enough of a deterrent or we might just be extremely lucky. Seems these days the real threat is drunk passengers attacking flight attendants.

Have they caught and arrested any would-be bad guys? Should be pretty easy to verify.

But how many were caught by TSA?

Re: Bypassing airport security via SQL injection

#408

Earlier quoted context omitted.

>destabilisation of Middle East diverted them away from continental US I put on my critical thinking hat and look at the timeline of "US meddling in the Middle East" and "first terror attack in the US by a middle eastern". I then notice that the years are 1948 and 1993 respectively and that wet roads actually do not cause rain after all.

I assume by 1948 you mean Israel’s declaration and subsequent war of independence. The US had nothing to do with Israel forming beyond being part of the UN vote - Britain was the architect of this part of the Middle East and is responsible for every border drawn by all nations there. This was fallout of the Ottoman Empire choosing to go to war against Western Europe and being defeated (after hundreds of years of inco…

> The US had nothing to do with Israel forming beyond being part of the UN vote

I put on my history hat and check the books

> Liberia's Ambassador to the United States complained that the US delegation threatened aid cuts to several countries.

> After a phone call from Washington, the representative was recalled and the Philippines' vote changed.

> After considering the danger of American aid being withheld, France finally voted in favour of it. So, too, did France's neighbours, Belgium, Luxembourg, and the Netherlands.

> [......]

Mind you that I am not calling foul play here, this is par for the course for politics. This is just to refute the quoted point above, unless you consider bribery and threats of sanctions a "nothing".

Re: Bypassing airport security via SQL injection

#409

Earlier quoted context omitted.

Pretty much, although most TsA check lines no longer require even a boarding pass- so in theory you could pack a bomb with you then bypass all the security theater with this.

My presumption was that when you give TSA your ID and they scan it, their systems check that there’s a boarding pass in your name (and DOB)?

I don’t think so- I believe it just checks the outstanding warrant/no fly list and that’s all, but I could be wrong.

Re: Bypassing airport security via SQL injection

#410

Earlier quoted context omitted.

This is the Transportation SECURITY Agency. If the managers involved here can't understand why this is a huge deal, they're exceptionally unqualified for their jobs. Edit: Fixed a double negative (previously: This is the Transportation SECURITY Agency. If the managers involved here can't understand why this is a huge deal, they're not exceptionally unqualified for their jobs.)

> If the managers involved here can't understand why this is a huge deal Was it a huge deal though?

It was the most humongous deal if we talk about IT security. SQL injection shouldn't be a thing in today's IT landscapes. And here we are giving everyone and their mother admin access to a database where the attackers can literally get not only on a plane but also in the fucking Cockpit. So yes, big big deal.
Post reply on HN