Ask Your Question
0

Keystone HTTP 500 Error on Initial admin user add

asked 2014-05-20 21:56:08 -0500

anonymous user

Anonymous

updated 2014-05-20 22:15:44 -0500

I'm trying to set up the admin user for keystone. I have been following the guide http://docs.openstack.org/icehouse/install-guide/install/yum/content/keystone-users.html (http://docs.openstack.org/icehouse/in...) and all the preceeding chapters accordingly.

When I run:

[root@ContNode001 ~]# keystone user-create --name=admin --pass=PASS --email=EM@I.L

I get:

An unexpected error prevented the server from fulfilling your request. (HTTP 500)

The following is the log information:

[root@ContNode001 ~]# tail /var/log/keystone/keystone.log 
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1691, in _execute_context
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi     context)
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 331, in do_execute
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi     cursor.execute(statement, parameters)
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi     self.errorhandler(self, exc, value)
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi     raise errorclass, errorvalue
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi OperationalError: (OperationalError) (1046, 'No database selected') 'SELECT domain.id AS domain_id, domain.name AS domain_name, domain.enabled AS domain_enabled, domain.extra AS domain_extra \nFROM domain \nWHERE domain.id = %s' ('default',)
2014-05-19 11:59:12.836 2361 TRACE keystone.common.wsgi

Why is no database selected? Thanks.

EDIT: I modifed my /etc/keystone/keystone.conf thusly:

connection = mysql://keystone:THE_PASS@127.0.0.1/keystone

However that has resulted in the following:

[root@ContNode001 ~]# tail /var/log/keystone/keystone.log 
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1691, in _execute_context
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi     context)
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/engine/default.py", line 331, in do_execute
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi     cursor.execute(statement, parameters)
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi     self.errorhandler(self, exc, value)
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi   File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi     raise errorclass, errorvalue
2014-05-19 12:25:11.584 2420 TRACE keystone.common.wsgi ProgrammingError: (ProgrammingError) (1146, "Table ...
(more)
edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2014-05-23 02:27:39 -0500

fbt045 gravatar image

HI, i also met the same problem, do you solved it?

edit flag offensive delete link more

Comments

Hit (more) at the bottom of the question for the answer.

loopback127 gravatar imageloopback127 ( 2014-06-22 20:54:49 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

Asked: 2014-05-20 21:56:08 -0500

Seen: 2,057 times

Last updated: May 23 '14