Getting error : Unknown MySQL server host 'db' (-2) in django python for docker

Question

I am new here in docker, and I am working on django python. When I try to run this command:

docker-compose run app sh -c "python app/manage.py migrate"

I am getting error Unknown MySQL server host 'db' (-2), can anyone please help me to resolve this issue ? Here I have added my whole dockerfile and db connection:

Dockerfile

FROM python:3.7 ENV PYTHONUNBUFFERED 1 RUN apt-get update && apt-get install -y --no-install-recommends \ python-dev \ default-libmysqlclient-dev \ && \ apt-get clean && \ rm -rf /var/lib/apt/lists/* COPY requirements.txt /requirements.txt RUN pip install -r /requirements.txt RUN mkdir /app COPY ./ /app

docker-compose.yml

version: "3" services: app: build: context: . ports: - "8000:8000" volumes: - ./:/app command: > sh -c "python app/manage.py runserver 0.0.0.0:8000" # Services db: image: mysql:5.7 #restart: no environment: # Password for root access MYSQL_ROOT_PASSWORD: '12345678' MYSQL_DATABASE: 'trail_risk_inc_backend' ports: # <Port exposed> : < MySQL Port running inside container> - '3306' expose: # Opens port 3306 on the container - '3306' # Where our data will be persisted volumes: - ./db-init:/docker-entrypoint-initdb.d

settings.py

DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'trail_risk_inc_backend', 'USER': 'root', 'PASSWORD': '12345678', 'HOST': 'db', # Or an IP Address that your DB is hosted on 'PORT': '3306', } }

LinPy · Accepted Answer · 2019-12-13 10:38:27Z

1

the problem is with your command:

docker-compose run app sh -c "python app/manage.py migrate"

that will start only the app container but not the db.

try to start your stack with:

docker-compose up -d

then run your command so:

docker exec -ti MY_APP_CON sh -c "python app/manage.py migrate"

answered Dec 13, 2019 at 10:38

LinPy

18.8k5 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Nikul Panchal Over a year ago

What we need to add for MY_APP_CON ?

Nikul Panchal Over a year ago

Thanks it is working to me now, migration is completed, now can you help me, can i connect this connection with workbench ?

LinPy Over a year ago

you need to edit your port section "3306:3306" , then you can setup your workbench with localhost 3306

Nikul Panchal Over a year ago

ports: # <Port exposed> : < MySQL Port running inside container> - '3306' at this line right ?

Nikul Panchal Over a year ago

here DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'trail_risk_inc_backend', 'USER': 'root', 'PASSWORD': '12345678', 'HOST': 'db', # Or an IP Address that your DB is hosted on 'PORT': '3306:3306', } } ?

|

Collectives™ on Stack Overflow

Getting error : Unknown MySQL server host 'db' (-2) in django python for docker

1 Answer 1

7 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Related