Using CodeQL to Investigate GraphQL Resolvers

Channel:

LiveUnderflow

Subscribers:

39,500

Published on December 22, 2022 3:45:02 PM ● Video Link: https://www.youtube.com/watch?v=VrF1RwnJzBk

Duration: 50:57

11,613 views

355

First time using CodeQL, trying to find an access control bug in a nodeJS application using ApolloServer for GraphQL.

My Shop (advertisement): https://shop.liveoverflow.com/

CodeQL: https://codeql.github.com/
RedEye: https://github.com/cisagov/RedEye
Reported Issue: https://github.com/cisagov/RedEye/issues/55

Chapters:
00:00 - Introduction
04:20 - The Research Question
06:40 - Getting Started CodeQL
09:24 - CodeQL for Visual Studio Code
12:41 - CodeQL Setup
16:55 - Create CodeQL Database
20:29 - Running First Query
22:26 - AST Viewer
28:36 - Create New Query
38:36 - ChatGPT Mixes CodeQL with SQL
30:28 - First Successful Query - Review Results
41:25 - Adding "Mutations" to Query
45:05 - Discovering Bug
45:56 - Proof of Concept with Burp
47:14 - Create Mutation PoC with ChatGPT
49:01 - Report Bug
50:16 - Conclusion

---

→ Twitch Subscription: https://www.twitch.tv/products/liveoverflow
→ per Video: https://www.patreon.com/join/liveoverflow
→ per Month: https://www.youtube.com/channel/UClcE-kVhqyiHCcjYwcpfj9w/join

=[ 📄 Info. ]=

Main Channel: https://youtube.com/LiveOverflowCTF
Twitch: https://twitch.tv/LiveOverflow

=[ 🐕 Social ]=

→ Twitter: https://twitter.com/LiveOverflow/
→ Website: https://liveoverflow.com/
→ Subreddit: https://www.reddit.com/r/LiveOverflow/
→ Facebook: https://www.facebook.com/LiveOverflow/

-=[ 📄 P.S. ]=-

#liveoverflow