HackTheBox - Bookworm

[@boogieman97]

Wow nicely done! I really like the way you have used classes in Python. The reason why asynchronous works so well, is because it tells the CPU to switch threads while there is slack time when it isn't really processing something, so it jumps to another thread within the process and it does that constantly. If you're cooking you're also not going to stop and do nothing while the oven is preheating. 😅 👏

[@boogieman97]

Ooh and a const in a loop is not possible, since it is a constant and of an immutable type which can only be declared ones and not updated within a while loop.

[@ippsec]

Thanks that makes total sense

[@Gordin508]

0:35 I fully expected that sentence to continue with "and by the end of the day, I had created my own Javascript framework".

[@pa-vl1kg]

and then you realise that he doesn't understand the await operator, so he puts it even when he calls the async function LOL (line 13 on VC @46:30), also he could have read the error message, it says right there.

[@0xdreadnaught]

I like how your videos have become reminders to release my season0 writeups lol great work as always man

[@The_Dark_Cats]

That was some voodoo! I understood about 10% at best. But i really enjoyed watching this. Great job as always!

[@pa-vl1kg]

@31:00 the best way to try js code is not the console prompt, but by clicking the icon that it's on the far right of the console prompt, called: multi-line editor mode.

[@souleymaneadellah1176]

Ippsec I hope you start doing live boxes some times just for us to see your thought process and maybe get a glimpse of how you do in real engagements

[@WyldeZk]

Loved this box! I used xhr api for the js script but I’ll definitely switch to fetch api in the future

[@malikkkk2679]

Great video as always, been looking forward to this one. Btw I'm not sure if you're aware, but in the converter web app it's also possible to get RCE by uploading a file with the extension .recipe which contains python code. Apparently the calibre converter will happily run any python code in .recipe files :)

[@ippsec]

I had no idea. That is cool

[@AUBCodeII]

Hi, how did you find this out?

[@malikkkk2679]

​@@AUBCodeII just by reading the docs

[@AUBCodeII]

@@malikkkk2679 I see. Thanks for the response

[@cymzfr]

I love what you do and learn a lot thanks ippsec❤

[@LePirate5930]

Thank you for the video realy appreciate it !

[@perfectshow-bx1ov]

Thanks sirji for this video ❤❤❤

[@orpheus0108]

Isn't the requests.Session() an instantiated object and therefore mutable? So wouldn't it be passed by object reference, meaning you wouldn't have to return anything to make changes to its data? I may be wrong, thoughts?

[@ippsec]

I think you are correct - However, that is now how my brain things code/functions/etc should work. So I avoid taking advantage of that.

[@orpheus0108]

​@ippsec ah yeah, I get what you mean. I love python but the weak typing makes things really ambiguous sometimes.

[@tntxqx8281]

Nice work ippsec, keep going

[@MusicDimensionYoutube]

Maybe that's a silly question, but, in the last piece when we try to write the key for root, we cannot just modify the entry in the database with the postscript payload and re run the script, pretending there was no sql injection in the python script? Sorry about my probable grammar errors in that sentence 😅 . Great video as always, we love IppSec.

[@ippsec]

Umm I hate myself right now, most likely you could totally do that 😂 I just didn’t think of it

[@MusicDimensionYoutube]

@@ippsec I'm sorry i didnt meant to point it out because i want to say that was a better way, that was no my intention at all, i was just wondering if that was possible, and to test my level of understanding 🤣. You show anyways that the script was vulnerable to sql injection, and how to benefit from that, so definitely your way is the best for us and for the sake of learning, as the purpose of your videos are sharing knowledge. As always you re the goat, thanks for all your videos.

[@ippsec]

@@MusicDimensionKZbin No i'm happy you did haha. Was more sarcastic

[@MusicDimensionYoutube]

@@ippseci totally get the sarcasm. I'm happy to know that modify the entry was an option that could work, I'm still learning and see that maybe I get something right make me willing to learn more and definitely you're the right place to learn, your approach to solve the boxes is amazing, the explanations of the steps you take to find the informations and the beyond root part is gold.

[@AUBCodeII]

​@@MusicDimensionKZbin I believe it's not possible to write to the file /root/.ssh/authorized_keys doing what you suggested because each injectable column can contain only up to 20 characters: Injectable columns: name, addressLine1, addressLine2, town, postcode MariaDB [(none)]> desc bookworm.Users \G *************************** 2. row *************************** Field: name Type: varchar(20) *************************** 6. row *************************** Field: addressLine1 Type: varchar(20) *************************** 7. row *************************** Field: addressLine2 Type: varchar(20) *************************** 8. row *************************** Field: town Type: varchar(20) *************************** 9. row *************************** Field: postcode Type: varchar(20) So, if you tried to change one of those columns to the PostScript payload, you would get an error saying you tried to insert too many characters on a column.

[@coursachGPT]

what vs code extensions do you use? autocomplete looks awesome

[@ippsec]

That is Github Copilot

[@apkanalyze3623]

One more question: when we identify SQL injection in GenLab and you mentioned that ‘it is not giving any new privileges,’ considering this binary runs with sudo, wouldn’t executing a system command through SQL injection grant us a privileged shell? I mean without needing ps2pdf, I might be mistaken, but I’d like to find out.

[@ippsec]

Running through SQL would still be a SQL User not root. So having the option to exploit SQL or the Injection to PDF Generator... I go for PDF Gen since that is running as root.

[@apkanalyze3623]

Hi IppSec, there's something I'd like to clarify to ensure I'm not misunderstanding. We observed the "script-src 'self'" directive in the HTTP response, which, as I understand it, allows scripts to run only from the same origin as the webpage. However, we also made an attempt to provide our IP address (10.10.14.8) which is different origin. Am I missing something? confused me because you also said that "I dont know what is blocking us"

[@ippsec]

I believe it blocks the page itself from running Javascript on itself, which is why the Alert() did not work, and there's something that's blocking you from loading scripts externally, so you can't just directly point it at yourself. Which is why I needed to host the script on the server through Avatar. I never run code from a server on my own IP, I just exfil data there. That said, in hindsight, I never tried to just point the javascript back to myself then do the malicious things there. I don't think it would work, but its possible would be a good thing to try out yourself and see why it does or doesn't work.

[@sassywoocooo]

hey ippsec would you consider doing THM too?

[@trueperson-o2z]

Curious about this too.

[@ippsec]

Nope, when they launched we got off on the wrong foot and I also didn’t enjoy their content. I feel there’s less effort put into making sure it’s quality content. Could have changed now; but I have no reason to check them out. Also I do work for HackTheBox now, did not for the first few years of doing videos. So not only would I be highlighting a site I don’t support, I’d also be highlighting a competitor

[@sassywoocooo]

@@ippsec in terms of content quality, you're absolutely right. TryHackMe seems to be making very "small" boxes in comparison to HackTheBox. so I understand your point.

[@AUBCodeII]

​@@ippsec you are HTB employee of the month (read this with Simeon Yetarian's voice)

[@tntxqx8281]

Good point

[@blackmine57]

1:27:26 I love this "oh". This was so funny

[@sotecluxan4221]

[@ChesapeakeMonstro]

when did you learn python ippgoat

[@RISE_BEFORE_YOU_GREECE]

Ippsec Is Python Charmer 😂

[@tg7943]

Push!

[@bowlofbootloops]

First

[@AUBCodeII]

Ip, Ipp and Ippy

[@0xrod]

@ippsec when copying node source code, you can skip the node_modules. much lighter and faster.

[@Exodia1988]

23:33

[@RISE_BEFORE_YOU_GREECE]

Too Many Joke About Javascript In Programming Memes , Call That Javascript Is Drunken Language 😂😂 Async Await Just Work On Function 😅 That's What I Know, Im From Java Dev 😂

[@AUBCodeII]

1:14:55 ipp-womp-womp.mp3