Hallo,
ich habe seit kurzem ein Sync / Import Problem mit LDAP.
Fehlermeldung:(sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back
LDAP Sync hat bereits funktioniert. Was ich geändert habe is ist in der LDAP Config User authentication mechanism von Only LDAP auf Automatic umgestellt.
Ein Rückstellen bring keine Änderung.
Über search in LDAP können User hinzugefügt werden. Check LDAP User funktioniert ebenfalls.
"Can't reconnect until invalid "
sqlalchemy.exc.InvalidRequestError: Can't reconnect until invalid transaction is rolled back
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "./tools/tasq.py", line 83, in dispatch
func(self, task)
File "./tools/tasq.py", line 163, in ldapSync
defaults = DBConf.getFile("grommunio-admin", "defaults-system", True).get("user", {})
File "./orm/misc.py", line 54, in getFile
data = {entry.key: _trydec(entry.value, entry.value) for entry in entries}
File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back
[SQL: SELECT configs.
keyAS configs_key, configs.value AS configs_value
FROM configs
WHERE configs.service = %s AND configs.file = %s]
[parameters: [immutabledict({})]]
[WARNING] (flask.app) POST /api/v1/domains/1/ldap/downsync?import=true from 2003:a:: -> 500 '{"message":"Synchronization failed: (sqlalchemy.exc.InvalidRequestError) Can\'t reconnect until invalid transaction is rolled back"}\n