#!/usr/bin/env bash
set -euo pipefail
cd /srv/apps/sotlab-music
set -a
. ./.env
set +a
printf '%s\n' '--- catalog_local schema/rows ---'
sudo docker exec -i sotlab-music-db-1 mariadb -u"$AMPACHE_DB_USER" -p"$AMPACHE_DB_PASSWORD" "$DB_NAME" <<'SQL'
SHOW COLUMNS FROM catalog_local;
SELECT * FROM catalog_local\G
SQL
printf '%s\n' '--- ampache logs tail ---'
sudo docker exec sotlab-music-ampache-1 sh -lc 'find /var/log/ampache /var/www/log -type f 2>/dev/null | xargs -r ls -lt | head -20'
sudo docker exec sotlab-music-ampache-1 sh -lc 'for f in $(find /var/log/ampache /var/www/log -type f 2>/dev/null | head -10); do echo FILE:$f; tail -80 "$f"; done' | sed -n '1,260p'