My Flowndly application deployment is stuck in "Deploying" state for over 8 hours due to persistent SSL certificate chain errors when connecting to Railway's internal PostgreSQL database.

Current Status

• Service: flowndly-main
• Status: Stuck in "Deploying (08:11)" state
• Environment: Production
• Project: astonishing-cooperation

Error Details

self-signed certificate in certificate chain

Error: self-signed certificate in certificate chain

at TLSSocket.onConnectSecure (node:_tls_wrap:1679:34)

at TLSSocket.emit (node:events:518:28)

at TLSSocket._finishInit (node:_tls_wrap:1078:8)

at ssl.onhandshakedone (node:_tls_wrap:864:12)

What I've Tried

1. SSL Configuration Attempts:

• Set POSTGRES_ENABLE_SSL="false" in environment variables
• Modified application code to disable SSL for Railway internal connections
• Tried rejectUnauthorized: false SSL configuration
• Added ?sslmode=disable to DATABASE_URL

1. Environment Variables Verified:

• All required security keys are set
• DATABASE_URL is properly configured
• REDISHOST is properly configured
• All Railway variable substitutions are correct

1. Service Configuration:

• PostgreSQL service (flowndly-database) is healthy
• Redis service (flowndly-redis) is healthy
• Services are properly connected in Architecture view

Technical Details

Application: Flowndly (Node.js/PostgreSQL/Redis)

Database: Railway PostgreSQL 14

Redis: Railway Redis 7.0

Connection: Internal Railway network (flowndly-database.railway.internal:5432)

Environment Variables:

DATABASE_URL=postgresql://postgres:password@flowndly-database.railway.internal:5432/railway

POSTGRES_ENABLE_SSL=false

APP_ENV=production

Expected Behavior

The application should connect to the PostgreSQL database using Railway's internal network without SSL certificate validation issues.

Actual Behavior

The application fails to start due to SSL certificate chain errors, preventing the deployment from completing.

Questions for Railway Support

1. SSL Configuration: What is the recommended SSL configuration for internal Railway PostgreSQL connections?
2. Certificate Trust: How should applications handle Railway's internal self-signed certificates?
3. Deployment Stuck: How can I force the deployment to proceed or restart it?
4. Best Practices: What are the recommended settings for Node.js applications connecting to Railway PostgreSQL?