work0 (054, "Unknown column 'app_resourcecert.conf_id' in 'where clause'")

DatabaseError at /rpki/ (1054, "Unknown column 'app_resourcecert.conf_id' in 'where clause'") Request Method: GET Request URL: https://demo.rpki.net/rpki/ Django Version: 1.4.2 Exception Type: DatabaseError Exception Value:
(1054, "Unknown column 'app_resourcecert.conf_id' in 'where clause'") Exception Location: /usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.1-PRERELEASE-amd64.egg/MySQLdb/connections.py in defaulterrorhandler, line 36 Python Executable:
Python Version: 2.7.3 Python Path:
['/usr/local/etc/rpki', '/usr/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg', '/usr/local/lib/python2.7/site-packages/flup-1.0.2-py2.7.egg', '/usr/local/lib/python2.7/site-packages/MarkupSafe-0.15-py2.7-freebsd-9.0-PRERELEASE-amd64.egg', '/usr/local/lib/python2.7/site-packages/zope.interface-3.8.0-py2.7-freebsd-9.0-PRERELEASE-amd64.egg', '/usr/local/lib/python2.7/site-packages/python_dateutil-1.5-py2.7.egg', '/usr/local/lib/python2.7/site-packages/vobject-0.8.1c-py2.7.egg', '/usr/local/lib/python2.7/site-packages/Genshi-0.6-py2.7.egg', '/usr/local/lib/python2.7/site-packages/Babel-0.9.6-py2.7.egg', '/usr/local/lib/python2.7/site-packages/Trac-0.12.3-py2.7.egg', '/usr/local/lib/python2.7/site-packages/darcsver-1.7.4-py2.7.egg', '/usr/local/lib/python2.7/site-packages/TracXMLRPC-1.0.6-py2.7.egg', '/usr/local/lib/python2.7/site-packages/lxml-2.3.4-py2.7-freebsd-9.0-STABLE-amd64.egg', '/usr/local/lib/python2.7/site-packages/Pygments-1.5-py2.7.egg', '/usr/local/lib/python2.7/site-packages/pyutil-1.9.3-py2.7.egg', '/usr/local/lib/python2.7/site-packages/pip-1.1-py2.7.egg', '/usr/local/lib/python2.7/site-packages/setuptools_darcs-1.2.11-py2.7.egg', '/usr/local/lib/python2.7/site-packages/pyasn1-0.1.4-py2.7.egg', '/usr/local/lib/python2.7/site-packages/MySQL_python-1.2.3-py2.7-freebsd-9.1-PRERELEASE-amd64.egg', '/usr/local/lib/python2.7/site-packages/TracAccountManager-0.4dev-py2.7.egg', '/usr/local/lib/python2.7/site-packages/SharedCookieAuth-0.1.3-py2.7.egg', '/usr/local/lib/python2.7/site-packages/pytz-2012f-py2.7.egg', '/usr/local/lib/python2.7/site-packages/Sphinx-1.1.3-py2.7.egg', '/usr/local/lib/python2.7/site-packages/virtualenv-1.8.2-py2.7.egg', '/usr/local/lib/python2.7/site-packages/Jinja2-2.6-py2.7.egg', '/usr/local/lib/python2.7/site-packages/zbase32-1.1.5-py2.7.egg', '/usr/local/lib/python2.7/site-packages/South-0.7.6-py2.7.egg', '/usr/local/lib/python27.zip', '/usr/local/lib/python2.7', '/usr/local/lib/python2.7/plat-freebsd9', '/usr/local/lib/python2.7/lib-tk', '/usr/local/lib/python2.7/lib-old', '/usr/local/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/site-packages'] Server time: Wed, 21 Nov 2012 16:25:23 +0000 Traceback Switch back to interactive view

Request information

GET No GET data POST No POST data FILES No FILES data COOKIES Variable Value csrftoken
'jatWzmgJo6CPUyQkNobAMOZFGfqyYPmA' sessionid
'5ea6e8673c57905b8c6d369705c9354c' META Variable Value mod_wsgi.listener_port
'443' HTTP_REFERER
'https://demo.rpki.net/rpki/conf/list?next=/rpki/roa/' mod_wsgi.listener_host
'' SERVER_SOFTWARE 'Apache/2.2.22 (FreeBSD) mod_python/3.3.1 Python/2.7.3 mod_wsgi/3.4 SVN/1.7.6 PHP/5.4.7 mod_ssl/2.2.22 OpenSSL/1.0.1c DAV/2 mod_fastcgi/2.4.6' SCRIPT_NAME u'' mod_wsgi.enable_sendfile
'0' mod_wsgi.handler_script '' SERVER_SIGNATURE
'' REQUEST_METHOD
'GET' PATH_INFO
u'/rpki/' SERVER_PROTOCOL 'HTTP/1.1' QUERY_STRING
'' SSL_TLS_SNI 'demo.rpki.net' HTTP_ACCEPTCHARSET 'ISO-8859-1,utf-8;q=0.7,;q=0.3' HTTP_USER_AGENT 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_2) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11' HTTP_CONNECTION 'keep-alive' HTTP_COOKIE 'csrftoken=jatWzmgJo6CPUyQkNobAMOZFGfqyYPmA; sessionid=5ea6e8673c57905b8c6d369705c9354c' SERVER_NAME 'demo.rpki.net' REMOTE_ADDR '210.138.216.50' mod_wsgi.queue_start
'1353515122712709' mod_wsgi.request_handler
'wsgi-script' wsgi.url_scheme 'https' PATH_TRANSLATED '/usr/local/share/rpki/wsgi/rpki.wsgi/rpki/' SERVER_PORT '443' wsgi.multiprocess
True mod_wsgi.input_chunked
'0' SERVER_ADDR '147.28.0.35' DOCUMENT_ROOT
'/usr/local/share/rpki/gui/apache' mod_wsgi.process_group
'' REMOTE_PORT '51463' SCRIPT_FILENAME '/usr/local/share/rpki/wsgi/rpki.wsgi' SERVER_ADMIN
'randy@psg.com' wsgi.input
<mod_wsgi.Input object at 0x818d5a4b0> HTTP_DNT
'1' HTTP_HOST
'demo.rpki.net' wsgi.multithread
False mod_wsgi.callable_object
'application' REQUEST_URI '/rpki/' HTTPACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,/_;q=0.8' wsgi.version
(1, 0) GATEWAY_INTERFACE
'CGI/1.1' wsgi.run_once
False wsgi.errors <mod_wsgi.Log object at 0x818c89970> PYTHON_EGG_CACHE
'/usr/local/var/rpki/.eggs' HTTP_ACCEPT_LANGUAGE
'en-US,en;q=0.8' mod_wsgi.version
(3, 4) mod_wsgi.application_group
'demo.rpki.net|' mod_wsgi.script_reloading
'1' wsgi.file_wrapper
'' CSRF_COOKIE 'jatWzmgJo6CPUyQkNobAMOZFGfqyYPmA' HTTP_ACCEPT_ENCODING
'gzip,deflate,sdch' UNIQUE_ID
'UK0AcpMcACMAAPZ9O@oAAAAH' Settings Using settings module settings Setting Value USE_L10N
False USE_THOUSAND_SEPARATOR
False CSRF_COOKIE_SECURE
False LANGUAGE_CODE
'en-us' ROOT_URLCONF
'rpki.gui.urls' MANAGERS
() DEFAULT_CHARSET 'utf-8' STATIC_ROOT '' MESSAGE_STORAGE 'django.contrib.messages.storage.fallback.FallbackStorage' EMAIL_SUBJECT_PREFIX
'[Django] ' FILE_UPLOAD_PERMISSIONS None URL_VALIDATOR_USER_AGENT
'Django/1.4.2 (https://www.djangoproject.com)' STATICFILES_FINDERS ('django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder') SESSION_COOKIE_DOMAIN
None SESSION_COOKIE_NAME 'sessionid' ADMIN_FOR
() TIME_INPUT_FORMATS
('%H:%M:%S', '%H:%M') DATABASES
{'default': {'ENGINE': 'django.db.backends.mysql', 'HOST': '', 'NAME': 'rg_irdbd', 'OPTIONS': {'init_command': 'SET storageengine=INNODB'}, 'PASSWORD': u'**_', 'PORT': '', 'TEST_CHARSET': None, 'TEST_COLLATION': None, 'TEST_MIRROR': None, 'TEST_NAME': None, 'TIME_ZONE': 'UTC', 'USER': 'rg_rpki'}} SERVER_EMAIL
'root@localhost' FILE_UPLOAD_HANDLERS
('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler') DEFAULT_CONTENT_TYPE
'text/html' APPEND_SLASH
True FIRST_DAY_OF_WEEK
0 DATABASE_ROUTERS
[] YEAR_MONTH_FORMAT
'F Y' STATICFILES_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage' CACHES
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', 'LOCATION': ''}} SESSION_COOKIE_PATH '/' USE_X_FORWARDED_HOST
False MIDDLEWARE_CLASSES
('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.http.ConditionalGetMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware') USE_I18N
True THOUSAND_SEPARATOR
',' SECRETKEY
u'******_' LANGUAGE_COOKIE_NAME
'django_language' DEFAULT_INDEX_TABLESPACE
'' TRANSACTIONS_MANAGED
False LOGGING_CONFIG
'django.utils.log.dictConfig' SEND_BROKEN_LINK_EMAILS False TEMPLATE_LOADERS
('django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader', 'django.template.loaders.eggs.Loader') WSGI_APPLICATION
None TEMPLATE_DEBUG
True X_FRAME_OPTIONS 'SAMEORIGIN' AUTHENTICATION_BACKENDS ('django.contrib.auth.backends.ModelBackend',) FORCE_SCRIPT_NAME
None CACHE_BACKEND
'locmem://' SIGNING_BACKEND 'django.core.signing.TimestampSigner' SESSION_COOKIE_SECURE
False CSRF_COOKIE_DOMAIN
None FILE_CHARSET
'utf-8' DEBUG
True SESSION_FILE_PATH
None DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage' INSTALLED_APPS
('django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.formtools', 'django.contrib.sessions', 'rpki.irdb', 'rpki.gui.app', 'rpki.gui.cacheview', 'rpki.gui.routeview', 'south') LANGUAGES
(('ar', 'Arabic'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('bn', 'Bengali'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy-nl', 'Frisian'), ('ga', 'Irish'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hu', 'Hungarian'), ('id', 'Indonesian'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('nb', 'Norwegian Bokmal'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese')) COMMENTS_ALLOW_PROFANITIES
False STATICFILES_DIRS
() PREPEND_WWW False SECURE_PROXY_SSL_HEADER None SESSION_COOKIE_HTTPONLY True DEBUG_PROPAGATE_EXCEPTIONS
False MONTH_DAY_FORMAT
'F j' LOGIN_URL
'/accounts/login/' SESSION_EXPIRE_AT_BROWSER_CLOSE False TIME_FORMAT 'P' RPKI_CONF_TEMPLATE
'/usr/local/share/rpki/rpki.conf.template' DATE_INPUT_FORMATS
('%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y') CSRF_COOKIE_NAME
'csrftoken' EMAIL_HOSTPASSWORD u'******_' PASSWORD_RESET_TIMEOUTDAYS u'******_' CACHE_MIDDLEWARE_ALIAS
'default' SESSION_SAVE_EVERY_REQUEST
False NUMBER_GROUPING 0 SESSION_ENGINE
'django.contrib.sessions.backends.db' CSRF_FAILURE_VIEW
'django.views.csrf.csrf_failure' CSRF_COOKIE_PATH
'/' LOGIN_REDIRECT_URL
'/accounts/profile/' LOGGING {'disable_existing_loggers': False, 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}}, 'handlers': {'mail_admins': {'class': 'django.utils.log.AdminEmailHandler', 'filters': ['require_debug_false'], 'level': 'ERROR'}}, 'loggers': {'django.request': {'handlers': ['mail_admins'], 'level': 'ERROR', 'propagate': True}}, 'version': 1} IGNORABLE_404_URLS
() LOCALE_PATHS
() TEMPLATE_STRING_IF_INVALID
'' LOGOUT_URL
'/accounts/logout/' EMAIL_USE_TLS
False FIXTURE_DIRS
() EMAIL_HOST
'localhost' DATE_FORMAT 'N j, Y' MEDIA_ROOT
'' DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter' ADMINS
() FORMAT_MODULE_PATH
None DEFAULT_FROM_EMAIL
'webmaster@localhost' MEDIA_URL
'' DATETIME_FORMAT 'N j, Y, P' TEMPLATE_DIRS
() DISALLOWED_USER_AGENTS
() ALLOWED_INCLUDE_ROOTS
() DECIMAL_SEPARATOR
'.' SHORT_DATE_FORMAT
'm/d/Y' TEST_RUNNER 'django.test.simple.DjangoTestSuiteRunner' CACHE_MIDDLEWARE_KEYPREFIX u'******_' TIME_ZONE
'UTC' FILE_UPLOAD_MAX_MEMORY_SIZE 2621440 EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend' DEFAULT_TABLESPACE
'' TEMPLATE_CONTEXT_PROCESSORS ('django.contrib.auth.context_processors.auth', 'django.core.context_processors.debug', 'django.core.context_processors.i18n', 'django.core.context_processors.media', 'django.contrib.messages.context_processors.messages', 'django.core.context_processors.request') SESSION_COOKIE_AGE
1209600 SETTINGS_MODULE 'settings' USE_ETAGS
False LANGUAGES_BIDI
('he', 'ar', 'fa') FILE_UPLOAD_TEMP_DIR
None INTERNAL_IPS
() STATIC_URL
None EMAIL_PORT
25 USE_TZ
False SHORT_DATETIME_FORMAT
'm/d/Y P' PASSWORDHASHERS
u'******_' ABSOLUTE_URL_OVERRIDES
{} CACHE_MIDDLEWARE_SECONDS
600 DATETIME_INPUT_FORMATS
('%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M:%S.%f', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M:%S.%f', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M:%S.%f', '%m/%d/%y %H:%M', '%m/%d/%y') EMAIL_HOST_USER '' PROFANITIESLIST
u'*******' You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard 500 page.

Trac ticket #354 component gui priority major, owner melkins, created by randy on 2012-11-21T16:27:20Z, last modified 2012-11-22T02:17:25Z

dragonresearch / rpki.net

work0 (054, "Unknown column 'app_resourcecert.conf_id' in 'where clause'") #369