12
How to say you're vulnerable to code injection without saying you're vulnerable to code injection.
this post was submitted on 24 Jan 2024
12 points (100.0% liked)
Cybersecurity - Memes
1796 readers
327 users here now
Only the hottest memes in Cybersecurity
founded 1 year ago
MODERATORS
Are they vulnerable though, if they already exclude it at the user input?
I yet have to learn SQL and is there a way to allow passwords with '); DROP TABLE... without being vulnerable to an injection?
nevermind i googled it, and there various ways to do so
This still smells though. Why is the raw, plain text password string getting anywhere near database queries in the first place?
I doubt it is. they probably have a WAF that blocks these strings though and didnt want to bother reconfiguring it
Prepared statements, mostly. You define the query using variables, turn that query into a language-dependent object, assign values to those variables, then execute the statement. The values will be passed verbatim, without any parsing.
Or, since we're talking about a password, you could encode or encrypt it before inserting it into the query string. The fact that the website could be negatively affected by phrases in the cleartext password is very concerning.
At best, it means they're storing your password instead of just a salted hash. And that's horrible.
I noticed that upper case select, drop etc are not prohibited.
Poorly implemented user input filters are not a valid solution to being vulnerable to injection.
No one in their right mind is storing plain text passwords, or letting them anywhere near the database.
You convert the password to a hash, and store that. And the hash will look nothing like the password the user typed.
You're right. No one in their right mind would do that.
On the other hand, people not in their right mind often run things. Such as my old professional liability insurance. Which wrote the username and password in the yearly statements...
And also sent you the password through email if you forgot it...
Also you couldn't change it...
There was a popular companion app to a game I play that’s stored passwords as MD5 hashes for years and when they got hacked they were able to decrypt everything.
Bonus point, the app was released multiple years after md5 was cracked.
Developers (including myself) cannot be trusted to implement the correct process 100% of the time. It’s happened too many times for it to be a single person issue and has transcended into a problem with software engineers
I don't believe this is real. This isn't real, right?
This is real - I took the screenshot myself.
So they’re not hashing or salting the passwords too. Cool…
Which makes me want to try and insert a password of a few megabytes worth of text. Should be fine, since there is no max lenght defined, right?
If there is no overwrought prohibition of something I know that at least in America that means it’s
- Affirmatively legal and
- Legislatively encouraged by the FREEE Act
So give ’em hell!
Obligatory Little Bobby Tables: https://xkcd.com/327/
And for those who feel like saying they've already seen it: https://xkcd.com/1053/
Little Bobby drop tables
Oh BobbyTables, you little rapscallion...
Looking at that I wouldn't be surprised if those rules are just client-side validation.
submits Drop Table as passphrase
Grabs popcorn
We could still have some fun with ALTER TABLE
Didn't say anything about truncate!