Docker and PostgreSQL: port 5432 failed: Connection refused error

[Edmaximus]

I'm trying to switch SQLite to PostgreSQL and keep getting connection error when I try to build the docker container to start the app. Can you help me figure out what I'm doing wrong. Below is the error and relevant code.

`=> ERROR [appseed-app 9/9] RUN python manage.py migrate 1.4s

[appseed-app 9/9] RUN python manage.py migrate: 1.340 Traceback (most recent call last): 1.340 File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection 1.340 self.connect() 1.340 File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner 1.340 return func(*args, kwargs) 1.340 File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect 1.340 self.connection = self.get_new_connection(conn_params) 1.340 File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner 1.340 return func(*args, kwargs) 1.340 File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connection 1.340 connection = self.Database.connect(conn_params) 1.340 File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect 1.340 conn = _connect(dsn, connection_factory=connection_factory, *kwasync) 1.340 psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: Connection refused 1.340 Is the server running on that host and accepting TCP/IP connections? 1.340 connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused 1.340 Is the server running on that host and accepting TCP/IP connections? 1.340 1.340 1.340 The above exception was the direct cause of the following exception: 1.340 1.340 Traceback (most recent call last): 1.340 File "//manage.py", line 22, in 1.340 main() 1.340 File "//manage.py", line 18, in main 1.340 execute_from_command_line(sys.argv) 1.340 File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_line 1.340 utility.execute() 1.340 File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute 1.340 self.fetch_command(subcommand).run_from_argv(self.argv) 1.340 File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv 1.341 self.execute(args, cmd_options) 1.341 File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute 1.341 output = self.handle(*args, options) 1.341 File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper 1.341 res = handle_func(*args, *kwargs) 1.341 File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle 1.341 executor = MigrationExecutor(connection, self.migration_progress_callback) 1.341 File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init 1.341 self.loader = MigrationLoader(self.connection) 1.341 File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init 1.341 self.build_graph() 1.341 File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph 1.341 self.applied_migrations = recorder.applied_migrations() 1.341 File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrations 1.341 if self.has_table(): 1.341 File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table 1.341 with self.connection.cursor() as cursor: 1.341 File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner 1.341 return func(args, kwargs) 1.341 File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor 1.341 return self._cursor() 1.341 File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor 1.342 self.ensure_connection() 1.342 File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner 1.342 return func(*args, kwargs) 1.342 File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection 1.342 with self.wrap_database_errors: 1.342 File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit 1.342 raise dj_exc_value.with_traceback(traceback) from exc_value 1.342 File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection 1.342 self.connect() 1.342 File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner 1.342 return func(*args, *kwargs) 1.342 File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect 1.342 self.connection = self.get_new_connection(conn_params) 1.342 File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner 1.342 return func(args, kwargs) 1.342 File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connection 1.342 connection = self.Database.connect(conn_params) 1.342 File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect 1.342 conn = _connect(dsn, connection_factory=connection_factory, kwasync) 1.342 django.db.utils.OperationalError: connection to server at "localhost" (::1), port 5432 failed: Connection refused 1.342 Is the server running on that host and accepting TCP/IP connections? 1.342 connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused 1.342 Is the server running on that host and accepting TCP/IP connections?`

My docker-compose looks like: `version: "3.8" services: appseed-app: container_name: appseed-app restart: always build: context: . networks:

• db_network

• web_network environment: DATABASE_URL: postgresql://postgres:password@postgres:5432/dbname depends_on: postgres: condition: service_healthy

  nginx: container_name: nginx restart: always image: "nginx:latest" ports:

• "5085:5085" volumes:
• ./nginx:/etc/nginx/conf.d networks:
• web_network depends_on:

• appseed-app

  redis: image: redis:7.0.12 container_name: redis command: ["redis-server", "--port", "6379", "--slave-read-only", "no"] restart: always ports:

• 6379:6379 networks:

• db_network

  celery: container_name: celery restart: always build: context: . networks:

• db_network environment: DJANGO_SETTINGS_MODULE: "core.settings" command: "celery -A apps.tasks worker -l info -B" depends_on:
• appseed-app

• redis

  postgres: container_name: postgres image: postgres:13 environment: POSTGRES_DB: dbname POSTGRES_USER: postgres POSTGRES_PASSWORD: password volumes:

• postgres_data:/var/lib/postgresql/data expose:
• 5432 networks:
• db_network healthcheck: test: ["CMD-SHELL", "pg_isready -U postgres"] interval: 5s timeout: 5s retries: 5

networks: db_network: driver: bridge web_network: driver: bridge volumes: postgres_data: `

Dockerfile

`FROM python:3.10.4

ENV PYTHONDONTWRITEBYTECODE 1 ENV PYTHONUNBUFFERED 1

RUN apt-get update && apt-get install -y postgresql-client

COPY requirements.txt .

RUN pip install --upgrade pip RUN pip install --no-cache-dir -r requirements.txt

COPY . .

RUN python manage.py collectstatic --no-input RUN python manage.py makemigrations RUN python manage.py migrate

EXPOSE 5005 CMD ["gunicorn", "--config", "gunicorn-cfg.py", "core.wsgi"] `

database settings in settings.py

`DB_ENGINE = os.getenv('DB_ENGINE' , None) DB_USERNAME = os.getenv('DB_USERNAME' , None) DB_PASS = os.getenv('DB_PASS' , None) DB_HOST = os.getenv('DB_HOST' , None) DB_PORT = os.getenv('DB_PORT' , None) DB_NAME = os.getenv('DB_NAME' , None)

if DB_ENGINE and DB_NAME and DB_USERNAME: DATABASES = { 'default': { 'ENGINE' : 'django.db.backends.' + DB_ENGINE, 'NAME' : DB_NAME, 'USER' : DB_USERNAME, 'PASSWORD': DB_PASS, 'HOST' : DB_HOST, 'PORT' : DB_PORT, }, } else: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': 'db.sqlite3', } }`

And finally the variables in .env:

DB_ENGINE=postgresql DB_NAME=dbname DB_HOST=localhost DB_PORT=5432 DB_USERNAME=postgres DB_PASS='password'

[Edmaximus]

I made some changes to correct a few issues with the docker configuration. but still getting some issue.

Latest Error:

nginx | 2024/07/31 12:58:41 [notice] 1#1: start worker process 43
db-1 | 2024-07-31 12:58:42.369 UTC [41] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:58:42.369 UTC [41] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app |
appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors: appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
celery | /usr/local/lib/python3.10/site-packages/celery/platforms.py:829: SecurityWarning: You're running the worker with superuser privileges: this isWatch celery | absolutely not recommended!
celery |
celery | Please specify a different user using the --uid option.
celery |
celery | User information: uid=0 euid=0 gid=0 egid=0
celery |
celery | warnings.warn(SecurityWarning(ROOT_DISCOURAGED.format(
celery | celery | -------------- celery@96233b1f8c02 v5.3.4 (emerald-rush)
celery | --- * -----
celery | -- *** ---- Linux-5.15.146.1-microsoft-standard-WSL2-x86_64-with-glibc2.31 2024-07-31 12:58:42
celery | - --- ---
celery | - ---------- [config]
celery | - ---------- .> app: core:0x7f8afa957b50
celery | - ---------- .> transport: redis://redis:6379//
celery | - ---------- .> results:
celery | - --- --- .> concurrency: 24 (prefork)
celery | -- *** ---- .> task events: OFF (enable -E to monitor tasks in this worker)
celery | --- * -----
celery | -------------- [queues]
celery | .> celery exchange=celery(direct) key=celery
celery |
celery |
celery | [tasks]
celery | . apps.tasks.tasks.execute_script
celery |
celery | [2024-07-31 12:58:43,786: INFO/Beat] beat: Starting... celery | [2024-07-31 12:58:44,149: WARNING/MainProcess] /usr/local/lib/python3.10/site-packages/celery/worker/consumer/consumer.py:507: CPendingDeprecationWarning: The broker_connection_retry configuration setting will no longer determine celery | whether broker connection retries are made during startup in Celery 6.0 and above.
celery | If you wish to retain the existing behavior for retrying connections on startup,
celery | you should set broker_connection_retry_on_startup to True.
celery | warnings.warn(
celery |
celery | [2024-07-31 12:58:44,157: INFO/MainProcess] Connected to redis://redis:6379//
celery | [2024-07-31 12:58:44,158: WARNING/MainProcess] /usr/local/lib/python3.10/site-packages/celery/worker/consumer/consumer.py:507: CPendingDeprecationWarning: The broker_connection_retry configuration setting will no longer determine celery | whether broker connection retries are made during startup in Celery 6.0 and above.
celery | If you wish to retain the existing behavior for retrying connections on startup,
celery | you should set broker_connection_retry_on_startup to True.
celery | warnings.warn( celery |
celery | [2024-07-31 12:58:44,159: INFO/MainProcess] mingle: searching for neighbors
appseed-app exited with code 0 celery | [2024-07-31 12:58:45,167: INFO/MainProcess] mingle: all alone celery | [2024-07-31 12:58:45,181: INFO/MainProcess] celery@96233b1f8c02 ready. db-1 | 2024-07-31 12:58:45.632 UTC [49] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:58:45.632 UTC [49] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app |
appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor() appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
appseed-app exited with code 0 db-1 | 2024-07-31 12:58:48.773 UTC [50] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:58:48.773 UTC [50] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params) appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app |
appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options) appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
appseed-app exited with code 0 db-1 | 2024-07-31 12:58:51.894 UTC [58] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:58:51.894 UTC [58] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app | appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
appseed-app exited with code 0 db-1 | 2024-07-31 12:58:55.147 UTC [59] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:58:55.147 UTC [59] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app |
appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs) appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
appseed-app exited with code 1 db-1 | 2024-07-31 12:58:59.160 UTC [67] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:58:59.160 UTC [67] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app |
appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params) appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
db-1 | 2024-07-31 12:59:04.279 UTC [75] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:59:04.279 UTC [75] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app | appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
db-1 | 2024-07-31 12:59:12.328 UTC [90] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:59:12.328 UTC [90] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256" Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app |
appseed-app | appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
db-1 | 2024-07-31 12:59:27.056 UTC [112] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:59:27.056 UTC [112] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app |
appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last): appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |
db-1 | 2024-07-31 12:59:54.388 UTC [149] FATAL: password authentication failed for user "postgres" db-1 | 2024-07-31 12:59:54.388 UTC [149] DETAIL: Connection matched pg_hba.conf line 100: "host all all all scram-sha-256"Docker Desktop w Enable Watch appseed-app | Traceback (most recent call last):
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, *kwasync)
appseed-app | psycopg2.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres"h appseed-app | appseed-app |
appseed-app | The above exception was the direct cause of the following exception:
appseed-app |
appseed-app | Traceback (most recent call last):
appseed-app | File "//manage.py", line 22, in
appseed-app | main()
appseed-app | File "//manage.py", line 18, in main
appseed-app | execute_from_command_line(sys.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 442, in execute_from_command_lineDesktop w Enable Watch appseed-app | utility.execute()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/init.py", line 436, in execute appseed-app | self.fetch_command(subcommand).run_from_argv(self.argv)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 412, in run_from_argv View in Docker Desktop w Enable Watch appseed-app | self.execute(args, cmd_options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 458, in execute
appseed-app | output = self.handle(*args, options)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/base.py", line 106, in wrapper
appseed-app | res = handle_func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/core/management/commands/migrate.py", line 117, in handle in Docker Desktop w Enable Watch appseed-app | executor = MigrationExecutor(connection, self.migration_progress_callback)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/executor.py", line 18, in init
appseed-app | self.loader = MigrationLoader(self.connection)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 58, in init
appseed-app | self.build_graph()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/loader.py", line 235, in build_graph appseed-app | self.applied_migrations = recorder.applied_migrations()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 81, in applied_migrationsin Docker Desktop w Enable Watch appseed-app | if self.has_table():
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/migrations/recorder.py", line 57, in has_table
appseed-app | with self.connection.cursor() as cursor:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 330, in cursor
appseed-app | return self._cursor()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 306, in _cursor
appseed-app | self.ensure_connection()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 288, in ensure_connection in Docker Desktop w Enable Watch appseed-app | with self.wrap_database_errors:
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/utils.py", line 91, in exit
appseed-app | raise dj_exc_value.with_traceback(traceback) from exc_value
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 289, in ensure_connection in Docker Desktop w Enable Watch appseed-app | self.connect()
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(*args, *kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/base/base.py", line 270, in connect
appseed-app | self.connection = self.get_new_connection(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/utils/asyncio.py", line 26, in inner
appseed-app | return func(args, kwargs)
appseed-app | File "/usr/local/lib/python3.10/site-packages/django/db/backends/postgresql/base.py", line 275, in get_new_connectionker Desktop w Enable Watch appseed-app | connection = self.Database.connect(conn_params)
appseed-app | File "/usr/local/lib/python3.10/site-packages/psycopg2/init.py", line 122, in connect
appseed-app | conn = _connect(dsn, connection_factory=connection_factory, kwasync)
appseed-app | django.db.utils.OperationalError: connection to server at "db" (172.25.0.2), port 5432 failed: FATAL: password authentication failed for user "postgres" appseed-app |

Latest docker-compose:

` version: "3.8" services: appseed-app: container_name: appseed-app restart: always build: context: . networks:

• db_network
• web_network environment:

• DATABASE_URL=postgresql://postgres:postgres@db:5432/postgres depends_on: db: condition: service_healthy command: sh -c "python manage.py migrate && gunicorn core.wsgi:application --bind 0.0.0.0:8000"

  db: image: postgres:14-alpine ports:

• '5432:5432'

  environment:

• POSTGRES_PASSWORD=${DB_PASS:-postgres}
• POSTGRES_USER=${DB_USERNAME:-postgres}

• POSTGRES_DB=${DB_NAME:-postgres}

  volumes:

• ./data/db:/var/lib/postgresql/data/ healthcheck: test: ["CMD-SHELL", "pg_isready -U postgres"] interval: 5s timeout: 5s retries: 5

  networks:

• db_network

  nginx: container_name: nginx restart: always image: "nginx:latest" ports:

• "5085:5085" volumes:
• ./nginx:/etc/nginx/conf.d networks:
• web_network depends_on:
• appseed-app
• db redis: image: redis:7.0.12 container_name: redis command: ["redis-server", "--port", "6379", "--slave-read-only", "no"] restart: always ports:
• 6379:6379 networks:
• db_network celery: container_name: celery restart: always build: context: . networks:
• db_network environment:
• DATABASE_URL=postgresql://postgres:postgres@db:5432/postgres
• DJANGO_SETTINGS_MODULE=core.settings command: "celery -A apps.tasks worker -l info -B" depends_on:
• appseed-app

networks: db_network: driver: bridge web_network: driver: bridge

`

latest dockerfile:

` FROM python:3.10.4

ENV PYTHONDONTWRITEBYTECODE 1 ENV PYTHONUNBUFFERED 1

RUN apt-get update && apt-get install -y postgresql-client

COPY requirements.txt .

RUN pip install --upgrade pip RUN pip install --no-cache-dir -r requirements.txt

COPY . .

RUN python manage.py collectstatic --no-input RUN python manage.py makemigrations

EXPOSE 5005 CMD ["gunicorn", "--config", "gunicorn-cfg.py", "core.wsgi"]

`

database settings and env variables are as expected

I'm new to using Docker for development so I might be missing something. Help me figure out what i'm doing wrong and provide documentation on how to configure postgres for this project. Thanks.

[app-generator]

Hello @Edmaximus

Just to summarize, you wan to use a Dockerized version of the product with PgSQL [ also in Docker ].

Please confirm if is this your intention.

TY!

[Edmaximus]

Hello @Edmaximus

Just to summarize, you wan to use a Dockerized version of the product with PgSQL [ also in Docker ].

Please confirm if is this your intention.

TY!

Yes. I need to switch from using sqlLite to PgSQL. I currently have that working fine in my local without Docker but I need to make sure I can dockerize the project without any issue.

[Edmaximus]

I was able to sort out this issue. It was due to port conflict and a few other settings I had wrong

updating docker-compose.yml to:

` services: appseed-app: container_name: appseed-app restart: always build: context: . networks:

• db_network
• web_network environment:
• IS_DOCKER=True
• DATABASE_URL=postgresql://${DB_USERNAME}:${DB_PASS}@db:5432/${DB_NAME} depends_on: db: condition: service_healthy command: sh -c "python manage.py migrate && gunicorn core.wsgi:application --bind 0.0.0.0:8000" ports:

• "8000:8000"

  db: image: postgres:14-alpine ports:

• '5433:5432'

  environment:

• POSTGRES_PASSWORD=${DB_PASS}
• POSTGRES_USER=${DB_USERNAME}

• POSTGRES_DB=${DB_NAME}

  volumes:

• ./data/db:/var/lib/postgresql/data/ healthcheck: test: ["CMD-SHELL", "pg_isready -U postgres"] interval: 5s timeout: 5s retries: 5

  networks:

• db_network

  nginx: container_name: nginx restart: always image: "nginx:latest" ports:

• "5085:5085" volumes:
• ./nginx:/etc/nginx/conf.d networks:
• web_network depends_on:
• appseed-app
• db redis: image: redis:7.0.12 container_name: redis command: ["redis-server", "--port", "6379", "--slave-read-only", "no"] restart: always ports:
• 6379:6379 networks:
• db_network celery: container_name: celery restart: always build: context: . networks:
• db_network environment:
• DATABASE_URL=postgresql://${DB_USERNAME}:${DB_PASS}@db:5432/${DB_NAME}
• DJANGO_SETTINGS_MODULE=core.settings command: "celery -A apps.tasks worker -l info -B" depends_on:
• appseed-app

networks: db_network: driver: bridge web_network: driver: bridge

` Change the database configuration in settings.py to:

IS_DOCKER = str2bool(os.getenv('IS_DOCKER', 'False'))

DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql', 'NAME': os.environ['DB_NAME'], 'USER': os.environ['DB_USERNAME'], 'PASSWORD': os.environ['DB_PASS'], 'HOST': 'db' if IS_DOCKER else 'localhost', 'PORT': os.environ.get('DB_PORT', '5432'), } }

Remove the migrate command from the Dockerfile since that process is now being done thru the docker-compose build process after the db is up.

And set the variables in the .env file accordingly. With those changes, I'm able to run the environment on docker (and on my local dev) without issue.