could not establish connection DETAIL: fe_sendauth: no password supplied
Request Method: | GET |
---|---|
Request URL: | http://www.transparencia.eco.br:8001/pm0437/listaFornecedor/ |
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: | Ter, 19 Mar 2024 08:20:05 -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 |
---|---|
urlconf | 'infotec.urls' |
callback_args | () |
callback_kwargs | {} |
response_is_rendered | False |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f051104eeb8>> |
callback | <function listaFornecedor at 0x7f0510d4c400> |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f05191b5ac8> |
resolver | <RegexURLResolver 'infotec.urls' (None:None) ^/> |
resolver_match | ResolverMatch(func=transparencia.views.listaFornecedor, args=(), kwargs={}, url_name=listaFornecedor, app_names=[], namespaces=[]) |
response | None |
wrapped_callback | <function listaFornecedor at 0x7f0510d4c400> |
request | <WSGIRequest: GET '/pm0437/listaFornecedor/'> |
/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 |
---|---|
urlconf | 'infotec.urls' |
callback_args | () |
callback_kwargs | {} |
response_is_rendered | False |
middleware_method | <bound method CsrfViewMiddleware.process_view of <django.middleware.csrf.CsrfViewMiddleware object at 0x7f051104eeb8>> |
callback | <function listaFornecedor at 0x7f0510d4c400> |
self | <django.core.handlers.wsgi.WSGIHandler object at 0x7f05191b5ac8> |
resolver | <RegexURLResolver 'infotec.urls' (None:None) ^/> |
resolver_match | ResolverMatch(func=transparencia.views.listaFornecedor, args=(), kwargs={}, url_name=listaFornecedor, app_names=[], namespaces=[]) |
response | None |
wrapped_callback | <function listaFornecedor at 0x7f0510d4c400> |
request | <WSGIRequest: GET '/pm0437/listaFornecedor/'> |
/var/www/transparencia/transparencia/views.py
in listaFornecedor
SQL += " group by vi.idpessoa, vi.nmpessoa, vi.cpf, vi.cnpj"
SQL += " having max(ano)> ( DATE_PART('YEAR', CURRENT_TIMESTAMP)-10)"
SQL += " order by 2"
#SQL += " limit 10"
conn = psycopg2.connect(request.session['connectDB'])
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
cur.execute(SQL)...
lista = cur.fetchall()
cur.close()
conn.close()
form = FormPesquisaCredor()
Variable | Value |
---|---|
pesq | '' |
SQL | ("select trim(to_char(idpessoa,'000000')) as idpessoa,nmpessoa,(case " "coalesce(cpf,0) when 0 then '' else " "substr(trim(to_char(cpf,'00000000000')), 1, 3) || '.' || " "substr(trim(to_char(cpf,'00000000000')), 4, 3) || '.' || " "substr(trim(to_char(cpf,'00000000000')), 7, 3) || '-' || " "substr(trim(to_char(cpf,'00000000000')), 10) end) as cpf,(case " "coalesce(cnpj,0) when 0 then '' else " "substr(trim(to_char(cnpj,'00000000000000')), 1, 2) || '.' || " "substr(trim(to_char(cnpj,'00000000000000')), 3, 3) || '.' || " "substr(trim(to_char(cnpj,'00000000000000')), 6, 3) || '/' || " "substr(trim(to_char(cnpj,'00000000000000')), 9, 4) || '-' || " "substr(trim(to_char(cnpj,'00000000000000')), 13) end) as cnpj,array(select " 'ano from co_empenho as em where em.idfornecedor=vi.idpessoa group by ano ' "having max(ano) > ( DATE_PART('YEAR', CURRENT_TIMESTAMP)-10) order by 1) " 'as anos from view_pe_pessoas as vi inner join co_empenho as fm on ' 'fm.idfornecedor = vi.idpessoa where vi.idpessoa not in (999999,999998) ' 'group by vi.idpessoa, vi.nmpessoa, vi.cpf, vi.cnpj having max(ano)> ( ' "DATE_PART('YEAR', CURRENT_TIMESTAMP)-10) order by 2") |
pagina | 1 |
request | <WSGIRequest: GET '/pm0437/listaFornecedor/'> |
cur | <cursor object at 0x7f0506f16808; closed: 0> |
conn | <connection object at 0x7f0506aee150; dsn: 'host=localhost port=5432 dbname=infotec_2013_pm0437 user=postgres password=xxxxxxx', closed: 0> |
/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 |
self | <cursor object at 0x7f0506f16808; closed: 0> |
query | ("select trim(to_char(idpessoa,'000000')) as idpessoa,nmpessoa,(case " "coalesce(cpf,0) when 0 then '' else " "substr(trim(to_char(cpf,'00000000000')), 1, 3) || '.' || " "substr(trim(to_char(cpf,'00000000000')), 4, 3) || '.' || " "substr(trim(to_char(cpf,'00000000000')), 7, 3) || '-' || " "substr(trim(to_char(cpf,'00000000000')), 10) end) as cpf,(case " "coalesce(cnpj,0) when 0 then '' else " "substr(trim(to_char(cnpj,'00000000000000')), 1, 2) || '.' || " "substr(trim(to_char(cnpj,'00000000000000')), 3, 3) || '.' || " "substr(trim(to_char(cnpj,'00000000000000')), 6, 3) || '/' || " "substr(trim(to_char(cnpj,'00000000000000')), 9, 4) || '-' || " "substr(trim(to_char(cnpj,'00000000000000')), 13) end) as cnpj,array(select " 'ano from co_empenho as em where em.idfornecedor=vi.idpessoa group by ano ' "having max(ano) > ( DATE_PART('YEAR', CURRENT_TIMESTAMP)-10) order by 1) " 'as anos from view_pe_pessoas as vi inner join co_empenho as fm on ' 'fm.idfornecedor = vi.idpessoa where vi.idpessoa not in (999999,999998) ' 'group by vi.idpessoa, vi.nmpessoa, vi.cpf, vi.cnpj having max(ano)> ( ' "DATE_PART('YEAR', CURRENT_TIMESTAMP)-10) order by 2") |
No GET data
No POST data
No FILES data
No cookie data
Variable | Value |
---|---|
mod_wsgi.handler_script | '' |
SERVER_ADMIN | 'infotec@infotecbg.com.br' |
HTTP_USER_AGENT | 'claudebot' |
CONTEXT_PREFIX | '' |
mod_wsgi.application_group | 'transparencia.eco.br:8001|' |
wsgi.run_once | False |
wsgi.version | (1, 0) |
CONTEXT_DOCUMENT_ROOT | '/var/www' |
mod_wsgi.script_reloading | '1' |
SERVER_ADDR | '192.168.24.103' |
wsgi.errors | <_io.TextIOWrapper encoding='utf-8'> |
SERVER_PROTOCOL | 'HTTP/1.1' |
DOCUMENT_ROOT | '/var/www' |
PATH_INFO | '/pm0437/listaFornecedor/' |
PATH_TRANSLATED | '/var/www/transparencia/infotec/wsgi.py/pm0437/listaFornecedor/' |
mod_wsgi.listener_host | '' |
SERVER_SOFTWARE | 'Apache/2.4.7 (Ubuntu)' |
mod_wsgi.listener_port | '8001' |
wsgi.multiprocess | False |
mod_wsgi.version | (3, 4) |
GATEWAY_INTERFACE | 'CGI/1.1' |
REQUEST_METHOD | 'GET' |
SERVER_NAME | 'www.transparencia.eco.br' |
mod_wsgi.queue_start | '1710847203037946' |
mod_wsgi.request_handler | 'wsgi-script' |
mod_wsgi.input_chunked | '0' |
SERVER_SIGNATURE | ('<address>Apache/2.4.7 (Ubuntu) Server at www.transparencia.eco.br Port ' '8001</address>\n') |
REQUEST_SCHEME | 'http' |
SCRIPT_NAME | '' |
wsgi.url_scheme | 'http' |
mod_wsgi.callable_object | 'application' |
SERVER_PORT | '8001' |
wsgi.multithread | True |
SCRIPT_FILENAME | '/var/www/transparencia/infotec/wsgi.py' |
REMOTE_PORT | '34260' |
REMOTE_ADDR | '54.157.61.194' |
wsgi.file_wrapper | '' |
HTTP_HOST | 'www.transparencia.eco.br:8001' |
QUERY_STRING | '' |
mod_wsgi.process_group | 'transparencia' |
wsgi.input | <mod_wsgi.Input object at 0x7f0506b5fab0> |
HTTP_ACCEPT | '*/*' |
REQUEST_URI | '/pm0437/listaFornecedor/' |
mod_wsgi.enable_sendfile | '0' |
infotec.settings
Setting | Value |
---|---|
EMAIL_USE_SSL | False |
LANGUAGE_CODE | 'pt-br' |
TEMPLATE_LOADERS | ['django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader'] |
ALLOWED_INCLUDE_ROOTS | [] |
SECURE_HSTS_SECONDS | 0 |
EMAIL_SSL_CERTFILE | None |
SESSION_CACHE_ALIAS | 'default' |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
EMAIL_HOST_PASSWORD | '********************' |
LOGIN_URL | '/accounts/login/' |
USE_X_FORWARDED_PORT | False |
CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
EMAIL_SUBJECT_PREFIX | '[Django] ' |
EMAIL_HOST_USER | '' |
SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
FILE_CHARSET | 'utf-8' |
SHORT_DATE_FORMAT | 'm/d/Y' |
LANGUAGE_COOKIE_DOMAIN | None |
ALLOWED_HOSTS | ['*'] |
DATE_FORMAT | 'N j, Y' |
X_FRAME_OPTIONS | 'SAMEORIGIN' |
PASSWORD_HASHERS | '********************' |
CSRF_TRUSTED_ORIGINS | [] |
CACHE_MIDDLEWARE_SECONDS | 600 |
DISALLOWED_USER_AGENTS | [] |
CSRF_COOKIE_NAME | 'csrftoken' |
EMAIL_HOST | 'localhost' |
DEFAULT_TABLESPACE | '' |
LOGIN_REDIRECT_URL | '/accounts/profile/' |
SESSION_COOKIE_DOMAIN | None |
TEMPLATE_DIRS | [] |
EMAIL_USE_TLS | False |
AUTH_PASSWORD_VALIDATORS | '********************' |
USE_TZ | True |
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'] |
AUTH_USER_MODEL | 'auth.User' |
FORMAT_MODULE_PATH | None |
DEBUG_PROPAGATE_EXCEPTIONS | False |
ADMINS | [] |
TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
SERVER_EMAIL | 'root@localhost' |
LOGGING | {} |
TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
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'] |
MONTH_DAY_FORMAT | 'F j' |
USE_ETAGS | False |
CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
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']}}] |
CSRF_COOKIE_DOMAIN | None |
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')] |
DEFAULT_INDEX_TABLESPACE | '' |
FILE_UPLOAD_TEMP_DIR | None |
MEDIA_ROOT | '/var/www/transparencia/media' |
THOUSAND_SEPARATOR | ',' |
DEBUG | True |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
USE_L10N | True |
WSGI_APPLICATION | 'infotec.wsgi.application' |
SESSION_COOKIE_NAME | 'sessionid' |
INTERNAL_IPS | [] |
CSRF_COOKIE_AGE | 31449600 |
SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
DEFAULT_CONTENT_TYPE | 'text/html' |
LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
FILE_UPLOAD_PERMISSIONS | None |
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'] |
TEST_NON_SERIALIZED_APPS | [] |
NUMBER_GROUPING | 0 |
SECURE_PROXY_SSL_HEADER | None |
SECURE_SSL_REDIRECT | False |
SECURE_REDIRECT_EXEMPT | [] |
SESSION_COOKIE_PATH | '/' |
TEMPLATE_STRING_IF_INVALID | '' |
DEFAULT_CHARSET | 'utf-8' |
SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
MEDIA_URL | '/media/' |
STATIC_URL | '/static/' |
FORCE_SCRIPT_NAME | None |
SESSION_COOKIE_HTTPONLY | True |
DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
PASSWORD_RESET_TIMEOUT_DAYS | '********************' |
CACHE_MIDDLEWARE_KEY_PREFIX | '********************' |
DECIMAL_SEPARATOR | '.' |
LOGGING_CONFIG | 'logging.config.dictConfig' |
STATIC_ROOT | None |
AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
FIRST_DAY_OF_WEEK | 0 |
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') |
USE_X_FORWARDED_HOST | False |
APPEND_SLASH | True |
SESSION_FILE_PATH | None |
LANGUAGE_COOKIE_PATH | '/' |
FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
EMAIL_SSL_KEYFILE | '********************' |
CSRF_COOKIE_HTTPONLY | False |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
SECURE_SSL_HOST | None |
ABSOLUTE_URL_OVERRIDES | {} |
USE_I18N | True |
USE_THOUSAND_SEPARATOR | True |
SESSION_SAVE_EVERY_REQUEST | False |
MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
SILENCED_SYSTEM_CHECKS | [] |
SESSION_COOKIE_SECURE | False |
SETTINGS_MODULE | 'infotec.settings' |
FIXTURE_DIRS | [] |
SECURE_BROWSER_XSS_FILTER | False |
ROOT_URLCONF | 'infotec.urls' |
SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
DATABASE_ROUTERS | [] |
TEMPLATE_DEBUG | False |
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'}} |
SESSION_COOKIE_AGE | 1209600 |
CACHE_MIDDLEWARE_ALIAS | 'default' |
FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
STATICFILES_DIRS | [] |
MIGRATION_MODULES | {} |
YEAR_MONTH_FORMAT | 'F Y' |
DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
SECURE_CONTENT_TYPE_NOSNIFF | False |
DATETIME_FORMAT | 'N j, Y, P' |
CSRF_COOKIE_PATH | '/' |
BASE_DIR | '/var/www/transparencia' |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
TIME_FORMAT | 'P' |
EMAIL_PORT | 25 |
LANGUAGE_COOKIE_AGE | None |
CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
SECRET_KEY | '********************' |
CSRF_COOKIE_SECURE | False |
EMAIL_TIMEOUT | None |
LOGOUT_URL | '/accounts/logout/' |
FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
PREPEND_WWW | False |
LANGUAGE_COOKIE_NAME | 'django_language' |
TIME_ZONE | 'America/Sao_Paulo' |
IGNORABLE_404_URLS | [] |
MANAGERS | [] |
LOCALE_PATHS | [] |
CRISPY_TEMPLATE_PACK | 'bootstrap3' |
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') |
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.