could not establish connection DETAIL: fe_sendauth: no password supplied
| Request Method: | GET |
|---|---|
| Request URL: | http://www.transparencia.eco.br:8001/pm0804/fornecedorselecionado/006270/ |
| Django Version: | 1.9 |
| Exception Type: | DatabaseError |
| Exception Value: | could not establish connection DETAIL: fe_sendauth: no password supplied |
| Exception Location: | /usr/lib/python3/dist-packages/psycopg2/extras.py in execute, line 123 |
| Python Executable: | /usr/bin/python3 |
| Python Version: | 3.4.3 |
| Python Path: | ['/var/www/transparencia', '/usr/lib/python3.4', '/usr/lib/python3.4/plat-x86_64-linux-gnu', '/usr/lib/python3.4/lib-dynload', '/usr/local/lib/python3.4/dist-packages', '/usr/lib/python3/dist-packages'] |
| Server time: | Qui, 18 Abr 2024 13:51:49 -0300 |
/usr/local/lib/python3.4/dist-packages/django/core/handlers/base.py in get_response
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs)
except Exception as e:
response = self.process_exception_by_middleware(e, request) ...# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
view_name = callback.__name__
else: # CBV
| Variable | Value |
|---|---|
| self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f575a7686d8> |
| urlconf | 'infotec.urls' |
| callback_kwargs | {'_idfornecedor': '006270'} |
| response_is_rendered | False |
| wrapped_callback | <function fornecedorselecionado at 0x7f574bd3d488> |
| response | None |
| callback | <function fornecedorselecionado at 0x7f574bd3d488> |
| resolver_match | ResolverMatch(func=transparencia.views.fornecedorselecionado, args=(), kwargs={'_idfornecedor': '006270'}, url_name=fornecedorselecionado, app_names=[], namespaces=[]) |
| middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f5750068ef0>> |
| request | <WSGIRequest: GET '/pm0804/fornecedorselecionado/006270/'> |
| callback_args | () |
| resolver | <RegexURLResolver 'infotec.urls' (None:None) ^/> |
/usr/local/lib/python3.4/dist-packages/django/core/handlers/base.py in get_response
response = middleware_method(request, callback, callback_args, callback_kwargs)
if response:
break
if response is None:
wrapped_callback = self.make_view_atomic(callback)
try:
response = wrapped_callback(request, *callback_args, **callback_kwargs) ...except Exception as e:
response = self.process_exception_by_middleware(e, request)
# Complain if the view returned None (a common error).
if response is None:
if isinstance(callback, types.FunctionType): # FBV
| Variable | Value |
|---|---|
| self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f575a7686d8> |
| urlconf | 'infotec.urls' |
| callback_kwargs | {'_idfornecedor': '006270'} |
| response_is_rendered | False |
| wrapped_callback | <function fornecedorselecionado at 0x7f574bd3d488> |
| response | None |
| callback | <function fornecedorselecionado at 0x7f574bd3d488> |
| resolver_match | ResolverMatch(func=transparencia.views.fornecedorselecionado, args=(), kwargs={'_idfornecedor': '006270'}, url_name=fornecedorselecionado, app_names=[], namespaces=[]) |
| middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f5750068ef0>> |
| request | <WSGIRequest: GET '/pm0804/fornecedorselecionado/006270/'> |
| callback_args | () |
| resolver | <RegexURLResolver 'infotec.urls' (None:None) ^/> |
/var/www/transparencia/transparencia/views.py in fornecedorselecionado
def fornecedorselecionado(request, _idfornecedor=0):
ler_config(request)
SQL = "select idpessoa,nmpessoa,coalesce(cpf,0) as cpf,coalesce(cnpj,0) as cnpj from view_pe_pessoas" \
" where idpessoa=" + str(_idfornecedor)
conn = psycopg2.connect(request.session['connectDB'])
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
cur.execute(SQL) ...lista = cur.fetchall()
novo = fornecedor()
for nome in lista:
novo.idpessoa = '{0:06}'.format(int(nome['idpessoa']))novo.nmpessoa = nome['nmpessoa']
| Variable | Value |
|---|---|
| SQL | ('select idpessoa,nmpessoa,coalesce(cpf,0) as cpf,coalesce(cnpj,0) as cnpj '
'from view_pe_pessoas where idpessoa=006270') |
| cur | <cursor object at 0x7f574b12faf0; closed: 0> |
| request | <WSGIRequest: GET '/pm0804/fornecedorselecionado/006270/'> |
| conn | <connection object at 0x7f574b108db0; dsn: 'host=localhost port=5432 dbname=infotec_2013_pm0804 user=postgres password=xxxxxxx', closed: 0> |
| _idfornecedor | '006270' |
/usr/lib/python3/dist-packages/psycopg2/extras.py in execute
kwargs['row_factory'] = DictRow
DictCursorBase.__init__(self, *args, **kwargs)
self._prefetch = 1
def execute(self, query, vars=None):
self.index = {}self._query_executed = 1
return _cursor.execute(self, query, vars) ...def callproc(self, procname, vars=None):
self.index = {}self._query_executed = 1
return _cursor.callproc(self, procname, vars)
| Variable | Value |
|---|---|
| vars | None |
| query | ('select idpessoa,nmpessoa,coalesce(cpf,0) as cpf,coalesce(cnpj,0) as cnpj '
'from view_pe_pessoas where idpessoa=006270') |
| self | <cursor object at 0x7f574b12faf0; closed: 0> |
No GET data
No POST data
No FILES data
No cookie data
| Variable | Value |
|---|---|
| mod_wsgi.script_reloading | '1' |
| SERVER_ADDR | '192.168.24.103' |
| REMOTE_PORT | '55448' |
| SCRIPT_NAME | '' |
| SERVER_ADMIN | 'infotec@infotecbg.com.br' |
| mod_wsgi.process_group | 'transparencia' |
| mod_wsgi.listener_host | '' |
| GATEWAY_INTERFACE | 'CGI/1.1' |
| wsgi.file_wrapper | '' |
| DOCUMENT_ROOT | '/var/www' |
| SERVER_SOFTWARE | 'Apache/2.4.7 (Ubuntu)' |
| CONTEXT_PREFIX | '' |
| mod_wsgi.listener_port | '8001' |
| mod_wsgi.input_chunked | '0' |
| mod_wsgi.callable_object | 'application' |
| REQUEST_URI | '/pm0804/fornecedorselecionado/006270/' |
| mod_wsgi.version | (3, 4) |
| wsgi.version | (1, 0) |
| QUERY_STRING | '' |
| mod_wsgi.request_handler | 'wsgi-script' |
| wsgi.errors | <_io.TextIOWrapper encoding='utf-8'> |
| PATH_TRANSLATED | '/var/www/transparencia/infotec/wsgi.py/pm0804/fornecedorselecionado/006270/' |
| HTTP_ACCEPT | '*/*' |
| REQUEST_SCHEME | 'http' |
| PATH_INFO | '/pm0804/fornecedorselecionado/006270/' |
| wsgi.input | <mod_wsgi.Input object at 0x7f574afbbf30> |
| HTTP_HOST | 'www.transparencia.eco.br:8001' |
| mod_wsgi.application_group | 'transparencia.eco.br:8001|' |
| REMOTE_ADDR | '18.221.41.214' |
| SERVER_PROTOCOL | 'HTTP/1.1' |
| wsgi.multithread | True |
| wsgi.url_scheme | 'http' |
| REQUEST_METHOD | 'GET' |
| mod_wsgi.handler_script | '' |
| mod_wsgi.queue_start | '1713459109263002' |
| SERVER_PORT | '8001' |
| SERVER_NAME | 'www.transparencia.eco.br' |
| SERVER_SIGNATURE | ('<address>Apache/2.4.7 (Ubuntu) Server at www.transparencia.eco.br Port '
'8001</address>\n') |
| mod_wsgi.enable_sendfile | '0' |
| SCRIPT_FILENAME | '/var/www/transparencia/infotec/wsgi.py' |
| wsgi.multiprocess | False |
| wsgi.run_once | False |
| CONTEXT_DOCUMENT_ROOT | '/var/www' |
| HTTP_USER_AGENT | 'claudebot' |
| HTTP_REFERER | 'http://www.transparencia.eco.br:8001/pm0804/fornecedorselecionado/006270' |
infotec.settings| Setting | Value |
|---|---|
| FILE_UPLOAD_TEMP_DIR | None |
| SESSION_COOKIE_PATH | '/' |
| EMAIL_SUBJECT_PREFIX | '[Django] ' |
| FILE_UPLOAD_PERMISSIONS | None |
| LOGIN_REDIRECT_URL | '/accounts/profile/' |
| SESSION_COOKIE_NAME | 'sessionid' |
| USE_I18N | True |
| LOCALE_PATHS | [] |
| TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
| TEMPLATE_CONTEXT_PROCESSORS | ['django.contrib.auth.context_processors.auth', 'django.template.context_processors.debug', 'django.template.context_processors.i18n', 'django.template.context_processors.media', 'django.template.context_processors.static', 'django.template.context_processors.tz', 'django.contrib.messages.context_processors.messages'] |
| CSRF_COOKIE_HTTPONLY | False |
| SECURE_REDIRECT_EXEMPT | [] |
| LANGUAGE_COOKIE_PATH | '/' |
| CSRF_COOKIE_NAME | 'csrftoken' |
| CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
| SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
| USE_THOUSAND_SEPARATOR | True |
| PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
| FILE_CHARSET | 'utf-8' |
| LANGUAGE_CODE | 'pt-br' |
| CSRF_COOKIE_PATH | '/' |
| DEFAULT_CHARSET | 'utf-8' |
| FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
| INSTALLED_APPS | ('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'bootstrap3',
'crispy_forms',
'transparencia',
'olerite',
'infotec') |
| MEDIA_ROOT | '/var/www/transparencia/media' |
| TIME_ZONE | 'America/Sao_Paulo' |
| STATICFILES_DIRS | [] |
| SESSION_FILE_PATH | None |
| SECURE_BROWSER_XSS_FILTER | False |
| SILENCED_SYSTEM_CHECKS | [] |
| SESSION_COOKIE_DOMAIN | None |
| STATIC_URL | '/static/' |
| DISALLOWED_USER_AGENTS | [] |
| CSRF_COOKIE_DOMAIN | None |
| TIME_FORMAT | 'P' |
| MIDDLEWARE_CLASSES | ('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.security.SecurityMiddleware') |
| USE_X_FORWARDED_PORT | False |
| AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
| SESSION_COOKIE_AGE | 1209600 |
| 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'] |
| LANGUAGE_COOKIE_DOMAIN | None |
| ALLOWED_HOSTS | ['*'] |
| EMAIL_HOST_USER | '' |
| CACHE_MIDDLEWARE_SECONDS | 600 |
| SECURE_CONTENT_TYPE_NOSNIFF | False |
| CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
| ABSOLUTE_URL_OVERRIDES | {} |
| SECURE_SSL_HOST | None |
| LANGUAGE_COOKIE_NAME | 'django_language' |
| SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
| SECURE_SSL_REDIRECT | False |
| PREPEND_WWW | False |
| ROOT_URLCONF | 'infotec.urls' |
| TEMPLATE_DIRS | [] |
| TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
| MANAGERS | [] |
| CSRF_TRUSTED_ORIGINS | [] |
| ADMINS | [] |
| MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
| TEMPLATES | [{'APP_DIRS': True,
'BACKEND': 'django.template.backends.django.DjangoTemplates',
'DIRS': ['/var/www/transparencia/infotec/templates'],
'OPTIONS': {'context_processors': ['django.template.context_processors.debug',
'django.template.context_processors.request',
'django.contrib.auth.context_processors.auth',
'django.contrib.messages.context_processors.messages']}}] |
| CRISPY_TEMPLATE_PACK | 'bootstrap3' |
| SECURE_PROXY_SSL_HEADER | None |
| SECRET_KEY | '********************' |
| SESSION_SAVE_EVERY_REQUEST | False |
| STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
| DECIMAL_SEPARATOR | '.' |
| THOUSAND_SEPARATOR | ',' |
| FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
| USE_TZ | True |
| CACHE_MIDDLEWARE_ALIAS | 'default' |
| MONTH_DAY_FORMAT | 'F j' |
| APPEND_SLASH | True |
| YEAR_MONTH_FORMAT | 'F Y' |
| FORCE_SCRIPT_NAME | None |
| FIXTURE_DIRS | [] |
| 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'] |
| LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
| EMAIL_PORT | 25 |
| LOGGING_CONFIG | 'logging.config.dictConfig' |
| SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
| ALLOWED_INCLUDE_ROOTS | [] |
| TEMPLATE_DEBUG | False |
| DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
| CSRF_COOKIE_AGE | 31449600 |
| EMAIL_TIMEOUT | None |
| SHORT_DATETIME_FORMAT | 'm/d/Y P' |
| SECURE_HSTS_SECONDS | 0 |
| DATE_FORMAT | 'N j, Y' |
| EMAIL_SSL_KEYFILE | '********************' |
| WSGI_APPLICATION | 'infotec.wsgi.application' |
| LANGUAGE_COOKIE_AGE | None |
| CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
| STATIC_ROOT | None |
| SETTINGS_MODULE | 'infotec.settings' |
| EMAIL_HOST | 'localhost' |
| USE_ETAGS | False |
| SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
| FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
| MEDIA_URL | '/media/' |
| EMAIL_SSL_CERTFILE | None |
| DEFAULT_INDEX_TABLESPACE | '' |
| SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
| LOGGING | {} |
| SESSION_CACHE_ALIAS | 'default' |
| CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
| MIGRATION_MODULES | {} |
| LANGUAGES | [('af', 'Afrikaans'),
('ar', 'Arabic'),
('ast', 'Asturian'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'),
('be', 'Belarusian'),
('bn', 'Bengali'),
('br', 'Breton'),
('bs', 'Bosnian'),
('ca', 'Catalan'),
('cs', 'Czech'),
('cy', 'Welsh'),
('da', 'Danish'),
('de', 'German'),
('el', 'Greek'),
('en', 'English'),
('en-au', 'Australian English'),
('en-gb', 'British English'),
('eo', 'Esperanto'),
('es', 'Spanish'),
('es-ar', 'Argentinian Spanish'),
('es-co', 'Colombian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'),
('et', 'Estonian'),
('eu', 'Basque'),
('fa', 'Persian'),
('fi', 'Finnish'),
('fr', 'French'),
('fy', 'Frisian'),
('ga', 'Irish'),
('gd', 'Scottish Gaelic'),
('gl', 'Galician'),
('he', 'Hebrew'),
('hi', 'Hindi'),
('hr', 'Croatian'),
('hu', 'Hungarian'),
('ia', 'Interlingua'),
('id', 'Indonesian'),
('io', 'Ido'),
('is', 'Icelandic'),
('it', 'Italian'),
('ja', 'Japanese'),
('ka', 'Georgian'),
('kk', 'Kazakh'),
('km', 'Khmer'),
('kn', 'Kannada'),
('ko', 'Korean'),
('lb', 'Luxembourgish'),
('lt', 'Lithuanian'),
('lv', 'Latvian'),
('mk', 'Macedonian'),
('ml', 'Malayalam'),
('mn', 'Mongolian'),
('mr', 'Marathi'),
('my', 'Burmese'),
('nb', 'Norwegian Bokmal'),
('ne', 'Nepali'),
('nl', 'Dutch'),
('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'),
('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'),
('udm', 'Udmurt'),
('uk', 'Ukrainian'),
('ur', 'Urdu'),
('vi', 'Vietnamese'),
('zh-hans', 'Simplified Chinese'),
('zh-hant', 'Traditional Chinese')] |
| EMAIL_HOST_PASSWORD | '********************' |
| SERVER_EMAIL | 'root@localhost' |
| DATABASES | {'default': {'ATOMIC_REQUESTS': False,
'AUTOCOMMIT': True,
'CONN_MAX_AGE': 0,
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'HOST': 'localhost',
'NAME': 'transp_site',
'OPTIONS': {},
'PASSWORD': '********************',
'PORT': '5432',
'TEST': {'CHARSET': None,
'COLLATION': None,
'MIRROR': None,
'NAME': None},
'TIME_ZONE': None,
'USER': 'postgres'}} |
| FORMAT_MODULE_PATH | None |
| EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
| INTERNAL_IPS | [] |
| DATABASE_ROUTERS | [] |
| DATETIME_FORMAT | 'N j, Y, P' |
| CSRF_COOKIE_SECURE | False |
| DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
| AUTH_USER_MODEL | 'auth.User' |
| DEFAULT_TABLESPACE | '' |
| IGNORABLE_404_URLS | [] |
| STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
| LOGIN_URL | '/accounts/login/' |
| SHORT_DATE_FORMAT | 'm/d/Y' |
| TEST_NON_SERIALIZED_APPS | [] |
| DEBUG_PROPAGATE_EXCEPTIONS | False |
| SESSION_COOKIE_SECURE | False |
| USE_X_FORWARDED_HOST | False |
| PASSWORD_HASHERS | '********************' |
| EMAIL_USE_TLS | False |
| DEFAULT_CONTENT_TYPE | 'text/html' |
| USE_L10N | True |
| TEMPLATE_LOADERS | ['django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader'] |
| BASE_DIR | '/var/www/transparencia' |
| FIRST_DAY_OF_WEEK | 0 |
| NUMBER_GROUPING | 0 |
| LOGOUT_URL | '/accounts/logout/' |
| EMAIL_USE_SSL | False |
| TEMPLATE_STRING_IF_INVALID | '' |
| X_FRAME_OPTIONS | 'SAMEORIGIN' |
| AUTH_PASSWORD_VALIDATORS | '********************' |
| DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
| DEBUG | True |
| SESSION_COOKIE_HTTPONLY | True |
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 page generated by the handler for this status code.