OperationalError at /cambiemosdeactitud/

(com_error(-2147352567, 'Exception occurred.', (0, u'Microsoft SQL Server Native Client 10.0', u"Login failed for user 'usercambiemos'.  Reason: The password of the account has expired.", None, 0, -2147467259), None), u'Error opening connection: DATA SOURCE=MTC-DVDBSQL01;Initial Catalog=DB_CAMBIEMOS2;UID=usercambiemos;PWD=******;PROVIDER=sqlncli10;DataTypeCompatibility=80;MARS Connection=True')
Request Method: GET
Request URL: http://portaldesa.mtc.gob.pe/cambiemosdeactitud/?page=9
Django Version: 1.7.8
Exception Type: OperationalError
Exception Value:
(com_error(-2147352567, 'Exception occurred.', (0, u'Microsoft SQL Server Native Client 10.0', u"Login failed for user 'usercambiemos'.  Reason: The password of the account has expired.", None, 0, -2147467259), None), u'Error opening connection: DATA SOURCE=MTC-DVDBSQL01;Initial Catalog=DB_CAMBIEMOS2;UID=usercambiemos;PWD=******;PROVIDER=sqlncli10;DataTypeCompatibility=80;MARS Connection=True')
Exception Location: C:\Python27\lib\site-packages\sqlserver_ado\dbapi.py in connect, line 196
Python Executable: C:\Python27\python.exe
Python Version: 2.7.10
Python Path:
['.',
 'C:\\Python27\\lib\\site-packages\\tzlocal-1.2-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\django_treebeard-3.0-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\django_appmedia-1.0.1-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\django_select2-4.3.0-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\djangocms_link-1.6.2-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\djangocms_style-1.5-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\html5lib-0.95-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\sqlparse-0.1.15-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\django_youtube-0.2-py2.7.egg',
 'C:\\Python27\\lib\\site-packages\\pywin32-219-py2.7-win32.egg',
 'C:\\inetpub\\wwwroot\\cambiemosdeactitud',
 'C:\\Windows\\system32\\python27.zip',
 'C:\\Python27\\DLLs',
 'C:\\Python27\\lib',
 'C:\\Python27\\lib\\plat-win',
 'C:\\Python27\\lib\\lib-tk',
 'C:\\Python27',
 'C:\\Python27\\lib\\site-packages']
Server time: Jue, 28 Mar 2024 05:01:20 -0500

Traceback Switch to copy-and-paste view



Request information

GET

Variable Value
page
u'9'

POST

No POST data

FILES

No FILES data

No cookie data

META

Variable Value
AUTH_TYPE
''
wfastcgi.http_x_original_url
'/cambiemosdeactitud/?page=9'
wsgi.multiprocess
True
HTTPS_SERVER_ISSUER
''
HTTP_MAX_FORWARDS
'10'
HTTPS_KEYSIZE
''
wsgi.multithread
False
SERVER_SOFTWARE
'Microsoft-IIS/7.5'
SCRIPT_NAME
u''
LOCAL_ADDR
'192.168.251.84'
QUERY_STRING
'page=9'
REQUEST_METHOD
'GET'
REMOTE_USER
''
PATH_INFO
u'/cambiemosdeactitud/'
SERVER_PROTOCOL
'HTTP/1.1'
CERT_COOKIE
''
wsgi.query_string
'page=9'
AUTH_PASSWORD
''
CONTENT_LENGTH
'0'
IIS_UrlRewriteModule
'7.1.1952.0'
HTTP_USER_AGENT
'claudebot'
HTTP_CONNECTION
'Keep-Alive'
SERVER_NAME
'portaldesa.mtc.gob.pe'
REMOTE_ADDR
'172.20.1.38'
APPL_MD_PATH
'/LM/W3SVC/2/ROOT'
INSTANCE_ID
'2'
URL
'/cambiemosdeactitud/'
APP_POOL_ID
'PORTAL'
SERVER_PORT
'80'
APPL_PHYSICAL_PATH
'D:\\nuevoportal\\nuevo\\'
REQUEST_URI
'/cambiemosdeactitud/?page=9'
CERT_SERIALNUMBER
''
CERT_FLAGS
''
HTTPS_SERVER_SUBJECT
''
wsgi.script_name
''
HTTP_X_ORIGINAL_URL
'/cambiemosdeactitud/?page=9'
SCRIPT_FILENAME
'C:\\inetpub\\wwwroot\\cambiemosdeactitud\\'
HTTPS_SECRETKEYSIZE
''
wsgi.path_info
'/cambiemosdeactitud/'
wsgi.input
<cStringIO.StringI object at 0x00ED73C8>
HTTP_X_ARR_LOG_ID
'd8650cd5-5638-4e62-8411-2d2df667217a'
HTTP_HOST
'portaldesa.mtc.gob.pe'
wsgi.run_once
False
HTTPS
'off'
SERVER_PORT_SECURE
'0'
CERT_SUBJECT
''
CERT_ISSUER
''
HTTP_ACCEPT
'*/*'
PATH_TRANSLATED
'C:\\inetpub\\wwwroot\\cambiemosdeactitud\\'
wsgi.version
(1, 0)
GATEWAY_INTERFACE
'CGI/1.1'
APP_POOL_CONFIG
'C:\\inetpub\\temp\\apppools\\PORTAL\\PORTAL.config'
wsgi.errors
<cStringIO.StringO object at 0x00F032A0>
REMOTE_PORT
'53066'
LOGON_USER
''
INSTANCE_NAME
'DESARROLLO DEL PORTAL DEL MTC'
HTTP_X_FORWARDED_FOR
'44.222.116.199:47724'
CONTENT_TYPE
''
INSTANCE_META_PATH
'/LM/W3SVC/2'
AUTH_USER
''
DOCUMENT_ROOT
'D:\\nuevoportal\\nuevo'
REMOTE_HOST
'172.20.1.38'
wsgi.url_scheme
'http'

Settings

Using settings module project.settings_iis

Setting Value
CLOSE_TIME
'2016-01-15 14:56:00'
USE_L10N
True
TIME_ZONE
'America/Lima'
CSRF_COOKIE_SECURE
False
LANGUAGE_CODE
'es'
ROOT_URLCONF
'project.urls'
MANAGERS
()
YOUTUBE_DEVELOPER_KEY
u'********************'
BASE_DIR
'C:\\inetpub\\wwwroot\\cambiemosdeactitud'
TEST_NON_SERIALIZED_APPS
[]
DEFAULT_CHARSET
'utf-8'
THUMBS_SIZES
((232, 158), (250, 250))
SESSION_SERIALIZER
'django.contrib.sessions.serializers.JSONSerializer'
STATIC_ROOT
'C:\\inetpub\\wwwroot\\cambiemosdeactitud\\static'
USE_THOUSAND_SEPARATOR
False
CONTENT_TYPES
['image', 'video']
ALLOWED_HOSTS
['*']
YOUTUBE_DELETE_REDIRECT_URL
'/cambiemosdeactitud/participantes-rechazados/'
MESSAGE_STORAGE
'django.contrib.messages.storage.fallback.FallbackStorage'
EMAIL_SUBJECT_PREFIX
'[Django] '
SEND_BROKEN_LINK_EMAILS
False
RANDOM_EXPERIENCES
5
STATICFILES_FINDERS
('django.contrib.staticfiles.finders.FileSystemFinder',
 'django.contrib.staticfiles.finders.AppDirectoriesFinder')
SESSION_CACHE_ALIAS
'default'
SESSION_COOKIE_DOMAIN
None
SESSION_COOKIE_NAME
'sessionid'
ADMIN_FOR
()
TIME_INPUT_FORMATS
('%H:%M:%S', '%H:%M:%S.%f', '%H:%M')
DATABASES
{'default': {'ATOMIC_REQUESTS': False,
             'AUTOCOMMIT': True,
             'CONN_MAX_AGE': 0,
             'ENGINE': 'sqlserver_ado',
             'HOST': 'MTC-DVDBSQL01',
             'NAME': 'DB_CAMBIEMOS2',
             'OPTIONS': {u'provider': u'sqlncli10'},
             'PASSWORD': u'********************',
             'PORT': '',
             'TEST': {'CHARSET': None,
                      'COLLATION': None,
                      'MIRROR': None,
                      'NAME': None},
             'TIME_ZONE': 'UTC',
             'USER': 'usercambiemos'}}
FILE_UPLOAD_DIRECTORY_PERMISSIONS
None
FILE_UPLOAD_PERMISSIONS
None
FILE_UPLOAD_HANDLERS
('django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler')
DEFAULT_CONTENT_TYPE
'text/html'
APPEND_SLASH
True
LOCALE_PATHS
()
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'}}
YOUTUBE_AUTH_EMAIL
'mtc.videos.oti@gmail.com'
SERVER_EMAIL
'root@localhost'
SESSION_COOKIE_PATH
'/'
SILENCED_SYSTEM_CHECKS
[]
CMS_TEMPLATES
(('template_1.html', 'Template One'), ('template_2.html', 'Template Two'))
MIDDLEWARE_CLASSES
('concursantes.middleware.ForceResponseMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'cms.middleware.user.CurrentUserMiddleware',
 'cms.middleware.page.CurrentPageMiddleware',
 'cms.middleware.toolbar.ToolbarMiddleware',
 'cms.middleware.language.LanguageCookieMiddleware',
 'secretballot.middleware.SecretBallotIpUseragentMiddleware')
USE_I18N
True
THOUSAND_SEPARATOR
','
SECRET_KEY
u'********************'
LANGUAGE_COOKIE_NAME
'django_language'
DEFAULT_INDEX_TABLESPACE
''
TRANSACTIONS_MANAGED
False
LOGGING_CONFIG
None
TEMPLATE_LOADERS
('django.template.loaders.filesystem.Loader',
 'django.template.loaders.app_directories.Loader')
FIRST_DAY_OF_WEEK
0
YOUTUBE_CLIENT_ID
'48208333156-9atp9r7a599d4kks4dsmgih3bkvhuork.apps.googleusercontent.com'
WSGI_APPLICATION
'project.wsgi.application'
TEMPLATE_DEBUG
True
X_FRAME_OPTIONS
'SAMEORIGIN'
CSRF_COOKIE_NAME
'csrftoken'
FORCE_SCRIPT_NAME
None
USE_X_FORWARDED_HOST
False
SIGNING_BACKEND
'django.core.signing.TimestampSigner'
SENDER_NAME
u'Cambiemos de Actitud'
SESSION_COOKIE_SECURE
False
CSRF_COOKIE_DOMAIN
None
FILE_CHARSET
'utf-8'
DEBUG
True
LANGUAGE_COOKIE_DOMAIN
None
DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage'
INSTALLED_APPS
('django.contrib.auth',
 'django.contrib.admin',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.staticfiles',
 'cms',
 'treebeard',
 'menus',
 'sekizai',
 'djangocms_admin_style',
 'django.contrib.messages',
 'reversion',
 'concursantes',
 'secretballot',
 'widget_tweaks',
 'django_youtube')
LANGUAGES
[('es', 'Spanish')]
COMMENTS_ALLOW_PROFANITIES
False
STATICFILES_DIRS
('C:\\inetpub\\wwwroot\\cambiemosdeactitud\\local_static',)
PREPEND_WWW
False
SECURE_PROXY_SSL_HEADER
None
LANGUAGE_COOKIE_AGE
None
SESSION_COOKIE_HTTPONLY
True
FACEBOOK_APP_ID
'832024756911136'
DEBUG_PROPAGATE_EXCEPTIONS
False
INTERNAL_IPS
()
MONTH_DAY_FORMAT
'F j'
LOGIN_URL
'/accounts/login/'
SESSION_EXPIRE_AT_BROWSER_CLOSE
False
MAX_DURATION_MINUTES
1
YOUTUBE_AUTH_PASSWORD
u'********************'
TIME_FORMAT
'P'
AUTH_USER_MODEL
'auth.User'
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')
AUTHENTICATION_BACKENDS
('django.contrib.auth.backends.ModelBackend',)
EMAIL_HOST_PASSWORD
u'********************'
PASSWORD_RESET_TIMEOUT_DAYS
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/'
DECIMAL_SEPARATOR
'.'
IGNORABLE_404_URLS
()
MIGRATION_MODULES
{}
TEMPLATE_STRING_IF_INVALID
''
LOGOUT_URL
'/accounts/logout/'
SENDER_EMAIL
'cambiemosdeactitud@mtc.gob.pe'
EMAIL_USE_TLS
False
TEMPLATE_DIRS
('C:\\inetpub\\wwwroot\\cambiemosdeactitud\\templates',)
FIXTURE_DIRS
()
EMAIL_HOST
'localhost'
DATE_FORMAT
'Y-m-d'
MEDIA_ROOT
'C:\\inetpub\\wwwroot\\cambiemosdeactitud\\media'
DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter'
ADMINS
()
FORMAT_MODULE_PATH
None
DEFAULT_FROM_EMAIL
'webmaster@localhost'
MEDIA_URL
'/media/'
DATETIME_FORMAT
'Y-m-d H:i:sO'
MAX_UPLOAD_SIZE
5242880
SITE_ID
1
DISALLOWED_USER_AGENTS
()
ALLOWED_INCLUDE_ROOTS
()
LOGGING
{'disable_existing_loggers': False,
 'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'},
             'require_debug_true': {'()': 'django.utils.log.RequireDebugTrue'}},
 'formatters': {'simple': {'datefmt': '%Y/%m/%d %H:%M:%S',
                           'format': '[%(asctime)s] %(levelname)s %(message)s'},
                'verbose': {'datefmt': '%Y/%m/%d %H:%M:%S',
                            'format': '[%(asctime)s] %(levelname)s [%(name)s.%(funcName)s.%(lineno)d] %(message)s'}},
 'handlers': {'console': {'class': 'logging.StreamHandler',
                          'filters': ['require_debug_true'],
                          'formatter': 'simple',
                          'level': 'DEBUG'},
              'development_log': {'class': 'logging.FileHandler',
                                  'filename': 'C:\\inetpub\\wwwroot\\cambiemosdeactitud\\logs/development.log',
                                  'filters': ['require_debug_true'],
                                  'formatter': 'verbose',
                                  'level': 'DEBUG'},
              'production_log': {'class': 'logging.FileHandler',
                                 'filename': 'C:\\inetpub\\wwwroot\\cambiemosdeactitud\\logs/production.log',
                                 'filters': ['require_debug_false'],
                                 'formatter': 'simple',
                                 'level': 'ERROR'}},
 'loggers': {'django': {'handlers': ['console',
                                     'development_log',
                                     'production_log']},
             'py.warnings': {'handlers': ['console', 'development_log']},
             'uploader': {'handlers': ['console',
                                       'development_log',
                                       'production_log']}},
 'version': 1}
SHORT_DATE_FORMAT
'm/d/Y'
YOUTUBE_UPLOAD_REDIRECT_URL
'/cambiemosdeactitud/participantes-aceptados/'
TEST_RUNNER
'django.test.runner.DiscoverRunner'
CACHE_MIDDLEWARE_KEY_PREFIX
u'********************'
SMTP_SERVER
'correo.mtc.gob.pe'
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend'
SENDER_PASSWORD
u'********************'
EMAIL_USE_SSL
False
TEMPLATE_CONTEXT_PROCESSORS
('django.contrib.auth.context_processors.auth',
 'django.contrib.messages.context_processors.messages',
 'django.core.context_processors.i18n',
 'django.core.context_processors.request',
 'django.core.context_processors.media',
 'django.core.context_processors.static',
 'sekizai.context_processors.sekizai',
 'cms.context_processors.cms_settings',
 'django.core.context_processors.csrf',
 'concursantes.context_processors.facebook_id_processor')
SESSION_COOKIE_AGE
1209600
SETTINGS_MODULE
'project.settings_iis'
USE_ETAGS
False
LANGUAGES_BIDI
('he', 'ar', 'fa', 'ur')
FILE_UPLOAD_TEMP_DIR
None
CSRF_COOKIE_AGE
31449600
STATIC_URL
'/static/'
EMAIL_PORT
25
USE_TZ
True
SHORT_DATETIME_FORMAT
'm/d/Y P'
PASSWORD_HASHERS
u'********************'
ABSOLUTE_URL_OVERRIDES
{}
LANGUAGE_COOKIE_PATH
'/'
CACHE_MIDDLEWARE_SECONDS
600
CSRF_COOKIE_HTTPONLY
False
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
''
PROFANITIES_LIST
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.