Re: [ovirt-users] Adding users through LDAP fails on external_id
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 lace...@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
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
[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
Re: [Users] Adding users
On 05/08/2012 01:44 PM, Yair Zaslavsky wrote: On 05/08/2012 02:26 PM, Dennis Jacobfeuerborn wrote: Hi, I just installed oVirt and so far things seem to be running smoothly for the 1-node setup. I can't seem to add users though. When I go to Users-add I only get a search dialog that lists the admin user no matter what I enter as search string and there seems to be no obvious way to actually add a new user. Clicking ok just dismisses the dialog. What user are you using to log in? Have you used engine-manage-domains in order to add an LDAP/Kerberos domain? I used the user admin that is the default with the regular rpm install. The UI doesn't mention anything about a LDAP/Kerberos domain when I try to add the user. Regards, Dennis ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Adding users
On 05/09/2012 02:18 PM, Dennis Jacobfeuerborn wrote: On 05/08/2012 01:44 PM, Yair Zaslavsky wrote: On 05/08/2012 02:26 PM, Dennis Jacobfeuerborn wrote: Hi, I just installed oVirt and so far things seem to be running smoothly for the 1-node setup. I can't seem to add users though. When I go to Users-add I only get a search dialog that lists the admin user no matter what I enter as search string and there seems to be no obvious way to actually add a new user. Clicking ok just dismisses the dialog. What user are you using to log in? Have you used engine-manage-domains in order to add an LDAP/Kerberos domain? I used the user admin that is the default with the regular rpm install. The UI doesn't mention anything about a LDAP/Kerberos domain when I try to add the user. ovirt doesn't manage internal users, rather support existing LDAP or Active Directory users. you need to configure the directory you want ovirt-engine to work with via the mentioned manage-domains utility. ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] Adding users
Hi, I just installed oVirt and so far things seem to be running smoothly for the 1-node setup. I can't seem to add users though. When I go to Users-add I only get a search dialog that lists the admin user no matter what I enter as search string and there seems to be no obvious way to actually add a new user. Clicking ok just dismisses the dialog. Also after installing my first VM, stopping it and starting it up again the console icon stayed greyed out. I actually had to restart my browser and log back in in order to make the console icon clickable again. Regards, Dennis ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Adding users
On 05/08/2012 02:26 PM, Dennis Jacobfeuerborn wrote: Hi, I just installed oVirt and so far things seem to be running smoothly for the 1-node setup. I can't seem to add users though. When I go to Users-add I only get a search dialog that lists the admin user no matter what I enter as search string and there seems to be no obvious way to actually add a new user. Clicking ok just dismisses the dialog. What user are you using to log in? Have you used engine-manage-domains in order to add an LDAP/Kerberos domain? King regards, Yair Also after installing my first VM, stopping it and starting it up again the console icon stayed greyed out. I actually had to restart my browser and log back in in order to make the console icon clickable again. Regards, Dennis ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
