Google Cloud部署Django Wagtail网站遇数据库配置错误求助

问题详情 #

已成功在Google Cloud部署Django Wagtail网站，但遇到错误：
settings.DATABASES is improperly configured. Please supply the ENGINE value. Check settings documentation for more details.

尝试在settings.py中硬编码数据库参数如下：

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'url to sql stuff',
        'USER': 'user I register',
        'PASSWORD': "my password",
        'PORT': '8080',
        'HOST': "127.0.0.1"
        }
}

已确认参数正确且云端数据库存在，但仍出现相同错误。完整错误回溯如下：

Traceback (most recent call last):
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/wagtail/views.py", line 14, in serve
    site = Site.find_for_request(request)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/wagtail/models/sites.py", line 150, in find_for_request
    site = Site._find_for_request(request)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/wagtail/models/sites.py", line 160, in _find_for_request
    site = get_site_for_hostname(hostname, port)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/wagtail/models/sites.py", line 23, in get_site_for_hostname
    sites = list(
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/query.py", line 320, in __iter__
    self._fetch_all()
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/query.py", line 1507, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/query.py", line 57, in __iter__
    results = compiler.execute_sql(
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1348, in execute_sql
    sql, params = self.as_sql()
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 573, in as_sql
    extra_select, order_by, group_by = self.pre_sql_setup()
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 64, in pre_sql_setup
    self.setup_query()
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 55, in setup_query
    self.select, self.klass_info, self.annotation_col_map = self.get_select()
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 284, in get_select
    sql, params = self.compile(col)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 496, in compile
    sql, params = node.as_sql(self, self.connection)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/expressions.py", line 948, in as_sql
    sql = ".".join(map(compiler.quote_name_unless_alias, identifiers))
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 487, in quote_name_unless_alias
    r = self.connection.ops.quote_name(name)
  File "/layers/google.python.pip/pip/lib/python3.10/site-packages/django/db/backends/dummy/base.py", line 20, in complain
    raise ImproperlyConfigured(
django.core.exceptions.ImproperlyConfigured: settings.DATABASES is improperly configured. Please supply the ENGINE value. Check settings documentation for more details. 

解决步骤 #

1. 确认配置文件是否被正确加载 #

• 检查是否存在多环境settings文件（如settings/production.py），部署时是否通过环境变量DJANGO_SETTINGS_MODULE指定了正确的配置路径。
• 在settings.py中添加临时调试代码，部署后查看日志确认实际加载的配置：

import os
print("Loaded DATABASES:", DATABASES)
print("Active settings module:", os.environ.get('DJANGO_SETTINGS_MODULE'))

2. 修正数据库参数错误 #

• HOST配置：Google Cloud SQL的主机地址不是127.0.0.1，除非使用Cloud SQL代理。直接连接需填写实例的公网/私有IP；使用代理时确保代理已启动，端口改为PostgreSQL默认的5432（8080是代理管理端口，非数据库连接端口）。
• NAME参数：NAME应填写数据库名称，而非连接URL。若使用Cloud SQL提供的连接URL，可通过dj-database-url解析：

import dj_database_url
DATABASES = {
    'default': dj_database_url.config(default='postgres://user:password@host:port/dbname')
}

3. 确认依赖安装 #

• 确保psycopg2-binary（或psycopg2）已加入requirements.txt：

psycopg2-binary>=2.9.0

重新部署时确认依赖已正确安装。

4. 验证Cloud SQL连接权限 #

• 确认部署服务的账号拥有roles/cloudsql.client角色。
• 若使用公网IP，确保实例的授权网络包含GCP服务的出口IP；若使用私有IP，确保服务与实例在同一VPC网络。

5. 检查配置覆盖情况 #

• 排查是否有其他代码（如local_settings.py）或环境变量（如DATABASE_URL）覆盖了你硬编码的DATABASES配置。

6. 执行数据库迁移 #

• 部署后执行python manage.py migrate初始化数据库结构，避免Wagtail访问Site模型时触发未初始化错误。

内容的提问来源于stack exchange，提问作者Leon_idas