Я также получаю аналогичную ошибку в консоли сервера при подключении к NextGIS Web из NextGIS Mobile/NextGIS QGIS (в настройках NextGIS Mobile добавил соединение к развернутому NextGIS Web. При подключении к сервису в окне Импорта нет доступных слоев из NextGIS Web и в консоли сервера возникает данная ошибка).
Полное сообщение ошибки:
Код: Выделить всё
DataError: (DataError) invalid input syntax for integer: "administrator"
LINE 3: ...uth_user.disabled = false AND auth_principal.id = 'administr...
^
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/api.py", line 204, in resource_exception_tween
response = handler(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 119, in tm_tween
reraise(*exc_info)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 98, in tm_tween
response = handler(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/router.py", line 155, in handle_request
view_name
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/view.py", line 612, in _call_view
response = view_callable(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/config/views.py", line 181, in __call__
return view(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 389, in attr_view
return view(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 367, in predicate_wrapper
return view(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 409, in viewresult_to_response
result = view(context, request)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/api.py", line 220, in item_get
request.resource_permission(PERM_READ)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/view.py", line 213, in resource_permission
if not resource.has_permission(permission, request.user):
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/decorator.py", line 42, in __get__
val = self.wrapped(inst)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/auth/__init__.py", line 63, in user
user_id = authenticated_userid(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/security.py", line 77, in authenticated_userid
return request.authenticated_userid
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/security.py", line 344, in authenticated_userid
return policy.authenticated_userid(self)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/pyramid/auth.py", line 54, in authenticated_userid
userid = m.authenticated_userid(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/authentication.py", line 92, in authenticated_userid
callback_ok = self.callback(userid, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/authentication.py", line 1123, in callback
return self.check(username, password, request)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/pyramid/auth.py", line 35, in check
user = User.filter_by(id=userid, disabled=False).first()
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2295, in first
ret = list(self[0:1])
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2162, in __getitem__
return list(res)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2366, in __iter__
return self._execute_and_instances(context)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2381, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in execute
params)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
context)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
exc_info
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
context)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 324, in do_execute
cursor.execute(statement, parameters)
Аналогичное сообщение ошибки возникает в консоли сервера после того как добавил в настройках подключения NextGIS QGIS коннект к NextGIS Web (в окне Редактирование подключение - успешное подключение, но после закрытия окна Настроек или Обновления возникает ошибка в консоли сервера)
Ошибка при создании векторного слоя используя шейп-файл.
Исходные данные:
shapefile
Архив с shp файлами успешно загрузился, но при нажатии на кнопку 'Создать' возникает 'alert' с сообщением 'Неизвестная ошибка 'KeyError' в сериализаторе 'vector_layer', атрибут 'source''
В консоли следующая ошибка:
Код: Выделить всё
KeyError: 12
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/api.py", line 204, in resource_exception_tween
response = handler(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid_tm/init.py", line 119, in tm_tween
reraise(*exc_info)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid_tm/init.py", line 98, in tm_tween
response = handler(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/router.py", line 155, in handle_request
view_name
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/view.py", line 612, in _call_view
response = view_callable(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/config/views.py", line 181, in call
return view(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 389, in attr_view
return view(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 367, in predicate_wrapper
return view(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 409, in viewresult_to_response
result = view(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 147, in _requestonly_view
response = view(request)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/api.py", line 315, in collection_post
serializer.deserialize()
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/serialize.py", line 216, in deserialize
mobj.deserialize()
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/serialize.py", line 178, in deserialize
sp.deserialize(self)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/serialize.py", line 96, in deserialize
self.setter(srlzr, srlzr.data[self.attrname])
File "/home/ngweb/ngw/nextgisweb/nextgisweb/vector_layer/model.py", line 715, in setter
self._ogrlayer(srlzr.obj, ogrlayer, recode)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/vector_layer/model.py", line 681, in _ogrlayer
obj.setup_from_ogr(ogrlayer, recode)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/vector_layer/model.py", line 370, in setup_from_ogr
tableinfo = TableInfo.from_ogrlayer(ogrlayer, self.srs.id, strdecode)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/vector_layer/model.py", line 165, in from_ogrlayer
_FIELD_TYPE_2_ENUM[fld_defn.GetType()],
Ошибка при добавлении WFS/WMS подключения (через стандартное меню добавления сервисов) в QGIS из развернутого NextGIS Web.
В окне 'Добавить слой WFS(WMS)' при нажатии на кнопку Подключиться возникает ошибка в консоли сервера:
Код: Выделить всё
Exception when serving /api/resource/28/wfs // Exception when serving /api/resource/30/wms (для WMS)
Traceback (most recent call last):
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/waitress/channel.py", line 338, in service
task.service()
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/waitress/task.py", line 169, in service
self.execute()
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/waitress/task.py", line 399, in execute
app_iter = self.channel.server.application(env, start_response)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/router.py", line 233, in __call__
response = self.invoke_subrequest(request, use_tweens=True)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/router.py", line 208, in invoke_subrequest
response = handle_request(request)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/pyramid/api.py", line 84, in cors_tween
response = handler(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/tweens.py", line 62, in excview_tween
reraise(*attrs['exc_info'])
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/tweens.py", line 22, in excview_tween
response = handler(request)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/api.py", line 204, in resource_exception_tween
response = handler(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 119, in tm_tween
reraise(*exc_info)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 98, in tm_tween
response = handler(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/router.py", line 155, in handle_request
view_name
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/view.py", line 612, in _call_view
response = view_callable(context, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/viewderivers.py", line 409, in viewresult_to_response
result = view(context, request)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/wfsserver/view.py", line 27, in handler
request.resource_permission(ServiceScope.connect)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/resource/view.py", line 213, in resource_permission
if not resource.has_permission(permission, request.user):
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/decorator.py", line 42, in __get__
val = self.wrapped(inst)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/auth/__init__.py", line 63, in user
user_id = authenticated_userid(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/security.py", line 77, in authenticated_userid
return request.authenticated_userid
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/security.py", line 344, in authenticated_userid
return policy.authenticated_userid(self)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/pyramid/auth.py", line 54, in authenticated_userid
userid = m.authenticated_userid(request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/authentication.py", line 92, in authenticated_userid
callback_ok = self.callback(userid, request)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/pyramid/authentication.py", line 1123, in callback
return self.check(username, password, request)
File "/home/ngweb/ngw/nextgisweb/nextgisweb/pyramid/auth.py", line 35, in check
user = User.filter_by(id=userid, disabled=False).first()
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2295, in first
ret = list(self[0:1])
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2162, in __getitem__
return list(res)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2366, in __iter__
return self._execute_and_instances(context)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2381, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 662, in execute
params)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 761, in _execute_clauseelement
compiled_sql, distilled_params
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
context)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
exc_info
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
context)
File "/home/ngweb/ngw/env/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 324, in do_execute
cursor.execute(statement, parameters)
DataError: (DataError) invalid input syntax for integer: "administrator"
LINE 3: ...uth_user.disabled = false AND auth_principal.id = 'administr...
^
'SELECT auth_principal.id AS auth_principal_id, auth_principal.cls AS auth_principal_cls, auth_principal.system AS auth_principal_system, auth_principal.display_name AS auth_principal_display_name, auth_principal.description AS auth_principal_description, auth_user.principal_id AS auth_user_principal_id, auth_user.keyname AS auth_user_keyname, auth_user.superuser AS auth_user_superuser, auth_user.disabled AS auth_user_disabled, auth_user.password_hash AS auth_user_password_hash \nFROM auth_principal JOIN auth_user ON auth_principal.id = auth_user.principal_id \nWHERE auth_user.disabled = false AND auth_principal.id = %(id_1)s \n LIMIT %(param_1)s' {'id_1': u'administrator', 'param_1': 1}
NextGIS Web установлен на Ubuntu 14.04.5. Запуск NextGIS Web выполнен через pserve.
[/url]
