942875e8d0
All checks were successful
Deploy to Production / test (push) Successful in 34s
The raw 'source .env' pattern breaks when values contain special bash characters like ) in passwords or database URLs. This caused deploy:remote to fail with 'syntax error near unexpected token )'. Changes: - Created shared/scripts/lib/load-env.sh: reads .env line-by-line with export instead of source, safely handling special characters - Updated db-backup.sh, db-restore.sh, deploy-remote.sh, remote.sh to use the shared loader - Reordered deploy-remote.sh: git pull now runs first (step 1) so the remote always has the latest scripts before running backup (step 2)
51 lines
1.7 KiB
Bash
Executable File
51 lines
1.7 KiB
Bash
Executable File
#!/bin/bash
|
|
|
|
# =============================================================================
|
|
# Aurora Remote Tunnel Script
|
|
# =============================================================================
|
|
# Establishes secure SSH tunnels to remote Aurora services.
|
|
# Uses autossh for automatic reconnection if available.
|
|
#
|
|
# Usage: ./remote.sh
|
|
# =============================================================================
|
|
|
|
# Load environment variables safely
|
|
SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
|
|
source "$SCRIPT_DIR/lib/load-env.sh"
|
|
load_env
|
|
|
|
if [ -z "$VPS_HOST" ] || [ -z "$VPS_USER" ]; then
|
|
echo "Error: VPS_HOST and VPS_USER must be set in .env"
|
|
echo "Please add them to your .env file:"
|
|
echo "VPS_USER=your-username"
|
|
echo "VPS_HOST=your-ip-address"
|
|
exit 1
|
|
fi
|
|
|
|
DASHBOARD_PORT=${DASHBOARD_PORT:-3000}
|
|
STUDIO_PORT=${STUDIO_PORT:-4983}
|
|
|
|
echo "🚀 Establishing secure tunnels to Aurora services..."
|
|
echo ""
|
|
echo "📊 Dashboard: http://localhost:$DASHBOARD_PORT"
|
|
echo "🔮 Studio: http://localhost:$STUDIO_PORT (https://local.drizzle.studio)"
|
|
echo ""
|
|
echo "Press Ctrl+C to stop all connections."
|
|
echo ""
|
|
|
|
# Check if autossh is available for auto-reconnection
|
|
if command -v autossh &> /dev/null; then
|
|
echo "✅ Using autossh for automatic reconnection"
|
|
SSH_CMD="autossh -M 0 -o ServerAliveInterval=30 -o ServerAliveCountMax=3"
|
|
else
|
|
echo "💡 Tip: Install autossh for automatic reconnection (brew install autossh)"
|
|
SSH_CMD="ssh -o ServerAliveInterval=30 -o ServerAliveCountMax=3"
|
|
fi
|
|
|
|
# Start both tunnels
|
|
# -N means "Do not execute a remote command". -L is for local port forwarding.
|
|
$SSH_CMD -N \
|
|
-L $DASHBOARD_PORT:127.0.0.1:$DASHBOARD_PORT \
|
|
-L $STUDIO_PORT:127.0.0.1:$STUDIO_PORT \
|
|
$VPS_USER@$VPS_HOST
|