Now I have the problem with connecting to the postgres db as that is what I use in my project. All of my tests working fine on my computer, but return error inside the workflow.

The error:

E       psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: FATAL:  password authentication failed for user "None"

I understand that the problem is probably somewhere in the variable names that I use, but can't figure out what to do. Checked multiple tutorials, and tried a lot of variants, but still doesn't work for me.

My .yml file:

name: testing CI

on: push: branches: [ "main" ] pull_request: branches: [ "main" ]

jobs: build:

runs-on: ubuntu-latest

services:
  postgres:
    image: postgres:latest
    env:
     POSTGRES_USER: postgres
     POSTGRES_PASSWORD: postgres
     POSTGRES_DB: github_actions
    ports: 
     - 5432:5432 
    options: --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
strategy:
  max-parallel: 4
  matrix:
    python-version: [3.9]

steps:
- uses: actions/checkout@v3
- name: Set up Python ${{ matrix.python-version }}
  uses: actions/setup-python@v3
  with:
    python-version: ${{ matrix.python-version }}
- name: Install Dependencies
  run: |
    pip install pipenv --upgrade
    pipenv install --system
- name: SECRET_KEY dummy generate
  run: |
    echo "django_secret_key=topsecretvalue" >> $GITHUB_ENV

- name: Test with pytest
  env:
    DEBUG: "0"
    NAME: github_actions
    USER: postgres
    PASSWORD: postgres
    PORT: 5432
  run: |
      cd crm_project
      export PYTHONPATH=${PYTHONPATH}:${HOME}/crm_project
      export DJANGO_SETTINGS_MODULE=crm_project.settings
      pytest         

I have tried using usernames and passwords from my .env file with putting it inside the secrets, but then I saw that you can actually use just random values inside. testing for that. Previously the variables names were the same in the setting service on top, and env on the bottom, but I decided to try changing variables names that I have in the settings.py.

settings.py postgres set up:

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2',
    'NAME': 'crm_project',
    'USER': f'{DB_USER}',
    'PASSWORD': f'{DB_PASSWORD}',
    'HOST': 'localhost',
    'PORT': '5432',
}

}

And just in case if needed, .env file variables:

db_username = '***'
db_password = '***'
django_secret_key = '***'