Custom Search

Thursday, May 2, 2013

openstack_auth.backend:Authorization Failed An unexpected error prevented the server from fulfilling your request. (OperationalError) no such table

Error Log
-------------
DEBUG:openstack_auth.backend:Authorization Failed: Unable to communicate with identity service: {"error": {"message": "An unexpected error prevented the server from fulfilling your request. (OperationalError) no such table: user u'SELECT user.id AS user_id, user.name AS user_name, user.domain_id AS user_domain_id, user.password AS user_password, user.enabled AS user_enabled, user.extra AS user_extra \\nFROM user \\nWHERE user.name = ? AND user.domain_id = ?' (u'admin', 'default')", "code": 500, "title": "Internal Server Error"}}. (HTTP 500)

Solution
-----------
#cd keystone

#Activate virtualenv
#source .venv/bin/activate

#Sync database
#./bin/keystone-manage db_sync

#Run keystone service
#./bin/keystone-all

OR

Following lines are missing in vim /etc/keystone/keystone.conf
[sql]
connection = mysql://root:password@127.0.0.1/keystone?charset=utf8


No comments:

Post a Comment