Hi Lucas,

how is your ldap set? Can you please share settings in /etc/ovirt-engine/extensions.d
Is the driver properly set? I've found similar issue here
https://users.ovirt.narkive.com/FveKIVCV/ovirt-users-adding-users-through-ldap-fails-on-external-id

Thank you.

Lucie

On 2/18/20 4:14 PM, Lucas Lamy wrote:
Hello everyone.

I have previously configured LDAP connexion 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. But the LDAP server I’m testing is OpenLDAP and not IBM.

Indeed with IBM  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.
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/[email protected]/message/PLCLWVJUD7KNOTG7HQ7Y4PDWYEJVG5JJ/

--
Lucie Leistnerova
Senior Quality Engineer, QE Cloud, RHVM
Red Hat EMEA

IRC: lleistne @ #rhev-qe

_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/[email protected]/message/4KZBABHA4GVZGTLQSZ5KEILOOGVCKX5P/

Reply via email to