mirror of
https://github.com/Finsys/dockhand.git
synced 2026-06-17 19:09:33 +03:00
jarek
81 lines
2.3 KiB
Bash
Executable File
81 lines
2.3 KiB
Bash
Executable File
#!/bin/sh
|
|
#
|
|
# SQLite: Emergency script to list all users
|
|
# Shows username, admin status, active status, and last login
|
|
#
|
|
# Usage:
|
|
# docker exec -it dockhand /app/scripts/emergency/sqlite/list-users.sh
|
|
#
|
|
|
|
set -e
|
|
|
|
echo "========================================"
|
|
echo " Dockhand - List Users (SQLite)"
|
|
echo "========================================"
|
|
echo ""
|
|
|
|
# Default database path
|
|
DB_PATH="${DOCKHAND_DB:-/app/data/db/dockhand.db}"
|
|
|
|
# Check if running locally (not in Docker)
|
|
if [ ! -f "$DB_PATH" ] && [ -f "./data/db/dockhand.db" ]; then
|
|
DB_PATH="./data/db/dockhand.db"
|
|
fi
|
|
|
|
if [ ! -f "$DB_PATH" ]; then
|
|
echo "Error: Database not found at $DB_PATH"
|
|
echo "Set DOCKHAND_DB environment variable to specify the database path"
|
|
exit 1
|
|
fi
|
|
|
|
# Get user count
|
|
USER_COUNT=$(sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM users;")
|
|
|
|
if [ "$USER_COUNT" -eq "0" ]; then
|
|
echo "No users found."
|
|
exit 0
|
|
fi
|
|
|
|
# Get Admin role ID for checking admin status
|
|
ADMIN_ROLE_ID=$(sqlite3 "$DB_PATH" "SELECT id FROM roles WHERE name='Admin';" 2>/dev/null || echo "")
|
|
|
|
# Print header
|
|
printf "%-4s %-20s %-8s %-8s %-6s %s\n" "ID" "Username" "Admin" "Active" "MFA" "Last Login"
|
|
printf "%-4s %-20s %-8s %-8s %-6s %s\n" "----" "--------------------" "--------" "--------" "------" "-------------------"
|
|
|
|
# List users (check admin status via user_roles table)
|
|
sqlite3 -separator '|' "$DB_PATH" "SELECT id, username, is_active, mfa_enabled, COALESCE(last_login, 'Never') FROM users ORDER BY id;" | while IFS='|' read id username is_active mfa_enabled last_login; do
|
|
# Check if user has Admin role
|
|
if [ -n "$ADMIN_ROLE_ID" ]; then
|
|
HAS_ADMIN=$(sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM user_roles WHERE user_id=$id AND role_id=$ADMIN_ROLE_ID;")
|
|
if [ "$HAS_ADMIN" -gt "0" ]; then
|
|
admin_str="Yes"
|
|
else
|
|
admin_str="No"
|
|
fi
|
|
else
|
|
admin_str="N/A"
|
|
fi
|
|
|
|
if [ "$is_active" = "1" ]; then
|
|
active_str="Yes"
|
|
else
|
|
active_str="No"
|
|
fi
|
|
|
|
if [ "$mfa_enabled" = "1" ]; then
|
|
mfa_str="Yes"
|
|
else
|
|
mfa_str="No"
|
|
fi
|
|
|
|
printf "%-4s %-20s %-8s %-8s %-6s %s\n" "$id" "$username" "$admin_str" "$active_str" "$mfa_str" "$last_login"
|
|
done
|
|
|
|
echo ""
|
|
echo "Total: $USER_COUNT user(s)"
|
|
|
|
# Show session count
|
|
SESSION_COUNT=$(sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM sessions;")
|
|
echo "Active sessions: $SESSION_COUNT"
|