4:39 a.m.
Hi,
I have previously configured LDAP though ovirt-engine-extension-aaa-ldap-setup.
The only working configuration was IBM Security Directory Server (the IBM Security
Directory Server RFC-2307 Schema doesn't work), ladps and anonymous search user.
With this one the search and login are working fine when I test them with
ovirt-engine-extensions-tool aaa.
But when I try to add a LDAP User in the User Administration Panel I get this Error
message : "Error while executing action AddUser : Internal Engine Error"
None of the solutions I've found on previous threads seems to works.
Does someone have an idea please ?
Please find the logs attached.
Thank you beforehand.
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
"external_id" violates not-null constraint
Detail: Failing row contains (**user info**).
Where: SQL statement "INSERT INTO users (
department,
domain,
email,
name,
note,
surname,
user_id,
username,
external_id,
namespace
)
VALUES (
v_department,
v_domain,
v_email,
v_name,
v_note,
v_surname,
v_user_id,
v_username,
v_external_id,
v_namespace
)"
PL/pgSQL function insertuser(character varying,character varying,character
varying,character varying,character varying,character varying,uuid,character
varying,text,character varying) line 3 at SQL state$
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at
org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:78)
at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:144)
at
org.jboss.jca.adapters.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:303)
at
org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
at
org.springframework.jdbc.core.JdbcTemplate.lambda$call$4(JdbcTemplate.java:1105)
[spring-jdbc.jar:5.0.4.RELEASE]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:1050)
[spring-jdbc.jar:5.0.4.RELEASE]
... 162 more
2020-02-15 10:16:53,337+01 ERROR [org.ovirt.engine.core.bll.aaa.AddUserCommand] (default
task-4) [222f7ca7-b669-40e0-b152-2ca898ebde09] Transaction rolled-back for command
'org.ovirt.engine.core.bll.aaa.$
2020-02-15 10:16:53,341+01 WARN
[org.ovirt.engine.core.dal.dbbroker.auditloghandling.AuditLogDirector] (default task-4)
[222f7ca7-b669-40e0-b152-2ca898ebde09] EVENT_ID: USER_FAILED_ADD_ADUSER(327), Fail, Failed
to add User 'user' to the system.