# Clean clone: secrets, config, build, migrations from zero, start, versions
# 2026-10-31T14:18:15Z, commit cf6e929 docs: PIPELINE, DEFENSE, DATA_MODEL, WINDOWS для lab5; черновик REPORT

$ git status --short --branch
## solution/bvt2302-bodanyuk...origin/solution/bvt2302-bodanyuk
[exit 0, 0.1 s]

$ C:\Users\wfa22\AppData\Local\Python\pythoncore-3.14-64\python.exe --version
Python 3.14.6
[exit 0, 0.0 s]

$ docker version --format client {{.Client.Version}} / server {{.Server.Version}}
client 29.8.0 / server 29.8.0
[exit 0, 0.1 s]

$ docker compose version
Docker Compose version v5.5.1
[exit 0, 0.1 s]

$ make --version
GNU Make 4.4.1
Built for Windows32
Copyright (C) 1988-2023 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <https://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
[exit 0, 0.0 s]

$ python scripts/init_secrets.py
created secrets/postgres_password
created secrets/valkey_password
created secrets/database_url
created secrets/cache_url
created secrets/s3_admin_access_key_id
created secrets/s3_admin_secret_access_key
created secrets/s3_api_access_key_id
created secrets/s3_api_secret_access_key
created secrets/s3_worker_access_key_id
created secrets/s3_worker_secret_access_key
created secrets/s3_auditor_access_key_id
created secrets/s3_auditor_secret_access_key
created secrets/rabbitmq_relay_password
created secrets/rabbitmq_worker_password
created secrets/rabbitmq_users.json
created secrets/broker_url_relay
created secrets/broker_url_worker
[exit 0, 0.1 s]

$ cp .env.example .env

$ docker compose --env-file .env config --quiet

[exit 0, 0.2 s]

$ docker compose --env-file .env up -d --build --wait
#1 [internal] load local bake definitions
#1 reading from stdin 1.32kB 0.0s done
#1 DONE 0.0s

#2 [migrate internal] load build definition from Dockerfile
#2 transferring dockerfile: 2.96kB done
#2 DONE 0.1s

#3 [migrate] resolve image config for docker-image://docker.io/docker/dockerfile:1
#3 DONE 6.2s

#4 [migrate] docker-image://docker.io/docker/dockerfile:1@sha256:4edf897a3ffa55b89f906fc8cc78afdb3f1834cc9c7083565e611a8a7d5fe99e
#4 resolve docker.io/docker/dockerfile:1@sha256:4edf897a3ffa55b89f906fc8cc78afdb3f1834cc9c7083565e611a8a7d5fe99e 0.0s done
#4 CACHED

#5 [api internal] load metadata for docker.io/library/python:3.13.16-slim-bookworm@sha256:a1165e272e578941b84abc79e4ab38a0305cd12803a5c4247979ac7655f4d641
#5 DONE 2.1s

#6 [migrate internal] load .dockerignore
#6 transferring context: 196B done
#6 DONE 0.1s

#7 [migrate 1/9] FROM docker.io/library/python:3.13.16-slim-bookworm@sha256:a1165e272e578941b84abc79e4ab38a0305cd12803a5c4247979ac7655f4d641
#7 resolve docker.io/library/python:3.13.16-slim-bookworm@sha256:a1165e272e578941b84abc79e4ab38a0305cd12803a5c4247979ac7655f4d641 0.1s done
#7 DONE 0.1s

#8 [api internal] load build context
#8 transferring context: 525.52kB 0.1s done
#8 transferring context: 525.52kB 0.1s done
#8 DONE 0.2s

#9 [api 2/9] WORKDIR /app
#9 CACHED

#10 [api 3/9] COPY requirements.txt ./
#10 CACHED

#11 [api 4/9] RUN pip install --root-user-action=ignore --require-hashes --no-deps -r requirements.txt
#11 CACHED

#12 [api 5/9] RUN apt-get update     && apt-get install -y --no-install-recommends libjpeg-turbo-progs=1:2.1.5-2     && rm -rf /var/lib/apt/lists/*
#12 CACHED

#13 [api 6/9] RUN groupadd --system --gid 10001 app     && useradd --system --uid 10001 --gid app --no-create-home --shell /usr/sbin/nologin app
#13 CACHED

#14 [api 7/9] COPY src/ ./src/
#14 DONE 0.1s

#15 [api 8/9] COPY migrations/ ./migrations/
#15 DONE 0.1s

#16 [migrate 9/9] COPY contracts/openapi.json ./contracts/openapi.json
#16 DONE 0.1s

#17 [api] exporting to image
#17 exporting layers
#17 exporting layers 0.3s done
#17 exporting manifest sha256:d5ce436c70dc889fae295b9c569550143a49023a8c8c276e83ec5b3e3e156d4d 0.0s done
#17 exporting config sha256:bd8b08e1de339150644db0527530d2ee10f7fdac39fb495916259bb92f8157ea 0.1s done
#17 exporting attestation manifest sha256:88b54cc6ae37ccc6d7bed5b2f499e6d2ad7b184c25c8f8da067db4010c4f341f 0.1s done
#17 exporting manifest list sha256:7689cb4ef3a9f3649524415f9528e0c84610759d6536e522dc5ea0d4305e3878
#17 exporting manifest list sha256:7689cb4ef3a9f3649524415f9528e0c84610759d6536e522dc5ea0d4305e3878 0.0s done
#17 naming to docker.io/library/mtusi-messenger:lab5 0.0s done
#17 unpacking to docker.io/library/mtusi-messenger:lab5
#17 unpacking to docker.io/library/mtusi-messenger:lab5 0.2s done
#17 DONE 0.8s

#18 [migrate] exporting to image
#18 exporting layers 0.3s done
#18 exporting manifest sha256:9b9171737d004d0514b7adf53f37158be51e19440ab86d15192ef7d71bcf1ec0 0.1s done
#18 exporting config sha256:2b03ff83f38876a18738b5fcf9676e1c840ca6162cdee4dd6252e1cab242448e 0.1s done
#18 exporting attestation manifest sha256:b62c3a0d59a966c45c4de062852cb7c68895fe85e1e669dce3bfe885f907ac72 0.1s done
#18 exporting manifest list sha256:a3c335533065814c753479d7820efef885c03a58eb62edbf2e21d0f267be982a 0.0s done
#18 naming to docker.io/library/mtusi-messenger:lab5 done
#18 unpacking to docker.io/library/mtusi-messenger:lab5 0.2s done
#18 DONE 0.9s

#19 [api] resolving provenance for metadata file
#19 DONE 0.0s

#20 [migrate] resolving provenance for metadata file
#20 DONE 0.0s
 Image mtusi-messenger:lab5 Building 
 Image mtusi-messenger:lab5 Building 
 Image mtusi-messenger:lab5 Built 
 Image mtusi-messenger:lab5 Built 
 Network mtusi-lab5_data Creating 
 Network mtusi-lab5_edge Creating 
 Network mtusi-lab5_data Creating 
 Network mtusi-lab5_queue Creating 
 Network mtusi-lab5_queue Creating 
 Volume mtusi-lab5_pgdata Creating 
 Volume mtusi-lab5_pgdata Creating 
 Volume mtusi-lab5_s3data Creating 
 Volume mtusi-lab5_s3data Creating 
 Volume mtusi-lab5_rabbitmqdata Creating 
 Volume mtusi-lab5_rabbitmqdata Creating 
 Volume mtusi-lab5_valkeydata Creating 
 Volume mtusi-lab5_valkeydata Creating 
 Network mtusi-lab5_edge Creating 
 Network mtusi-lab5_storage Creating 
 Network mtusi-lab5_storage Creating 
 Volume mtusi-lab5_valkeydata Created 
 Volume mtusi-lab5_valkeydata Created 
 Volume mtusi-lab5_pgdata Created 
 Volume mtusi-lab5_pgdata Created 
 Volume mtusi-lab5_s3data Created 
 Volume mtusi-lab5_s3data Created 
 Volume mtusi-lab5_rabbitmqdata Created 
 Volume mtusi-lab5_rabbitmqdata Created 
 Network mtusi-lab5_data Created 
 Network mtusi-lab5_data Created 
 Container mtusi-lab5-valkey-1 Creating 
 Container mtusi-lab5-postgres-1 Creating 
 Network mtusi-lab5_storage Created 
 Network mtusi-lab5_storage Created 
 Container mtusi-lab5-s3-1 Creating 
 Network mtusi-lab5_queue Created 
 Network mtusi-lab5_queue Created 
 Container mtusi-lab5-broker-1 Creating 
 Network mtusi-lab5_edge Created 
 Network mtusi-lab5_edge Created 
 Container mtusi-lab5-postgres-1 Created 
 Container mtusi-lab5-migrate-1 Creating 
 Container mtusi-lab5-valkey-1 Created 
 Container mtusi-lab5-broker-1 Created 
 Container mtusi-lab5-s3-1 Created 
 Container mtusi-lab5-migrate-1 Created 
 Container mtusi-lab5-s3-init-1 Creating 
 Container mtusi-lab5-relay-1 Creating 
 Container mtusi-lab5-s3-init-1 Created 
 Container mtusi-lab5-api-2 Creating 
 Container mtusi-lab5-api-1 Creating 
 Container mtusi-lab5-worker-1 Creating 
 Container mtusi-lab5-relay-1 Created 
 Container mtusi-lab5-worker-1 Created 
 Container mtusi-lab5-api-1 Created 
 Container mtusi-lab5-api-2 Created 
 Container mtusi-lab5-lb-1 Creating 
 Container mtusi-lab5-lb-1 Created 
 Container mtusi-lab5-s3-1 Starting 
 Container mtusi-lab5-valkey-1 Starting 
 Container mtusi-lab5-postgres-1 Starting 
 Container mtusi-lab5-broker-1 Starting 
 Container mtusi-lab5-s3-1 Started 
 Container mtusi-lab5-valkey-1 Started 
 Container mtusi-lab5-postgres-1 Started 
 Container mtusi-lab5-postgres-1 Waiting 
 Container mtusi-lab5-broker-1 Started 
 Container mtusi-lab5-postgres-1 Healthy 
 Container mtusi-lab5-migrate-1 Starting 
 Container mtusi-lab5-migrate-1 Started 
 Container mtusi-lab5-s3-1 Waiting 
 Container mtusi-lab5-postgres-1 Waiting 
 Container mtusi-lab5-broker-1 Waiting 
 Container mtusi-lab5-migrate-1 Waiting 
 Container mtusi-lab5-migrate-1 Waiting 
 Container mtusi-lab5-s3-1 Healthy 
 Container mtusi-lab5-postgres-1 Healthy 
 Container mtusi-lab5-migrate-1 Exited 
 Container mtusi-lab5-migrate-1 Exited 
 Container mtusi-lab5-s3-init-1 Starting 
 Container mtusi-lab5-s3-init-1 Started 
 Container mtusi-lab5-postgres-1 Waiting 
 Container mtusi-lab5-valkey-1 Waiting 
 Container mtusi-lab5-migrate-1 Waiting 
 Container mtusi-lab5-s3-1 Waiting 
 Container mtusi-lab5-s3-init-1 Waiting 
 Container mtusi-lab5-migrate-1 Waiting 
 Container mtusi-lab5-postgres-1 Waiting 
 Container mtusi-lab5-broker-1 Waiting 
 Container mtusi-lab5-s3-init-1 Waiting 
 Container mtusi-lab5-s3-1 Waiting 
 Container mtusi-lab5-postgres-1 Healthy 
 Container mtusi-lab5-migrate-1 Exited 
 Container mtusi-lab5-s3-1 Healthy 
 Container mtusi-lab5-s3-1 Healthy 
 Container mtusi-lab5-postgres-1 Healthy 
 Container mtusi-lab5-valkey-1 Healthy 
 Container mtusi-lab5-migrate-1 Exited 
 Container mtusi-lab5-broker-1 Healthy 
 Container mtusi-lab5-broker-1 Healthy 
 Container mtusi-lab5-relay-1 Starting 
 Container mtusi-lab5-relay-1 Started 
 Container mtusi-lab5-s3-init-1 Exited 
 Container mtusi-lab5-worker-1 Starting 
 Container mtusi-lab5-s3-init-1 Exited 
 Container mtusi-lab5-api-2 Starting 
 Container mtusi-lab5-worker-1 Started 
 Container mtusi-lab5-api-2 Started 
 Container mtusi-lab5-api-1 Starting 
 Container mtusi-lab5-api-1 Started 
 Container mtusi-lab5-api-2 Waiting 
 Container mtusi-lab5-api-1 Waiting 
 Container mtusi-lab5-api-2 Healthy 
 Container mtusi-lab5-api-1 Healthy 
 Container mtusi-lab5-lb-1 Starting 
 Container mtusi-lab5-lb-1 Started 
 Container mtusi-lab5-valkey-1 Waiting 
 Container mtusi-lab5-postgres-1 Waiting 
 Container mtusi-lab5-s3-init-1 Waiting 
 Container mtusi-lab5-migrate-1 Waiting 
 Container mtusi-lab5-api-2 Waiting 
 Container mtusi-lab5-api-1 Waiting 
 Container mtusi-lab5-s3-1 Waiting 
 Container mtusi-lab5-relay-1 Waiting 
 Container mtusi-lab5-broker-1 Waiting 
 Container mtusi-lab5-lb-1 Waiting 
 Container mtusi-lab5-worker-1 Waiting 
 Container mtusi-lab5-valkey-1 Healthy 
 Container mtusi-lab5-broker-1 Healthy 
 Container mtusi-lab5-worker-1 Healthy 
 Container mtusi-lab5-relay-1 Healthy 
 Container mtusi-lab5-postgres-1 Healthy 
 Container mtusi-lab5-migrate-1 Exited 
 Container mtusi-lab5-s3-1 Healthy 
 Container mtusi-lab5-s3-init-1 Exited 
 Container mtusi-lab5-api-2 Healthy 
 Container mtusi-lab5-api-1 Healthy 
 Container mtusi-lab5-lb-1 Healthy
[exit 0, 41.2 s]

$ docker compose ps -a --format table {{.Service}}	{{.Image}}	{{.Status}}
SERVICE    IMAGE                                                                                                  STATUS
api        mtusi-messenger:lab5                                                                                   Up 11 seconds (healthy)
api        mtusi-messenger:lab5                                                                                   Up 12 seconds (healthy)
broker     rabbitmq:4.3.7-alpine@sha256:b1f997f74103d08fc1f20a13890dc44fe6cfa51d528cf521b480ada988d3ffa5          Up 26 seconds (healthy)
lb         haproxy:3.2.26-alpine@sha256:254e6370f01cd654e0744edf607c67f33777c1b6a9dc0d4b28bcba7171460122          Up 5 seconds (healthy)
migrate    mtusi-messenger:lab5                                                                                   Exited (0) 19 seconds ago
postgres   postgres:18.6-bookworm@sha256:afc7e2d441324c0388fa80c3d24f733b4194a4eb7f47dd8ee2b08eb1a24a647c         Up 26 seconds (healthy)
relay      mtusi-messenger:lab5                                                                                   Up 15 seconds (healthy)
s3         chrislusf/seaweedfs:4.46@sha256:08d516132314207d10c8e37cbffc1f32b147d870169688734cc61c6231625b62       Up 27 seconds (healthy)
s3-init    mtusi-messenger:lab5                                                                                   Exited (0) 12 seconds ago
valkey     valkey/valkey:8.1.3-bookworm@sha256:fea8b3e67b15729d4bb70589eb03367bab9ad1ee89c876f54327fc7c6e618571   Up 27 seconds (healthy)
worker     mtusi-messenger:lab5                                                                                   Up 12 seconds (healthy)
[exit 0, 0.3 s]

$ docker compose logs --no-log-prefix migrate
migrate: 0001_init: applied
migrate: 0002_idempotency_keys: applied
migrate: 0003_post_message_function: applied
migrate: 0004_attachments: applied
migrate: 0005_pipeline: applied
migrate: done, 5 migration file(s) checked
[exit 0, 0.3 s]

$ docker compose logs --no-log-prefix s3-init
s3-bootstrap: bucket messenger-attachments: created
s3-bootstrap: bucket messenger-staging: created
s3-bootstrap: sentinel health/sentinel: written
s3-bootstrap: anonymous GET object of messenger-attachments: HTTP 403 -> refused
s3-bootstrap: anonymous LIST of messenger-attachments: HTTP 403 -> refused
s3-bootstrap: anonymous GET object of messenger-staging: HTTP 403 -> refused
s3-bootstrap: anonymous LIST of messenger-staging: HTTP 403 -> refused
s3-bootstrap: api: write staging: allowed -> OK
s3-bootstrap: api: delete staging (janitor): allowed -> OK
s3-bootstrap: api: read staging: refused (403) -> OK
s3-bootstrap: api: read final: allowed -> OK
s3-bootstrap: api: write final: refused (AccessDenied) -> OK
s3-bootstrap: api: list final: refused (AccessDenied) -> OK
s3-bootstrap: api: list staging: refused (AccessDenied) -> OK
s3-bootstrap: api: create bucket: refused (AccessDenied) -> OK
s3-bootstrap: api: read another bucket: refused (403) -> OK
s3-bootstrap: worker: read staging: allowed -> OK
s3-bootstrap: worker: write final: allowed -> OK
s3-bootstrap: worker: delete final: allowed -> OK
s3-bootstrap: worker: write staging: allowed -> OK
s3-bootstrap: worker: delete staging: allowed -> OK
s3-bootstrap: worker: list final: refused (AccessDenied) -> OK
s3-bootstrap: worker: create bucket: refused (AccessDenied) -> OK
s3-bootstrap: worker: read another bucket: refused (403) -> OK
s3-bootstrap: auditor: list final: allowed -> OK
s3-bootstrap: auditor: list staging: allowed -> OK
s3-bootstrap: auditor: read final: allowed -> OK
s3-bootstrap: auditor: write final: refused (AccessDenied) -> OK
s3-bootstrap: auditor: delete staging: refused (AccessDenied) -> OK
s3-bootstrap: api: buckets visible in ListBuckets: [] -> OK
s3-bootstrap: done: private buckets, least-privilege keys verified
[exit 0, 0.3 s]

$ C:\Users\wfa22\AppData\Local\Python\pythoncore-3.14-64\python.exe scripts/lbctl.py replicas
mtusi-lab5-api-1         X-Instance-Id=d08185c0e3f3  running  health=healthy   pid=83074 started=2026-10-31T14:18:45.487 ip=172.25.0.7,172.26.0.5,172.28.0.3
mtusi-lab5-api-2         X-Instance-Id=85c7cde066aa  running  health=healthy   pid=82998 started=2026-10-31T14:18:45.132 ip=172.25.0.6,172.26.0.4,172.28.0.2
[exit 0, 0.5 s]

$ C:\Users\wfa22\AppData\Local\Python\pythoncore-3.14-64\python.exe scripts/lbctl.py status
api1   172.28.0.3      UP       mtusi-lab5-api-1         X-Instance-Id=d08185c0e3f3
api2   172.28.0.2      UP       mtusi-lab5-api-2         X-Instance-Id=85c7cde066aa
(other slots: MAINT, no container)
[exit 0, 0.7 s]

$ docker compose exec -T broker rabbitmqctl -q list_users
user	tags
relay	[]
worker	[]
[exit 0, 2.0 s]

$ docker compose exec -T broker rabbitmqctl -q list_queues name type durable messages consumers arguments
name	type	durable	messages	consumers	arguments
messenger.attachment-jobs	quorum	true	0	1	[{"x-dead-letter-exchange","messenger.jobs.dlx"},{"x-delivery-limit",20},{"x-queue-type","quorum"}]
messenger.attachment-jobs.dlq	quorum	true	0	0	[{"x-queue-type","quorum"}]
[exit 0, 2.0 s]

$ docker compose exec -T broker rabbitmqctl -q list_permissions
user	configure	write	read
relay	^$	^messenger\.jobs$	^$
worker	^$	^$	^messenger\.attachment-jobs$
[exit 0, 3.9 s]

$ docker inspect (limits)
/mtusi-lab5-api-1 cpus=1000000000 memory=536870912 memswap=536870912 image=mtusi-messenger:lab5
/mtusi-lab5-api-2 cpus=1000000000 memory=536870912 memswap=536870912 image=mtusi-messenger:lab5
/mtusi-lab5-broker-1 cpus=1000000000 memory=536870912 memswap=1073741824 image=rabbitmq:4.3.7-alpine@sha256:b1f997f74103d08fc1f20a13890dc44fe6cfa51d528cf521b480ada988d3ffa5
/mtusi-lab5-lb-1 cpus=1000000000 memory=134217728 memswap=268435456 image=haproxy:3.2.26-alpine@sha256:254e6370f01cd654e0744edf607c67f33777c1b6a9dc0d4b28bcba7171460122
/mtusi-lab5-postgres-1 cpus=2000000000 memory=1073741824 memswap=2147483648 image=postgres:18.6-bookworm@sha256:afc7e2d441324c0388fa80c3d24f733b4194a4eb7f47dd8ee2b08eb1a24a647c
/mtusi-lab5-relay-1 cpus=500000000 memory=268435456 memswap=536870912 image=mtusi-messenger:lab5
/mtusi-lab5-s3-1 cpus=1000000000 memory=1073741824 memswap=2147483648 image=chrislusf/seaweedfs:4.46@sha256:08d516132314207d10c8e37cbffc1f32b147d870169688734cc61c6231625b62
/mtusi-lab5-valkey-1 cpus=500000000 memory=268435456 memswap=536870912 image=valkey/valkey:8.1.3-bookworm@sha256:fea8b3e67b15729d4bb70589eb03367bab9ad1ee89c876f54327fc7c6e618571
/mtusi-lab5-worker-1 cpus=2000000000 memory=1610612736 memswap=1610612736 image=mtusi-messenger:lab5
[exit 0, 0.1 s]

$ C:\Users\wfa22\AppData\Local\Python\pythoncore-3.14-64\python.exe -m venv .venv

[exit 0, 7.0 s]

$ C:\Users\wfa22\Desktop\Высоконагруженные приложения\lab5-clean\.venv\Scripts\python.exe -m pip install -q --require-hashes --no-deps -r requirements.txt

[notice] A new release of pip is available: 26.1.2 -> 26.2.2
[notice] To update, run: C:\Users\wfa22\Desktop\Высоконагруженные приложения\lab5-clean\.venv\Scripts\python.exe -m pip install --upgrade pip
[exit 0, 28.9 s]

$ C:\Users\wfa22\Desktop\Высоконагруженные приложения\lab5-clean\.venv\Scripts\python.exe -m pip install -q -r requirements-test.txt -r requirements-dev.txt

[notice] A new release of pip is available: 26.1.2 -> 26.2.2
[notice] To update, run: C:\Users\wfa22\Desktop\Высоконагруженные приложения\lab5-clean\.venv\Scripts\python.exe -m pip install --upgrade pip
[exit 0, 16.0 s]
