Unable to start the docker containers

[Elamurugan-Nallathambi]

Unable to start the docker containers

[yezz123]

Let me share my default configuration with you

# Backend API
PROJECT_NAME= FRDP
DOMAIN= http://localhost:8080

# openssl rand -hex 32 - Generate secret key
SECRET_KEY= SecretKey
USERS_OPEN_REGISTRATION= true
EMAIL_RESET_TOKEN_EXPIRE_HOURS= 48

# Server Settings
SERVER_NAME= localhost
SERVER_HOST= http://localhost:8080

# Postgres default username and password
POSTGRES_USER= postgres
POSTGRES_PASSWORD= postgres
POSTGRES_DB= frdp
POSTGRES_PORT= 5432
POSTGRES_SERVER= pgdb

# PGADMIN_LISTEN_PORT
PGADMIN_DEFAULT_EMAIL= [email protected]
PGADMIN_DEFAULT_PASSWORD= postgres

I guess the issue is related to the database here or the server of the database we use mostly the name of the Docker container as you see:

  pgdb:
    image: postgres:12
    container_name: postgres_db
    restart: always
    volumes:
      - postgres-data:/var/lib/postgresql/data/
    env_file:
      - ./.env
    ports:
      - "5432:5432"

we have the pgdb that's why it's would not run for you

[Elamurugan-Nallathambi]

Hello Yasser,

Thank you for addressing this queries so quickly, I ended up inserting bcrypt hashed password based super_user row into users table manually since to use the API I require to have atleast one user.

[Elamurugan-Nallathambi]

Thank you so much for checking my question and sharing this resolution. The following works ok

.env

# Backend API
PROJECT_NAME=FRDP
DOMAIN=http://localhost:8080

# openssl rand -hex 32 - Generate secret key
SECRET_KEY=SecretKey
USERS_OPEN_REGISTRATION=true
EMAIL_RESET_TOKEN_EXPIRE_HOURS=48

# Server Settings
SERVER_NAME=localhost
SERVER_HOST=http://localhost:8080

# Postgres default username and password
POSTGRES_USER=postgres
POSTGRES_PASSWORD=postgres
POSTGRES_DB=frdp
POSTGRES_PORT=5432
POSTGRES_SERVER=pgdb

# PGADMIN_LISTEN_PORT
[email protected]
PGADMIN_DEFAULT_PASSWORD=postgres

docker-compose

  pgdb:
    image: postgres:12.9
    container_name: postgres_db
    restart: always
    volumes:
      - postgres-data:/var/lib/postgresql/data/
    env_file:
      - ./.env
    ports:
      - "5432:5432"

After this update and clearing the previous docker volumes worked ok., still I manually assigned the user to the frdp Db

GRANT ALL PRIVILEGES ON DATABASE frdp TO postgres; then DB access also worked ok.

Only one more question is, users table doesn't have entries. If I create a user from postman, that user will became super_user?

[yezz123]

Thank you so much for checking my question and sharing this resolution. The following works ok

.env

# Backend API
PROJECT_NAME=FRDP
DOMAIN=http://localhost:8080

# openssl rand -hex 32 - Generate secret key
SECRET_KEY=SecretKey
USERS_OPEN_REGISTRATION=true
EMAIL_RESET_TOKEN_EXPIRE_HOURS=48

# Server Settings
SERVER_NAME=localhost
SERVER_HOST=http://localhost:8080

# Postgres default username and password
POSTGRES_USER=postgres
POSTGRES_PASSWORD=postgres
POSTGRES_DB=frdp
POSTGRES_PORT=5432
POSTGRES_SERVER=pgdb

# PGADMIN_LISTEN_PORT
[email protected]
PGADMIN_DEFAULT_PASSWORD=postgres

docker-compose

  pgdb:
    image: postgres:12.9
    container_name: postgres_db
    restart: always
    volumes:
      - postgres-data:/var/lib/postgresql/data/
    env_file:
      - ./.env
    ports:
      - "5432:5432"

After this update and clearing the previous docker volumes worked ok.

Only one more question is, users table doesn't have entries. If I create a user from the postman, that user will become super_user?

You can create it using the curl command or also inject it directly to the database u have the UI part in this link: http://localhost:5050/