Skip to main content
 首页 » 编程设计

python之django 无法打开数据库文件

2025年05月04日19cyq1162

我正在实现一个 Django 网站,

站点进入hello world View :

http://ec2-107-20-20-19.compute-1.amazonaws.com/

views.py /home/ubuntu/djangoProj/micopiloto/portfolio

    # Create your views here. 
    from django.http import HttpResponse  
 
    def view(request): 
        return HttpResponse('Hello Worlsss9d!') 

但我看不到 amin 站点,我看到这个错误:无法打开数据库文件

> http://ec2-107-20-20-19.compute-1.amazonaws.com/admin/ 
 
settings.py `/home/ubuntu/djangoProj/micopiloto` 
 
 
# Django settings for micopiloto project. 
 
DEBUG = True 
TEMPLATE_DEBUG = DEBUG 
 
ADMINS = ( 
    # ('Your Name', 'your_email@example.com'), 
) 
 
MANAGERS = ADMINS 
 
DATABASES = { 
    'default': { 
        'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'. 
        'NAME': 'thadb.db',                      # 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/List_of_tz_zones_by_name 
# although not all choices may be available on all operating systems. 
# On Unix systems, a value of None will cause Django to use the same 
# timezone as the operating system. 
# If running in a Windows environment this must be set to the same as your 
# system time zone. 
TIME_ZONE = 'America/Chicago' 
 
# Language code for this installation. All choices can be found here: 
# 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 
 
# Absolute filesystem path to the directory that will hold user-uploaded files. 
# Example: "/home/media/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/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.com/static/" 
STATIC_ROOT = '' 
 
# URL prefix for static files. 
# Example: "http://media.lawrence.com/static/" 
STATIC_URL = '/static/' 
 
# URL prefix for admin static files -- CSS, JavaScript and images. 
# Make sure to use a trailing slash. 
# Examples: "http://foo.com/static/admin/", "/static/admin/". 
ADMIN_MEDIA_PREFIX = '/static/admin/' 
 
# 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.finders.FileSystemFinder', 
    'django.contrib.staticfiles.finders.AppDirectoriesFinder', 
#    'django.contrib.staticfiles.finders.DefaultStorageFinder', 
) 
 
# Make this unique, and don't share it with anybody. 
SECRET_KEY = '2&g_&k=+^(0t)1xf82m^=#0u6v1e!)nn7ixq*+2^h%4$mwlrsm' 
 
# List of callables that know how to import templates from various sources. 
TEMPLATE_LOADERS = ( 
    'django.template.loaders.filesystem.Loader', 
    'django.template.loaders.app_directories.Loader', 
#     'django.template.loaders.eggs.Loader', 
) 
 
MIDDLEWARE_CLASSES = ( 
    'django.middleware.common.CommonMiddleware', 
    'django.contrib.sessions.middleware.SessionMiddleware', 
    'django.middleware.csrf.CsrfViewMiddleware', 
    'django.contrib.auth.middleware.AuthenticationMiddleware', 
    'django.contrib.messages.middleware.MessageMiddleware', 
) 
 
ROOT_URLCONF = 'micopiloto.urls' 
 
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', 
    # Uncomment the next line to enable the admin: 
    'django.contrib.admin', 
    # Uncomment the next line to enable admin documentation: 
    # 'django.contrib.admindocs', 
    'portfolio'  
) 
 
# 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. 
# See 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, 
    'handlers': { 
        'mail_admins': { 
            'level': 'ERROR', 
            'class': 'django.utils.log.AdminEmailHandler' 
        } 
    }, 
    'loggers': { 
        'django.request': { 
            'handlers': ['mail_admins'], 
            'level': 'ERROR', 
            'propagate': True, 
        }, 
    } 
} 

所以我看到创建的 thadb.db 在我的项目文件夹中,

我有错误:

Exception Value:     
unable to open database file 

所以我有 $sudo chmod 777 thadb.db

还是报错,

这是因为权限吗? 我应该将文件夹设置为 777 吗?

编辑>>

按照建议的解决方案,我为数据库和根文件夹尝试了 chmod root

-rwxrwxrwx 1 root     ubuntu   44032 2012-04-09 09:49 thadb.db 
drwxrwxrwx 3 root   ubuntu 4096 2012-04-09 12:44 micopiloto 

还是不行! ;(

我收到这个错误:

Exception Value:     
unable to open database file 

那么怎么让admin显示出来呢??

  • 安全性会受到怎样的影响?

谢谢!

请您参考如下方法:

这是一篇描述您的问题的解决方案的文章:

http://www.pantz.org/software/sqlite/unabletoopendbsqliteerror.html

解决方案是确保包含数据库文件的目录也允许对进程进行写访问。

另外,Django 有一个页面来解决这个问题。

https://code.djangoproject.com/wiki/NewbieMistakes#DjangosaysUnabletoOpenDatabaseFilewhenusingSQLite3