'settings.DATABASES is improperly configured. Heroku
Trying to do some testing on my Heroku Local Server (http://0.0.0.0:8000/) - the index.html loads correctly but when I navigate away (for example to admin) from that page I get the following error:
Traceback (most recent call last):
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 47, in inner
response = get_response(request)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 181, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 43, in _wrapper
return bound_method(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/views/decorators/cache.py", line 57, in _wrapped_view_func
response = view_func(request, *args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/contrib/admin/sites.py", line 417, in login
return LoginView.as_view(**defaults)(request)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 69, in view
return self.dispatch(request, *args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 43, in _wrapper
return bound_method(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/views/decorators/debug.py", line 90, in sensitive_post_parameters_wrapper
return view(request, *args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 43, in _wrapper
return bound_method(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 130, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/decorators.py", line 43, in _wrapper
return bound_method(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/views/decorators/cache.py", line 57, in _wrapped_view_func
response = view_func(request, *args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/contrib/auth/views.py", line 64, in dispatch
return super().dispatch(request, *args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 101, in dispatch
return handler(request, *args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/views/generic/edit.py", line 135, in get
return self.render_to_response(self.get_context_data())
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/contrib/auth/views.py", line 101, in get_context_data
current_site = get_current_site(self.request)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/contrib/sites/shortcuts.py", line 13, in get_current_site
return Site.objects.get_current(request)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/contrib/sites/models.py", line 58, in get_current
return self._get_site_by_id(site_id)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/contrib/sites/models.py", line 30, in _get_site_by_id
site = self.get(pk=site_id)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/models/query.py", line 435, in get
num = len(clone)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
self._fetch_all()
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1354, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1200, in execute_sql
cursor = self.connection.cursor()
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 270, in cursor
return self._cursor()
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 246, in _cursor
self.ensure_connection()
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 230, in ensure_connection
self.connect()
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/utils/asyncio.py", line 25, in inner
return func(*args, **kwargs)
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/backends/base/base.py", line 210, in connect
conn_params = self.get_connection_params()
File "/Users/x/Desktop/Programming/projects/anybody/venv/lib/python3.9/site-packages/django/db/backends/postgresql/base.py", line 159, in get_connection_params
raise ImproperlyConfigured(
Exception Type: ImproperlyConfigured at /admin/login/
Exception Value: settings.DATABASES is improperly configured. Please supply the NAME or OPTIONS['service'] value.
settings.DATABASES:
DATABASES = {
'default': {
'ENGINE': 'django.contrib.gis.db.backends.postgis',
'NAME': 'vygr',
'USER': 'x',
'PASSWORD': 'x',
'HOST': 'localhost',
'PORT': '5432'
}
}
[...]
import django_heroku
django_heroku.settings(locals())
import dj_database_url
DATABASES['default'] = dj_database_url.config()
DATABASES['default']['ENGINE'] = 'django.contrib.gis.db.backends.postgis'
[...]
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
