44 lines
1.3 KiB
Bash
44 lines
1.3 KiB
Bash
|
#!/bin/bash
|
||
|
|
# Check database connection and credentials
|
||
|
|
|
||
|
|
set -e
|
||
|
|
|
||
|
|
DB_HOST="${DB_HOST:-localhost}"
|
||
|
|
DB_PORT="${DB_PORT:-5432}"
|
||
|
|
DB_USER="${DB_USER:-explorer}"
|
||
|
|
DB_PASSWORD="${DB_PASSWORD:-changeme}"
|
||
|
|
DB_NAME="${DB_NAME:-explorer}"
|
||
|
|
|
||
|
|
echo "=== Database Connection Check ==="
|
||
|
|
echo "Host: $DB_HOST:$DB_PORT"
|
||
|
|
echo "User: $DB_USER"
|
||
|
|
echo "Database: $DB_NAME"
|
||
|
|
echo ""
|
||
|
|
|
||
|
|
export PGPASSWORD="$DB_PASSWORD"
|
||
|
|
|
||
|
|
# Test connection
|
||
|
|
echo -n "Testing connection... "
|
||
|
|
if psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "SELECT 1;" > /dev/null 2>&1; then
|
||
|
|
echo "✅ Connected"
|
||
|
|
|
||
|
|
# Check if migration tables exist
|
||
|
|
echo -n "Checking for track schema tables... "
|
||
|
|
if psql -h "$DB_HOST" -p "$DB_PORT" -U "$DB_USER" -d "$DB_NAME" -c "SELECT EXISTS(SELECT 1 FROM information_schema.tables WHERE table_name = 'addresses');" -t | grep -q "t"; then
|
||
|
|
echo "✅ Tables exist"
|
||
|
|
else
|
||
|
|
echo "⚠️ Tables not found - migration needed"
|
||
|
|
fi
|
||
|
|
else
|
||
|
|
echo "❌ Connection failed"
|
||
|
|
echo ""
|
||
|
|
echo "Troubleshooting:"
|
||
|
|
echo "1. Check if PostgreSQL is running: systemctl status postgresql"
|
||
|
|
echo "2. Verify credentials in database config"
|
||
|
|
echo "3. Check pg_hba.conf for authentication method"
|
||
|
|
echo "4. Try connecting manually: psql -h $DB_HOST -U $DB_USER -d $DB_NAME"
|
||
|
|
fi
|
||
|
|
|
||
|
|
unset PGPASSWORD
|
||
|
|
|