How can I connect to rds ?

[youssefmaher99]

As the title states, I have an RDS PostgreSQL instance. After updating the docker-compose.yaml file, I made the following changes:

• Removed the DB service
• Added PostgreSQL RDS environment variables to all services
• Updated cms/settings.py, cms/local_settings.py, and deploy/local_settings.py with the correct RDS values
  The migration service works correctly, but the web service fails, resulting in a 500 server status.
  If anyone has experience connecting to RDS, I would really appreciate your help.

[mgogoulos]

if the migration service works correctly, it means that connection to RDS is succesful, so the web service should be able to connect to. What is the log message, can you check with docker logs?

[youssefmaher99]

this is my docker-compose.yaml file

version: "3"
services:
  migrations:
    image: mediacms-custom6:latest
    volumes:
      - ./:/home/mediacms.io/mediacms/
    environment:
      ENABLE_UWSGI: 'no'
      ENABLE_NGINX: 'no'
      ENABLE_CELERY_SHORT: 'no'
      ENABLE_CELERY_LONG: 'no'
      ENABLE_CELERY_BEAT: 'no'
      ADMIN_USER: 'admin'
      ADMIN_EMAIL: 'admin@localhost'
      ADMIN_PASSWORD: 'admin'
      POSTGRES_HOST: '********'
      POSTGRES_PORT: '5432'
      POSTGRES_DB: 'mediacms'
      POSTGRES_USER: '********'
      POSTGRES_PASSWORD: '********'
      PGSSLMODE: "require"
    command: "./deploy/docker/prestart.sh"
    restart: on-failure
    depends_on:
      redis:
        condition: service_healthy
  web:
    image: mediacms-custom6:latest
    deploy:
      replicas: 1
    ports:
      - "80:80"
    volumes:
      - ./:/home/mediacms.io/mediacms/
    environment:
      ENABLE_CELERY_BEAT: 'no'
      ENABLE_CELERY_SHORT: 'no'
      ENABLE_CELERY_LONG: 'no'
      ENABLE_MIGRATIONS: 'no'
      POSTGRES_HOST: ''********''
      POSTGRES_PORT: '5432'
      POSTGRES_DB: 'mediacms'
      POSTGRES_USER: ''********''
      POSTGRES_PASSWORD: ''********''
      PGSSLMODE: "require"
    depends_on:
      - migrations
  celery_beat:
    image: mediacms-custom6:latest
    volumes:
      - ./:/home/mediacms.io/mediacms/
      - ./global-bundle.pem:/etc/ssl/certs/global-bundle.pem
    environment:
      ENABLE_UWSGI: 'no'
      ENABLE_NGINX: 'no'
      ENABLE_CELERY_SHORT: 'no'
      ENABLE_CELERY_LONG: 'no'
      ENABLE_MIGRATIONS: 'no'
      POSTGRES_HOST: ''********''
      POSTGRES_PORT: '5432'
      POSTGRES_DB: 'mediacms'
      POSTGRES_USER: ''********''
      POSTGRES_PASSWORD: ''********''
      PGSSLMODE: "require"
    depends_on:
      - redis
  celery_worker:
    image: mediacms-custom6:latest
    deploy:
      replicas: 1
    volumes:
      - ./:/home/mediacms.io/mediacms/
    environment:
      ENABLE_UWSGI: 'no'
      ENABLE_NGINX: 'no'
      ENABLE_CELERY_BEAT: 'no'
      ENABLE_MIGRATIONS: 'no'
      POSTGRES_HOST: ''********''
      POSTGRES_PORT: '5432'
      POSTGRES_DB: 'mediacms'
      POSTGRES_USER: ''********''
      POSTGRES_PASSWORD: ''********''
      PGSSLMODE: "require"
    depends_on:
      - migrations
  redis:
    image: "redis:alpine"
    restart: always
    healthcheck:
      test: ["CMD", "redis-cli","ping"]
      interval: 30s
      timeout: 10s
      retries: 3

[youssefmaher99]

I also modified the code so I built another image modfying cms/local_settings.py, and deploy/local_settings.py with the correct database settings

[youssefmaher99]

the migration service run correctly and rds is affected but for some reason when I up open login page I get this

with nothing useful in the logs of web service.

[mgogoulos]

if this is giving a 500, there has to be something on the logs. Alternatively, you can set Debug=True on the logs and the error will appear on the page itself