#!/bin/bash # Task3: preserve supplied import.sh and supplement its omitted address fields. set -euo pipefail mkdir -p /root/kim2027-import /mnt/additional chmod 700 /root/kim2027-import mountpoint -q /mnt/additional || mount -o ro /dev/sr0 /mnt/additional cp /mnt/additional/import.sh /mnt/additional/users.csv /root/kim2027-import/ cd /root/kim2027-import python3 <<'PY' import csv import subprocess rows = list(csv.DictReader(open('users.csv', newline=''), delimiter=';')) names = [(r['First Name'][0] + r['Last Name']).lower() for r in rows] assert len(names) == len(set(names)), 'Duplicate CSV usernames' existing = set(subprocess.check_output(['samba-tool', 'user', 'list'], text=True).splitlines()) assert not existing.intersection(names), 'Import already started: review before re-running' assert all(r['Country/Region'] == 'Russia' for r in rows), 'Review country code mapping' print('Validated CSV rows:', len(rows)) PY # The supplied file uses CRLF; keep the original and normalize only the runner. sed 's/\r$//' import.sh > import-lf.sh bash -n import-lf.sh bash import-lf.sh > import.log 2>&1 chmod 600 import.log python3 <<'PY' import csv import ldb import subprocess from samba.auth import system_session from samba.param import LoadParm from samba.samdb import SamDB lp = LoadParm(); lp.load_default() db = SamDB(url='/var/lib/samba/private/sam.ldb', session_info=system_session(), lp=lp) rows = list(csv.DictReader(open('users.csv', newline=''), delimiter=';')) for row in rows: username = (row['First Name'][0] + row['Last Name']).lower() found = db.search(base=db.domain_dn(), expression='(sAMAccountName=%s)' % ldb.binary_encode(username)) if not found: # The original while/read loop skips a final CSV row without newline. subprocess.run(['samba-tool', 'user', 'create', username, row['Password'], '--given-name='+row['First Name'], '--surname='+row['Last Name'], '--job-title='+row['Role'], '--telephone-number='+row['Phone'], '--userou=OU='+row['OU']], check=True, capture_output=True) found = db.search(base=db.domain_dn(), expression='(sAMAccountName=%s)' % ldb.binary_encode(username)) assert len(found) == 1, username attrs = {'givenName': row['First Name'], 'sn': row['Last Name'], 'title': row['Role'], 'telephoneNumber': row['Phone'], 'streetAddress': row['Street'], 'postalCode': row['ZIP/Postal Code'], 'l': row['City'], 'co': row['Country/Region'], 'c': 'RU', 'countryCode': '643'} msg = ldb.Message(); msg.dn = found[0].dn for key, value in attrs.items(): msg[key] = ldb.MessageElement(value, ldb.FLAG_MOD_REPLACE, key) db.modify(msg) check = db.search(base=msg.dn, scope=ldb.SCOPE_BASE)[0] for key, value in attrs.items(): assert str(check[key][0]) == value, (username, key) assert str(check.dn).lower().endswith(('OU=' + row['OU'] + ',' + str(db.domain_dn())).lower()), username print('ALL_CSV_ATTRIBUTES_AND_OU_VERIFIED:', len(rows)) PY