PG Nibbles

-

I look into vsftpd 3.0.3 first. Only a DDoS vulnerablity exists. Anonymous login is not working.

I move onto port 80. I don't see anyting interesting. ffuf is not showing anything.

It must be the postgresql server. I try psql and it does not work. It does not work because I need to set the port! The postgresql is sitting on port 5437. The default port is 5432. The default username/password is postgres/postgres.

I don't know much about postgres so I go on hacktricks. https://book.hacktricks.xyz/network-services-pentesting/pentesting-postgresql

The three metasploit modules stand out.

I read the /etc/passwd file. wilson is a user. I try to read /home/wilson/.ssh/authorized_keys and /home/wilson/.ssh/id_rsa. He does not have either. Reading doesn't help. The /bin/bash on postgres is insteresting to me.

I got stuck on this part for 1 hour. I use my favorite port 443 for reverse shells. Most Firewalls allow port 80 and 443. In Offsec fashion, they blocked port 443. I have run into this issue on another Offsec box a year ago. After an hour, I change the port to 80 and this exploit works.

I finally have a shell on a box. Priv Esc takes little time. Wget linpeas.sh and run it.

Find on gtfobins: https://gtfobins.github.io/gtfobins/find/

🗡️ Solved in Under 4 Hours 🗡️

First Intermediate box yay! I'm playing pokemon now. I collected postgres. I'm still looking for Oracle, MySQL, and more web apps.

Lessons Learned

  1. If a reverse shell is not working, try setting port 80 on it.
  2. First Postgres hack.
  3. Starting a Postgres Jutsu sheet

Additional Work

Manual Exploit

I want a manual exploit. 50847 works. searchsploit -m 50847. https://www.exploit-db.com/exploits/50847

FTP User/Pass List

For when I was using hydra on FTP: https://github.com/danielmiessler/SecLists/blob/master/Passwords/Default-Credentials/ftp-betterdefaultpasslist.txt

Actually going a directory up, this all looks good. https://github.com/danielmiessler/SecLists/tree/master/Passwords/Default-Credentials

Read this and grap important info for jutsu sheet: https://medium.com/@netscylla/pentesters-guide-to-postgresql-hacking-59895f4f007 and https://book.hacktricks.xyz/network-services-pentesting/pentesting-postgresql

Comments

Post a Comment

Popular posts from this blog

Palo Alto for GNS3 CCDC Tutorial

-
Image
Opening Hello fellow CCDC Competitors! Struggling to get a Palo-Alto VM? I know how you can get one! Email me at ASzampiasSWD@gmail.com. I'll tell you the steps to get a PA-VM for GNS3. Why am I giving this info to you? Wouldn't it make sense to hog the info to myself? Wouldn't my team have an advantage? There are have and have not universities when it comes to PaloAltos. I fell into the "have not" group. Our college didn't have access to PA-VMs and still doesn't. Even if PA Cybersecurity Academy is free, there is too much red tape. I can't change the outcome. I can only come up with this one solution. Another reason is Tri-C is a tryout team. I think its pretty unfair as a potential Firewall Admin I'm the only one with access. No one can challenge me unless they spend 2K for a PA-VM. It becomes a rich-person only position. I have a leftover PA-VM from 2018 I promised not to share. I couldn't share that with my challengers. But I f...
Read more

Trace Labs Global Missing Persons CTF V

-
Image
Trace Labs CTF V TraceLabs hosted the Global Missing Persons CTF V event on July 11, 2020. My team //synergy got 64th place out of 190 teams. Introduction This was my first Trace Labs CTF. I captained a team. The good thing about being a captain is you can control who is on the team. My rules were: Must have sock puppet accounts ready. Must have a VPN. Writing out this is a competitive team where we work the entire 6 hours. I was worried about a future team member spamming submissions and disqualifying the team. I thought my requirements would eliminate people who weren't serious. The team hit 4 members Friday evening pretty quickly. Notes My laptop was too slow for this event. My virtual machine froze and I had to restart. Restarting means I have to login to my accounts again. I'll use my desktop next time. The team used Slack and Trello. Our strategy was to research a person and rotate every hour. This strategy broke after 1 rotation. Some missin...
Read more

Release of CCDC ISE Manager Website

-
Image
I worked on the ISE (Inject Scoring Engine) website from 2017 to 2019. I made it to encourage teams to follow a merit-based, open admission tryout format. I identified a problem and made a solution for it. Problem: Call for Merit and Fairness on CCDC Rosters Solution: Github Project Solution: How to run a Team After Tri-C was finished with 2017 Midwest Wildcards I used httrack to grap the Inject PDF files. I didn't grap just the files, but the entire front-end code of the website. If you created the HTML and CSS of the original ISE website, tell me your name so I can give you credit! My goal was to make an almost-replica of the original. The database and back-end code is all guessing by me. I used a LAMP stack because I believe the original website is built on that. I did some fingerprinting and found the "ccdcadmin1" website was hosted on Apache and PHP. If you notice any bugs or errors let me know. If you want a feature added let me know. I will be working ...
Read more