[Openstack] [keystone] Keystone service creation (HTTP 500)
Mohammed Naser
mnaser at vexxhost.com
Wed Feb 24 15:07:45 UTC 2016
Alexandr,
You should make sure to hit “Reply all” so that it goes back to the
mailing list, but I’m not sure why it’s not connected. I’d try
connecting from the mysql CLI client and see what happens
Mohammed
On Wed, Feb 24, 2016 at 10:04 AM, Alexandr Porunov
<alexandr.porunov at gmail.com> wrote:
> Hello Mohammed,
>
> I don't know why my keystone is not able to authenticate with the MySQL
> server. I have created a user like in the tutorial:
>
> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY
> 'KEYSTONE_DBPASS';
> GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY
> 'KEYSTONE_DBPASS'
>
> But it doesn't work
>
> On Wed, Feb 24, 2016 at 4:26 PM, Mohammed Naser <mnaser at vexxhost.com> wrote:
>>
>> 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
>>
>
--
Mohammed Naser — vexxhost
-----------------------------------------------------
D. 514-316-8872
D. 800-910-1726 ext. 200
E. mnaser at vexxhost.com
W. http://vexxhost.com
More information about the Openstack
mailing list