forked from mtusi2026/mtusi2026lab7
27 lines
1.3 KiB
Bash
Executable File
27 lines
1.3 KiB
Bash
Executable File
#!/bin/sh
|
|
set -eu
|
|
cd "$(dirname "$0")/.."
|
|
|
|
docker compose exec -T db sh -ec '
|
|
export PGPASSWORD=$(cat /run/secrets/database_worker_password)
|
|
export PGCHANNELBINDING=disable PGSSLMODE=verify-full PGSSLROOTCERT=/run/tls/ca.crt
|
|
psql -X -h db -U messenger_worker "$POSTGRES_DB" -Atc "
|
|
SELECT has_table_privilege(current_user, '\''attachments'\'', '\''UPDATE'\'')
|
|
AND NOT has_table_privilege(current_user, '\''users'\'', '\''SELECT'\'')
|
|
AND NOT has_schema_privilege(current_user, '\''public'\'', '\''CREATE'\'');
|
|
" | grep -qx t
|
|
'
|
|
printf '%s\n' 'PASS PostgreSQL: worker can update attachments; user table and schema creation denied'
|
|
docker compose exec -T broker rabbitmqctl -q list_permissions -p / |
|
|
awk -F '\t' '
|
|
$1=="messenger_dispatcher" && $2=="^attachments\\.v1$" && $3=="^amq\\.default$" && $4=="^$" { p=1 }
|
|
$1=="messenger_worker" && $2=="^attachments\\.v1$" && $3=="^$" && $4=="^attachments\\.v1$" { c=1 }
|
|
END {exit !(p && c)}
|
|
'
|
|
printf '%s\n' 'PASS RabbitMQ: producer can publish and consumer can read attachments.v1'
|
|
docker compose exec -T redis sh -ec '
|
|
export REDISCLI_AUTH=$(cat /run/secrets/redis_password)
|
|
redis-cli --tls --cacert /run/tls/ca.crt -h redis --user messenger CONFIG GET dir | grep -q NOPERM
|
|
'
|
|
printf '%s\n' 'PASS Redis: application role cannot read server configuration'
|