[Openstack-operators] Openstack-Keystone error

Alex Leonhardt aleonhardt.py at gmail.com
Thu Jan 15 09:58:45 UTC 2015


this is probably the issue then:

2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi ProgrammingError:
(ProgrammingError) (1146, "Table 'keystone.token' doesn't exist") 'SELECT
token.idAS token_id, token.expires AS token_expires, token.extra AS
token_extra, token.valid AS token_valid, token.user_id AS token_user_id,
token.trust_id AS token_trust_id \nFROM token \nWHERE token.id = %s'
('2c0dc0032d675623f37a',)


you may need to run those db migrate scripts for keystone first ....

alex


On Thu Jan 15 2015 at 09:09:57 Anwar Durrani <durrani.anwar at gmail.com>
wrote:

> Hi Alex, below is error in log file
>
> 2015-01-15 01:08:34.128 50243 ERROR keystone.common.wsgi [-]
> (ProgrammingError) (1146, "Table 'keystone.token' doesn't exist") 'SELECT
> token.id AS token_id, token.expires AS token_expires, token.extra AS
> token_extra, token.valid AS token_valid, token.user_id AS token_user_id,
> token.trust_id AS token_trust_id \nFROM token \nWHERE token.id = %s'
> ('2c0dc0032d675623f37a',)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi Traceback (most
> recent call last):
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 430, in
> __call__
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     response =
> self.process_request(request)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/middleware/core.py", line 279,
> in process_request
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     auth_context
> = self._build_auth_context(request)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/middleware/core.py", line 259,
> in _build_auth_context
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> token_data=self.token_provider_api.validate_token(token_id))
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/token/provider.py", line 225, in
> validate_token
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     token =
> self._validate_token(unique_id)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1013, in
> decorate
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> should_cache_fn)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 640, in
> get_or_create
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> async_creator) as value:
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 158, in
> __enter__
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> self._enter()
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 98, in
> _enter
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     generated =
> self._enter_create(createdtime)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 149, in
> _enter_create
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     created =
> self.creator()
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 612, in
> gen_value
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     created_value
> = creator()
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1009, in
> creator
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> fn(*arg, **kw)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/token/provider.py", line 318, in
> _validate_token
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     token_ref =
> self._persistence.get_token(token_id)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/token/persistence/core.py", line
> 76, in get_token
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     token_ref =
> self._get_token(unique_id)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1013, in
> decorate
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> should_cache_fn)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 640, in
> get_or_create
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> async_creator) as value:
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 158, in
> __enter__
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> self._enter()
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 98, in
> _enter
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     generated =
> self._enter_create(createdtime)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/core/dogpile.py", line 149, in
> _enter_create
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     created =
> self.creator()
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 612, in
> gen_value
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     created_value
> = creator()
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/dogpile/cache/region.py", line 1009, in
> creator
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> fn(*arg, **kw)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/token/persistence/core.py", line
> 88, in _get_token
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> self.driver.get_token(token_id)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/token/persistence/backends/sql.py",
> line 92, in get_token
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     token_ref =
> session.query(TokenModel).get(token_id)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 820, in
> get
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> loading.load_on_ident(self, key)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/loading.py", line 231,
> in load_on_ident
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return q.one()
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2369, in
> one
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     ret =
> list(self)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2412, in
> __iter__
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> self._execute_and_instances(context)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2427, in
> _execute_and_instances
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     result =
> conn.execute(querycontext.statement, self._params)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729,
> in execute
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> meth(self, multiparams, params)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 321,
> in _execute_on_connection
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     return
> connection._execute_clauseelement(self, multiparams, params)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826,
> in _execute_clauseelement
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     compiled_sql,
> distilled_params
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958,
> in _execute_context
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     context)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1156,
> in _handle_dbapi_exception
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> util.raise_from_cause(newraise, exc_info)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199,
> in raise_from_cause
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> reraise(type(exception), exception, tb=exc_tb)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951,
> in _execute_context
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     context)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
> 436, in do_execute
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> cursor.execute(statement, parameters)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 174, in
> execute
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> self.errorhandler(self, exc, value)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in
> defaulterrorhandler
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi     raise
> errorclass, errorvalue
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi ProgrammingError:
> (ProgrammingError) (1146, "Table 'keystone.token' doesn't exist") 'SELECT
> token.id AS token_id, token.expires AS token_expires, token.extra AS
> token_extra, token.valid AS token_valid, token.user_id AS token_user_id,
> token.trust_id AS token_trust_id \nFROM token \nWHERE token.id = %s'
> ('2c0dc0032d675623f37a',)
> 2015-01-15 01:08:34.128 50243 TRACE keystone.common.wsgi
> 2015-01-15 01:08:34.131 50243 INFO eventlet.wsgi.server [-] 192.168.0.200
> - - [15/Jan/2015 01:08:34] "POST /v2.0/tenants HTTP/1.1" 500 291 0.020139
>
>
> On Thu, Jan 15, 2015 at 2:04 PM, Alex Leonhardt <aleonhardt.py at gmail.com>
> wrote:
>
>> I don't think anyone should try to install OS manually :) .. But check
>> the keystone logs for what caused the 500? Maybe the admin tenant/project
>> already exists?
>>
>> On Thu, 15 Jan 2015 08:29 Anwar Durrani <durrani.anwar at gmail.com> wrote:
>>
>>> Hi everyone,
>>>
>>> i am getting below error while running below command
>>>
>>> [root at localhost ~]# keystone tenant-create --name admin --description
>>> "Admin Tenant"
>>> An unexpected error prevented the server from fulfilling your request.
>>> (HTTP 500)
>>> [root at localhost ~]#
>>>
>>> Prior to run this command i have done following :
>>>
>>> *o -  Juno -  Juno -  Juno -  Juno -  Juno -  Juno -  Juno - *
>>>
>>> * Create tenants, users, and roles*
>>>
>>> After you install the Identity service, create tenants (projects), users,
>>> and roles for your environment. You must use the temporary
>>> administration token that you created in the section called “Install
>>> and configure”
>>> <http://docs.openstack.org/juno/install-guide/install/yum/content/keystone-install.html>
>>> and manually configure the location (endpoint) of the Identity service
>>> before you run *keystone* commands.
>>>
>>> You can pass the value of the administration token to the *keystone*
>>> command with the --os-token option or set the temporary OS_SERVICE_TOKEN
>>> environment variable. Similarly, you can pass the location of the Identity
>>> service to the *keystone* command with the --os-endpoint option or set
>>> the temporary OS_SERVICE_ENDPOINT environment variable. This guide uses
>>> environment variables to reduce command length.
>>>
>>> For more information, see the Operations Guide - Managing Project and
>>> Users
>>> <http://docs.openstack.org/openstack-ops/content/projects_users.html>.
>>>
>>>
>>>
>>> *To configure prerequisites*
>>>
>>>    1. Configure the administration token:
>>>    $ export OS_SERVICE_TOKEN=1dd717043ad277e29edb
>>>    $ export OS_SERVICE_TOKEN=294a4c8a8a475f9b9836
>>>    2. Configure the endpoint:
>>>    $ export OS_SERVICE_ENDPOINT=http://*controller*:35357/v2.0
>>>
>>>
>>> ​Please advise, how to fix this issue ?
>>>
>>> Thanks​
>>>
>>> --
>>> Thanks & regards,
>>> Anwar M. Durrani
>>> +91-8605010721
>>> <http://in.linkedin.com/pub/anwar-durrani/20/b55/60b>
>>>
>>>
>>>  _______________________________________________
>>> OpenStack-operators mailing list
>>> OpenStack-operators at lists.openstack.org
>>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators
>>>
>>
>
>
> --
> Thanks & regards,
> Anwar M. Durrani
> +91-8605010721
> <http://in.linkedin.com/pub/anwar-durrani/20/b55/60b>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20150115/20ce072b/attachment.html>


More information about the OpenStack-operators mailing list