Hello,
i tried to add a User to an existing SQLResolver. By adding the Resolver i had no problems and the connection to the Database and Table was successful established.
I found these Error Message inside the log after i tried to add a User.
[2018-10-16 10:03:00,668][8445][140227020211968][ERROR][privacyidea.app:1423] Exception on /user/ [POST]
Traceback (most recent call last):
File “/usr/lib/python2.7/dist-packages/flask/app.py”, line 1817, in wsgi_app
response = self.full_dispatch_request()
File “/usr/lib/python2.7/dist-packages/flask/app.py”, line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File “/usr/lib/python2.7/dist-packages/flask/app.py”, line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File “/usr/lib/python2.7/dist-packages/flask/app.py”, line 1475, in full_dispatch_request
rv = self.dispatch_request()
File “/usr/lib/python2.7/dist-packages/flask/app.py”, line 1461, in dispatch_request
return self.view_functionsrule.endpoint
File “/usr/lib/python2.7/dist-packages/privacyidea/api/lib/prepolicy.py”, line 120, in policy_wrapper
return wrapped_function(*args, **kwds)
File “/usr/lib/python2.7/dist-packages/privacyidea/api/auth.py”, line 317, in decorated_function
return f(*args, **kwargs)
File “/usr/lib/python2.7/dist-packages/privacyidea/api/user.py”, line 173, in create_user_api
r = create_user(resolvername, attributes, password=password)
File “/usr/lib/python2.7/dist-packages/privacyidea/lib/log.py”, line 154, in log_wrapper
return func(*args, **kwds)
File “/usr/lib/python2.7/dist-packages/privacyidea/lib/user.py”, line 505, in create_user
uid = y.add_user(attributes)
File “/usr/lib/python2.7/dist-packages/privacyidea/lib/resolvers/SQLIdResolver.py”, line 551, in add_user
self.db.commit()
File “/usr/lib/python2.7/dist-packages/sqlsoup.py”, line 268, in commit
self.session.commit()
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/scoping.py”, line 150, in do
return getattr(self.registry(), name)(*args, **kwargs)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py”, line 813, in commit
self.transaction.commit()
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py”, line 392, in commit
self._prepare_impl()
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py”, line 372, in _prepare_impl
self.session.flush()
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py”, line 2027, in flush
self._flush(objects)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py”, line 2145, in _flush
transaction.rollback(_capture_exception=True)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py”, line 60, in exit
compat.reraise(exc_type, exc_value, exc_tb)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py”, line 2109, in _flush
flush_context.execute()
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py”, line 373, in execute
rec.execute(self)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py”, line 532, in execute
uow
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py”, line 174, in save_obj
mapper, table, insert)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py”, line 800, in _emit_insert_statements
execute(statement, params)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py”, line 914, in execute
return meth(self, multiparams, params)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py”, line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py”, line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File “/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py”, line 1146, in _execute_context
context)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py”, line 1341, in _handle_dbapi_exception
exc_info
File “/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py”, line 200, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py”, line 1139, in _execute_context
context)
File “/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py”, line 450, in do_execute
cursor.execute(statement, parameters)
File “/usr/lib/python2.7/dist-packages/pymysql/cursors.py”, line 158, in execute
result = self._query(query)
File “/usr/lib/python2.7/dist-packages/pymysql/cursors.py”, line 308, in _query
conn.query(q)
File “/usr/lib/python2.7/dist-packages/pymysql/connections.py”, line 820, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File “/usr/lib/python2.7/dist-packages/pymysql/connections.py”, line 1002, in _read_query_result
result.read()
File “/usr/lib/python2.7/dist-packages/pymysql/connections.py”, line 1285, in read
first_packet = self.connection._read_packet()
File “/usr/lib/python2.7/dist-packages/pymysql/connections.py”, line 966, in _read_packet
packet.check_error()
File “/usr/lib/python2.7/dist-packages/pymysql/connections.py”, line 394, in check_error
err.raise_mysql_exception(self._data)
File “/usr/lib/python2.7/dist-packages/pymysql/err.py”, line 120, in raise_mysql_exception
_check_mysql_exception(errinfo)
File “/usr/lib/python2.7/dist-packages/pymysql/err.py”, line 112, in _check_mysql_exception
raise errorclass(errno, errorvalue)
If i try to list all exisiting User i got the Error that no Object “User” exists.
[2018-10-16 10:30:32,687][8445][140227011819264][ERROR][privacyidea.lib.user:651] AttributeError("'Query' object has no attribute 'user'",)
Could please anyone give me a hint or a way to fix and solve this Issue?
Best Regards