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!
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@roboticresearch.com> To: users@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@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (2)
-
Alon Bar-Lev -
Zach La Celle