Update docker-entrypoint-wrapper.sh

docker-entrypoint-wrapper.sh

@@ -1,55 +1,29 @@
 #!/bin/sh
 
-# Create necessary directories in the persistent /data volume
-echo "Creating necessary directories in the persistent /data volume..."
-mkdir -p /data/postgresql/data /data/postgresql/run
-chmod 0700 /data/postgresql/data
-chmod 0755 /data/postgresql/run
+echo "Using remote PostgreSQL on Neon.tech..."
 
-# Initialize PostgreSQL if not already initialized
-echo "Initializing PostgreSQL if not already initialized..."
-if [ ! -f "/data/postgresql/data/PG_VERSION" ]; then
-    # Initialize database
-    echo "Initializing database..."
-    initdb -D /data/postgresql/data
-    
-    # Modify pg_hba.conf to allow local connections
-    echo "local all all trust" > /data/postgresql/data/pg_hba.conf
-    echo "host all all 127.0.0.1/32 trust" >> /data/postgresql/data/pg_hba.conf
-    echo "host all all ::1/128 trust" >> /data/postgresql/data/pg_hba.conf
-    echo "host all all 0.0.0.0/0 trust" >> /data/postgresql/data/pg_hba.conf
-    echo "host all all ::/0 trust" >> /data/postgresql/data/pg_hba.conf
-fi
-
-# Start PostgreSQL with the persistent directories
-echo "Starting PostgreSQL..."
-pg_ctl -D /data/postgresql/data -o "-c listen_addresses='*' -c unix_socket_directories='/data/postgresql/run'" start
-
-# Wait for PostgreSQL to be ready
-echo "Waiting for PostgreSQL to be ready..."
-until pg_isready -h localhost; do
-  echo "Waiting for PostgreSQL to be ready..."
-  sleep 1
-done
-
-# Create database and roles
-echo "Creating database and roles..."
-createuser -h /data/postgresql/run -s postgres || true
-createdb -h /data/postgresql/run node || true
+# Skip local PostgreSQL init and start
 
 # Set NEXTAUTH_URL based on SPACE_HOST if available
 if [ -n "$SPACE_ID" ]; then
-    echo "Setting NEXTAUTH_URL to https://huggingface.co/spaces/${SPACE_ID}"
-    # export NEXTAUTH_URL="https://huggingface.co/spaces/${SPACE_ID}"
+    echo "Setting NEXTAUTH_URL to https://${SPACE_HOST}"
     export NEXTAUTH_URL="https://${SPACE_HOST}"
 else
     echo "WARNING: SPACE_ID not found"
 fi
 
-# Update DATABASE_URL to use TCP connection
-export DATABASE_URL="postgresql://postgres:postgres@localhost:5432/node"
+# Set Neon PostgreSQL connection environment variables
+export PGHOST='ep-steep-dream-adqtvjel-pooler.c-2.us-east-1.aws.neon.tech'
+export PGDATABASE='neondb'
+export PGUSER='neondb_owner'
+export PGPASSWORD='npg_Qq0B1uWRXavx'
+export PGSSLMODE='require'
+export PGCHANNELBINDING='require'
+
+# Compose the DATABASE_URL
+export DATABASE_URL="postgresql://${PGUSER}:${PGPASSWORD}@${PGHOST}:5432/${PGDATABASE}?sslmode=${PGSSLMODE}&channel_binding=${PGCHANNELBINDING}"
 
-# Export these environment variables to influence Next.js binding
+# Export environment variables to influence Next.js binding
 export HOSTNAME="0.0.0.0"
 export HOST="0.0.0.0"
 export PORT=3000
@@ -57,25 +31,26 @@ export PORT=3000
 # Disable CSP headers to allow for embedded use within HF
 export LANGFUSE_CSP_DISABLE="true"
 
-# Preset oauth env vars based on injected space variables
-# See https://huggingface.co/docs/hub/en/spaces-oauth#create-an-oauth-app
+# Preset OAuth env vars based on injected space variables
 export AUTH_CUSTOM_CLIENT_ID=$OAUTH_CLIENT_ID
 export AUTH_CUSTOM_CLIENT_SECRET=$OAUTH_CLIENT_SECRET
 export AUTH_CUSTOM_ISSUER=$OPENID_PROVIDER_URL
 export AUTH_CUSTOM_SCOPE=$OAUTH_SCOPES
 export AUTH_CUSTOM_NAME="Hugging Face"
 
-# Disable authentication via username/password to enforce authentication via HF
+# Disable authentication via username/password
 export AUTH_DISABLE_USERNAME_PASSWORD="true"
 
-# Pass through AUTH_DISABLE_SIGNUP value if set, default to false if not set
+# Handle signup disabling logic
 if [ -n "$AUTH_DISABLE_SIGNUP" ]; then
     export AUTH_DISABLE_SIGNUP="$AUTH_DISABLE_SIGNUP"
 else
     export AUTH_DISABLE_SIGNUP="false"
 fi
 
-# Start Next.js in the background
+# Log connection details (don't do this in production with real passwords!)
+echo "Connecting to Neon PostgreSQL at $PGHOST"
+
+# Start Next.js app
 echo "Starting Next.js..."
-./web/entrypoint.sh node ./web/server.js \
-    --keepAliveTimeout 110000
+./web/entrypoint.sh node ./web/server.js