search

DDMAL / RodanClient-old

Client for DDMAL Rodan software suite
0 stars 0 forks source link

"session" login not working #23

Closed mrbannon closed 10 years ago

mrbannon commented 10 years ago

Since we got CORS running, session login isn't working. The response below is sent back.

Two things:

1 - I investigated and this also happens during 'token', but the authentication controller just seems to handle it better. 2 - The same error can be reproduced by attempting to access the 'Workflow' table in the rodan-dev admin.

I'm thinking that there are two errors here, but need to confirm with Ruth.

///////////////////

"ProgrammingError at /auth/session/ column rodan_workflow.valid does not exist LINE 1: ..._workflow"."runs", "rodan_workflow"."creator_id", "rodan_wor... ^

Request Method: POST Request URL: http://rodan-dev.simssa.ca/auth/session/ Django Version: 1.7c1 Python Executable: /home/rodan/rodan_env/bin/python Python Version: 2.7.6 Python Path: ['/srv/webapps/Rodan', '/home/rodan/rodan_env/bin', '/home/rodan/rodan_env/local/lib/python2.7/site-packages/pymei-2.0-py2.7-linux-x86_64.egg', '/srv/webapps/Rodan', '/home/rodan/Rodan', '/home/rodan/rodan_env/lib/python2.7', '/home/rodan/rodan_env/lib/python2.7/plat-x86_64-linux-gnu', '/home/rodan/rodan_env/lib/python2.7/lib-tk', '/home/rodan/rodan_env/lib/python2.7/lib-old', '/home/rodan/rodan_env/lib/python2.7/lib-dynload', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/home/rodan/rodan_env/local/lib/python2.7/site-packages', '/home/rodan/rodan_env/local/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg-info', '/home/rodan/rodan_env/lib/python2.7/site-packages/setuptools-0.6c11-py2.7.egg-info', '/home/rodan/Rodan'] Server time: Wed, 16 Jul 2014 19:16:13 -0400 Installed Applications: ('django.contrib.auth', 'django.contrib.admin', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'rodan', 'django_extensions', 'rest_framework', 'rest_framework.authtoken', 'guardian', 'corsheaders') Installed Middleware: ('corsheaders.middleware.CorsMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.gzip.GZipMiddleware')

Traceback: File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response

  1. response = wrapped_callback(request, _callback_args, *_callback_kwargs) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/views/generic/base.py" in view
  2. return self.dispatch(request, _args, *_kwargs) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
  3. return view_func(_args, *_kwargs) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/rest_framework/views.py" in dispatch
  4. response = self.handle_exception(exc) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/rest_framework/views.py" in dispatch
  5. response = handler(request, _args, *_kwargs) File "/srv/webapps/Rodan/rodan/views/auth.py" in post
  6. return Response(serializer.data) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/rest_framework/serializers.py" in data
  7. self._data = self.to_native(obj) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/rest_framework/serializers.py" in to_native
  8. value = field.field_to_native(obj, field_name) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/rest_framework/relations.py" in field_to_native
  9. return [self.to_native(item) for item in value.all()] File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/models/query.py" in iter
  10. self._fetch_all() File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all
  11. self._result_cache = list(self.iterator()) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/models/query.py" in iterator
  12. for row in compiler.results_iter(): File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in results_iter
  13. for rows in self.execute_sql(MULTI): File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
  14. cursor.execute(sql, params) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  15. return super(CursorDebugWrapper, self).execute(sql, params) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  16. return self.cursor.execute(sql, params) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/utils.py" in exit
  17. six.reraise(dj_exc_type, dj_exc_value, traceback) File "/home/rodan/rodan_env/local/lib/python2.7/site-packages/django/db/backends/utils.py" in execute
  18. return self.cursor.execute(sql, params)

Exception Type: ProgrammingError at /auth/session/ Exception Value: column rodan_workflow.valid does not exist LINE 1: ..._workflow"."runs", "rodan_workflow"."creator_id", "rodan_wor... ^

Request information: GET: No GET data

POST: username = u'mrbannon' password = **'

FILES: No FILES data

COOKIES: csrftoken = 'FrAM8Y6qCvTerj0C4hAJ9Fsw46W5LjqW'

META: CONTENT_LENGTH = '41' SERVER_PORT = '80' HTTP_X_REQUESTED_WITH = 'XMLHttpRequest' HTTP_ACCEPT = 'application/json' SERVER_PROTOCOL = 'HTTP/1.1' SERVER_SOFTWARE = 'gunicorn/18.0' SCRIPT_NAME = u'' HTTP_IF_MODIFIED_SINCE = 'Thu, 01 Jan 1970 00:00:00 GMT' wsgi.input = <gunicorn.http.body.Body object at 0x7f45f22a2f50> REQUEST_METHOD = 'POST' HTTP_HOST = 'rodan-dev.simssa.ca' PATH_INFO = u'/auth/session/' HTTP_ORIGIN = 'http://rodan-dev.simssa.ca' wsgi.multithread = False QUERY_STRING = '' HTTP_CONNECTION = 'close' HTTP_CACHE_CONTROL = 'no-cache' HTTP_X_REAL_IP = '132.206.14.212' HTTP_X_SCHEME = 'http' HTTP_USER_AGENT = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36' wsgi.version = HTTP_REFERER = 'http://rodan-dev.simssa.ca/client/index-debug.html' RAW_URI = '/auth/session/' REMOTE_ADDR = '132.206.14.212' wsgi.run_once = False wsgi.errors = <open file '', mode 'w' at 0x7f45fc3b51e0> wsgi.multiprocess = True HTTP_ACCEPT_LANGUAGE = 'en-US,en;q=0.8' REMOTE_PORT = '80' CSRF_COOKIE_USED = True wsgi.url_scheme = 'http' gunicorn.socket = <socket._socketobject object at 0x7f45f23a96e0> SERVER_NAME = 'rodan-dev.simssa.ca' CONTENT_TYPE = 'application/x-www-form-urlencoded' HTTP_X_FORWARDED_FOR = '132.206.14.212' wsgi.file_wrapper = '' CSRF_COOKIE = u'0l9RnqKPxBTxZDZJqs9LyFvTIXgxpyDg' HTTP_ACCEPT_ENCODING = 'gzip,deflate,sdch' HTTP_COOKIE = 'csrftoken=FrAM8Y6qCvTerj0C4hAJ9Fsw46W5LjqW'

Settings: Using settings module rodan.settings TRACEBACK_IN_ERROR_DETAIL = True USE_L10N = True USE_THOUSAND_SEPARATOR = False CSRF_COOKIE_SECURE = False LANGUAGE_CODE = 'en-us' ROOT_URLCONF = 'rodan.urls' MANAGERS = BROKER_URL = 'amqp://rodanuser:DDMALrodan@localhost:5672/DDMAL' IMAGE_TYPES = TEST_NON_SERIALIZED_APPS = [] DEFAULT_CHARSET = 'utf-8' SESSION_SERIALIZER = 'django.contrib.sessions.serializers.JSONSerializer' STATIC_ROOT = '' GREY16 = 2 ALLOWED_HOSTS = ['rodan-dev.simssa.ca'] MESSAGE_STORAGE = 'django.contrib.messages.storage.fallback.FallbackStorage' EMAIL_SUBJECT_PREFIX = '[Django] ' SEND_BROKEN_LINK_EMAILS = False STATICFILES_FINDERS = SESSION_CACHE_ALIAS = 'default' CELERY_IMPORTS = SESSION_COOKIE_DOMAIN = None SESSION_COOKIE_NAME = 'sessionid' ADMIN_FOR = TIME_INPUT_FORMATS = DATABASES = {'default': {'ENGINE': 'django.db.backends.postgresql_psycopg2', 'AUTOCOMMIT': True, 'ATOMIC_REQUESTS': False, 'NAME': 'rodan', 'CONN_MAX_AGE': 0, 'TIMEZONE': 'UTC', 'PORT': '5432', 'HOST': 'localhost', 'USER': 'rodan', 'TEST': {'COLLATION': None, 'CHARSET': None, 'NAME': None, 'MIRROR': None}, 'PASSWORD': u'***', 'OPTIONS': {}}} FILE_UPLOAD_DIRECTORY_PERMISSIONS = None FILE_UPLOAD_PERMISSIONS = None FILE_UPLOAD_HANDLERS = 'django.core.files.uploadhandler.TemporaryFileUploadHandler' DEFAULT_CONTENT_TYPE = 'text/html' APPEND_SLASH = True FIRST_DAY_OF_WEEK = 0 DATABASE_ROUTERS = [] DEFAULT_TABLESPACE = '' YEAR_MONTH_FORMAT = 'F Y' STATICFILES_STORAGE = 'django.contrib.staticfiles.storage.StaticFilesStorage' CACHES = {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} SERVER_EMAIL = 'root@localhost' CORS_EXPOSE_HEADERS = RGB = 3 COMPLEX = 5 MEDIUM_THUMBNAIL = 400 SILENCED_SYSTEM_CHECKS = [] MIDDLEWARE_CLASSES = USE_I18N = True THOUSAND_SEPARATOR = ',' SECRETKEY = u'******_' CORS_ORIGIN_WHITELIST = NONIMAGE = -1 DEFAULT_INDEX_TABLESPACE = '' TRANSACTIONS_MANAGED = False LOGGING_CONFIG = 'logging.config.dictConfig' TEMPLATE_LOADERS = WSGI_APPLICATION = None TEMPLATE_DEBUG = True X_FRAME_OPTIONS = 'SAMEORIGIN' CSRF_COOKIE_NAME = 'csrftoken' FORCE_SCRIPT_NAME = None USE_X_FORWARDED_HOST = False CORS_ALLOW_CREDENTIALS = True SIGNING_BACKEND = 'django.core.signing.TimestampSigner' SESSION_COOKIE_SECURE = False BASE_URL = 'http://rodan-dev.simssa.ca' CSRF_COOKIE_DOMAIN = None FILE_CHARSET = 'utf-8' DEBUG = True LANGUAGE_COOKIE_DOMAIN = None DEFAULT_FILE_STORAGE = 'django.core.files.storage.FileSystemStorage' INSTALLED_APPS = LANGUAGES_BIDI = COMMENTS_ALLOW_PROFANITIES = False STATICFILES_DIRS = PREPEND_WWW = False SECURE_PROXY_SSL_HEADER = None SMALL_THUMBNAIL = 150 LANGUAGE_COOKIE_AGE = None SESSION_COOKIE_HTTPONLY = True DEBUG_PROPAGATE_EXCEPTIONS = False CSRF_COOKIE_AGE = 31449600 JPEG2000 = 7 MONTH_DAY_FORMAT = 'F j' LOGIN_URL = '/accounts/login/' SESSION_EXPIRE_AT_BROWSER_CLOSE = False BACKUP_WORKFLOWRUN_ON_RETRY = True TIME_FORMAT = 'P' AUTH_USER_MODEL = 'auth.User' DATE_INPUT_FORMATS = AUTHENTICATION_BACKENDS = EMAIL_HOSTPASSWORD = u'******_' PASSWORD_RESET_TIMEOUTDAYS = u'******_' SESSION_FILE_PATH = None 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/' SESSION_COOKIE_PATH = '/' ONEBIT = 0 DECIMAL_SEPARATOR = '.' IGNORABLE_404_URLS = LOCALE_PATHS = SOLR_URL = 'http://rodan-dev.simssa.ca:8080/rodan-search-dev' TEMPLATE_STRING_IF_INVALID = '' LOGOUT_URL = '/accounts/logout/' EMAIL_USE_TLS = False THUMBNAIL_SIZES = FIXTURE_DIRS = EMAIL_HOST = 'localhost' DATE_FORMAT = 'N j, Y' PACKAGE = 8 IIP_URL = 'http://rodan-dev.simssa.ca/fcgi-bin/iipsrv.fcgi' MEDIA_ROOT = '/mnt/rodan/rodan-dev.simssa.ca/data' MEI = 6 DEFAULT_EXCEPTION_REPORTER_FILTER = 'django.views.debug.SafeExceptionReporterFilter' ADMINS = FORMAT_MODULE_PATH = None DEFAULT_FROM_EMAIL = 'webmaster@localhost' REST_FRAMEWORK = {'DEFAULT_AUTHENTICATION_CLASSES': ('rest_framework.authentication.TokenAuthentication', 'rest_framework.authentication.SessionAuthentication'), 'DEFAULT_RENDERER_CLASSES': ('rest_framework.renderers.JSONRenderer',), 'DEFAULT_FILTER_BACKENDS': ('rest_framework.filters.DjangoFilterBackend', 'rest_framework.filters.OrderingFilter'), 'PAGINATE_BY': 100, 'USE_ABSOLUTE_URLS': True} LARGE_THUMBNAIL = 1500 MEDIA_URL = 'http://rodan-dev.simssa.ca/data/' DATETIME_FORMAT = 'N j, Y, P' TEMPLATE_DIRS = SITE_ID = 1 DISALLOWED_USER_AGENTS = ALLOWED_INCLUDE_ROOTS = GREYSCALE = 1 LOGGING = {'loggers': {'django': {'handlers': ['console'], 'propagate': True, 'level': 'ERROR'}, 'django.request': {'handlers': ['console'], 'propagate': True, 'level': 'ERROR'}, 'rodan': {'handlers': ['file'], 'propagate': True, 'level': 'WARNING'}}, 'disable_existing_loggers': False, 'handlers': {'console': {'formatter': 'simple', 'class': 'logging.StreamHandler', 'level': 'DEBUG'}, 'file': {'level': 'DEBUG', 'formatter': 'verbose', 'class': 'logging.FileHandler', 'filename': 'rodan.log'}}, 'formatters': {'simple': {'format': '%(levelname)s %(message)s'}, 'verbose': {'datefmt': '%d/%b/%Y %H:%M:%S', 'format': '[%(asctime)s] %(levelname)s [%(name)s:%(lineno)s] %(message)s'}}, 'version': 1, 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}}} PROJECT_DIR = '/srv/webapps/Rodan/rodan' TEST_RUNNER = 'django.test.runner.DiscoverRunner' SHORT_DATE_FORMAT = 'm/d/Y' CACHE_MIDDLEWARE_KEYPREFIX = u'******_' TIME_ZONE = 'America/Montreal' CORS_ORIGIN_ALLOW_ALL = False FILE_UPLOAD_MAX_MEMORY_SIZE = 2621440 EMAIL_BACKEND = 'django.core.mail.backends.smtp.EmailBackend' CSRF_COOKIE_HTTPONLY = False LANGUAGE_COOKIE_NAME = 'django_language' EMAIL_USE_SSL = False TEMPLATE_CONTEXT_PROCESSORS = MIGRATION_MODULES = {} SESSION_COOKIE_AGE = 1209600 SETTINGS_MODULE = 'rodan.settings' USE_ETAGS = False CLASSIFIER_XML = 'salzinnes_demo_classifier.xml' LANGUAGES = FILE_UPLOAD_TEMP_DIR = None INTERNAL_IPS = STATIC_URL = '/static/' EMAIL_PORT = 25 USE_TZ = True SHORT_DATETIME_FORMAT = 'm/d/Y P' CELERY_RESULT_BACKEND = 'amqp' PASSWORDHASHERS = u'******_' ABSOLUTE_URL_OVERRIDES = {} LANGUAGE_COOKIE_PATH = '/' FLOAT = 4 GAMERA_XML = 9 THUMBNAIL_EXT = 'jpg' CACHE_MIDDLEWARE_SECONDS = 600 ANONYMOUS_USER_ID = -1 DATETIME_INPUT_FORMATS = 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. "

ahankinson commented 10 years ago

I edited this because there was a password in plaintext there...

This looks like there's a field missing (workflow.valid)

mrbannon commented 10 years ago

HA...thanks. Stupid me.

Anyways, the issue was resolved. Migrations were not being handled properly. We had to wipe the damn DB and then apply the migrations. I'm thinking this wasn't the proper way to go...this might be a django issue?