Hey guys,
I need a lot of help getting github actions up and running with my private postgres project. I get the following error on github actions:
Error: 22:36:19.848 [error] Postgrex.Protocol (#PID<0.457.0>) failed to connect: **
(DBConnection.ConnectionError) tcp connect (invoices_control_db:5432):
non-existing domain - :nxdomain
Here is my workflow file:
name: Elixir CI
on:
push:
branches: ['master']
pull_request:
branches: ['master']
env:
MIX_ENV: test
# NOTE: make sure these versions match in Containerfile and .tool-versions
ELIXIR_VERSION_SPEC: "1.15.1"
OTP_VERSION_SPEC: "26.0.2"
jobs:
compile:
name: Compile
runs-on: ubuntu-latest
steps:
- name: Checkout
uses: actions/checkout@v3
- name: Set up Elixir
uses: erlef/setup-beam@v1.16
with:
elixir-version: ${{ env.ELIXIR_VERSION_SPEC }}
otp-version: ${{ env.OTP_VERSION_SPEC }}
- name: Install dependencies
run: mix deps.get
- name: Compile dependencies
run: mix deps.compile
- name: Compile
run: mix compile --warnings-as-errors
test:
name: Test
runs-on: ubuntu-22.04
services:
postgres:
image: postgres:latest
ports: ['5432:5432']
env:
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres
options: >-
--health-cmd pg_isready
--health-interval 10s
--health-timeout 5s
--health-retries 5
env:
MIX_ENV: test
steps:
- name: Checkout
uses: actions/checkout@v3
- name: Set up Elixir
uses: erlef/setup-beam@v1.16
with:
elixir-version: ${{ env.ELIXIR_VERSION_SPEC }}
otp-version: ${{ env.OTP_VERSION_SPEC }}
- name: Install dependencies
run: mix deps.get
- name: Compile dependencies
run: mix deps.compile
- name: Setup database
env:
DATABASE_URL: postgresql://postgres:postgres@invoices_control_db:${{job.services.postgres.ports[5432]}}/invoices_control_test
DB_USERNAME: postgres
DB_PASSWORD: postgres
DB_HOSTNAME: invoices_control_db
MIX_ENV: test
run:
mix ecto.drop
mix ecto.create
mix ecto.migrate
- name: Run tests
env:
DATABASE_URL: postgresql://postgres:postgres@invoices_control_db:${{job.services.postgres.ports[5432]}}/invoices_control_test
DB_USERNAME: postgres
DB_PASSWORD: postgres
DB_HOSTNAME: invoices_control_db
MIX_ENV: test
run:
mix ecto.drop
mix ecto.create
mix ecto.migrate
mix test
check-formatted:
name: Check Formatted
runs-on: ubuntu-latest
steps:
- name: Checkout
uses: actions/checkout@v3
- name: Set up Elixir
uses: erlef/setup-beam@v1.16
with:
elixir-version: ${{ env.ELIXIR_VERSION_SPEC }}
otp-version: ${{ env.OTP_VERSION_SPEC }}
- name: Install dependencies
run: mix deps.get
- name: Compile dependencies
run: mix deps.compile
- name: Check formatted
run: mix format --check-formatted
credo:
name: Credo
runs-on: ubuntu-latest
steps:
- name: Checkout
uses: actions/checkout@v3
- name: Set up Elixir
uses: erlef/setup-beam@v1.16
with:
elixir-version: ${{ env.ELIXIR_VERSION_SPEC }}
otp-version: ${{ env.OTP_VERSION_SPEC }}
- name: Install dependencies
run: mix deps.get
- name: Compile dependencies
run: mix deps.compile
- name: Run credo
run: mix credo --strict
what do you think about this?