Ask Your Question
1

Cant add user to project [closed]

asked 2014-01-12 06:14:49 -0500

mili gravatar image

Hi,

I just deleted the _member_ role by mistake, and created it again. but now whenever I add a users to a project the system says user added bu i cannot loging with the user or after adding I cannot see it on project members tab. And also when adding user to a project i cannot see the users role anymore....

Please help

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by dheeru
close date 2014-01-14 21:02:36.857801

Comments

1

Did you try creating the users on command line ? Please do give me the complete command you tried for this.

dheeru gravatar imagedheeru ( 2014-01-12 11:03:39 -0500 )edit

Hi, I can do it via command line but something is hard coded somwhere: 2014-01-14 01:51:14.057 1310 INFO keystone.assignment.core [-] Creating the default role 9fe2ff9ee4384b1894a908shab792bab because it does not exist. 2014-01-14 01:51:14.062 1310 WARNING keystone.common.wsgi [-] Conflict occurred attempting to store role. (1062, "Duplicate entry '_member_' for key 'name'") role-list gives admin, _member_(which i created after deletion)

mili gravatar imagemili ( 2014-01-13 20:02:04 -0500 )edit

2 answers

Sort by ยป oldest newest most voted
1

answered 2014-01-14 19:47:59 -0500

mili gravatar image

I finally figured this out, what i did was checked the default entry for _member_ in a new installation elsewhere. In the _member_ user it had below in extra field. I added it to my _member_ extra field and darahhh:

{"enabled": "True", "description": "Default role for project membership"}
edit flag offensive delete link more

Comments

did you modify the db for this ?

dheeru gravatar imagedheeru ( 2014-01-14 21:02:21 -0500 )edit

Yes I did.

mili gravatar imagemili ( 2014-01-14 21:41:21 -0500 )edit
1

answered 2014-01-13 20:50:30 -0500

dheeru gravatar image

updated 2014-01-13 22:59:46 -0500

ok. How do regain this back. I suggest you do the following fix your keystone role issue. You just drop the keystone db and re-create. You will be all set. Max it just takes 5 mins. Hope your box is ubuntu.

Here are the steps.

# mysql -u root -p
mysql> drop DATABASE keystone;
mysql> CREATE DATABASE keystone;
mysql> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' \
IDENTIFIED BY 'KEYSTONE_DBPASS';
mysql> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' \
IDENTIFIED BY 'KEYSTONE_DBPASS';

# keystone-manage db_sync

This will not impact any other function as well. Restart all the services.
edit flag offensive delete link more

Comments

Hi dheeru, I tried this but i lost all of my information in the DB and lost access to all tenants and. I took a backup beforehand and restored it and now back with the issue

mili gravatar imagemili ( 2014-01-14 04:41:31 -0500 )edit

what information you have in DB ? Your keystone db will have user, tenants and roles. How many users, tenant etc you have ? I think it is better we chat and resolve your issue. If you are interested do let me know. I can chat and close this issue.

dheeru gravatar imagedheeru ( 2014-01-14 07:01:33 -0500 )edit

Thanks dheeru, I was able to figure this out

mili gravatar imagemili ( 2014-01-14 19:46:21 -0500 )edit

Hi dheeru, I have the same issue. I updated database and added some value in role table in extra column, Now it does not even let me login. Earlier i could login correctly but i was not able to create user. Can you suggest me something.

rajiv-kumar gravatar imagerajiv-kumar ( 2014-11-18 04:24:37 -0500 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

Asked: 2014-01-12 06:14:49 -0500

Seen: 984 times

Last updated: Jan 14 '14