首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >将Django docker连接到远程数据库

问将Django docker连接到远程数据库
EN

Stack Overflow用户
提问于 2020-12-17 19:51:10
回答 1查看 760关注 0票数 0

我有一个运行在docker上的Django应用程序,连接到同一主机上另一个容器中的数据库。这看起来工作得很好,但当我尝试更改到另一台服务器上的数据库的连接时,它无法连接。不仅如此,当我尝试在浏览器(如admin或api)中连接到Django应用程序时,我没有得到任何响应,在输出日志中也看不到任何活动。如果我在容器外部运行应用程序,那么它在远程数据库中运行得很好,并且数据库被设置为接受我试图连接的用户的所有IP。

有什么想法可以解释为什么我不能连接吗?

Dockerfile:

代码语言:javascript
复制
FROM python:3.8-alpine

ENV PATH="/scripts:${PATH}"

COPY ./requirements.txt /requirements.txt
RUN apk add --update --no-cache --virtual .tmp gcc libc-dev linux-headers
RUN apk add mariadb-dev python3-dev postgresql-dev
RUN pip install -r /requirements.txt
RUN apk del .tmp

RUN mkdir /app_django
COPY ./app_django /app_django
WORKDIR /app_django
COPY ./scripts /scripts

RUN chmod +x /scripts/*

RUN mkdir -p /vol/web/media
RUN mkdir -p /vol/web/static
RUN adduser -D user
RUN chown -R user:user /vol
RUN chmod -R 755 /vol/web
USER user

CMD ["entrypoint.sh"]

docker-compose.yml

代码语言:javascript
复制
version: '3.7'

services:
  db:
    build: mysql/
    environment:
      MYSQL_ROOT_PASSWORD: 'password'
      MYSQL_DATABASE: database
    volumes:
      - ./mysql/data:/var/lib/mysql
      - ./mysql/conf:/etc/mysql/conf.d
      - ./mysql/entrypoint-initdb.d:/docker-entrypoint-initdb.d/
      - ./mysql/backup_database:/var/local/mysql/backups
    ports:
      - 3306:3306
    restart: always
    
  pdb:
    build:
      context: .
    ports:
      - "8000:8000"
    volumes:
      - ./pdb_django:/pdb_django
    command: sh -c "python manage.py runserver 0.0.0.0:8000"
    environment:
      - DEBUG=1

entrypoint.sh

代码语言:javascript
复制
#!/bin/sh

set -e

python manage.py collectstatic --noinput

uwsgi --socket :8000 --master --enable-threads --module app.wsgi

Django数据库设置(连接到主机容器上的数据库时使用注释部分):

代码语言:javascript
复制
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'database',
        'HOST': '<remote IP>',
        # 'HOST': 'db',
        'USER': 'user',
        'PASSWORD': 'password',
        'PORT': '3308'
        # 'PORT': '3306',
    }
}

requirements.txt

代码语言:javascript
复制
Django==3.1.4
uWSGI>=2.0.18,<2.1
django-filter==2.4.0
djangorestframework==3.12.2
mysql-connector-python==8.0.22
mysqlclient==2.0.2
PyMySQL==0.10.1
sqlparse==0.4.1

应用程序的输出日志:

代码语言:javascript
复制
pdb_1  | Watching for file changes with StatReloader
pdb_1  | Exception in thread django-main-thread:
pdb_1  | Traceback (most recent call last):
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
pdb_1  |     self.connect()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
pdb_1  |     return func(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 200, in connect
pdb_1  |     self.connection = self.get_new_connection(conn_params)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
pdb_1  |     return func(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 234, in get_new_connection
pdb_1  |     return Database.connect(**conn_params)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/MySQLdb/__init__.py", line 130, in Connect
pdb_1  |     return Connection(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/MySQLdb/connections.py", line 185, in __init__
pdb_1  |     super().__init__(*args, **kwargs2)
pdb_1  | MySQLdb._exceptions.OperationalError: (2002, "Can't connect to MySQL server on '<remote IP>' (115)")
pdb_1  |
pdb_1  | The above exception was the direct cause of the following exception:
pdb_1  |
pdb_1  | Traceback (most recent call last):
pdb_1  |   File "/usr/local/lib/python3.8/threading.py", line 932, in _bootstrap_inner
pdb_1  |     self.run()
pdb_1  |   File "/usr/local/lib/python3.8/threading.py", line 870, in run
pdb_1  |     self._target(*self._args, **self._kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/utils/autoreload.py", line 53, in wrapper
pdb_1  |     fn(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/core/management/commands/runserver.py", line 121, in inner_run
pdb_1  |     self.check_migrations()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/core/management/base.py", line 459, in check_migrations
pdb_1  |     executor = MigrationExecutor(connections[DEFAULT_DB_ALIAS])
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/migrations/executor.py", line 18, in __init__
pdb_1  |     self.loader = MigrationLoader(self.connection)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/migrations/loader.py", line 53, in __init__
pdb_1  |     self.build_graph()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/migrations/loader.py", line 216, in build_graph
pdb_1  |     self.applied_migrations = recorder.applied_migrations()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 77, in applied_migrations
pdb_1  |     if self.has_table():
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 55, in has_table
pdb_1  |     with self.connection.cursor() as cursor:
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
pdb_1  |     return func(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 259, in cursor
pdb_1  |     return self._cursor()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 235, in _cursor
pdb_1  |     self.ensure_connection()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
pdb_1  |     return func(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
pdb_1  |     self.connect()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/utils.py", line 90, in __exit__
pdb_1  |     raise dj_exc_value.with_traceback(traceback) from exc_value
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 219, in ensure_connection
pdb_1  |     self.connect()
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
pdb_1  |     return func(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/base/base.py", line 200, in connect
pdb_1  |     self.connection = self.get_new_connection(conn_params)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
pdb_1  |     return func(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/django/db/backends/mysql/base.py", line 234, in get_new_connection
pdb_1  |     return Database.connect(**conn_params)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/MySQLdb/__init__.py", line 130, in Connect
pdb_1  |     return Connection(*args, **kwargs)
pdb_1  |   File "/usr/local/lib/python3.8/site-packages/MySQLdb/connections.py", line 185, in __init__
pdb_1  |     super().__init__(*args, **kwargs2)
pdb_1  | django.db.utils.OperationalError: (2002, "Can't connect to MySQL server on '<remote IP>' (115)")
EN

回答 1

Stack Overflow用户

发布于 2020-12-18 17:04:17

这似乎是我的VPN的一个问题。当我试图在网络上的服务器上运行容器时,它工作得很好,当我关闭VPN时,我也能得到响应(尽管我显然不能访问服务器上的数据库)。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/65340186

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档