Yeah, psycopg2 is definitely installed...
On Thursday, December 27, 2012 9:03:31 AM UTC-5, ke1g wrote:
>
>
>
> On Thu, Dec 27, 2012 at 8:26 AM, Dan Richards <roda...@gmail.com<javascript:>
> > wrote:
>
>> Hmmm...well that isn't working either - same error. My method for
>> verifying it's picking up the right settings.py is by putting a syntax
>> error in the settings.py it should be using and seeing that it generates an
>> error. This is the settings.py file in the directory below my app
>> directory and that includes url.py and wsgi.py...
>>
>> On Wednesday, December 26, 2012 4:25:11 PM UTC-5, Ryan Blunden wrote:
>>>
>>> Ok. I would try setting the ENGINE value to *sqlite3* and try running
>>> *syncdb
>>> *again. If that works (which it should), then we can presume it's a
>>> configuration access problem with the DB.
>>>
>>>
>>> On 26 December 2012 13:18, Dan Richards <roda...@gmail.com> wrote:
>>>
>>>> NO, just me messing around that it made no difference. I have the db
>>>> access to all and trust and the error doesn't change no matter what I use
>>>> there. It feels like it could be a permissions problem, but I don't know
>>>> how to track it down other than to verify I can access postgres via psql
>>>> which I can do...
>>>>
>>>>
>>>> On Wednesday, December 26, 2012 12:40:28 PM UTC-5, Dan Richards wrote:
>>>>>
>>>>> First off, I am a newbie to django, python and postgres - so I suspect
>>>>> I am missing something obvious, but I am stumped. Any ideas will be
>>>>> gratefully accepted...
>>>>>
>>>>> I get the popular "Improperly configured settings.DATABASES" error
>>>>> message when I run syncdb on my test app. I am running:
>>>>>
>>>>> django 1.4.3
>>>>> postgres 9.2
>>>>> MAC OS 10.6.8
>>>>>
>>>>> I have verified that it is picking up the right settings.py file (the
>>>>> one in the app subdirectory) so I assume there is either something wrong
>>>>> with the settings I have entered or something wrong with postgres. How
>>>>> does one debug this??
>>>>>
>>>>> I can connect to my database via psql, but nothing I have tried seems
>>>>> to work and there seems to be very little I can do to actually debug what
>>>>> the problem is...when the syncdb doesn't work, how do you debug to figure
>>>>> out what exactly isn't working???
>>>>>
>>>>> My settings.py file:
>>>>>
>>>>> # Django settings for hellodjango project.
>>>>>
>>>>> DEBUG = True
>>>>> TEMPLATE_DEBUG = DEBUG
>>>>>
>>>>> ADMINS = (
>>>>> ('Joe Smith', 'jsm...@foobar.com'),
>>>>> )
>>>>>
>>>>> MANAGERS = ADMINS
>>>>>
>>>>> DATABASES = {
>>>>> 'default': {
>>>>> 'ENGINE': 'django.db.backends.**postgresql**_psycopg2', # Add
>>>>> 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
>>>>> 'NAME': 'test_db1', # Or path to database
>>>>> file if using sqlite3.
>>>>> 'USER': '', # Not used with sqlite3.
>>>>> 'PASSWORD': '', # Not used with sqlite3.
>>>>> 'HOST': '', # Set to empty string for
>>>>> localhost. Not used with sqlite3.
>>>>> 'PORT': '', # Set to empty string for
>>>>> default. Not used with sqlite3.
>>>>> }
>>>>> }
>>>>>
>>>>> # Local time zone for this installation. Choices can be found here:
>>>>> #
>>>>> http://en.wikipedia.org/wiki/**L**ist_of_tz_zones_by_name<http://en.wikipedia.org/wiki/List_of_tz_zones_by_name>
>>>>> # although not all choices may be available on all operating systems.
>>>>> # In a Windows environment this must be set to your system time zone.
>>>>> TIME_ZONE = 'America/New_York'
>>>>>
>>>>> # Language code for this installation. All choices can be found here:
>>>>> #
>>>>> http://www.i18nguy.com/**unicode**/language-identifiers.**html<http://www.i18nguy.com/unicode/language-identifiers.html>
>>>>> LANGUAGE_CODE = 'en-us'
>>>>>
>>>>> SITE_ID = 1
>>>>>
>>>>> # If you set this to False, Django will make some optimizations so as
>>>>> not
>>>>> # to load the internationalization machinery.
>>>>> USE_I18N = True
>>>>>
>>>>> # If you set this to False, Django will not format dates, numbers and
>>>>> # calendars according to the current locale.
>>>>> USE_L10N = True
>>>>>
>>>>> # If you set this to False, Django will not use timezone-aware
>>>>> datetimes.
>>>>> USE_TZ = True
>>>>>
>>>>> # Absolute filesystem path to the directory that will hold
>>>>> user-uploaded files.
>>>>> # Example:
>>>>> "/home/media/media.lawrence.**co**m/media/<http://media.lawrence.com/media/>
>>>>> "
>>>>> MEDIA_ROOT = ''
>>>>>
>>>>> # URL that handles the media served from MEDIA_ROOT. Make sure to use a
>>>>> # trailing slash.
>>>>> # Examples:
>>>>> "http://media.lawrence.com/**med**ia/<http://media.lawrence.com/media/>",
>>>>> "http://example.com/media/";
>>>>> MEDIA_URL = ''
>>>>>
>>>>> # Absolute path to the directory static files should be collected to.
>>>>> # Don't put anything in this directory yourself; store your static
>>>>> files
>>>>> # in apps' "static/" subdirectories and in STATICFILES_DIRS.
>>>>> # Example:
>>>>> "/home/media/media.lawrence.**co**m/static/<http://media.lawrence.com/static/>
>>>>> "
>>>>> STATIC_ROOT = ''
>>>>>
>>>>> # URL prefix for static files.
>>>>> # Example:
>>>>> "http://media.lawrence.com/**sta**tic/<http://media.lawrence.com/static/>
>>>>> "
>>>>> STATIC_URL = '/static/'
>>>>>
>>>>> # Additional locations of static files
>>>>> STATICFILES_DIRS = (
>>>>> # Put strings here, like "/home/html/static" or
>>>>> "C:/www/django/static".
>>>>> # Always use forward slashes, even on Windows.
>>>>> # Don't forget to use absolute paths, not relative paths.
>>>>> )
>>>>>
>>>>> # List of finder classes that know how to find static files in
>>>>> # various locations.
>>>>> STATICFILES_FINDERS = (
>>>>> 'django.contrib.staticfiles.**fi**nders.FileSystemFinder',
>>>>> 'django.contrib.staticfiles.**fi**nders.AppDirectoriesFinder',
>>>>> # 'django.contrib.staticfiles.**f**inders.DefaultStorageFinder',
>>>>> )
>>>>>
>>>>> # Make this unique, and don't share it with anybody.
>>>>> SECRET_KEY = '3*a*mgk*)dcdyzi8v4#2%z^mt^63-****uqq5g)q63)xy37ogcqxux'
>>>>>
>>>>> # List of callables that know how to import templates from various
>>>>> sources.
>>>>> TEMPLATE_LOADERS = (
>>>>> 'django.template.loaders.**files**ystem.Loader',
>>>>> 'django.template.loaders.app_**d**irectories.Loader',
>>>>> # 'django.template.loaders.eggs.****Loader',
>>>>> )
>>>>>
>>>>> MIDDLEWARE_CLASSES = (
>>>>> 'django.middleware.common.**Comm**onMiddleware',
>>>>> 'django.contrib.sessions.**middl**eware.SessionMiddleware',
>>>>> 'django.middleware.csrf.**CsrfVi**ewMiddleware',
>>>>> 'django.contrib.auth.**middlewar**e.**AuthenticationMiddleware',
>>>>> 'django.contrib.messages.**middl**eware.MessageMiddleware',
>>>>> # Uncomment the next line for simple clickjacking protection:
>>>>> # 'django.middleware.**clickjackin**g.**XFrameOptionsMiddleware',
>>>>> )
>>>>>
>>>>> ROOT_URLCONF = 'hellodjango.urls'
>>>>>
>>>>> # Python dotted path to the WSGI application used by Django's
>>>>> runserver.
>>>>> WSGI_APPLICATION = 'hellodjango.wsgi.application'
>>>>>
>>>>> TEMPLATE_DIRS = (
>>>>> # Put strings here, like "/home/html/django_templates" or
>>>>> "C:/www/django/templates".
>>>>> # Always use forward slashes, even on Windows.
>>>>> # Don't forget to use absolute paths, not relative paths.
>>>>> )
>>>>>
>>>>> INSTALLED_APPS = (
>>>>> 'django.contrib.auth',
>>>>> 'django.contrib.contenttypes',
>>>>> 'django.contrib.sessions',
>>>>> 'django.contrib.sites',
>>>>> 'django.contrib.messages',
>>>>> 'django.contrib.staticfiles',
>>>>> 'kombu.transport.django',
>>>>> 'djcelery',
>>>>> # Uncomment the next line to enable the admin:
>>>>> # 'django.contrib.admin',
>>>>> # Uncomment the next line to enable admin documentation:
>>>>> # 'django.contrib.admindocs',
>>>>> )
>>>>>
>>>>> # A sample logging configuration. The only tangible logging
>>>>> # performed by this configuration is to send an email to
>>>>> # the site admins on every HTTP 500 error when DEBUG=False.
>>>>> # See
>>>>> http://docs.djangoproject.com/****en/dev/topics/logging<http://docs.djangoproject.com/en/dev/topics/logging>for
>>>>> # more details on how to customize your logging configuration.
>>>>> LOGGING = {
>>>>> 'version': 1,
>>>>> 'disable_existing_loggers': False,
>>>>> 'filters': {
>>>>> 'require_debug_false': {
>>>>> '()': 'django.utils.log.**RequireDebug**False'
>>>>> }
>>>>> },
>>>>> 'handlers': {
>>>>> 'mail_admins': {
>>>>> 'level': 'ERROR',
>>>>> 'filters': ['require_debug_false'],
>>>>> 'class': 'django.utils.log.**AdminEmailHa**ndler'
>>>>> }
>>>>> },
>>>>> 'loggers': {
>>>>> 'django.request': {
>>>>> 'handlers': ['mail_admins'],
>>>>> 'level': 'ERROR',
>>>>> 'propagate': True,
>>>>> },
>>>>> }
>>>>> }
>>>>> # Parse database configuration from $DATABASE_URL
>>>>> import dj_database_url
>>>>> DATABASES['default'] = dj_database_url.config()
>>>>>
>>>>> BROKER_BACKEND = 'django'
>>>>>
>>>>> import djcelery
>>>>> djcelery.setup_loader()
>>>>>
>>>>>
>>>>>
>>>>> And here is the traceback:
>>>>>
>>>>> (venv)mac-rodan:hellodjango rodan$ python manage.py syncdb --verbosity
>>>>> 2
>>>>> here we are
>>>>> Traceback (most recent call last):
>>>>> File "manage.py", line 10, in <module>
>>>>> execute_from_command_line(sys.****argv)
>>>>> File "/Users/rodan/testdev/**hellodja**ngo/venv/lib/python2.**
>>>>> 7/site-**packages/django/core/**managemen**t/__init__.py", line 443,
>>>>> in execute_from_command_line
>>>>> utility.execute()
>>>>> File "/Users/rodan/testdev/**hellodja**ngo/venv/lib/python2.**
>>>>> 7/site-**packages/django/core/**managemen**t/__init__.py", line 382,
>>>>> in execute
>>>>> self.fetch_command(subcommand)****.run_from_argv(self.argv)
>>>>> File "/Users/rodan/testdev/**hellodja**ngo/venv/lib/python2.**
>>>>> 7/site-**packages/django/core/**managemen**t/base.py", line 196, in
>>>>> run_from_argv
>>>>> self.execute(*args, **options.__dict__)
>>>>> File "/Users/rodan/testdev/**hellodja**ngo/venv/lib/python2.**
>>>>> 7/site-**packages/django/core/**managemen**t/base.py", line 232, in
>>>>> execute
>>>>> output = self.handle(*args, **options)
>>>>> File "/Users/rodan/testdev/**hellodja**ngo/venv/lib/python2.**
>>>>> 7/site-**packages/django/core/**managemen**t/base.py", line 371, in
>>>>> handle
>>>>> return self.handle_noargs(**options)
>>>>> File "/Users/rodan/testdev/**hellodja**ngo/venv/lib/python2.**
>>>>> 7/site-**packages/django/core/**managemen**t/commands/syncdb.py"**,
>>>>> line 58, in handle_noargs
>>>>> cursor = connection.cursor()
>>>>> File "/Users/rodan/testdev/**hellodja**ngo/venv/lib/python2.**
>>>>> 7/site-**packages/django/db/**backends/**dummy/base.py", line 15, in
>>>>> complain
>>>>> raise ImproperlyConfigured("**settings**.DATABASES is improperly
>>>>> configured. "
>>>>> django.core.exceptions.**Imprope**rlyConfigured: settings.DATABASES
>>>>> is improperly configured. Please supply the ENGINE value. Check settings
>>>>> documentation for more details.
>>>>>
>>>>>
>>>>> I would expect a different error, but are you certain that psycopg2 is
> installed?
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/django-users/-/-KD-crMKhXYJ.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
