triclops200 Posted August 4, 2011 Share Posted August 4, 2011 Hello, I am setting up a django site, and I have a sqlite3 database file I am trying to access, with permissions 777 (I know, overkill) but I get the unable to open database error with it. I would have used mysql, but I get 500 errors everytime I try with some problem about .python-egg-cache being inaccessible even though I have it set to .777. Here is how I have databases set up: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'. 'NAME': '/home1/triclops/test', # 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. } } Here is the stack trace for django sqlite3 error: Environment: Request Method: GET Request URL: http://triclops200.com/djangotest/dispatch.wsgi/djangotest/dispatch.wsgi/admin/ Django Version: 1.3 Python Version: 2.7.1 Installed Applications: ['django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'polls', 'django.contrib.admin'] Installed Middleware: ('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware') Traceback: File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response 178. response = middleware_method(request, response) File "/usr/local/lib/python2.7/site-packages/django/contrib/sessions/middleware.py" in process_response 36. request.session.save() File "/usr/local/lib/python2.7/site-packages/django/contrib/sessions/backends/db.py" in save 63. obj.save(force_insert=must_create, using=using) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py" in save 460. self.save_base(using=using, force_insert=force_insert, force_update=force_update) File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py" in save_base 553. result = manager._insert(values, return_id=update_pk, using=using) File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py" in _insert 195. return insert_query(self.model, values, **kwargs) File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in insert_query 1436. return query.get_compiler(using=using).execute_sql(return_id) File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql 791. cursor = super(SQLInsertCompiler, self).execute_sql(None) File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql 735. cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute 34. return self.cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute 234. return Database.Cursor.execute(self, query, params) Exception Type: DatabaseError at /djangotest/dispatch.wsgi/admin/ Exception Value: unable to open database file I fixed it, I accidentally used '_' instead of '-' in .python-egg-cache Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.