[ovirt-users] Adding users through LDAP fails on "external_id"

[Alon Bar-Lev]

This probably state that you do not use the correct driver.

You did not mention what LDAP server do you use, and you pasted only partial profile.

----- Original Message -----
> From: "Zach La Celle" <lacelle at roboticresearch.com>
> To: users at ovirt.org
> Sent: Monday, June 15, 2015 10:04:47 PM
> Subject: [ovirt-users] Adding users through LDAP fails on "external_id"
> 
> Hello,
> 
> We have a small oVirt cluster set up, and are trying to get it
> integrated with our LDAP server.
> 
> I've changed some configuration values in order to try and make it
> function, and it seems to communicate correctly with the LDAP server.
> However, when trying to add the user, I get the following error upon SQL
> entry add:
> 
> 2015-06-15 14:44:49,439 ERROR
> [org.ovirt.engine.core.bll.aaa.AddUserCommand] (ajp--127.0.0.1-8702-6)
> [3b15cbfe] Command org.ovirt.engine.core.bll.aaa.AddUserCommand throw
> exception: org.springframework.da\
> o.DataIntegrityViolationException: CallableStatementCallback; SQL [{call
> insertuser(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; ERROR: null
> value in column "external_id" violates not-null constraint
>   Where: SQL statement "INSERT INTO users(department, domain, email,
> groups, name, note, role, active, surname, user_id, username, group_ids,
> external_id,namespace) VALUES( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $\
> 6 ,  $7 ,  $8 ,  $9 ,  $10 ,  $11 ,  $12 ,  $13 ,  $14 )"
> PL/pgSQL function "insertuser" line 2 at SQL statement; nested exception
> is org.postgresql.util.PSQLException: ERROR: null value in column
> "external_id" violates not-null constraint
>   Where: SQL statement "INSERT INTO users(department, domain, email,
> groups, name, note, role, active, surname, user_id, username, group_ids,
> external_id,namespace) VALUES( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $\
> 6 ,  $7 ,  $8 ,  $9 ,  $10 ,  $11 ,  $12 ,  $13 ,  $14 )"
> 
> I can't figure out what maps from the LDAP user to "external_id" for the
> SQL table entry.
> 
> Here are the changes I made to profile1.properties:
> 
> #Mapping changes
> attrmap.map-principal-record.attr.PrincipalRecord_DISPLAY_NAME.map = cn
> attrmap.map-principal-record.attr.PrincipalRecord_EMAIL.map = Email
> attrmap.map-group-record.attr.GroupRecord_DISPLAY_NAME.map = cn
> 
> #LDAP value changes
> sequence.openldap-init-vars.030.var-set.value = entryUUID, uid, cn,
> givenName, sn, Email
> sequence.openldap-init-vars.040.var-set.value =
> (objectClass=posixAccount)(uid=*)
> sequence.openldap-init-vars.050.var-set.value = entryUUID, cn
> sequence.openldap-init-vars.060.var-set.value = (objectClass=posixGroup)
> sequence.openldap-init-vars.070.var-set.value = memberUid
> 
> Any help is appreciated!
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>