[Openstack] [keystone] Keystone service creation (HTTP 500)

Mohammed Naser mnaser at vexxhost.com
Wed Feb 24 14:26:10 UTC 2016


Hi Alexandr,

The key error to check:

2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi OperationalError:
(_mysql_exceptions.OperationalError) (1045, "Access denied for user
'keystone'@'controller' (using password: YES)")

You'll need to make sure you address and resolve this, your keystone is not
able to authenticate with your MySQL server.

Mohammed

On Wednesday, 24 February 2016, Alexandr Porunov <alexandr.porunov at gmail.com>
wrote:

> Hello everyone,
>
> I am trying to pass this tutorial:
> http://docs.openstack.org/liberty/install-guide-rdo/keystone-services.html
> but without success.
>
> It is my /etc/hosts file:
> 127.0.0.1 me
> 192.168.56.111 controller
> 192.168.56.131 compute1
> 192.168.56.141 block1
> 192.168.56.151 object1
> 192.168.56.152 object2
> 192.168.56.50 ns1.porunov.com ns1
>
> I am using CentOS 7 in all nodes.
>
> When I try to create the service entity for the Identity service I always
> gets an error 500:
> openstack service create  --name keystone --description "OpenStack
> Identity" identity
>
> An unexpected error prevent the server from fulfilling your request. (HTTP
> 500) (Request-ID: req-12dc5717-71b4-4311-87e9-b0cfd4e90837)
>
> Request-ID always changes.
>
> This is my /var/log/keystone/keystone.log:
> 2016-02-24 15:09:45.922 4518 INFO oslo_service.service [-] Caught SIGTERM,
> stopping children
> 2016-02-24 15:09:45.923 4518 INFO oslo_service.service [-] Waiting on 4
> children to exit
> 2016-02-24 15:09:45.926 4528 INFO eventlet.wsgi.server
> [req-550473ac-acff-4581-af0f-1e02a66e4f66 - - - - -] (4528) wsgi exited,
> is_accepting=True
> 2016-02-24 15:09:45.931 4529 INFO eventlet.wsgi.server [-] (4529) wsgi
> exited, is_accepting=True
> 2016-02-24 15:09:45.933 4530 INFO eventlet.wsgi.server [-] (4530) wsgi
> exited, is_accepting=True
> 2016-02-24 15:09:45.936 4531 INFO eventlet.wsgi.server [-] (4531) wsgi
> exited, is_accepting=True
> 2016-02-24 15:09:45.942 4518 INFO oslo_service.service [-] Child 4528
> exited with status 0
> 2016-02-24 15:09:45.943 4518 INFO oslo_service.service [-] Child 4529
> exited with status 0
> 2016-02-24 15:09:45.943 4518 INFO oslo_service.service [-] Child 4530
> exited with status 0
> 2016-02-24 15:09:45.944 4518 INFO oslo_service.service [-] Child 4531
> exited with status 0
> 2016-02-24 15:09:45.947 4518 INFO oslo_service.service [-] Caught SIGTERM,
> stopping children
> 2016-02-24 15:18:29.074 1123 INFO keystone.common.wsgi
> [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -] POST
> http://controller:35357/v3/services
> 2016-02-24 15:18:29.075 1123 WARNING keystone.common.controller
> [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -] RBAC: Bypassing
> authorization
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> [req-00fd181c-00ea-4b74-a16a-3ab8c1c38e24 - - - - -]
> (_mysql_exceptions.OperationalError) (1045, "Access denied for user
> 'keystone'@'controller' (using password: YES)")
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi Traceback (most
> recent call last):
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/common/wsgi.py", line 248, in
> __call__
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     result =
> method(context, **params)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/common/controller.py", line 163,
> in inner
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return f(self,
> context, *args, **kwargs)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/common/validation/__init__.py",
> line 71, in wrapper
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> func(*args, **kwargs)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/catalog/controllers.py", line
> 272, in create_service
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     ref =
> self.catalog_api.create_service(ref['id'], ref, initiator)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/catalog/core.py", line 187, in
> create_service
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     ref =
> self.driver.create_service(service_id, service_ref)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/catalog/backends/sql.py", line
> 205, in create_service
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     session =
> sql.get_session()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 192,
> in get_session
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> _get_engine_facade().get_session(expire_on_commit=expire_on_commit)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/keystone/common/sql/core.py", line 176,
> in _get_engine_facade
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     _engine_facade
> = db_session.EngineFacade.from_config(CONF)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
> 1015, in from_config
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> expire_on_commit=expire_on_commit, _conf=conf)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
> 943, in __init__
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> slave_connection=slave_connection)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
> 338, in _start
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     engine_args,
> maker_args)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line
> 362, in _setup_for_connection
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> sql_connection=sql_connection, **engine_kwargs)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 152,
> in create_engine
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     test_conn =
> _test_connection(engine, max_retries, retry_interval)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py", line 326,
> in _test_connection
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> engine.connect()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2018,
> in connect
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> self._connection_cls(self, **kwargs)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 72, in
> __init__
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     if connection
> is not None else engine.raw_connection()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2104,
> in raw_connection
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> self.pool.unique_connection, _connection)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2078,
> in _wrap_pool_connect
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     e, dialect,
> self)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1401,
> in _handle_dbapi_exception_noconnection
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> util.raise_from_cause(newraise, exc_info)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 200,
> in raise_from_cause
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> reraise(type(exception), exception, tb=exc_tb)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 2074,
> in _wrap_pool_connect
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return fn()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 318, in
> unique_connection
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> _ConnectionFairy._checkout(self)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 713, in
> _checkout
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     fairy =
> _ConnectionRecord.checkout(pool)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 480, in
> checkout
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     rec =
> pool._do_get()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1060, in
> _do_get
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> self._dec_overflow()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line
> 60, in __exit__
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> compat.reraise(exc_type, exc_value, exc_tb)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 1057, in
> _do_get
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> self._create_connection()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 323, in
> _create_connection
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> _ConnectionRecord(self)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 449, in
> __init__
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> self.connection = self.__connect()
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/pool.py", line 607, in
> __connect
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     connection =
> self.__pool._invoke_creator(self)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/strategies.py", line
> 97, in connect
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> dialect.connect(*cargs, **cparams)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line
> 385, in connect
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> self.dbapi.connect(*cargs, **cparams)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/MySQLdb/__init__.py", line 81, in
> Connect
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi     return
> Connection(*args, **kwargs)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi   File
> "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 187, in
> __init__
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
> super(Connection, self).__init__(*args, **kwargs2)
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi OperationalError:
> (_mysql_exceptions.OperationalError) (1045, "Access denied for user
> 'keystone'@'controller' (using password: YES)")
> 2016-02-24 15:18:29.100 1123 ERROR keystone.common.wsgi
>
> Please, help me to figure out what is going on.
>
> Sincerely, Alexandr Porunov
>


-- 
Mohammed Naser — vexxhost
-----------------------------------------------------
D. 514-316-8872
D. 800-910-1726 ext. 200
E. mnaser at vexxhost.com
W. http://vexxhost.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160224/6c91b370/attachment.html>


More information about the Openstack mailing list