Dear Lucie, 
Thanks for your help.
You can find my configuration file below :

sudo nano /etc/ovirt-engine/extensions.d/ldap.mydomain.fr-authn.properties

ovirt.engine.extension.name = ldap.mydomain.fr-authn
ovirt.engine.extension.bindings.method = jbossmodule
ovirt.engine.extension.binding.jbossmodule.module = 
org.ovirt.engine-extensions.aaa.ldap
ovirt.engine.extension.binding.jbossmodule.class = 
org.ovirt.engineextensions.aaa.ldap.AuthnExtension
ovirt.engine.extension.provides = org.ovirt.engine.api.extensions.aaa.Authn
ovirt.engine.aaa.authn.profile.name = ldap.mydomain.fr
ovirt.engine.aaa.authn.authz.plugin = ldap.mydomain.fr
config.profile.file.1 = ../aaa/ldap.mydomain.fr.properties
config.globals.baseDN.simple_baseDN = ou=people,dc=mydomain,dc=fr

sudo nano /etc/ovirt-engine/extensions.d/ldap.mydomain.fr-authz.properties

ovirt.engine.extension.name = ldap.mydomain.fr
ovirt.engine.extension.bindings.method = jbossmodule
ovirt.engine.extension.binding.jbossmodule.module = 
org.ovirt.engine-extensions.aaa.ldap
ovirt.engine.extension.binding.jbossmodule.class = 
org.ovirt.engineextensions.aaa.ldap.AuthzExtension
ovirt.engine.extension.provides = org.ovirt.engine.api.extensions.aaa.Authz
config.profile.file.1 = ../aaa/ldap.mydomain.fr.properties
config.globals.baseDN.simple_baseDN = ou=people,dc=mydomain,dc=fr

sudo nano /etc/ovirt-engine/aaa/ldap.mydomain.fr.properties

include = <isds.properties>

vars.server = ldap.mydomain.fr

pool.authz.auth.type = none
pool.default.serverset.type = single
pool.default.serverset.single.server = ${global:vars.server}
pool.default.serverset.single.port = 636
pool.default.ssl.enable = true
pool.default.ssl.truststore.file = ${local:_basedir}/ldap.mydomain.fr.jks
pool.default.ssl.truststore.password = changeit


Thank you beforehand,
Best Regards,
LAMY Lucas


> Le 19 févr. 2020 à 8:31 AM, Lucie Leistnerova <[email protected]> a écrit :
> 
> 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/IBBPTA2QCW7OLVEE4XTVUX2JODDVJMV4/

Reply via email to